expCWT_DATA


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NHSNumber varchar 10 √ null
NHSNumberStatusIndicator varchar 2 √ null
PatientPathwayId varchar 20 √ null
PatientPathwayIdIssuer varchar 5 √ null
SourceOfReferral varchar 2 √ null
PriorityTypeCode varchar 1 √ null
DecisionToReferDate datetime 16,3 √ null
CancerReferralToTreatmentStartDate datetime 16,3 √ null
TwoWeekWaitReferralType varchar 2 √ null
ConsultantUpgradeDate datetime 16,3 √ null
ProviderConsultantUpgradeSiteCode varchar 5 √ null
DateFirstSeen datetime 16,3 √ null
ProviderFirstSeenSiteCode varchar 5 √ null
FirstSeenWaitingTimeAdjustment int 4 √ null
FirstSeenWaitingTimeAdjustmentReason varchar 1 √ null
DelayReasonReferralToFirstSeen varchar 2 √ null
DelayReasonComment varchar 2147483647 √ null
DiscussionInd varchar 1 √ null
DiscussionDate datetime 16,3 √ null
PatientReferralStatus varchar 2 √ null
PrimaryDiagnosisICD varchar 5 √ null
TumourLaterality varchar 1 √ null
CancerTreatmentPeriodStartDate datetime 16,3 √ null
ProviderDecisionToTreatSiteCode varchar 5 √ null
ReferralRequestReceivedDateIPT datetime 16,3 √ null
TreatmentStartDate datetime 16,3 √ null
ProviderCancerTreatmentStartDateSiteCode varchar 5 √ null
CancerTreatmentEventType varchar 2 √ null
CancerTreatmentModality varchar 2 √ null
ClinicalTrialInd varchar 2 √ null
CancerTreatmentCareSetting varchar 2 √ null
RadiotherapyPriority varchar 1 √ null
DecisionToTreatmentDelayReason varchar 2 √ null
DecisionToTreatmentDelayReasonComment varchar 2147483647 √ null
TreatmentWaitingTimeAdjustment int 4 √ null
TreatmentWaitingTimeAdjustmentReason varchar 1 √ null
ReferralToTreatmentDelayReason varchar 2 √ null
ReferralToTreatmentDelayReasonComment varchar 2147483647 √ null
ConsultantUpgradeDelayReason varchar 2 √ null
ConsultantUpgradeDelayReasonComment varchar 2147483647 √ null
CARE_ID int 4 √ null
NSTS_Status int 4 √ null
Forename varchar 50 √ null
Surname varchar 60 √ null
HospitalNumber varchar 50 √ null
CancerSite varchar 50 √ null
DateOfBirth datetime 16,3 √ null
DateOfDeath datetime 16,3 √ null
ReferralReceivedDate datetime 16,3 √ null
DecisionToTreatDate datetime 16,3 √ null
DateDNA datetime 16,3 √ null
DateDiffFirstSeen int 4 √ null
DateDiffRefTx int 4 √ null
DateDiffDTTTx int 4 √ null
DateDiagnosis datetime 16,3 √ null
AgeAtDiagnosis int 4 √ null
Histology varchar 10 √ null
DateDTT datetime 16,3 √ null
Validated varchar 5 √ null
HasNoTumourStatus int 4 √ null
RefToTreatDelayCodeValidation int 4 √ null
UpgradeTreatmentDelayReasonValidation int 4 √ null
DecisionToTreatmentDelayReasonValidation int 4 √ null
Username varchar 50 √ null
Err70Helper bit 1 ((0))
Err69Helper bit 1 ((0))
Err68Helper bit 1 ((0))
SNOMedCT int 4 √ null
FirstAppointmentOffered bit 1 null
FirstAppointmentAdjustmentReason int 4 √ null

Diagram producer might be missing

No diagrams were produced please see application output for any errors