BIvwDiagnosisAndTargets


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Visit Number varchar 50 √ null
CareID int 4 null
Cancer Site varchar 50 √ null
Date Recipt of Referral smalldatetime 16 √ null
Date First Seen smalldatetime 16 √ null
Date of Diagnosis smalldatetime 16 √ null
Primary Diagnosis (ICD) varchar 203 √ null
Primary Diagnosis (SNOMED) nvarchar 566 √ null
NHS Number varchar 10 null
Hospital Number varchar 20 √ null
Surname varchar 60 √ null
Forename varchar 50 √ null
Date of Birth date 20 √ null
Referral Type varchar 100 √ null
Patient Status varchar 100 √ null
RTT Target Date smalldatetime 16 √ null
DTT Target Date smalldatetime 16 √ null
Faster Diagnosis End Date datetime 16,3 √ null

View Definition

Possibly Referenced Tables/Views