vwBAUS_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NHSNumber varchar 10 √ null
ConsultantNo int 4 √ null
ReferenceDate datetime 16,3 √ null
CentreNo int 4 √ null
HospitalNumber varchar 10 √ null
Sex int 4 √ null
DateBirth datetime 16,3 √ null
PostCode varchar 10 √ null
DateReferral datetime 16,3 √ null
SourceReferral int 4 √ null
OtherSource int 4 √ null
PriorityInitialReferral int 4 √ null
DateFirstConsultation datetime 16,3 √ null
DateDiagnosis datetime 16,3 √ null
DelayDiagnosis int 4 √ null
OtherDelay varchar 255 √ null
HistologicalConfirmation int 4 √ null
OtherDiagnosisBasis int 4 √ null
SpecifyOtherBasis varchar 255 √ null
Organ int 4 √ null
OtherOrgan varchar 255 √ null
Side int 4 √ null
Histology int 4 √ null
OtherHistology varchar 255 √ null
PathologyRefNumber varchar 50 √ null
HistologicalDifferentiation int 4 √ null
ClinicalTStage varchar 2 √ null
ClinicalNStage varchar 2 √ null
ClinicalMStage varchar 2 √ null
PSADiagnosis real 4 √ null
GleasonScore1 int 4 √ null
GleasonScore2 int 4 √ null
SCategory int 4 √ null
InitialTreatmentIntent int 4 √ null
InitialTreatmentType varchar 50 √ null
SpecifySurgery varchar 255 √ null
SpecifyLaparoscopic varchar 255 √ null
SpecifyTreatment varchar 255 √ null
PathTStage varchar 2 √ null
PathNStage varchar 2 √ null
PathMStage varchar 2 √ null
DateDefinitiveTreatment varchar 50 √ null
TrialStatus int 4 √ null
DiscussedMDT int 4 √ null
Complete int 4 √ null
DateDeath varchar 50 √ null
CauseDeath int 4 √ null
DateAdded datetime 16,3 √ null
DateAmended datetime 16,3 √ null
Username varchar 50 √ null

View Definition

Possibly Referenced Tables/Views