tblMAIN_REFERRALS


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int identity 4 √ null
lnkDiagnosisAddress.CareID FK_lnkDiagnosisAddress_tblMAIN_REFERRALS1R
lnkPretextAnnotationFactors.CareID FK_lnkPretextAnnotationFactors_tblMAIN_REFERRALSR
lnkPretextAnnotationFactorsMDT.CareID FK_lnkPretextAnnotationFactorsMDT_tblMAIN_REFERRALSC
NOGCAProformaData.CareID FK_NOGCAProformaData_tblMAIN_REFERRALSR
tblAHP_CONTACTS.CARE_ID FK_tblAHP_CONTACTS_tblMAIN_REFERRALSC
tblAllTreatmentDeclined.CARE_ID FK_tblAllTreatmentDeclined_tblMAIN_REFERRALSC
tblBRAIN_MDT.CARE_ID FK_tblBRAIN_MDT_tblMAIN_REFERRALSC
tblBREAST_MDT.CARE_ID FK_tblBREAST_MDT_tblMAIN_REFERRALSC
tblBREAST_VISITS.CARE_ID FK_tblBREAST_VISITS_tblMAIN_REFERRALSC
tblCNSContact.CareID FK_tblCNSContact_tblMAIN_REFERRALSC
tblCNSInitialReferral.CareID FK_tblCNSInitialReferral_tblMAIN_REFERRALSC
tblCNSTriage.CareID FK_tblCNSTriage_tblMAIN_REFERRALSC
tblCOLORECTAL_MDT.CARE_ID FK_tblCOLORECTAL_MDT_tblMAIN_REFERRALSC
tblCOSD_CTYA.CARE_ID FK_tblCOSD_CTYA_tblMAIN_REFERRALSC
tblCUP_MDT.CARE_ID FK_tblCUP_MDT_tblMAIN_REFERRALSC
tblDEFINITIVE_TREATMENT.CARE_ID FK_tblDEFINITIVE_TREATMENT_tblMAIN_REFERRALSC
tblDERMATOLOGY_RECURRENCES.CARE_ID FK_tblDERMATOLOGY_RECURRENCES_tblMAIN_REFERRALSC
tblGYNAECOLOGY_MDT.CARE_ID FK_tblGYNAECOLOGY_MDT_tblMAIN_REFERRALSC
tblHAEM_RELAPSE_TRANSFORM.CARE_ID FK_tblHAEM_RELAPSE_TRANSFORM_tblMAIN_REFERRALSC
tblHAEMATOLOGY_MDT.CARE_ID FK_tblHAEMATOLOGY_MDT_tblMAIN_REFERRALSC
tblHEAD_NECK_MDT.CARE_ID FK_tblHEAD_NECK_MDT_tblMAIN_REFERRALSC
tblHIGH_GRADE_DYSPLASIA.CARE_ID FK_tblHIGH_GRADE_DYSPLASIA_tblMAIN_REFERRALSC
tblINITIAL_ASSESSMENT.CARE_ID FK_tblINITIAL_ASSESSMENT_tblMAIN_REFERRALSC
tblINPATIENT_ADMISSIONS.CARE_ID FK_tblINPATIENT_ADMISSIONS_tblMAIN_REFERRALSC
tblLinkedReferrals.LinkedCareID FK_tblLinkedReferrals_tblMAIN_REFERRALS1R
tblLinkedReferrals.OriginalCareID FK_tblLinkedReferrals_tblMAIN_REFERRALSR
tblLUNG_MDT.CARE_ID FK_tblLUNG_MDT_tblMAIN_REFERRALSC
tblMAIN_ASSESSMENT.CARE_ID FK_tblMAIN_ASSESSMENT_tblMAIN_REFERRALSC
tblMAIN_BRACHYTHERAPY.CARE_ID FK_tblMAIN_BRACHYTHERAPY_tblMAIN_REFERRALSC
tblMAIN_CARE_PLAN.CARE_ID FK_tblMAIN_CARE_PLAN_tblMAIN_REFERRALSC
tblMAIN_CHEMOTHERAPY.CARE_ID FK_tblMAIN_CHEMOTHERAPY_tblMAIN_REFERRALSC
tblMAIN_PALLIATIVE.CARE_ID FK_tblMAIN_PALLIATIVE_tblMAIN_REFERRALSC
tblMAIN_PATHOLOGY.CARE_ID FK_tblMAIN_PATHOLOGY_tblMAIN_REFERRALSC
tblMAIN_SURGERY.CARE_ID FK_tblMAIN_SURGERY_tblMAIN_REFERRALSC
tblMAIN_TELETHERAPY.CARE_ID FK_tblMAIN_TELETHERAPY_tblMAIN_REFERRALSC
tblMAIN_TRIAL.CARE_ID FK_tblMAIN_TRIAL_tblMAIN_REFERRALSC
tblMetastases.CareID FK_tblMetastases_tblMAIN_REFERRALSR
tblMetsMDT.CareID FK_tblMetsMDT_tblMAIN_REFERRALSR
tblMONITORING.CARE_ID FK_tblMONITORING_tblMAIN_REFERRALSC
tblNonPrimaryPathway.CareID FK_tblNonPrimaryPathway_tblMAIN_REFERRALSR
tblOTHER_MDT.CARE_ID FK_tblOTHER_MDT_tblMAIN_REFERRALSC
tblOTHER_TREATMENT.CARE_ID FK_tblOTHER_TREATMENT_tblMAIN_REFERRALSC
tblPAEDIATRIC_MDT.CARE_ID FK_tblPAEDIATRIC_MDT_tblMAIN_REFERRALSC
tblPathwayUpdateEvents.CareID FK_tblPathwayUpdateEvents_CareIDR
tblRDCClinicalTriageDiagnosticTesting.CareID FK_tblRDCClinicalTriageDiagnosticTesting_tblMAIN_REFERRALSC
tblRDCDiagnosis.CareID FK_tblRDCDiagnosis_tblMAIN_REFERRALSC
tblRDCPresentation.CareID FK_tblRDCPresentation_tblMAIN_REFERRALSC
tblREFERRAL_BRAIN.CARE_ID FK_tblREFERRAL_BRAIN_tblMAIN_REFERRALSC
tblREFERRAL_BREAST.CARE_ID FK_tblREFERRAL_BREAST_tblMAIN_REFERRALSC
tblREFERRAL_COLORECTAL.CARE_ID FK_tblREFERRAL_COLORECTAL_tblMAIN_REFERRALSC
tblREFERRAL_CUP.CARE_ID FK_tblREFERRAL_CUP_tblMAIN_REFERRALSC
tblREFERRAL_DERMATOLOGY.CARE_ID FK_tblREFERRAL_DERMATOLOGY_tblMAIN_REFERRALSC
tblREFERRAL_GYNAECOLOGY.CARE_ID FK_tblREFERRAL_GYNAECOLOGY_tblMAIN_REFERRALSC
tblREFERRAL_HAEMATOLOGY.CARE_ID FK_tblREFERRAL_HAEMATOLOGY_tblMAIN_REFERRALSC
tblREFERRAL_HEAD_NECK.CARE_ID FK_tblREFERRAL_HEAD_NECK_tblMAIN_REFERRALSC
tblREFERRAL_LUNG.CARE_ID FK_tblREFERRAL_LUNG_tblMAIN_REFERRALSC
tblREFERRAL_OTHER.CARE_ID FK_tblREFERRAL_OTHER_tblMAIN_REFERRALSC
tblREFERRAL_PAEDIATRICS.CARE_ID FK_tblREFERRAL_PAEDIATRICS_tblMAIN_REFERRALSC
tblREFERRAL_SARCOMA.CARE_ID FK_tblREFERRAL_SARCOMA_tblMAIN_REFERRALSC
tblREFERRAL_UPPER_GI.CARE_ID FK_tblREFERRAL_UPPER_GI_tblMAIN_REFERRALSC
tblREFERRAL_UROLOGY.CARE_ID FK_tblREFERRAL_UROLOGY_tblMAIN_REFERRALSC
tblROOT_CAUSE_EVENTS.CARE_ID FK_tblROOT_CAUSE_EVENTS_tblMAIN_REFERRALSC
tblROOT_CAUSE_NOTES.CARE_ID FK_tblROOT_CAUSE_NOTES_tblMAIN_REFERRALSC
tblSARCOMA_MDT.CARE_ID FK_tblSARCOMA_MDT_tblMAIN_REFERRALSC
tblSCORES.CARE_ID FK_tblSCORES_tblMAIN_REFERRALSC
tblSKIN_MDT.CARE_ID FK_tblSKIN_MDT_tblMAIN_REFERRALSC
tblSUPPORTIVE_TREATMENT.CARE_ID FK_tblSUPPORTIVE_TREATMENT_tblMAIN_REFERRALSC
tblTERTIARY_REFERRAL.CARE_ID FK_tblTERTIARY_REFERRAL_tblMAIN_REFERRALSC
tblTERTIARY_REFERRALS_NEW.CARE_ID FK_tblTERTIARY_REFERRALS_NEW_tblMAIN_REFERRALSC
tblTERTIARY_REFERRALS_RECIEVED.CARE_ID FK_tblTERTIARY_REFERRALS_RECIEVED_tblMAIN_REFERRALSC
tblTNM_VERSION_HISTORY_LOCAL.CARE_ID FK_tblTNM_VERSION_HISTORY_LOCAL_tblMAIN_REFERRALSC
tblTRACKING_COMMENTS.CARE_ID FK_tblTRACKING_COMMENTS_tblMAIN_REFERRALSC
tblTREATMENT_SUMMARY.CARE_ID FK_tblTREATMENT_SUMMARY_tblMAIN_REFERRALSC
tblUGI_MDT.CARE_ID FK_tblUGI_MDT_tblMAIN_REFERRALSC
tblUROLOGY_MDT.CARE_ID FK_tblUROLOGY_MDT_tblMAIN_REFERRALSC
TimedPathwayAssociation.CARE_ID FK_TimedPathwayAssociation_tblMAIN_REFERRALSR
TimedPathwayEventLink.CARE_ID FK_TimedPathwayEventLink_tblMAIN_REFERRALSR

Referral Record ID
PATIENT_ID int 4 null
tblDEMOGRAPHICS.PATIENT_ID FK_tblMAIN_REFERRALS_tblDEMOGRAPHICSC

Demographic Record ID
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
L_CANCER_SITE varchar 50 √ null

Cancer Site
N2_1_REFERRAL_SOURCE varchar 2 √ null

CWT Referral Source (derived from N2_16_OP_REFERRAL)
N2_2_ORG_CODE_REF varchar 6 √ null

Referring Organisation
N2_3_REFERRER_CODE varchar 10 √ null

Code of referrer
N2_4_PRIORITY_TYPE varchar 2 √ null

Priority Type
N2_5_DECISION_DATE smalldatetime 16 √ null

Date Decision to Refer
N2_6_RECEIPT_DATE smalldatetime 16 √ null

Date Receipt of Referral
N2_7_CONSULTANT varchar 8 √ null

Specialist Referral - Consultant
N2_8_SPECIALTY int 4 √ null

Specialist Referral - Specialty
N2_9_FIRST_SEEN_DATE smalldatetime 16 √ null

Date First Appointment
N1_3_ORG_CODE_SEEN varchar 5 √ null

Organisation (Provider First Seen)
N2_10_FIRST_SEEN_DELAY varchar 2 √ null

Delay Reason (Receipt to First Seen)
N2_12_CANCER_TYPE varchar 2 √ null

Referral Type
N2_13_CANCER_STATUS varchar 2 √ null

Patient Status
L_FIRST_APPOINTMENT int 4 √ null

Was this the first appt offered
L_CANCELLED_DATE smalldatetime 16 √ null

Date DNA Appt Re-Booked
N2_14_ADJ_TIME int 4 √ null

Waiting Time Adjustment (First Appointment)
N2_15_ADJ_REASON int 4 √ null

Adjustment Reason (First Appointment)
L_REFERRAL_METHOD int 4 √ null

Method of Referral
N2_16_OP_REFERRAL varchar 2 √ null

Source of Referral for Outpatients
L_SPECIALIST_DATE smalldatetime 16 √ null

Date Referred to Specialist
L_ORG_CODE_SPECIALIST varchar 5 √ null

Organisation (Referred From)
L_SPECIALIST_SEEN_DATE smalldatetime 16 √ null

Date First Appt with Specialist
N1_3_ORG_CODE_SPEC_SEEN varchar 5 √ null

Organisation (First Appt Specialist)
N_UPGRADE_DATE smalldatetime 16 √ null

Date Consultant Upgrade
N_UPGRADE_ORG_CODE varchar 5 √ null

Organisation (Consultant Upgrade)
L_UPGRADE_WHEN int 4 √ null

When Patient Upgraded
L_UPGRADE_WHO int 4 √ null

Patient Upgraded By
N4_1_DIAGNOSIS_DATE smalldatetime 16 √ null

Date of Diagnosis (Clinically Agreed)
L_DIAGNOSIS varchar 5 √ null

Primary Diagnosis (Group)
N4_2_DIAGNOSIS_CODE varchar 5 √ null

Primary Diagnosis (Code)
L_ORG_CODE_DIAGNOSIS varchar 5 √ null

Organisation diagnosed at
L_PT_INFORMED_DATE smalldatetime 16 √ null

Date Patient Informed
L_OTHER_DIAG_DATE smalldatetime 16 √ null

Other Diagnosis Date
N4_3_LATERALITY varchar 1 √ null

Laterality
N4_4_BASIS_DIAGNOSIS int 4 √ null

Basis of Diagnosis
L_TOPOGRAPHY varchar 7 √ null

Topography (ICDO3)
L_HISTOLOGY_GROUP int 4 √ null

Morphology Group (SNOMed) (Haematology/Paediatrics Only)
N4_5_HISTOLOGY varchar 10 √ null

Morphology Code (SNOMed)
N4_6_DIFFERENTIATION varchar 2 √ null

Grade of Differentiation
ClinicalTStage varchar 5 √ null

Final Pre-Treatment (Clinical) Staging - T Stage
ClinicalTCertainty varchar 2 √ null

Final Pre-Treatment (Clinical) Staging - Certainty Factors - T
ClinicalNStage varchar 5 √ null

Final Pre-Treatment (Clinical) Staging - N Stage
ClinicalNCertainty varchar 2 √ null

Final Pre-Treatment (Clinical) Staging - Certainty Factors - N
ClinicalMStage varchar 5 √ null

Final Pre-Treatment (Clinical) Staging - M Stage
ClinicalMCertainty varchar 2 √ null

Final Pre-Treatment (Clinical) Staging - Certainty Factors - M
ClinicalOverallCertainty varchar 2 √ null

Final Pre-Treatment (Clinical) Staging - Certainty Factors - Overall
N6_9_SITE_CLASSIFICATION varchar 2 √ null

Site Specific Staging Value (Ann Arbor/Dukes/Ennking)
PathologicalOverallCertainty varchar 2 √ null

Final (Integrated) Staging - Certainty Factors - Overall
PathologicalTCertainty varchar 2 √ null

Final (Integrated) Staging - Certainty Factors - T
PathologicalTStage varchar 5 √ null

Final (Integrated) Staging - T Stage
PathologicalNCertainty varchar 2 √ null

Final (Integrated) Staging - Certainty Factors - N
PathologicalNStage varchar 5 √ null

Final (Integrated) Staging - N Stage
PathologicalMCertainty varchar 2 √ null

Final (Integrated) Staging - Certainty Factors - M
PathologicalMStage varchar 5 √ null

Final (Integrated) Staging - M Stage
L_GP_INFORMED int 4 √ null

GP Informed of Diagnosis
L_GP_INFORMED_DATE smalldatetime 16 √ null

Date GP Informed
L_GP_NOT varchar 255 √ null

Reason Not Informed
L_REL_INFORMED int 4 √ null

Relative/Carer Informed of Diagnosis
L_NURSE_PRESENT varchar 3 √ null

Spec. Nurse Present when Pt. Informed
L_SPEC_NURSE_DATE smalldatetime 16 √ null
L_SEEN_NURSE_DATE smalldatetime 16 √ null

Date First Seen by CNS
N16_1_ADJ_DAYS int 4 √ null

Receipt of Referral to Treatment - Waiting Time Adjustment
N16_2_ADJ_DAYS int 4 √ null

Decision to Treat to Treatment - Waiting Time Adjustment
N16_3_ADJ_DECISION_CODE int 4 √ null
ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.Code Implied ConstraintR

Receipt of Referral to Treatment - Adjustment Reason
N16_4_ADJ_TREAT_CODE int 4 √ null
ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.Code Implied ConstraintR

Decision to Treat to Treatment - Adjustment Reason
N16_5_DECISION_REASON_CODE int 4 √ null

Receipt of Referral to Treatment - Delay Reason
N16_6_TREATMENT_REASON_CODE int 4 √ null

Decision to Treat to Treatment - Delay Reason
PathologicalTNMDate smalldatetime 16 √ null

Final (Integrated) Staging - Date
ClinicalTNMDate smalldatetime 16 √ null

Final Pre-Treatment (Clinical) Staging - Date
L_FIRST_CONSULTANT varchar 8 √ null

Consultant (First Appointment)
L_APPROPRIATE int 4 √ null

Was initial referral made to appropriate specialist
L_TERTIARY_DATE smalldatetime 16 √ null

Date Referred (Tertiary Centre)
L_TERTIARY_TRUST varchar 5 √ null

Organisation (Tertiary Centre)
L_TERTIARY_REASON int 4 √ null

Reason for Referral (Tertiary Centre)
L_INAP_REF int 4 √ null

Other Tumour Site - Make New Referral? No longer used
L_NEW_CA_SITE varchar 20 √ null

Other Tumour Site - New Tumour Site No longer used
L_AUTO_REF int 4 √ null

Whether referral has been moved from another
L_SEC_DIAGNOSIS_G varchar 5 √ null

Other Tumour Site - Diagnosis (Group)
L_SEC_DIAGNOSIS varchar 5 √ null

Other Tumour Site - Diagnosis (Code)
L_WRONG_REF int 4 √ null

Appropriateness of Referral
L_WRONG_REASON varchar 2147483647 √ null

Reason Inappropriate
L_TUMOUR_STATUS int 4 null
ltblCA_STATUS.STATUS_CODE FK_tblMAIN_REFERRALS_ltblCA_STATUSR

Tumour Status
L_NON_CANCER varchar 255 √ null

Non-cancer Details
L_FIRST_APP int 4 √ null
ltblAPP_TYPE.TYPE_CODE FK_tblMAIN_REFERRALS_ltblAPP_TYPER

First Appointment Type
L_NO_APP int 4 √ null

Reason No Appointment
L_DIAG_WHO int 4 √ null

Assessed By
L_RECURRENCE int 4 √ null

Not in use
L_OTHER_SYMPS text 2147483647 √ null

Other Symptoms
L_COMMENTS text 2147483647 √ null

Additional Comments
N2_11_FIRST_SEEN_REASON text 2147483647 √ null

Two Week Wait - Delay Reason Comments
N16_7_DECISION_REASON text 2147483647 √ null

Receipt of Referral to Treatment - Delay Reason Comments
N16_8_TREATMENT_REASON text 2147483647 √ null

Decision to Treat to Treatment - Delay Reason Comments
L_DIAGNOSIS_COMMENTS text 2147483647 √ null

Diagnosis Comments
GP_PRACTICE_CODE varchar 15 √ null

Referring GP Practice Code
ClinicalTNMGroup varchar 50 √ null

TNM Stage Grouping (Final Pre Treatment)
PathologicalTNMGroup varchar 50 √ null

TNM Stage Grouping (Final Integrated)
L_KEY_WORKER_SEEN varchar 1 √ null

Was patient seen by key worker other than CNS/Pall Care
L_PALLIATIVE_SPECIALIST_SEEN varchar 1 √ null

Palliative Care Specialist Seen Indicator
GERM_CELL_NON_CNS_ID int 4 √ null

TNM Stage Grouping for Non-CNS Germ Cell Tumours
RECURRENCE_CANCER_SITE_ID int 4 √ null

Cancer Site of Recurrence
ICD03_GROUP int 4 √ null

Morphology (ICDO3) (Group)
ICD03 varchar 6 √ null

Morphology (ICDO3)
L_DATE_DIAGNOSIS_DAHNO_LUCADA smalldatetime 16 √ null

Date of Diagnosis (DAHNO/LUCADA)
L_INDICATOR_CODE varchar 2 √ null

CNS Seen By Indication Code
PRIMARY_DIAGNOSIS_SUB_COMMENT varchar 50 √ null

Primary Diagnosis Subsidiary Comment
CONSULTANT_CODE_AT_DIAGNOSIS varchar 8 √ null

Consultant (at diagnosis)
CONSULTANT_AGE_SPECIALTY_AT_DIAGNOSIS varchar 1 √ null

Consultant Age Specialty (at diagnosis)
FETOPROTEIN int 4 √ null

Alpha Fetoprotein (Cerebrospinal Fluid)
GONADOTROPIN int 4 √ null

Beta Human Chorionic Gonadotropin
GONADOTROPIN_SERUM int 4 √ null

Beta Human Chorionic Gonadotropin (Serum)
FETOPROTEIN_SERUM int 4 √ null

Alpha Fetoprotein (Serum)
SARCOMA_TUMOUR_SITE_BONE varchar 4 √ null

Tumour Site (Bone)
SARCOMA_TUMOUR_SITE_SOFT_TISSUE varchar 4 √ null

Tumour Site (Soft Tissue)
SARCOMA_TUMOUR_SUBSITE_BONE varchar 2 √ null

Tumour Sub-Site (Bone)
SARCOMA_TUMOUR_SUBSITE_SOFT_TISSUE int 4 √ null

Tumour Sub-Site (Soft Tissue)
ROOT_DECISION_DATE_COMMENTS text 2147483647 √ null

Not in use
ROOT_RECEIPT_DATE_COMMENTS text 2147483647 √ null

Not in use
ROOT_FIRST_SEEN_DATE_COMMENTS text 2147483647 √ null

Not in use
ROOT_DIAGNOSIS_DATE_COMMENTS text 2147483647 √ null

Not in use
ROOT_DNA_APPT_REBOOKED_DATE_COMMENTS text 2147483647 √ null

Not in use
ROOT_UPGRADE_COMMENTS text 2147483647 √ null

Not in use
FIRST_APPT_TIME datetime 16,3 √ null

Time First Appointment
TRANSFER_REASON int 4 √ null

Referral Transfer - Other Reason
DATE_NEW_REFERRAL smalldatetime 16 √ null

Date of New Referral
TUMOUR_SITE_NEW int 4 √ null

New Tumour Site
DATE_TRANSFER_ACTIONED smalldatetime 16 √ null

Date Transfer Actioned
SOURCE_CARE_ID int 4 √ null

ID of Referral Transferred From
ADT_REF_ID varchar 50 √ null

Visit ID from ADT Message (Used to link messages to referrals)
ACTION_ID int 4 √ null

Latest Audit ID for Referral Data
DIAGNOSIS_ACTION_ID int 4 √ null

Latest Audit ID for Diagnosis Data
ORIGINAL_SOURCE_CARE_ID int 4 √ null

ID of Original Referral
TRANSFER_DATE_COMMENTS text 2147483647 √ null
SPECIALIST_REFERRAL_COMMENTS text 2147483647 √ null
NON_CANCER_DIAGNOSIS_CHAPTER int 4 √ null
NON_CANCER_DIAGNOSIS_GROUP varchar 5 √ null
NON_CANCER_DIAGNOSIS_CODE varchar 5 √ null
TNM_UNKNOWN bit 1 ((0))
ReferringPractice int 4 √ null
Practice.ID FK_tblMAIN_REFERRALS_PracticeR
ReferringGP int 4 √ null
GP.ID FK_tblMAIN_REFERRALS_GPR
ReferringBranch int 4 √ null
Branch.ID FK_tblMAIN_REFERRALS_BranchR
BankedTissue int 4 √ null
ltblBankedTissue.ID FK_tblMAIN_REFERRALS_ltblBankedTissueR
BankedTissueTumour bit 1 ((0))
BankedTissueBlood bit 1 ((0))
BankedTissueCSF bit 1 ((0))
BankedTissueBoneMarrow bit 1 ((0))
SNOMed_CT int 4 √ null
ADT_PLACER_ID varchar 50 √ null
SNOMEDCTDiagnosisID int 4 √ null
SNOMEDCTConcepts.ID FK_tblMAIN_REFERRALS_SNOMEDCTConceptsR
FasterDiagnosisOrganisationID int 4 √ null
OrganisationSites.ID FK_tblMAIN_REFERRALS_OrganisationSitesR
FasterDiagnosisCancerSiteOverrideID int 4 √ null
ltblFasterDiagnosisCancerSite.ID FK_tblMAIN_REFERRALS_ltblFasterDiagnosisCancerSiteR
FasterDiagnosisExclusionDate datetime 16,3 √ null
FasterDiagnosisExclusionReasonID int 4 √ null
ltblFasterDiagnosisExclusionReason.ID FK_tblMAIN_REFERRALS_ltblFasterDiagnosisExclusionReasonR
FasterDiagnosisDelayReasonID int 4 √ null
ltblFasterDiagnosisDelayReason.ID FK_tblMAIN_REFERRALS_ltblFasterDiagnosisDelayReasonR
FasterDiagnosisDelayReasonComments nvarchar 1073741823 √ null
FasterDiagnosisCommunicationMethodID int 4 √ null
ltblFasterDiagnosisCommunicationMethod.ID FK_tblMAIN_REFERRALS_ltblFasterDiagnosisCommunicationMethodR
FasterDiagnosisInformingCareProfessionalID int 4 √ null
ltblCareProfessional.ID FK_tblMAIN_REFERRALS_ltblCareProfessionalR
FasterDiagnosisOtherCareProfessional nvarchar 100 √ null
FasterDiagnosisOtherCommunicationMethod nvarchar 100 √ null
NonPrimaryPathwayOptionsID int 4 √ null
ltblNonPrimaryPathwayOptions.NonPrimaryPathwayOptionsID FK_tblMAIN_REFERRALS_ltblNonPrimaryPathwayOptionsR
DiagnosisUncertainty bit 1 ((0))
TNMOrganisation int 4 √ null
FasterDiagnosisTargetRCComments varchar 2147483647 √ null
FasterDiagnosisEndRCComments varchar 2147483647 √ null
TNMOrganisation_Integrated int 4 √ null
LDHValue int 4 √ null
BankedTissueUrine bit 1 ((0))
SubsiteID int 4 √ null
CancerReferralSubsites.ID FK_tblMAIN_REFERRALS_CancerReferralSubsitesR
PredictedBreachStatus int 4 √ null
ltblPredictedBreachStatus.ID FK_tblMAIN_REFERRALS_PredictedBreachStatusR
RMRefID int 4 √ null
TertiaryReferralKey uniqueidentifier 16 √ null
ClinicalTLetter varchar 5 √ null
ClinicalNLetter varchar 5 √ null
ClinicalMLetter varchar 5 √ null
PathologicalTLetter varchar 5 √ null
PathologicalNLetter varchar 5 √ null
PathologicalMLetter varchar 5 √ null
FDPlannedInterval bit 1 ((0))
LabReportDate smalldatetime 16 √ null
LabReportOrgID int 4 √ null
OrganisationSites.ID FK_tblMAIN_REFERRALS_OrganisationSites1R
ReferralRoute int 4 √ null
ltblReferralRoute.ID FK_ReferralRoute_ltblReferralRouteR
ReferralOtherRoute nvarchar 100 √ null
RelapseMorphology bit 1 ((0))
RelapseFlow bit 1 ((0))
RelapseMolecular bit 1 ((0))
RelapseClinicalExamination bit 1 ((0))
RelapseOther bit 1 ((0))
RapidDiagnostic nvarchar 4 √ null
PrimaryReferralFlag bit 1 ((0))
OtherAssessedBy varchar 50 √ null
SharedBreach decimal 4,1 √ null
PredictedBreachYear int 4 √ null
PredictedBreachMonth int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblMAIN_REFERRALS Primary key Asc CARE_ID
IX_CareID_CancerSite Performance Asc/Asc CARE_ID + L_CANCER_SITE
IX_CoverNBOCAP_BASE_TUMOURS Performance Asc L_CANCER_SITE
IX_CWTBasic Performance Asc CARE_ID
IX_CWTBasic_Diagnosis Performance Asc CARE_ID
IX_DiagCode_Site_CareID Performance Asc/Asc/Asc N4_2_DIAGNOSIS_CODE + L_CANCER_SITE + CARE_ID
IX_FasterDiagnosis Performance Asc/Asc CARE_ID + N2_6_RECEIPT_DATE
IX_FasterDiagnosis_Diagnosis Performance Asc N4_2_DIAGNOSIS_CODE
IX_FD_PTL Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc N2_6_RECEIPT_DATE + N2_13_CANCER_STATUS + L_INAP_REF + L_FIRST_APPOINTMENT + N2_4_PRIORITY_TYPE + N2_16_OP_REFERRAL + CARE_ID
IX_ORIGINAL_SOURCE_CARE_ID Must be unique Asc/Desc ORIGINAL_SOURCE_CARE_ID + CARE_ID
IX_ReceiptDate Must be unique Asc CARE_ID
IX_SubsiteAndReceipt Performance Asc CARE_ID
IX_tblMAIN_REFERRALS Performance Asc PATIENT_ID
IX_tblMAIN_REFERRALS__N4_1_DIAGNOSIS_DATE__CARE_ID Performance Asc N4_1_DIAGNOSIS_DATE
IX_tblMAIN_REFERRALS_CARE_ID_TRANSFER_REASON Performance Asc/Asc CARE_ID + TRANSFER_REASON
IX_tblMAIN_REFERRALS_Get_Transfer_Details Performance Asc SOURCE_CARE_ID
NonClusteredIndex-20190121-114315 Performance Asc/Asc CARE_ID + L_CANCER_SITE
UQ_tblMAIN_REFERRALS_TertiaryReferralKey Must be unique Asc TertiaryReferralKey

Check Constraints

Constraint Name Constraint
InformedOrExcluded ([L_PT_INFORMED_DATE] IS NULL OR [FasterDiagnosisExclusionDate] IS NULL)

Relationships

Close relationships within degrees of separation