Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
bktblINITIAL_ASSESSMENT.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
DEPRECATED_21_01_bk_tblMAIN_IMAGING.[PortalVeinInvasionID] ltblPortalVeinInvasion.[PortalVeinInvasionID]
DEPRECATED_21_01_bk_tblMAIN_IMAGING.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
DisAntiCancerDrugsLinkage.[ACDrugsID] DisAntiCancerDrugsImport.[ACDrugsID]
DisHistopathologyLinkage.[HistoID] DisHistopathologyImport.[HistoID]
DisOscopyLinkage.[OscopyID] DisOscopyImport.[OscopyID]
DisRadiologyLinkage.[RadioID] DisRadiologyImport.[RadioID]
DisRadiotherapyLinkage.[RadiotherapyID] DisRadiotherapyImport.[RadiotherapyID]
expROOT_HELPER_1.[ADJ_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
expROOT_HELPER_1.[N16_4_ADJ_TREAT_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
expROOT_HELPER_2.[ADJ_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
expROOT_HELPER_2.[N16_4_ADJ_TREAT_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
expROOT_REFERRAL_DATA.[SubsiteID] ltblAO_PRIMARY_DIAGNOSIS_SUBSITE.[SubSiteID]
expRootCause.[N16_4_ADJ_TREAT_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblAcuteToxicity.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblBAUS_TNM_Mapping.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblBILIARY_STENT_INTENT.[STENT_INTENT_CODE] ltblDRUG_INTENT.[INTENT_CODE]
ltblBREAST_NODES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblBREAST_PROCEDURE.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblBREAST_PROCEDURE.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblBREAST_RECONSTRUCTION.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblBREAST_SYMMETRISATION.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblCNS_BiopsyType.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblCOLO_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblCOLO_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblCPET_Type.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblDeathCauseLaterDate.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblDeathWithin30DaysOfTreat.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblERASPathwayCompleted.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblFundingCategory.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblGYNAE_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblGYNAE_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHAEM_ICD03_MAPPING.[ICD03ID] ltblHAEM_ICD03.[ICD03ID]
ltblHAEM_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHAEM_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHN_GRAFT.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHN_PROC_AIRWAY.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHN_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHN_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHN_RECONSTRUCTION.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblHNOtherSite.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblHNReferringSymptomSite.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblHNSiteNewTumour.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblHNSiteRecurrence.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblInvestigationsOrdered.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblLongTermComplications.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblLUNG_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblLUNG_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblNonHeadNeckSite.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblNuclearGrade.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblPAED_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblPAED_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblRegionalAnaestheticTechnique.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblSKIN_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblSKIN_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblSNOMedCT.[CT_Concept_ID] HistoricData.[ID]
ltblSurgicalPathway.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblSymptomReferralLetter.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblSymptomSiteReferralLetter.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblSYN_TUMOUR.[CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
ltblUGI_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblUGI_PROCEDURES.[OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblUROLOGY_PROCEDURES.[OLD_OPCS_CODE] ltblSURGICAL_APPROACH.[OPCS_CODE]
ltblUrologyDeathCause.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
PiradsCategory.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
RDCBaseDataHelper.[RDCFinalDiagnosisStatusID] ltblRDCFinalDiagnosisStatus.[RDCFinalDiagnosisStatusID]
RDCBaseDataHelper.[RDCResultOfReferralID] ltblRDCResultOfReferral.[RDCResultOfReferralID]
RDCOtherTestsHelper1.[RDCTestID] RDCTest.[RDCTestID]
RDCOtherTestsHelper2.[RDCTestID] RDCTest.[RDCTestID]
RDCTestsPerformedBase.[RDCTestID] RDCTest.[RDCTestID]
RDCTestsPerformedHelper1.[RDCTestID] RDCTest.[RDCTestID]
RDCTestsPerformedHelper2.[RDCTestID] RDCTest.[RDCTestID]
RDCTestsPerformedHelper3.[RDCTestID] RDCTest.[RDCTestID]
RDCTestsPerformedString.[RDCTestID] RDCTest.[RDCTestID]
tblAO_ASSESSMENT.[AssessmentTypeID] ltblAO_ASSESSMENT_TYPE.[AssessmentTypeID]
tblAO_ASSESSMENT.[AuditID] tblAUDIT_RECORD.[AuditID]
tblAO_COMPLICATIONS_TREATMENT.[AuditID] tblAUDIT_RECORD.[AuditID]
tblAO_MSCC.[AuditID] tblAUDIT_RECORD.[AuditID]
tblAO_NEUTROPENIC_SEPSIS.[AuditID] tblAUDIT_RECORD.[AuditID]
tblAO_OUTCOME.[AuditID] tblAUDIT_RECORD.[AuditID]
tblAO_REFERRAL.[AuditID] tblAUDIT_RECORD.[AuditID]
tblAO_REFERRAL.[ReferredToID] ltblAO_REFERRED_TO.[ReferredToID]
tblAUDIT.[RECORD_ID] HistoricData.[ID]
tblBREAST_VISITS.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblDEFINITIVE_TREATMENT.[ADJ_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tblDEMOGRAPHICS.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblDERMATOLOGY_RECURRENCES.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblFAMILY_HISTORY.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblFamilyHistoryBackup.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblHAEM_RELAPSE_TRANSFORM.[ICDO3_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tblHAEMATOLOGY_MDT.[AMLRiskFactorsID] ltblAMLRiskFactors.[AMLRiskFactorsID]
tblHAEMATOLOGY_MDT.[DEBTestID] ltblDEBTest.[DebTestID]
tblHAEMATOLOGY_MDT.[DysplasticHaemopoiesisID] ltblDysplasticHaemopoiesis.[DysplasticHaemopoiesisID]
tblHAEMATOLOGY_MDT.[EGILScoreID] ltblEGILScore.[EGILScoreID]
tblINPATIENT_ADMISSIONS.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_ASSESSMENT.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_BRACHYTHERAPY.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_CARE_PLAN.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_CHEMO_TREATMENT.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_CHEMOTHERAPY.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_IMAGING.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_PALLIATIVE.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_PATHOLOGY.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_REFERRALS.[N16_3_ADJ_DECISION_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tblMAIN_REFERRALS.[N16_4_ADJ_TREAT_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tblMAIN_REFERRALS.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_SURGERY.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_TELETHERAPY.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMAIN_TRIAL.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblMDT_GP_Practices.[PracticeID] Practice.[ID]
tblMDT_GP_Practices_Pal.[PracticeID] Practice.[ID]
tblMONITORING.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblOTHER_TREATMENT.[AdjunctiveTherapyID] ltblAdjunctiveTherapy.[AdjunctiveTherapyID]
tblPAEDIATRIC_MDT.[AMLRiskFactorsID] ltblAMLRiskFactors.[AMLRiskFactorsID]
tblPAEDIATRIC_MDT.[DEBTestID] ltblDEBTest.[DebTestID]
tblPAEDIATRIC_MDT.[DysplasticHaemopoiesisID] ltblDysplasticHaemopoiesis.[DysplasticHaemopoiesisID]
tblPAEDIATRIC_MDT.[EGILScoreID] ltblEGILScore.[EGILScoreID]
tblPALLIATIVE_CARE.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblPALLIATIVE_CONTACT.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblPALLIATIVE_CONTACT_BACK_UP.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblPALLIATIVE_INPATIENTS.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblPALLIATIVE_MDT.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblPATHOLOGY_HAEMATOLOGY.[ICD03_Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tblPOSSUM_SCORE.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblREFERRAL_HAEMATOLOGY.[AMLRiskFactorsID] ltblAMLRiskFactors.[AMLRiskFactorsID]
tblREFERRAL_HAEMATOLOGY.[DEBTestID] ltblDEBTest.[DebTestID]
tblREFERRAL_HAEMATOLOGY.[DysplasticHaemopoiesisID] ltblDysplasticHaemopoiesis.[DysplasticHaemopoiesisID]
tblREFERRAL_HAEMATOLOGY.[EGILScoreID] ltblEGILScore.[EGILScoreID]
tblREFERRAL_HAEMATOLOGY.[MURPHY_CODE] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tblREFERRAL_PAEDIATRICS.[AMLRiskFactorsID] ltblAMLRiskFactors.[AMLRiskFactorsID]
tblREFERRAL_PAEDIATRICS.[DEBTestID] ltblDEBTest.[DebTestID]
tblREFERRAL_PAEDIATRICS.[DysplasticHaemopoiesisID] ltblDysplasticHaemopoiesis.[DysplasticHaemopoiesisID]
tblREFERRAL_PAEDIATRICS.[EGILScoreID] ltblEGILScore.[EGILScoreID]
tblSCORES.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblSUPPORTIVE_TREATMENT.[TEMP_ID] ltblTEMP_NHS_NUMBERS.[TEMP_ID]
tblSURGERY_UROLOGY.[ClavienDindoID] ltblClavienDindo.[ClavienDindoID]
tblTREATMENT_SUMMARY.[FLU_JAB] ltblFLU_JAB_DETAILS.[FLU_JAB]
tblTREATMENT_SUMMARY.[PATIENT_REC] ltblPAT_RECEIVED_TREATMENT_SUMMARY.[PATIENT_REC]
tmpHANAPATH_First_Care_Plan_Agreed_At_MDT.[PlanID] ltblNOGCA_ONGOING_PLAN.[PlanID]
tmpHANAPATH_First_MDT.[PlanID] ltblNOGCA_ONGOING_PLAN.[PlanID]
tmpHANAPATH_HNA_Completed.[NurseID] ltblPreviousDistressScore.[nurseID]
tmpHANAPATH_Post_Treat_Assessment.[AssessmentID] tblAO_ASSESSMENT.[AssessmentID]
tmpHANAPATH_tblChemotherapyToxicitySymptoms.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tmpHANAPATH_tblTeletherapyToxicitySymptoms.[Code] ltblSYMPTOMS_HEAD_NECK_HANA_VALUES.[Code]
tmpRPT_SACT_AUDIT.[Person_Stated_Gender_Code] ltblGENDER.[GENDER_CODE]
tmpSACT_AUDIT.[Person_Stated_Gender_Code] ltblGENDER.[GENDER_CODE]

Tables without indexes

Table
BACKUP_18_01_CWT_BUG_SURGERY_RECORD_IDs
BACKUP_18_01_CWT_BUG_SURGERY_RECORD_IDs_PreviousFix
BACKUP_ltblNBOCAP_PREFERRED_SURGERY_V18_02
bkCNSCarePlan
bkHolisticAssessment
bkltblNBOCAP_PREFERRED_SURGERY
bktblINITIAL_ASSESSMENT
bktblINITIAL_BRAIN
bktblINITIAL_PAEDIATRICS
CancerWaitingTimes
CWTData1
CWTData2
CWTMinDecisionDate
CWTMinTreatNo
CWTProviderCodeHelper
CWTReferralData
CWTTreatmentData
DEPRECATED_21_01_bk_tblMAIN_IMAGING
DisAntiCancerDrugsLinkage
DisHistopathologyLinkage
DisOscopyLinkage
DisRadiologyLinkage
DisRadiotherapyLinkage
DisSurgeryLinkage
expAO_DATA
expCUP_CARE_PLAN
expCUP_CATEGORY
expCUP_MAX_FOLLOW_UP
expCUP_REASON_STRING
expCUP_REASON_STRING_CONCAT
expCUP_REFERRALS
expCUP_SECOND_TREATMENT_MIN
expCUP_TREATMENTS
expCWT_DATA
expCWT_TERTIARY_DATES
expPALCCCURRYEAR
expPALCCOLDYEAR
expPALCCS3ADMITDATAEXISTING
expPALCCS3ADMITDATANEW
expPALDCCURRYEAR
expPALDCOLDYEAR
expPALHOSPCURRYEAR
expPALHOSPOLDYEAR
expPALHOSPS4ADMITDATAEXISTING
expPALHOSPS4ADMITDATANEW
expPALIPCURRYEAR
expPALIPOLDYEAR
expPALIPS1ADMITDATAEXIST
expPALIPS1ADMITDATANEW
expPALOPCURRYEAR
expPALOPOLDYEAR
expPALOPS2ADMITDATAEXIST
expPALOPS2ADMITDATANEW
expPALOPS6ADMITDATAEXISTING
expPALOPS6ADMITDATANEW
expROOT_1
expROOT_2
expROOT_REFERRAL_DATA
expRootCause
expRootCauseTertiary
FirstAndLastPSAHelper
importICD03
lnkSurgeryAdditionalSurgeon
ltblAddressTypes
ltblBAUS_DEATH_CAUSE
ltblBAUS_NEPH_SITE_OF_RECURRENCE
ltblBRAFStatus
ltblCOLO_LOCAL_INVASION
ltblDIAGNOSIS_backup
ltblHAEM_ICDO3_HELP
ltblHANASurgeryPreTreatmentModalities
ltblHANASynchronousTumour
ltblMORBIDITY_SURGERY
ltblNextSteps
ltblOrderByForYearReport
ltblPADUA_EXOPHYTIC
ltblPADUA_face
ltblPADUA_renalsinus
ltblPADUA_tumour
ltblPADUA_urinary
ltblRDCDatasets
ltblResidualDisease
ltblRiskCatagory
ltblSOURCE_REFERRAL
ltblSURGERY_LINK
ltblTERTIARY_REFERRALS_LEGACY_DATE
ltblUNIT_CODES
ltblUNIT_MDT
ltblUNRESECTABLE_REASON
ltblUROLOGY_INTERVENTION_PROST
MDTDiscussionData
NBCA_MAPPING_ADDITIONS
NBCAAuditData
NBCAData
NBOCAP_MAPPING_TEMP
newNBOCAP_ACTIVE_MONITORINGS
newNBOCAP_BASE_CARE_PLANS
newNBOCAP_BASE_EVENTS_CARE_PLANS_SURGERIES
newNBOCAP_CARE_IDS
newNBOCAP_CARE_PLANS
newNBOCAP_CARE_PLANS_AFTER_SURGERIES
newNBOCAP_CARE_PLANS_ALL_OTHER
newNBOCAP_CARE_PLANS_TREATMENTS
newNBOCAP_CARE_PLANS_WITH_TREATMENTS
newNBOCAP_CARE_PLANS_WITHOUT_SURGERIES
newNBOCAP_CHECK_TABLE
newNBOCAP_CHEMO_RESULTS
newNBOCAP_CHEMORADIOTHERAPIES
newNBOCAP_CHEMORADIOTHERAPY
newNBOCAP_CHEMORADIOTHERAPY_NO_SURGERY
newNBOCAP_CHEMORADIOTHERAPY_POSTOP
newNBOCAP_CHEMORADIOTHERAPY_PREOP
newNBOCAP_CHEMOS_POSTOP
newNBOCAP_CHEMOS_PREOP
newNBOCAP_CHEMOS_PREOP_CONCAT
newNBOCAP_CHEMOS_PREOP_CONCAT_HELPER
newNBOCAP_MDT
newNBOCAP_NON_LINKAGE_CARE_IDS
newNBOCAP_Non_Primary
newNBOCAP_PATHOLOGIES
newNBOCAP_PATHOLOGY
newNBOCAP_PATIENT
newNBOCAP_PATIENTS
newNBOCAP_POST_SURGERY_PATHOLOGIES
newNBOCAP_PROFORMA_CHEMO_INITIAL
newNBOCAP_PROFORMA_CHEMO_MAIN
newNBOCAP_QUALIFICATION
newNBOCAP_QUALIFYING_CARE_PLANS
newNBOCAP_SURGERIES
newNBOCAP_SURGERY
newNBOCAP_SURGERY_PATHOLOGY
newNBOCAP_TNM
newNBOCAP_TUMOURS
palliative41a
palliative41b
palliative41c
palliative41d
palliative41e
palliative46d
palliative47a
palliative61a
palliative61b
palliative61c
palliative61d
palliativeContact
palliativeSection4
palliativeSection6
PatientStatusTreatmentEventMap
RDCBaseDataHelper
RDCCheckReportHelper
RDCFasterDiagnosisHelper
RDCOnlyOtherTestHelper
RDCOtherTestsHelper1
RDCOtherTestsHelper2
RDCProviderCodeHelper
RDCTestsPerformedBase
RDCTestsPerformedHelper1
RDCTestsPerformedHelper2
RDCTestsPerformedHelper3
RDCTestsPerformedString
SNOMEDCTMap
SomaticTestingColorectalOutput
SurgicalAccessMap
tblAuditReferenceData
tblCancerSiteTotals
tblLocalRptKey
tblMDT_GP_Practices
tblMDT_GP_Practices_Pal
tblNextSteps
tblRptCWTErrCodes
tblSelectedMDTIDs
tblSelectedMDTsToOutput
tblTimelineRAG
tblTREATMENT_SUMMARY_ALERT_SYMPTOMS
tblTREATMENT_SUMMARY_ALERT_SYMPTOMS_PUBLISHED
tblTREATMENT_SUMMARY_REFERRAL_MAPPING
TimedPathwayReportData
tmpDAHNO_BaselineB
tmpDAHNO_Non_Surgical
tmpHANAPATH_Chemoradiotherapies
tmpHANAPATH_Chemotherapies
tmpHANAPATH_First_Brachy
tmpHANAPATH_First_Care_Plan_Agreed_At_MDT
tmpHANAPATH_First_Chemotherapy
tmpHANAPATH_First_Chest_CT
tmpHANAPATH_First_Chest_XRay
tmpHANAPATH_First_CNS
tmpHANAPATH_First_CT_Primary_Neck
tmpHANAPATH_First_Dietitian_After_TX
tmpHANAPATH_First_Dietitian_Before_TX
tmpHANAPATH_First_MDT
tmpHANAPATH_First_MRI_Primary
tmpHANAPATH_First_OPG
tmpHANAPATH_First_Palliative
tmpHANAPATH_First_PET_CT
tmpHANAPATH_First_Teletherapy
tmpHANAPATH_First_Treatment
tmpHANAPATH_First_Trial
tmpHANAPATH_First_Ultrasound
tmpHANAPATH_HNA_Completed
tmpHANAPATH_Investigations
tmpHANAPATH_Investigations_B4_TX
tmpHANAPATH_Investigations_With_Mets
tmpHANAPATH_Last_Surgery
tmpHANAPATH_Last_TX_B4_Chemo
tmpHANAPATH_Last_TX_B4_Tele
tmpHANAPATH_Most_Recent_Dietitian
tmpHANAPATH_Patient
tmpHANAPATH_Post_Treat_Assessment
tmpHANAPATH_Post_Treatment_Salt_Assessment
tmpHANAPATH_Pre_Chemo_Treatment
tmpHANAPATH_Pre_Tele_Treatment
tmpHANAPATH_Pre_Treatment_Salt_Assessment
tmpHANAPATH_Subprocedure_Biopsy
tmpHANAPATH_Subprocedure_Diagnosis
tmpHANAPATH_Subprocedure_Excision
tmpHANAPATH_tblChemotherapyToxicitySymptoms
tmpHANAPATH_tblTeletherapyToxicitySymptoms
tmpHANAPATH_Teletherapies
tmpHANAPATH_Three_Month_Salt_Assessment
tmpHANAPATH_Treatments
tmpHANAPATH_Twelve_Month_Salt_Assessment
tmpHANARAD_Baseline_A
tmpHANARAD_Subprocedure
tmpHANASURG_Baseline_A
tmpHANASURG_Baseline_B
tmpHANASURG_Subprocedure
tmpPALLIATIVE_CARE_DOWNLOAD
TumourStatusPatientStatusMap

Tables with incrementing column names, potentially indicating denormalization

Table
bktblINITIAL_ASSESSMENT
Branch
CancerWaitingTimes
CWTData1
CWTData2
CWTReferralData
DEPRECATED_21_01_bk_tblMAIN_IMAGING
DisRadiologyImport
DisSurgeryImport
expLOCAL
expLOCALEXPDETAIL
expNETWORK_MDT_TEMP
expROOT_1
expROOT_2
expSWCIS_SURGERY_TEMP
expTERTIARY_REFERRALS_TEMP
ltblBREAST_NODES
ltblBREAST_PROCEDURE
ltblBREAST_RECONSTRUCTION
ltblBREAST_SYMMETRISATION
ltblCOLO_PROCEDURES
ltblDENTIST_INFO
ltblGYNAE_PROCEDURES
ltblHAEM_PROCEDURES
ltblHN_GRAFT
ltblHN_PROCEDURES
ltblHNProcedure
ltblHNReconstruction
ltblLUNG_PROCEDURES
ltblMDT_MEETING_TYPE
ltblNATIONAL_CCG_INFO
ltblPAED_PROCEDURES
ltblSKIN_PROCEDURES
ltblTRUST_ADDRESS
ltblUGI_PROCEDURES
ltblUROLOGY_PROCEDURES
NBOCAP_MAPPING_TEMP
Practice
rptCWT_TEMP
rptNBOCAP_PATIENT_TEMP
rptNCPC_TEMP
rptNMBRA_PATIENT_TEMP
rptNOGCA_PATIENT_TEMP
tblAddress
tblBRAIN_MDT
tblBREAST_MDT
tblBREAST_VISITS
tblCNSContact
tblCOLORECTAL_MDT
tblCUP_MDT
tblDEMOGRAPHICS
tblGYNAECOLOGY_MDT
tblHAEMATOLOGY_MDT
tblHEAD_NECK_MDT
tblINITIAL_ASSESSMENT
tblINPATIENT_ADMISSIONS
tblLUNG_MDT
tblMAIN_CARE_PLAN
tblMAIN_IMAGING
tblMAIN_SURGERY
tblMAIN_TELETHERAPY
tblMDT_MEETINGS
tblNonPrimaryPathway
tblOTHER_MDT
tblPAEDIATRIC_MDT
tblPALLIATIVE_CONTACT
tblPALLIATIVE_CONTACT_BACK_UP
tblPATHOLOGY_DERMATOLOGY
tblPATHOLOGY_GYNAECOLOGY
tblPATHOLOGY_HEAD_NECK
tblPATHOLOGY_LUNG
tblPATHOLOGY_UROLOGY
tblPOSSUM_SCORE
tblREFERRAL_GYNAECOLOGY
tblREFERRAL_HAEMATOLOGY
tblREFERRAL_PAEDIATRICS
tblREFERRAL_SARCOMA
tblREFERRAL_UROLOGY
tblSARCOMA_MDT
tblSCORES
tblSKIN_MDT
tblSURGERY_BREAST
tblSURGERY_DAHNO_GMC_CODES
tblSURGERY_DERMATOLOGY
tblSURGERY_GYNAECOLOGY
tblSURGERY_HEAD_NECK
tblSURGERY_LUNG
tblSURGERY_UROLOGY
tblTREATMENT_SUMMARY_PUBLISHED
tblTREATMENT_SUMMARY_PUBLISHED_TREATMENTS
tblUGI_MDT
tblUROLOGY_MDT
tmpCOSD_CORE_DATA
tmpHANAPATH_Baseline_A
tmpRPT_NOGCA_REFERRAL
tmpRPT_SACT_AUDIT

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected