Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
Links record to Referral |
||||||
| N_C1_DIAGNOSTIC_ROUTE | varchar | 50 | √ | null |
|
|
Diagnostic Route |
|||||
| R_SCREENING_TYPE | varchar | 50 | √ | null |
|
|
Screening Type |
|||||
| R_SYNC_TUMOUR | varchar | 5 | √ | null |
|
|
Synchronous Cancer |
|||||
| R_SYNC_CAECUM | varchar | 1 | √ | null |
|
|
Caecum |
|||||
| R_SYNC_APPENDIX | varchar | 1 | √ | null |
|
|
Appendix |
|||||
| R_SYNC_ASCENDING | varchar | 1 | √ | null |
|
|
Ascending Colon |
|||||
| R_SYNC_HEPATIC | varchar | 1 | √ | null |
|
|
Hepatic Flexure |
|||||
| R_SYNC_TRANSVERSE | varchar | 1 | √ | null |
|
|
Transverse Colon |
|||||
| R_SYNC_SPLENIC | varchar | 1 | √ | null |
|
|
Splenic Flexure |
|||||
| R_SYNC_DESCENDING | varchar | 1 | √ | null |
|
|
Descending Colon |
|||||
| R_SYNC_SIGMOID | varchar | 1 | √ | null |
|
|
Sigmoid Colon |
|||||
| R_SYNC_RECTOSIGMOID | varchar | 1 | √ | null |
|
|
Recto/Sigmoid |
|||||
| R_SYNC_RECTUM | varchar | 1 | √ | null |
|
|
Rectum |
|||||
| R_TUMOUR_HEIGHT | varchar | 50 | √ | null |
|
|
Height Above Anal Verge |
|||||
| L_3M_REVIEW | varchar | 3 | √ | null |
|
|
3 Month Review (not used) |
|||||
| L_DIAG_METHOD | varchar | 50 | √ | null |
|
|
Method of Diagnosis |
|||||
| N_C10_LYMPH_NODE | varchar | 50 | √ | null |
|
|
Marker Lymph Node |
|||||
| L_POLYPS | varchar | 5 | √ | null |
|
|
Polyps |
|||||
| L_FULL_COLONIC | varchar | 5 | √ | null |
|
|
Full Colonic Imaging |
|||||
| L_LIVER_METS | varchar | 5 | √ | null |
|
|
Liver Imaging |
|||||
| L_CYSTS | varchar | 5 | √ | null |
|
|
Cysts |
|||||
| L_HAEMANGIOMA | varchar | 50 | √ | null |
|
|
Haemangioma |
|||||
| L_SIG_BIOPSY | varchar | 50 | √ | null |
|
|
FT Flexi Sig/Biopsy |
|||||
| R_FIRST_REFERRAL | varchar | 3 | √ | null |
|
|
Is this first referral to member of MDT |
|||||
| L_HAGGITT | int | 4 | √ | null |
|
|
||||||
| L_KIKUCHI | int | 4 | √ | null |
|
|
||||||
| DUKES_DATE | smalldatetime | 16 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblREFERRAL_COLORECTAL_1 | Primary key | Asc | CARE_ID |
| IX_tblREFERRAL_COLORECTAL | Performance | Asc | CARE_ID |