Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | √ | null |
|
|
||||
| ORIGINAL_SOURCE_CARE_ID | int | 4 | √ | null |
|
|
||||
| SOURCE_CARE_ID | int | 4 | √ | null |
|
|
||||
| TRANSFER_REASON | int | 4 | √ | null |
|
|
||||
| L_CANCER_SITE | varchar | 20 | √ | null |
|
|
||||
| DATE_NEW_REFERRAL | datetime | 16,3 | √ | null |
|
|
||||
| L_ORG_CODE_SPECIALIST | varchar | 100 | √ | null |
|
|
||||
| TRANSFER_DATE_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| L_CANCELLED_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N1_3_ORG_CODE_SEEN | varchar | 100 | √ | null |
|
|
||||
| ROOT_DNA_APPT_REBOOKED_DATE_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| N2_6_RECEIPT_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N2_2_ORG_CODE_REF | varchar | 100 | √ | null |
|
|
||||
| ROOT_RECEIPT_DATE_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| N2_9_FIRST_SEEN_DATE | datetime | 16,3 | √ | null |
|
|
||||
| ROOT_FIRST_SEEN_DATE_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| N_UPGRADE_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N_UPGRADE_ORG_CODE | varchar | 100 | √ | null |
|
|
||||
| ROOT_UPGRADE_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| L_SPECIALIST_SEEN_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N1_3_ORG_CODE_SPEC_SEEN | varchar | 100 | √ | null |
|
|
||||
| SPECIALIST_REFERRAL_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| N2_8_SPECIALTY | int | 4 | √ | null |
|
|
||||
| N2_7_CONSULTANT | varchar | 8 | √ | null |
|
|
||||
| TUMOUR_SITE_NEW | int | 4 | √ | null |
|
|
||||
| N4_1_DIAGNOSIS_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N4_2_DIAGNOSIS_CODE | varchar | 5 | √ | null |
|
|
||||
| L_ORG_CODE_DIAGNOSIS | varchar | 100 | √ | null |
|
|
||||
| ROOT_DIAGNOSIS_DATE_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| TREAT_NO | int | 4 | √ | null |
|
|
||||
| TREATMENT_ID | int | 4 | √ | null |
|
|
||||
| TREAT_ID | int | 4 | √ | null |
|
|
||||
| START_DATE | datetime | 16,3 | √ | null |
|
|
||||
| ORG_CODE_DTT | varchar | 100 | √ | null |
|
|
||||
| ROOT_TCI_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| DECISION_DATE | datetime | 16,3 | √ | null |
|
|
||||
| ROOT_DTT_DATE_COMMENTS | varchar | 2147483647 | √ | null |
|
|
||||
| N2_15_ADJ_REASON | int | 4 | √ | null |
|
|
||||
| TREATMENT | varchar | 2 | √ | null |
|
|
||||
| TREAT_ORG | varchar | 100 | √ | null |
|
|
||||
| SubsiteID | int | 4 | √ | null |
|
|
||||
| Username | varchar | 50 | √ | null |
|
|
||||
| FirstDefinitiveTreatment | bit | 1 | null |
|
|
|||||
| ICD03_GROUP | int | 4 | √ | null |
|
|
||||
| ICD03 | int | 4 | √ | null |
|
|
||||
| ADJ_DAYS | int | 4 | √ | null |
|
|
||||
| TREATMENT_ADJ_DATE | smalldatetime | 16 | √ | null |
|
|
||||
| N2_14_ADJ_TIME | int | 4 | √ | null |
|
|