Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
NHSNumber | varchar | 10 | √ | null |
|
|
||
HospitalNumber | varchar | 10 | √ | null |
|
|
||
PatientSurname | varchar | 60 | √ | null |
|
|
||
PatientForename | varchar | 50 | √ | null |
|
|
||
PatientDOB | datetime | 16,3 | √ | 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 |
|
|
||
Referrer | varchar | 50 | √ | null |
|
|
||
ReferrerCode | varchar | 8 | √ | null |
|
|
||
DecisionReferDate | datetime | 16,3 | √ | null |
|
|
||
DecisionDay | varchar | 50 | √ | null |
|
|
||
DecisionReceipt | int | 4 | √ | null |
|
|
||
ReceiptReferralDate | datetime | 16,3 | √ | null |
|
|
||
ReceiptDay | varchar | 50 | √ | null |
|
|
||
DateCancelledAppointment | datetime | 16,3 | √ | null |
|
|
||
AdjustmentTime | int | 4 | √ | null |
|
|
||
FirstAppointmentDate | datetime | 16,3 | √ | null |
|
|
||
FirstAppointmentDay | varchar | 50 | √ | null |
|
|
||
DecisionSeen | int | 4 | √ | null |
|
|
||
ReferralAppropriateness | varchar | 50 | √ | null |
|
|
||
ReasonInappropriate | varchar | 255 | √ | null |
|
|
||
TwoWeekWaitComments | varchar | 500 | √ | null |
|
|
||
SuspectedCancerType | varchar | 100 | √ | null |
|
|
||
CancerStatus | varchar | 100 | √ | null |
|
|
||
DiagnosisDate | datetime | 16,3 | √ | null |
|
|
||
PatientInformedDate | datetime | 16,3 | √ | null |
|
|
||
GPInformedDate | datetime | 16,3 | √ | null |
|
|
||
GPInformedNextWorkingDay | varchar | 5 | √ | null |
|
|
||
ReasonNotInformed | varchar | 255 | √ | null |
|
|
||
Comments | varchar | 500 | √ | null |
|
|
||
Username | varchar | 50 | √ | null |
|
|