vwRPT_PTL_31_3


Columns

Column Type Size Nulls Auto Default Children Parents Comments
Surname varchar 60 √ null
Forename varchar 50 √ null
DateBirth datetime 16,3 √ null
HospitalNumber varchar 10 √ null
NHSNumber varchar 10 √ null
DateDeath datetime 16,3 √ null
CancerSite varchar 50 √ null
TargetDate62Days datetime 16,3 √ null
DaysTo62DayBreach int 4 √ null
WaitingTimeRefTreatment int 4 √ null
DaysTo62DayBreachNoDTT int 4 √ null
TargetDate31Days datetime 16,3 √ null
DaysTo31DayBreach int 4 √ null
WaitingTimeDTTTreatment int 4 √ null
TrackingNotes varchar 500 √ null
PriorityType varchar 100 √ null
TumourStatus varchar 50 √ null
PatientStatus varchar 100 √ null
DateReceipt datetime 16,3 √ null
DateFirstSeen datetime 16,3 √ null
OrgCodeFirstSeen varchar 5 √ null
FirstSeenAdjTime int 4 √ null
FirstSeenAdjReason varchar 50 √ null
DateConsultantUpgrade datetime 16,3 √ null
OrgCodeUpgrade varchar 5 √ null
Consultant varchar 50 √ null
DateDiagnosis datetime 16,3 √ null
Diagnosis varchar 150 √ null
Treatment varchar 60 √ null
TreatmentSetting varchar 50 √ null
DateDecisionTreat datetime 16,3 √ null
DateTreatment datetime 16,3 √ null
OrgCodeTreatment varchar 5 √ null
FirstSeenDTTAdjTime int 4 √ null
FirstSeenDTTAdjReason varchar 150 √ null
DTTTreatmentAdjTime int 4 √ null
DTTTreatmentAdjReason varchar 150 √ null
ReportDate datetime 16,3 √ null
Username varchar 50 √ null
UrgentCancerType varchar 2 √ null
AgeAtDiagnosis int 4 √ null
DiagnosisCode varchar 5 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null

View Definition

Possibly Referenced Tables/Views