Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
RecordType | int | 4 | null |
|
|
|||
NHSNumber | varchar | 10 | null |
|
|
|||
CareSpellNumber | varchar | 22 | null |
|
|
|||
OriginatingOrgCode | varchar | 10 | null |
|
|
|||
FirstSeenOrgCode | varchar | 5 | √ | null |
|
|
||
DateClinicalDiagnosis | datetime | 16,3 | √ | null |
|
|
||
DateDiagnosis | datetime | 16,3 | √ | null |
|
|
||
ReferralSource | varchar | 2 | √ | null |
|
|
||
DiagnosticRoute | int | 4 | √ | null |
|
|
||
DateReferralReceipt | datetime | 16,3 | √ | null |
|
|
||
PriorityReferral | varchar | 2 | √ | null |
|
|
||
DateFirstAppointment | datetime | 16,3 | √ | null |
|
|
||
MajorSiteCode | int | 4 | √ | null |
|
|
||
SyncCaecum | varchar | 1 | √ | null |
|
|
||
SyncAppendix | varchar | 1 | √ | null |
|
|
||
SyncAscending | varchar | 1 | √ | null |
|
|
||
SyncHepatic | varchar | 1 | √ | null |
|
|
||
SyncTransverse | varchar | 1 | √ | null |
|
|
||
SyncSplenic | varchar | 1 | √ | null |
|
|
||
SyncDescending | varchar | 1 | √ | null |
|
|
||
SyncSigmoid | varchar | 1 | √ | null |
|
|
||
SyncRectoSigmoid | varchar | 1 | √ | null |
|
|
||
SyncRectum | varchar | 1 | √ | null |
|
|
||
HeightAboveAnalVerge | real | 4 | √ | null |
|
|
||
DukesStage | varchar | 2 | √ | null |
|
|
||
DateColonoscopy | datetime | 16,3 | √ | null |
|
|
||
ResultColonoscopy | int | 4 | √ | null |
|
|
||
IncompleteReason | int | 4 | √ | null |
|
|
||
ColonoscopyComplications | int | 4 | √ | null |
|
|
||
DateBariumEnema | datetime | 16,3 | √ | null |
|
|
||
ResultBariumEnema | int | 4 | √ | null |
|
|
||
CTColonography | int | 4 | √ | null |
|
|
||
DateCT | datetime | 16,3 | √ | null |
|
|
||
ResultCT | varchar | 2 | √ | null |
|
|
||
DateFirstMRI | datetime | 16,3 | √ | null |
|
|
||
ResultFirstMRI_T | varchar | 2 | √ | null |
|
|
||
ResultFirstMRI_N | varchar | 2 | √ | null |
|
|
||
MarginsThreatenedFirstMRI | varchar | 1 | √ | null |
|
|
||
DateSecondMRI | datetime | 16,3 | √ | null |
|
|
||
ResultSecondMRI | varchar | 2 | √ | null |
|
|
||
DateEndoanalUSS | datetime | 16,3 | √ | null |
|
|
||
ResultEndoanalUSS | varchar | 2 | √ | null |
|
|
||
DateAbdominalUSS | datetime | 16,3 | √ | null |
|
|
||
ResultAbdominalUSS | varchar | 2 | √ | null |
|
|
||
PreTreatmentTStage | varchar | 2 | √ | null |
|
|
||
PreTreatmentNStage | varchar | 2 | √ | null |
|
|
||
PreTreatmentMStage | varchar | 2 | √ | null |
|
|
||
LiverMets | int | 4 | √ | null |
|
|
||
LungMets | int | 4 | √ | null |
|
|
||
BoneMets | int | 4 | √ | null |
|
|
||
OtherMets | int | 4 | √ | null |
|
|
||
MDT | varchar | 1 | √ | null |
|
|
||
Username | varchar | 50 | √ | null |
|
|