vwCWT_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NHSNumber varchar 10 √ null
PatientPathwayID varchar 20 √ null
PathwayIDOrgCode varchar 5 √ null
SourceReferral varchar 2 √ null
PriorityType varchar 1 √ null
ReferralDecisionDate varchar 10 √ null
ReferralReceivedDate varchar 10 √ null
ReferralType varchar 2 √ null
UpgradeDate varchar 10 √ null
UpgradeOrgCode varchar 5 √ null
FirstSeenDate varchar 10 √ null
FirstSeenOrgCode varchar 5 √ null
FirstSeenAdj int 4 √ null
FirstSeenAdjReason int 4 √ null
FirstSeenDelayComment varchar 500 √ null
FirstSeenDelayReason varchar 2 √ null
MDTDiscussionIndicator varchar 1 √ null
MDTDiscussionDate varchar 10 √ null
PatientStatus varchar 2 √ null
PrimaryDiagnosis varchar 5 √ null
MetastaticSite varchar 2 √ null
TumourLaterality varchar 1 √ null
TreatmentEventType varchar 2 √ null
DecisionTreatOrgCode varchar 5 √ null
DecisionTreatDate varchar 10 √ null
TreatmentStartDate varchar 10 √ null
TreatmentModality varchar 2 √ null
ClinicalTrial varchar 2 √ null
CareSetting varchar 2 √ null
TreatmentOrgCode varchar 5 √ null
RadiotherapyIntent varchar 2 √ null
RadiotherapyPriority varchar 2 √ null
DecisionTreatmentDelayComment varchar 500 √ null
DecisionTreatmentDelayReason varchar 2 √ null
TreatmentAdj int 4 √ null
TreatmentAdjReason int 4 √ null
RefTreatmentDelayComment varchar 500 √ null
RefTreatmentDelayReason varchar 2 √ null
UpgradeTreatmentDelayComment varchar 500 √ null
UpgradeTreatmentDelayReason varchar 2 √ null
Username varchar 50 √ null

View Definition

Possibly Referenced Tables/Views