Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| N1_6_FORENAME | varchar | 100 | √ | null |
|
|
||||
| N1_5_SURNAME | varchar | 100 | √ | null |
|
|
||||
| N1_1_NHS_NUMBER | varchar | 10 | √ | null |
|
|
||||
| N1_2_HOSPITAL_NUMBER | varchar | 100 | √ | null |
|
|
||||
| N1_10_DATE_BIRTH | datetime | 16,3 | √ | null |
|
|
||||
| Gender | varchar | 20 | √ | null |
|
|
||||
| CARE_ID | int | 4 | √ | null |
|
|
||||
| N_UPGRADE_DATE | datetime | 16,3 | √ | null |
|
|
||||
| SeenOrg | varchar | 100 | √ | null |
|
|
||||
| N16_2_ADJ_DAYS | int | 4 | √ | null |
|
|
||||
| N16_4_ADJ_TREAT_CODE | int | 4 | √ | null |
|
|
||||
| N16_5_DECISION_REASON_CODE | int | 4 | √ | null |
|
|
||||
| N16_7_DECISION_REASON | varchar | 2147483647 | √ | null |
|
|
||||
| N2_10_FIRST_SEEN_DELAY | varchar | 2 | √ | null |
|
|
||||
| N2_11_FIRST_SEEN_REASON | varchar | 2147483647 | √ | null |
|
|
||||
| N2_14_ADJ_TIME | int | 4 | √ | null |
|
|
||||
| AdjustmentReason | varchar | 50 | √ | null |
|
|
||||
| N2_6_RECEIPT_DATE | datetime | 16,3 | √ | null |
|
|
||||
| CancerSite | varchar | 20 | √ | null |
|
|
||||
| TreatOrg | varchar | 100 | √ | null |
|
|
||||
| DECISION_DATE | datetime | 16,3 | √ | null |
|
|
||||
| START_DATE | datetime | 16,3 | √ | null |
|
|
||||
| ADJ_DAYS | int | 4 | √ | null |
|
|
||||
| ADJ_CODE | int | 4 | √ | null |
|
|
||||
| PathwayStartDate | datetime | 16,3 | √ | null |
|
|
||||
| TimeRefToTreat | int | 4 | √ | null |
|
|
||||
| TimeDecToTreat | int | 4 | √ | null |
|
|
||||
| DelayReasonDesc | varchar | 200 | √ | null |
|
|
||||
| TargetDate | datetime | 16,3 | √ | null |
|
|
||||
| TREATMENT_SETTING | varchar | 2 | √ | null |
|
|
||||
| Username | varchar | 50 | √ | null |
|
|
||||
| N2_5_DECISION_DATE | datetime | 16,3 | √ | null |
|
|
||||
| Title | varchar | 20 | √ | null |
|
|
||||
| PatientStatus | varchar | 100 | √ | null |
|
|
||||
| FasterDiagnosisEndDate | datetime | 16,3 | √ | null |
|
|
||||
| FasterDiagnosisDaysInPathway | int | 4 | √ | null |
|
|
||||
| FasterDiagnosisExclusionReason | nvarchar | 160 | √ | null |
|
|
||||
| FasterDiagnosisEndReason | nvarchar | 50 | √ | null |
|
|
||||
| FasterDiagnosisDelayReason | nvarchar | 320 | √ | null |
|
|
||||
| FasterDiagnosisDelayComments | nvarchar | 1073741823 | √ | null |
|
|
||||
| SubtypeDescription | nvarchar | 100 | √ | null |
|
|
||||
| decimal | 4,1 | √ | null |
|
|
|||||
| PredictedBreachStatus | varchar | 25 | √ | null |
|
|
||||
| PredictedBreachMonth | varchar | 3 | √ | null |
|
|
||||
| PredictedBreachYear | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| IX_expROOT_HELPER_2_Wide | Performance | Asc | Username |