Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CARE_ID | int | 4 | null |
|
|
|||
Cancer Site | varchar | 50 | √ | null |
|
|
||
NHS Number | varchar | 10 | √ | null |
|
|
||
Hospital Number | varchar | 20 | √ | null |
|
|
||
Full Name | varchar | 111 | √ | null |
|
|
||
Pre-Treatment Staging Date | date | 20 | √ | null |
|
|
||
Pre-Treatment T Stage | varchar | 10 | √ | null |
|
|
||
Pre-Treatment N Stage | varchar | 10 | √ | null |
|
|
||
Pre-Treatment M Stage | varchar | 10 | √ | null |
|
|
||
Pre-Treatment Staging | varchar | 8000 | √ | null |
|
|
||
Pre-Treatment Certainty Factor T Stage | varchar | 2 | √ | null |
|
|
||
Pre-Treatment Certainty Factor N Stage | varchar | 2 | √ | null |
|
|
||
Pre-Treatment Certainty Factor M Stage | varchar | 2 | √ | null |
|
|
||
Pre-Treatment Certainty Factor Overall | varchar | 2 | √ | null |
|
|
||
Pre-Treatment Certainty Factors Staging | varchar | 21 | √ | null |
|
|
||
Final Staging Date | date | 20 | √ | null |
|
|
||
Final T Stage | varchar | 10 | √ | null |
|
|
||
Final N Stage | varchar | 10 | √ | null |
|
|
||
Final M Stage | varchar | 10 | √ | null |
|
|
||
Final Staging | varchar | 8000 | √ | null |
|
|
||
Final Certainty Factor T Stage | varchar | 2 | √ | null |
|
|
||
Final Certainty Factor N Stage | varchar | 2 | √ | null |
|
|
||
Final Certainty Factor M Stage | varchar | 2 | √ | null |
|
|
||
Final Certainty Factor Overall | varchar | 2 | √ | null |
|
|
||
Final Certainty Factors Staging | varchar | 21 | √ | null |
|
|
||
Dukes | varchar | 100 | √ | null |
|
|
||
Ann Arbor Stage | varchar | 100 | √ | null |
|
|
||
Specialty | varchar | 150 | √ | null |
|
|
||
Alpha Fetoprotein (Cerebrospinal Fluid) | int | 4 | √ | null |
|
|
||
Beta Human Chorionic Gonadotropin | int | 4 | √ | null |
|
|
||
TNM Non CNS Germ | varchar | 50 | √ | null |
|
|
||
Beta Human Chorionic Gonadotropin (Serum) | int | 4 | √ | null |
|
|
||
Alpha Fetoprotein (Serum) | int | 4 | √ | null |
|
|
||
Organisation (Pre-Treatment) | nvarchar | 500 | √ | null |
|
|
||
Organisation (Final) | nvarchar | 500 | √ | null |
|
|
View Definition
Possibly Referenced Tables/Views
- TNM
- BIvwDukesAnnStageCode
- ltblSPECIALTIES
- ltblGERM_CELL_NON_CNS
- tblMAIN_REFERRALS
- tblDEMOGRAPHICS
- tblREFERRAL_BRAIN
- tblREFERRAL_BREAST
- tblREFERRAL_COLORECTAL
- tblREFERRAL_CUP
- tblREFERRAL_GYNAECOLOGY
- tblREFERRAL_HAEMATOLOGY
- tblREFERRAL_HEAD_NECK
- tblREFERRAL_LUNG
- tblREFERRAL_OTHER
- tblREFERRAL_PAEDIATRICS
- tblREFERRAL_SARCOMA
- tblREFERRAL_DERMATOLOGY
- tblREFERRAL_UPPER_GI
- tblREFERRAL_UROLOGY
- OrganisationSites