Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
CARE_ID | int | 4 | null |
|
|
|||
Extramedullary Disease - CNS1 | varchar | 3 | null |
|
|
|||
Extramedullary Disease - CNS2 | varchar | 3 | null |
|
|
|||
Extramedullary Disease - CNS3 | varchar | 3 | null |
|
|
|||
Extramedullary Disease - Testes | varchar | 3 | null |
|
|
|||
Extramedullary Disease - Other | varchar | 3 | null |
|
|
|||
Morphology (ICD03) | varchar | 218 | √ | null |
|
|
||
White Blood Cell Count (Highest Pre Treatment) | real | 4 | √ | null |
|
|
||
Cytogenetic Risk Code Comments | varchar | 50 | √ | null |
|
|
||
Murphy (St Jude) Stage | varchar | 50 | √ | null |
|
|
||
ALK-1 Status | varchar | 50 | √ | null |
|
|
||
Ann Arbor Stage | varchar | 50 | √ | null |
|
|
||
Ann Arbor Symptoms | varchar | 50 | √ | null |
|
|
||
Ann Arbor Extranodal Involvement | varchar | 50 | √ | null |
|
|
||
Wilms Tumour Stage | varchar | 50 | √ | null |
|
|
||
Risk Classification (Pathological) after Immediate Nephrectomy | varchar | 50 | √ | null |
|
|
||
Risk Classification (Pathological) after Pre-op Chemo | varchar | 50 | √ | null |
|
|
||
IRS Grouping | varchar | 50 | √ | null |
|
|
||
Cytogenetics for Alveolar Rhabdomyosarcoma | varchar | 50 | √ | null |
|
|
||
Rhabdomyosarcoma Site Prognosis Code | varchar | 50 | √ | null |
|
|
||
Primary Tumour Size (Radiological) | real | 4 | √ | null |
|
|
||
Extent of Necrosis after Chemotherapy | int | 4 | √ | null |
|
|
||
Cytogenetics for Ewings Sarcoma | varchar | 50 | √ | null |
|
|
||
Tumour Volume at Diagnosis | varchar | 50 | √ | null |
|
|
||
Chang Stage | varchar | 50 | √ | null |
|
|
||
Pretext Grouping (Second Dropdown) | varchar | 50 | √ | null |
|
|
||
Tumour Site (Bone) | varchar | 255 | √ | null |
|
|
||
Tumour Site (Soft Tissue) | varchar | 287 | √ | null |
|
|
||
Tumour Sub-Site (Bone) | varchar | 50 | √ | null |
|
|
||
Tumour Sub-Site (Soft Tissue) | varchar | 50 | √ | null |
|
|
View Definition
Possibly Referenced Tables/Views
- tblMAIN_REFERRALS
- tblREFERRAL_PAEDIATRICS
- vwSARCOMA_TISSUE
- tblREFERRAL_UROLOGY
- ltblSAR_TISSUE_SUBSITE
- ltblSAR_PART_SITE
- vwSARCOMA_BONE
- ltblPAED_EXT
- tblCOSD_CTYA
- ltblHAEM_ANN
- ltblPAED_CHANG
- ltblEWINGS_TUMOR_VOLUME
- ltblEWINGS_CYTOGENETICS
- ltblCYTOGENETICS_RHABDOMYOSARCOMA
- ltblIRS_GROUP
- ltblLIH
- ltblFAVOURABLE_UNFAVOURABLE
- ltblPAED_RENAL
- ltblANN_ARBOR_EXTRANODALITY
- ltblHAEM_ANN_STAGE
- ltblALK_1
- ltblPAED_STAGE
- ltblHAEM_ICD03
- ltblHAEM_ICD03_MAPPING