CWTReferralData


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CareID int 4 null
PatientID int 4 null
NHSNumber varchar 10 √ null
HospitalNumber varchar 50 √ null
Surname varchar 60 √ null
Forename varchar 50 √ null
Gender char 1 √ null
CancerSite varchar 50 √ null
DateOfBirth date 20 √ null
DateOfDeath date 20 √ null
PPI varchar 20 √ null
SourceOfReferralForOutpatients varchar 2 √ null
CancerType varchar 2 √ null
PriorityType varchar 2 √ null
DateDecisionToRefer smalldatetime 16 √ null
DateReceipt smalldatetime 16 √ null
DateFirstSeen smalldatetime 16 √ null
DateUpgrade smalldatetime 16 √ null
CancerStatus varchar 2 √ null
Diagnosis1 varchar 5 √ null
Diagnosis2 varchar 5 √ null
DateDiagnosis smalldatetime 16 √ null
TumourStatus int 4 √ null
DateDTT smalldatetime 16 √ null
DateTreatmentStart smalldatetime 16 √ null
TreatmentEvent varchar 2 √ null
TreatmentSetting varchar 2 √ null
TreatNo int 4 √ null
AdjustmentReason int 4 √ null
DateCancelled smalldatetime 16 √ null
AdjustmentDays int 4 √ null
AdjustmentCode int 4 √ null
FirstApptOffered int 4 √ null
DatePatientInformed smalldatetime 16 √ null
FasterDiagnosisExclusionDate datetime 16,3 √ null
OrgFirstSeen varchar 5 √ null
OrgUpgrade varchar 5 √ null
OrgTreatment varchar 5 √ null
OrgDTT varchar 5 √ null
Morphology varchar 10 √ null
MorphologySNOMED int 4 √ null
DiagnosisSNOMED int 4 √ null
TreatmentID int 4 √ null
TreatmentType char 2 √ null
FasterDiagnosisOrganisation int 4 √ null
FasterDiagnosisSiteOverride int 4 √ null
TransferReason int 4 √ null
IsTransfer bit 1 null
IsOtherSite bit 1 null
IsNoCancerStatus bit 1 null
IsNoTreatment bit 1 null
IsBCC bit 1 null
IsNonCancerDiagnosis bit 1 null
OffAllCWTPaths bit 1 null
OffCWTTreatmentPathA bit 1 null
OffCWTTreatmentPathB bit 1 null
OffCWTTreatmentPathC bit 1 null
AgeRefRcvd int 4 √ null
AgeAtDiagnosis int 4 √ null
IsRecurrenceOrMets bit 1 null
IsSuspectedRecurrence bit 1 null
IsFirstTreatment bit 1 null
IsUrgent bit 1 null
Is2WW bit 1 null
IsScreening bit 1 null
IsBreastSymptomatic bit 1 null
IsSuspectedLeukaemia bit 1 null
IsSuspectedTesticular bit 1 null
IsLeukaemia bit 1 null
IsAdmission bit 1 null
IsNoSubsequentTreatmentPlanned bit 1 null
IsPrimaryToTransformationProgressionExclusion bit 1 null
IsTransformationProgression bit 1 null
IsPrimaryReferral bit 1 null
InappropriateReferral int 4 √ null
Subtype varchar 50 √ null
IsSuspectedChildrens bit 1 null
PCTCode varchar 5 √ null
PCTDesc varchar 100 √ null
TargetDate62Days date 20 √ null
RTTRow int 4 √ null
MinRow int 4 √ null
MinDecisionDate smalldatetime 16 √ null
MinTreatNo int 4 √ null
IsCWT2WW bit 1 null
IsCWTScreening bit 1 null
IsCWTUpgrade bit 1 null
ALTCWTDTTorECAD int 4 null
CWTDTTorECAD int 4 null
Special varchar 2 √ null
IsCWTFDP bit 1 null
FirstSeenAdjTime int 4 null
FirstSeenAdjReason int 4 √ null
DTTTreatmentADJTime int 4 null
DTTTreatmentADJReason int 4 √ null
CWT2WWRTT int 4 null
FirstSeenAdjTimeUpgrade int 4 null
FDPPathwayEndDate smalldatetime 16 √ null
minFDPPathwayEndDate smalldatetime 16 √ null
TWWTargetDate smalldatetime 16 √ null
TWWWait int 4 √ null
RTTTargetDate smalldatetime 16 √ null
RTTWait int 4 √ null
DTTECADTargetDate smalldatetime 16 √ null
DTTECADWait int 4 √ null
RTTScreeningTargetDate smalldatetime 16 √ null
RTTScreeningWait int 4 √ null
RTTUpgradeTargetDate smalldatetime 16 √ null
RTTUpgradeWait int 4 √ null
FDPTargetDate smalldatetime 16 √ null
FDPWait int 4 √ null
TabNon_Pathway int 4 √ null
OrgCodeFDP varchar 5 √ null
Username varchar 100 √ null

Diagram producer might be missing

No diagrams were produced please see application output for any errors