Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| NHSNumber | varchar | 10 | √ | null |
|
|
||
| HospitalNumber | varchar | 10 | √ | null |
|
|
||
| Forename | varchar | 50 | √ | null |
|
|
||
| Surname | varchar | 60 | √ | null |
|
|
||
| DateBirth | datetime | 16,3 | √ | null |
|
|
||
| Gender | varchar | 1 | √ | null |
|
|
||
| RegisteredGP | varchar | 50 | √ | null |
|
|
||
| RegisteredGPCode | varchar | 8 | √ | null |
|
|
||
| RegisteredPractice | varchar | 50 | √ | null |
|
|
||
| RegisteredPracticeCode | varchar | 15 | √ | null |
|
|
||
| CCG | varchar | 100 | √ | null |
|
|
||
| CCGCode | varchar | 5 | √ | null |
|
|
||
| DateDeath | datetime | 16,3 | √ | null |
|
|
||
| PatientPathwayID | varchar | 20 | √ | null |
|
|
||
| PathwayIDOrgCode | varchar | 5 | √ | null |
|
|
||
| ReferralDecisionDate | varchar | 10 | √ | null |
|
|
||
| SourceReferral | varchar | 2 | √ | null |
|
|
||
| PriorityType | varchar | 2 | √ | null |
|
|
||
| ReferralReceivedDate | varchar | 10 | √ | null |
|
|
||
| ReferralType | varchar | 2 | √ | null |
|
|
||
| UpgradeDate | varchar | 10 | √ | null |
|
|
||
| UpgradeOrgCode | varchar | 5 | √ | null |
|
|
||
| FirstSeenDate | varchar | 10 | √ | null |
|
|
||
| FirstSeenOrgCode | varchar | 5 | √ | null |
|
|
||
| FirstSeenAdj | int | 4 | √ | null |
|
|
||
| FirstSeenAdjReason | int | 4 | √ | null |
|
|
||
| FirstSeenDelayComment | varchar | 500 | √ | null |
|
|
||
| FirstSeenDelayReason | varchar | 2 | √ | null |
|
|
||
| MDTDiscussionIndicator | varchar | 1 | √ | null |
|
|
||
| MDTDiscussionDate | varchar | 10 | √ | null |
|
|
||
| PatientStatus | varchar | 2 | √ | null |
|
|
||
| PrimaryDiagnosis | varchar | 5 | √ | null |
|
|
||
| TumourLaterality | varchar | 1 | √ | null |
|
|
||
| TreatmentEventType | varchar | 2 | √ | null |
|
|
||
| MetastaticSite | varchar | 2 | √ | null |
|
|
||
| DecisionTreatOrgCode | varchar | 5 | √ | null |
|
|
||
| DecisionTreatDate | varchar | 10 | √ | null |
|
|
||
| TreatmentStartDate | varchar | 10 | √ | null |
|
|
||
| TreatmentModality | varchar | 2 | √ | null |
|
|
||
| CareSetting | varchar | 2 | √ | null |
|
|
||
| ClinicalTrial | varchar | 2 | √ | null |
|
|
||
| TreatmentOrgCode | varchar | 5 | √ | null |
|
|
||
| RadiotherapyPriority | varchar | 2 | √ | null |
|
|
||
| RadiotherapyIntent | varchar | 2 | √ | null |
|
|
||
| DecisionTreatmentDelayComment | varchar | 500 | √ | null |
|
|
||
| DecisionTreatmentDelayReason | int | 4 | √ | null |
|
|
||
| TreatmentAdj | int | 4 | √ | null |
|
|
||
| TreatmentAdjReason | int | 4 | √ | null |
|
|
||
| RefTreatmentDelayComment | varchar | 500 | √ | null |
|
|
||
| RefTreatmentDelayReason | int | 4 | √ | null |
|
|
||
| DecisionTreatAdj | int | 4 | √ | null |
|
|
||
| DecisionTreatAdjReason | int | 4 | √ | null |
|
|
||
| Comments | text | 2147483647 | √ | null |
|
|
||
| Validated | varchar | 5 | √ | null |
|
|
||
| Username | varchar | 50 | √ | null |
|
|