expTERTIARY_REFERRALS_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TERTIARY_ID int identity 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
PLAN_ID int 4 √ null
TReferralType varchar 50 √ null
NSTS_Status int 4 √ null
CancerSite varchar 50 √ null
DateFirstSeen datetime 16,3 √ null
DateDNA datetime 16,3 √ 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
PtAddress1 varchar 150 √ null
PtAddress2 varchar 150 √ null
PtAddress3 varchar 150 √ null
PtAddress4 varchar 150 √ null
PtPostCode varchar 10 √ null
RegisteredGP varchar 50 √ null
RegisteredGPCode varchar 8 √ null
RegisteredPracticeCode varchar 15 √ null
GPAddress1 varchar 50 √ null
GPAddress2 varchar 50 √ null
GPAddress3 varchar 50 √ null
GPAddress4 varchar 50 √ null
GPPostCode varchar 10 √ null
PCT varchar 50 √ null
PCTCode varchar 5 √ 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
DiagnosisDate smalldatetime 16 √ null
PrimaryDiagnosis varchar 5 √ null
TumourLaterality varchar 1 √ null
PtInformedDiagnosis varchar 3 √ null
RelativeCarerInformedDiagnosis varchar 3 √ null
TreatmentEventType varchar 2 √ null
MetastaticSite varchar 500 √ 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 int 4 √ null
TreatmentAdj int 4 √ null
TreatmentAdjReason int 4 √ null
RefTreatmentDelayComment varchar 500 √ null
RefTreatmentDelayReason int 4 √ null
DecisionTreatAdj int 4 √ null
DecisionTreatAdjReason int 4 √ null
TertiaryReferralDate smalldatetime 16 √ null
TertiaryReferral varchar 5 √ null
TertiaryReferralReason int 4 √ null
TertiaryReferralReasonDesc varchar 100 √ null
CWTComments varchar 500 √ null
DiagnosisComments varchar 500 √ null
Username varchar 50 √ null
NhsNumberStatus varchar 3 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_expTERTIARY_REFERRALS_TEMP Primary key Asc TERTIARY_ID
IX_expTERTIARY_REFERRALS_TEMP Performance Asc Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors