vwPTL_TEMP


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 20 √ null
NHSNumber varchar 12 √ null
DateDeath datetime 16,3 √ null
PatientPathwayID varchar 30 √ null
CancerSite varchar 50 √ null
Subtype nvarchar 30 √ 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 8000 √ null
PriorityType varchar 100 √ null
ReferralRoute nvarchar 200 √ null
RapidDiagnostic varchar 3 √ 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 70 √ 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

View Definition

Possibly Referenced Tables/Views