expSWCIS_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SWCIS_ID int identity 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
NHSNumber varchar 10 √ null
HospitalNumber varchar 10 √ null
OrgCodeSubmitting varchar 5 √ null
CareSpellID varchar 50 √ null
PatientSurname varchar 60 √ null
PatientForename varchar 50 √ null
PatientAddress varchar 500 √ null
PatientPostCode varchar 10 √ null
PatientSex int 4 √ null
PatientDOB datetime 16,3 √ null
RegisteredGP varchar 8 √ null
RegisteredPractice varchar 6 √ null
PatientPCT varchar 5 √ null
PatientSurnameBirth varchar 60 √ null
PatientEthnicity varchar 50 √ null
ReferralSource varchar 2 √ null
ReferringOrgCode varchar 6 √ null
ReferrerCode varchar 10 √ null
CancerReferralPriorityType varchar 2 √ null
CancerReferralDecisionDate datetime 16,3 √ null
ReferralRequestReceivedDate datetime 16,3 √ null
Consultant varchar 8 √ null
Specialty int 4 √ null
FirstSeenDate datetime 16,3 √ null
ReferralToFirstSeenDelayReason varchar 2 √ null
FirstSeenDelayReasonComment varchar 500 √ null
UrgentCancerReferralType varchar 2 √ null
CancerStatus varchar 2 √ null
FirstSeenAdjustment int 4 √ null
FirstSeenAdjustmentReason int 4 √ null
ReferralSourceOPA varchar 2 √ null
DiagnosisDate datetime 16,3 √ null
PrimaryDiagnosis varchar 5 √ null
TumourLaterality varchar 1 √ null
BasisDiagnosis int 4 √ null
Histology varchar 10 √ null
GradeDifferentiation varchar 2 √ null
PreTreatmentTStage varchar 5 √ null
CertaintyTStage varchar 2 √ null
PreTreatmentNStage varchar 5 √ null
CertaintyNStage varchar 2 √ null
PreTreatmentMStage varchar 5 √ null
CertaintyMStage varchar 2 √ null
PreTreatmentTNM varchar 50 √ null
CertaintyTNMStage char 10 √ null
Staging_Dukes varchar 20 √ null
Staging_NPI varchar 20 √ null
Staging_FIGO varchar 20 √ null
Staging_Breslow varchar 20 √ null
Staging_Clark varchar 100 √ null
Staging_Gleason varchar 20 √ null
FinalTNM varchar 50 √ null
FinalTStage varchar 5 √ null
FinalNStage varchar 5 √ null
FinalMStage varchar 5 √ null
DecisionTreatDatePalliative datetime 16,3 √ null
StartDatePalliative datetime 16,3 √ null
TrialStatus varchar 2 √ null
TrialType int 4 √ null
DateDeath datetime 16,3 √ null
DeathLocation int 4 √ null
DeathCauseMethod int 4 √ null
DeathCauseImmediate varchar 5 √ null
DeathCauseCondition varchar 5 √ null
DeathCauseUnderlying varchar 5 √ null
DeathCauseSignificant varchar 5 √ null
DiagnosticRouteBreast varchar 1 √ null
EndocrineTherapyType varchar 1 √ null
MarkerResultBreast varchar 1 √ null
DiagnosticRouteColorectal varchar 1 √ null
MarkerResultColorectal varchar 1 √ null
PatientHistoryCancer varchar 5 √ null
YearCancerDiagnosed int 4 √ null
PreviousTreatmentCancer varchar 10 √ null
DiagnosticRouteGynaecology varchar 1 √ null
CancerSite varchar 50 √ null
TumourStatus varchar 50 √ null
Username varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_expSWCIS_TEMP Primary key Asc SWCIS_ID
IX_expSWCIS_TEMP Performance Asc Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors