Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TReferralType | varchar | 50 | √ | null |
|
|
||
| CancerSite | varchar | 50 | √ | null |
|
|
||
| NHSNumber | varchar | 10 | √ | null |
|
|
||
| NhsNumberStatus | varchar | 3 | √ | null |
|
|
||
| HospitalNumber | varchar | 10 | √ | null |
|
|
||
| Forename | varchar | 50 | √ | null |
|
|
||
| Surname | varchar | 60 | √ | null |
|
|
||
| DateBirth | datetime | 16,3 | √ | null |
|
|
||
| Gender | varchar | 1 | √ | null |
|
|
||
| PtAddress1 | varchar | 150 | √ | null |
|
|
||
| PtAddress2 | varchar | 150 | √ | null |
|
|
||
| PtAddress3 | varchar | 150 | √ | null |
|
|
||
| PtAddress4 | varchar | 150 | √ | null |
|
|
||
| PtPostCode | varchar | 10 | √ | null |
|
|
||
| RegisteredGP | varchar | 50 | √ | null |
|
|
||
| RegisteredGPCode | varchar | 8 | √ | null |
|
|
||
| RegisteredPracticeCode | varchar | 15 | √ | null |
|
|
||
| GPAddress1 | varchar | 50 | √ | null |
|
|
||
| GPAddress2 | varchar | 50 | √ | null |
|
|
||
| GPAddress3 | varchar | 50 | √ | null |
|
|
||
| GPAddress4 | varchar | 50 | √ | null |
|
|
||
| GPPostCode | varchar | 10 | √ | null |
|
|
||
| PCT | varchar | 50 | √ | null |
|
|
||
| PCTCode | 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 |
|
|
||
| DiagnosisDate | smalldatetime | 16 | √ | null |
|
|
||
| PrimaryDiagnosis | varchar | 5 | √ | null |
|
|
||
| TumourLaterality | varchar | 1 | √ | null |
|
|
||
| PtInformedDiagnosis | varchar | 3 | √ | null |
|
|
||
| RelativeCarerInformedDiagnosis | varchar | 3 | √ | 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 |
|
|
||
| TertiaryReferralDate | smalldatetime | 16 | √ | null |
|
|
||
| TertiaryReferral | varchar | 5 | √ | null |
|
|
||
| TertiaryReferralReason | int | 4 | √ | null |
|
|
||
| TertiaryReferralReasonDesc | varchar | 50 | √ | null |
|
|
||
| CWTComments | varchar | 500 | √ | null |
|
|
||
| DiagnosisComments | varchar | 500 | √ | null |
|
|
||
| Username | varchar | 50 | √ | null |
|
|