Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
NHSNumber | varchar | 10 | √ | null |
|
|
||
HospitalNumber | varchar | 10 | √ | null |
|
|
||
OrgCodeSubmitting | varchar | 5 | √ | null |
|
|
||
CareSpellID | varchar | 50 | √ | null |
|
|
||
PatientSurname | varchar | 60 | √ | null |
|
|
||
PatientForename | varchar | 50 | √ | null |
|
|
||
PatientAddress | varchar | 500 | √ | null |
|
|
||
PatientPostCode | varchar | 10 | √ | null |
|
|
||
PatientSex | int | 4 | √ | null |
|
|
||
PatientDOB | datetime | 16,3 | √ | null |
|
|
||
RegisteredGP | varchar | 8 | √ | null |
|
|
||
RegisteredPractice | varchar | 6 | √ | null |
|
|
||
PatientPCT | varchar | 5 | √ | null |
|
|
||
PatientSurnameBirth | varchar | 60 | √ | null |
|
|
||
PatientEthnicity | varchar | 50 | √ | null |
|
|
||
ReferralSource | varchar | 2 | √ | null |
|
|
||
ReferringOrgCode | varchar | 6 | √ | null |
|
|
||
ReferrerCode | varchar | 10 | √ | null |
|
|
||
CancerReferralPriorityType | varchar | 2 | √ | null |
|
|
||
CancerReferralDecisionDate | datetime | 16,3 | √ | null |
|
|
||
ReferralRequestReceivedDate | datetime | 16,3 | √ | null |
|
|
||
Consultant | varchar | 8 | √ | null |
|
|
||
Specialty | int | 4 | √ | null |
|
|
||
FirstSeenDate | datetime | 16,3 | √ | null |
|
|
||
ReferralToFirstSeenDelayReason | varchar | 2 | √ | null |
|
|
||
FirstSeenDelayReasonComment | varchar | 500 | √ | null |
|
|
||
UrgentCancerReferralType | varchar | 2 | √ | null |
|
|
||
CancerStatus | varchar | 2 | √ | null |
|
|
||
FirstSeenAdjustment | int | 4 | √ | null |
|
|
||
FirstSeenAdjustmentReason | int | 4 | √ | null |
|
|
||
ReferralSourceOPA | varchar | 2 | √ | null |
|
|
||
DiagnosisDate | datetime | 16,3 | √ | null |
|
|
||
PrimaryDiagnosis | varchar | 5 | √ | null |
|
|
||
TumourLaterality | varchar | 1 | √ | null |
|
|
||
BasisDiagnosis | int | 4 | √ | null |
|
|
||
Histology | varchar | 10 | √ | null |
|
|
||
GradeDifferentiation | varchar | 2 | √ | null |
|
|
||
PreTreatmentTStage | varchar | 5 | √ | null |
|
|
||
CertaintyTStage | varchar | 2 | √ | null |
|
|
||
PreTreatmentNStage | varchar | 5 | √ | null |
|
|
||
CertaintyNStage | varchar | 2 | √ | null |
|
|
||
PreTreatmentMStage | varchar | 5 | √ | null |
|
|
||
CertaintyMStage | varchar | 2 | √ | null |
|
|
||
PreTreatmentTNM | varchar | 10 | √ | null |
|
|
||
CertaintyTNMStage | char | 10 | √ | null |
|
|
||
Staging_Dukes | varchar | 20 | √ | null |
|
|
||
Staging_NPI | varchar | 20 | √ | null |
|
|
||
Staging_FIGO | varchar | 20 | √ | null |
|
|
||
Staging_Breslow | varchar | 20 | √ | null |
|
|
||
Staging_Clark | varchar | 20 | √ | null |
|
|
||
Staging_Gleason | varchar | 20 | √ | null |
|
|
||
FinalTNM | varchar | 10 | √ | null |
|
|
||
FinalTStage | varchar | 5 | √ | null |
|
|
||
FinalNStage | varchar | 5 | √ | null |
|
|
||
FinalMStage | varchar | 5 | √ | null |
|
|
||
DecisionTreatDatePalliative | datetime | 16,3 | √ | null |
|
|
||
StartDatePalliative | datetime | 16,3 | √ | null |
|
|
||
TrialStatus | varchar | 2 | √ | null |
|
|
||
TrialType | int | 4 | √ | null |
|
|
||
DateDeath | datetime | 16,3 | √ | null |
|
|
||
DeathLocation | int | 4 | √ | null |
|
|
||
DeathCauseMethod | int | 4 | √ | null |
|
|
||
DeathCauseImmediate | varchar | 5 | √ | null |
|
|
||
DeathCauseCondition | varchar | 5 | √ | null |
|
|
||
DeathCauseUnderlying | varchar | 5 | √ | null |
|
|
||
DeathCauseSignificant | varchar | 5 | √ | null |
|
|
||
DiagnosticRouteBreast | varchar | 1 | √ | null |
|
|
||
EndocrineTherapyType | varchar | 1 | √ | null |
|
|
||
MarkerResultBreast | varchar | 1 | √ | null |
|
|
||
DiagnosticRouteColorectal | varchar | 1 | √ | null |
|
|
||
MarkerResultColorectal | varchar | 1 | √ | null |
|
|
||
PatientHistoryCancer | varchar | 5 | √ | null |
|
|
||
YearCancerDiagnosed | int | 4 | √ | null |
|
|
||
PreviousTreatmentCancer | varchar | 10 | √ | null |
|
|
||
DiagnosticRouteGynaecology | varchar | 1 | √ | null |
|
|
||
TumourStatus | varchar | 50 | √ | null |
|
|
||
Username | varchar | 50 | √ | null |
|
|