Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | √ | null |
|
|
||||
| PATIENT_ID | int | 4 | √ | null |
|
|
||||
| OrgCodeSeen | varchar | 100 | √ | null |
|
|
||||
| NHSNumber | varchar | 15 | √ | null |
|
|
||||
| HospitalNumber | varchar | 100 | √ | null |
|
|
||||
| Surname | varchar | 100 | √ | null |
|
|
||||
| Forename | varchar | 100 | √ | null |
|
|
||||
| CancerSite | varchar | 20 | √ | null |
|
|
||||
| N4_2_DIAGNOSIS_CODE | varchar | 10 | √ | null |
|
|
||||
| PathwayStartDate | datetime | 16,3 | √ | null |
|
|
||||
| PathwayStartDateType | varchar | 50 | √ | null |
|
|
||||
| TreatmentDecisionDate | datetime | 16,3 | √ | null |
|
|
||||
| TreatmentStartDate | datetime | 16,3 | √ | null |
|
|
||||
| TreatmentOrganisation | varchar | 100 | √ | null |
|
|
||||
| TertiaryDate | datetime | 16,3 | √ | null |
|
|
||||
| BreachReason | int | 4 | √ | null |
|
|
||||
| BreachComments | varchar | 2147483647 | √ | null |
|
|
||||
| PerformanceIssues | varchar | 2147483647 | √ | null |
|
|
||||
| ActionPlan | varchar | 2147483647 | √ | null |
|
|
||||
| N1_10_DATE_BIRTH | datetime | 16,3 | √ | null |
|
|
||||
| N2_4_PRIORITY_TYPE | varchar | 5 | √ | null |
|
|
||||
| N2_6_RECEIPT_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N2_9_FIRST_SEEN_DATE | datetime | 16,3 | √ | null |
|
|
||||
| L_CANCELLED_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N2_12_CANCER_TYPE | varchar | 5 | √ | null |
|
|
||||
| N2_13_CANCER_STATUS | varchar | 5 | √ | null |
|
|
||||
| N2_15_ADJ_REASON | varchar | 5 | √ | null |
|
|
||||
| N2_16_OP_REFERRAL | varchar | 5 | √ | null |
|
|
||||
| N_UPGRADE_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N4_1_DIAGNOSIS_DATE | datetime | 16,3 | √ | null |
|
|
||||
| N16_2_ADJ_DAYS | int | 4 | √ | null |
|
|
||||
| N16_4_ADJ_TREAT_CODE | int | 4 | √ | null |
|
|
||||
| N2_14_ADJ_TIME | int | 4 | √ | null |
|
|
||||
| TREATMENT_SETTING | varchar | 5 | √ | null |
|
|
||||
| N4_5_HISTOLOGY | varchar | 10 | √ | null |
|
|
||||
| PATHWAY_ID | varchar | 25 | √ | null |
|
|
||||
| L_TUMOUR_STATUS | varchar | 5 | √ | null |
|
|
||||
| HasAcuteDiagnosis | bit | 1 | √ | null |
|
|
||||
| Confirmed | varchar | 5 | √ | null |
|
|
||||
| BreachDate | datetime | 16,3 | √ | null |
|
|
||||
| AgeAtDiagnosisOrFirstSeen | int | 4 | √ | null |
|
|
||||
| SeenDate | datetime | 16,3 | √ | null |
|
|
||||
| HasValidDiagnosis | bit | 1 | √ | null |
|
|
||||
| IsCWTPatient | bit | 1 | √ | null |
|
|
||||
| Is31Day | bit | 1 | √ | null |
|
|
||||
| AdjustmentValue | int | 4 | √ | null |
|
|
||||
| TargetDate | datetime | 16,3 | √ | null |
|
|
||||
| TargetDays | int | 4 | √ | null |
|
|
||||
| IsBreach | bit | 1 | √ | null |
|
|
||||
| Username | varchar | 100 | √ | null |
|
|
||||
| ReferralDecisionDate | datetime | 16,3 | √ | null |
|
|
||||
| SNOMedCT | int | 4 | √ | null |
|
|
||||
| Diagnosis | varchar | 500 | √ | null |
|
|
||||
| DiagnosisDate | date | 20 | √ | null |
|
|
||||
| CCG | varchar | 500 | √ | null |
|
|
||||
| SubSite | varchar | 100 | √ | null |
|
|
||||
| L_FIRST_APP | int | 4 | √ | null |
|
|
||||
| PatientPathwayIdentifier | varchar | 20 | √ | null |
|
|
||||
| TREATMENT_ADJ_DATE | date | 20 | √ | null |
|
|