rptNBOCAP_TUMOUR_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NBOCAP_ID int identity 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
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
DateMDT datetime 16,3 √ null
MDT varchar 1 √ null
Username varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_rptNBOCAP_TUMOUR_TEMP Primary key Asc NBOCAP_ID
IX_rptNBOCAP_TUMOUR_TEMP Performance Asc Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors