Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CARE_ID | int | 4 | null |
|
|
|||
Hospital Number | varchar | 20 | √ | null |
|
|
||
NHS Number | varchar | 10 | √ | null |
|
|
||
Cancer Site | varchar | 50 | √ | null |
|
|
||
ICD10 Code | varchar | 5 | √ | null |
|
|
||
Diagnosis (SNOMED) | bigint | 8 | √ | null |
|
|
||
Date of Diagnosis | smalldatetime | 16 | √ | null |
|
|
||
Basis of Diagnosis | varchar | 50 | √ | null |
|
|
||
Organisation (Diagnosis) | varchar | 5 | √ | null |
|
|
||
Performance Status | varchar | 183 | √ | null |
|
|
||
Pre Treatment T Stage | varchar | 11 | √ | null |
|
|
||
Pre Treatment N Stage | varchar | 11 | √ | null |
|
|
||
Pre Treatment M Stage | varchar | 11 | √ | null |
|
|
||
Pre-Treatment Staging | varchar | 8000 | √ | null |
|
|
||
Pre Treatment TNM Grouping | varchar | 20 | √ | null |
|
|
||
Pre Treatment TNM Date | smalldatetime | 16 | √ | null |
|
|
||
Final T Stage | varchar | 11 | √ | null |
|
|
||
Final N Stage | varchar | 11 | √ | null |
|
|
||
Final M Stage | varchar | 11 | √ | null |
|
|
||
Final Staging | varchar | 8000 | √ | null |
|
|
||
Final TNM Stage Grouping | varchar | 20 | √ | null |
|
|
||
Final TNM Stage Date | smalldatetime | 16 | √ | null |
|
|
||
FIGO Stage | varchar | 3 | √ | null |
|
|
||
FIGO Letter | varchar | 3 | √ | null |
|
|
||
FIGO Number | varchar | 3 | √ | null |
|
|
||
Ann Arbor Stage | varchar | 50 | √ | null |
|
|
||
Ann Arbor Symptoms | varchar | 50 | √ | null |
|
|
||
Ann Arbor Extranodality | varchar | 50 | √ | null |
|
|
||
Ann Arbor Bulk | varchar | 30 | √ | null |
|
|
||
Binet Stage | varchar | 50 | √ | null |
|
|
||
Murphy (St Jude) Stage | varchar | 50 | √ | null |
|
|
||
Wilms Tumour Stage | varchar | 50 | √ | null |
|
|
||
RMH Stage Grouping | varchar | 5 | √ | null |
|
|
||
Barcelona Clinic Liver Cancer Stage | varchar | 20 | √ | null |
|
|
||
R-ISS Stage | int | 4 | √ | null |
|
|
||
Co-Morbidity Evaluation Score | varchar | 50 | √ | null |
|
|
||
CNS Seen by Indicator Code | varchar | 255 | √ | null |
|
|
View Definition
Possibly Referenced Tables/Views
- tblMAIN_REFERRALS
- tblMAIN_CARE_PLAN
- SNOMEDCTConcepts
- SNOMED
- DIAGNOSIS
- TNM
- ltblHAEM_ANN_STAGE
- tblDEMOGRAPHICS
- ltblBASIS_DIAG
- ltblCOMORBIDITY_INDEX
- ltblWHO
- tblREFERRAL_BREAST
- tblREFERRAL_DERMATOLOGY
- tblREFERRAL_COLORECTAL
- tblREFERRAL_GYNAECOLOGY
- tblREFERRAL_HEAD_NECK
- tblREFERRAL_HAEMATOLOGY
- tblREFERRAL_LUNG
- tblREFERRAL_PAEDIATRICS
- tblREFERRAL_UPPER_GI
- tblREFERRAL_UROLOGY
- tblREFERRAL_BRAIN
- tblREFERRAL_CUP
- tblREFERRAL_OTHER
- tblREFERRAL_SARCOMA
- ltblDUKES
- ltblHAEM_ANN
- ltblANN_ARBOR_EXTRANODALITY
- ltblANN_ARBOR_BULK
- ltblHAEM_BINET
- ltblHAEM_RAI
- ltblPAED_STAGE
- ltblPAED_RENAL
- ltblRMH_STAGE
- ltblCNS_INDICATION_CODES
- ltblSTAGE_GROUP_MAPPING
- ltblBARCELONA_CLINIC_STAGE