rptCWT_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CWT_ID int identity 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
NSTS_Status int 4 √ null
CancerSite varchar 50 √ null
DateFirstSeen 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
DateTreatment datetime 16,3 √ null
NHSNumber varchar 10 √ null
HospitalNumber varchar 10 √ null
Forename varchar 50 √ null
Surname varchar 60 √ null
DateBirth datetime 16,3 √ null
Gender varchar 1 √ null
DateDeath datetime 16,3 √ null
PatientPathwayID varchar 20 √ null
PathwayIDOrgCode varchar 5 √ null
ReferralDecisionDate varchar 10 √ null
SourceReferral varchar 2 √ null
PriorityType varchar 2 √ 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
TumourLaterality varchar 1 √ null
TreatmentEventType varchar 2 √ null
MetastaticSite varchar 2 √ null
DecisionTreatOrgCode varchar 5 √ null
DecisionTreatDate varchar 10 √ null
TreatmentStartDate varchar 10 √ null
TreatmentModality varchar 2 √ null
CareSetting varchar 2 √ null
ClinicalTrial varchar 2 √ null
TreatmentOrgCode varchar 5 √ null
RadiotherapyPriority varchar 2 √ null
RadiotherapyIntent 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
Err1 int 4 √ null
Err2 int 4 √ null
Err3 int 4 √ null
Err4 int 4 √ null
Err5 int 4 √ null
Err6 int 4 √ null
Err7 int 4 √ null
Err8 int 4 √ null
Err9 int 4 √ null
Err10 int 4 √ null
Err11 int 4 √ null
Err12 int 4 √ null
Err13 int 4 √ null
Err14 int 4 √ null
Err15 int 4 √ null
Err16 int 4 √ null
Err17 int 4 √ null
Err18 int 4 √ null
Err19 int 4 √ null
Err20 int 4 √ null
Err21 int 4 √ null
Err22 int 4 √ null
Err23 int 4 √ null
Err24 int 4 √ null
Err25 int 4 √ null
Err26 int 4 √ null
Err27 int 4 √ null
Err28 int 4 √ null
Err29 int 4 √ null
Err30 int 4 √ null
Err31 int 4 √ null
Err32 int 4 √ null
Err33 int 4 √ null
Err34 int 4 √ null
Err35 int 4 √ null
Err36 int 4 √ null
Err37 int 4 √ null
Err38 int 4 √ null
Err39 int 4 √ null
Err40 int 4 √ null
Err41 int 4 √ null
Err42 int 4 √ null
Err43 int 4 √ null
Err44 int 4 √ null
Err45 int 4 √ null
Err46 int 4 √ null
Err47 int 4 √ null
Err48 int 4 √ null
Err49 int 4 √ null
Err50 int 4 √ null
Err51 int 4 √ null
Err52 int 4 √ null
Err53 int 4 √ null
Err54 int 4 √ null
Err55 int 4 √ null
Err56 int 4 √ null
Err57 int 4 √ null
Err58 int 4 √ null
Err59 int 4 √ null
Err60 int 4 √ null
Err61 int 4 √ null
Err62 int 4 √ null
Err63 int 4 √ ((0))
Err64 int 4 √ ((0))
Err65 int 4 √ ((0))
Err66 int 4 √ ((0))
Err67 int 4 √ ((0))
Chk1 int 4 √ null
Username varchar 50 √ null
Err68 int 4 √ null
Err69 int 4 √ null
Err70 int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_rptCWT_TEMP Primary key Asc CWT_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors