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
AD_PowerBI_GroupUsers.[distinguishedName] ADGroups.[DistinguishedName]
AD_PowerBI_Stage_GroupUsers.[distinguishedName] ADGroups.[DistinguishedName]
ADUsers.[distinguishedName] ADGroups.[DistinguishedName]
ADUsers_Monthly.[distinguishedName] ADGroups.[DistinguishedName]
AutoPop_AvaReportingFacMembers.[ReportAcctFacCode] AutoPop_AvaReportingFac.[ReportAcctFacCode]
AutoPop_AvaReportingFacPPPLMembers.[ReportAcctFacCode] AutoPop_AvaReportingFac.[ReportAcctFacCode]
AutoPop_AvaReportingFacROXMembers.[ReportAcctFacCode] AutoPop_AvaReportingFac.[ReportAcctFacCode]
Base10_Export_Residents.[FacilityId] PCC_Cache_FacID.[FacilityID]
Base10_Export_Residents.[Medicare_Beneficiary_ID] pbi_activities.[Id]
Base10_Export_Residents.[Provider_One_ID] pbi_activities.[Id]
Base10_PCC_CovidLabResults.[FacilityId] PCC_Cache_FacID.[FacilityID]
CapEx_tblItem.[RequestID] CapEx_tblRequest.[RequestID]
CEU360_UserEnrollments.[attempt_id] CEU360_Users.[id]
CEU360_UserEnrollments.[course_id] CEU360_Users.[id]
CEU360_UserEnrollments.[curriculum_id] CEU360_Users.[id]
CEU360_UserEnrollments.[exam_id] CEU360_Users.[id]
CEU360_UserEnrollments.[user_id] CEU360_Users.[id]
Code.[Code_id] Code_With_Categories.[Code_id]
Code.[Population_Information_Id] Population_Information.[Population_Information_id]
Code.[Source_System_Id] Source_System.[Source_System_id]
Code_Category.[Population_Information_Id] Population_Information.[Population_Information_id]
Code_Category.[Source_System_Id] Source_System.[Source_System_id]
Code_Code_Map.[Left_Code_Id] Code_With_Categories.[Code_id]
Code_Code_Map.[Population_Information_Id] Population_Information.[Population_Information_id]
Code_Code_Map.[Right_Code_Id] Code_With_Categories.[Code_id]
Code_Code_Map.[Source_System_Id] Source_System.[Source_System_id]
Code_With_Categories.[Population_Information_Id] Population_Information.[Population_Information_id]
Code_With_Categories.[Source_System_Id] Source_System.[Source_System_id]
Continuum_PCC_discharge_HCHB.[pcc_FirstCensusID] Continuum_PCC_Stays.[FirstCensusID]
CTM_Notes.[Order ID] CTM_Orders.[Order ID]
DataTable_AR_Reconciliation_2018-12-12.[FacilityId] PCC_Cache_FacID.[FacilityID]
dim_bed.[facilityid] PCC_Cache_FacID.[FacilityID]
dim_facility.[facilityid] PCC_Cache_FacID.[FacilityID]
dim_patient.[facilityid] PCC_Cache_FacID.[FacilityID]
dim_payer.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_bed.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_facility.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_facility_common_codes.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_facility_patient.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_level_of_care.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_patient_ar_insurance.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_patient_census.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_patient_diagnosis.[facilityid] PCC_Cache_FacID.[FacilityID]
ds_pcc_payer.[facilityid] PCC_Cache_FacID.[FacilityID]
Electronic_Address.[Population_Information_Id] Population_Information.[Population_Information_id]
Electronic_Address.[Source_System_Id] Source_System.[Source_System_id]
Employee.[Population_Information_Id] Population_Information.[Population_Information_id]
Employee.[Source_System_Id] Source_System.[Source_System_id]
Employee_Hist.[Population_Information_Id] Population_Information.[Population_Information_id]
Employee_Hist.[Source_System_Id] Source_System.[Source_System_id]
Facility.[Facility_id] ROX_Cache_Fac.[Facility_ID]
Facility.[Population_Information_Id] Population_Information.[Population_Information_id]
Facility.[Source_System_Id] Source_System.[Source_System_id]
fact_patient_census.[dim_bed_key] dim_bed.[dim_bed_key]
fact_patient_census.[dim_date_key] dim_date.[dim_date_key]
fact_patient_census.[dim_facility_key] dim_facility.[dim_facility_key]
fact_patient_census.[dim_location_key] dim_location.[dim_location_key]
fact_patient_census.[dim_patient_key] dim_patient.[dim_patient_key]
fact_patient_census.[dim_payer_key] dim_payer.[dim_payer_key]
fact_patient_diagnosis.[dim_date_key] dim_date.[dim_date_key]
fact_patient_diagnosis.[dim_diagnosis_key] dim_diagnosis.[dim_diagnosis_key]
fact_patient_diagnosis.[dim_facility_key] dim_facility.[dim_facility_key]
fact_patient_diagnosis.[dim_patient_key] dim_patient.[dim_patient_key]
fact_patient_diagnosis.[facilityid] PCC_Cache_FacID.[FacilityID]
fact_patient_facility_stay.[dim_diagnosis_key] dim_diagnosis.[dim_diagnosis_key]
fact_patient_facility_stay.[dim_facility_key] dim_facility.[dim_facility_key]
fact_patient_facility_stay.[dim_patient_key] dim_patient.[dim_patient_key]
fact_patient_facility_stay.[dim_payer_key] dim_payer.[dim_payer_key]
fact_patient_insurance_active.[dim_date_key] dim_date.[dim_date_key]
fact_patient_insurance_active.[dim_facility_key] dim_facility.[dim_facility_key]
fact_patient_insurance_active.[dim_insurance_key] dim_insurance.[dim_insurance_key]
fact_patient_insurance_active.[dim_patient_key] dim_patient.[dim_patient_key]
fact_patient_insurance_active.[dim_payer_key] dim_payer.[dim_payer_key]
fact_patient_insurance_active.[facilityid] PCC_Cache_FacID.[FacilityID]
HCHB_Rollup_Daily.[branch_groupname] Ref_Signature_BranchGroup.[branch_groupname]
Import_Esp_GLAccount.[ORGANIZATIONUNIQUEID] Import_Esp_Organization.[ORGANIZATIONUNIQUEID]
InOut_patient_facility_stay_newer.[facilityid] PCC_Cache_FacID.[FacilityID]
Kronos_C19HourlyWages.[ReportAcctFacCode] AutoPop_AvaReportingFac.[ReportAcctFacCode]
Kronos_HourlyWages.[ReportAcctFacCode] AutoPop_AvaReportingFac.[ReportAcctFacCode]
load_pcc_bed.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_facility.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_facility_common_codes.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_facility_patient.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_level_of_care.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_patient_ar_insurance.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_patient_census.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_patient_diagnosis.[facilityid] PCC_Cache_FacID.[FacilityID]
load_pcc_payer.[facilityid] PCC_Cache_FacID.[FacilityID]
MDS_Metric.[Population_Information_Id] Population_Information.[Population_Information_id]
MDS_Metric.[Section_Id] CEU360_Users.[id]
MDS_Metric.[Source_System_Id] Source_System.[Source_System_id]
MDS_Metric_Score.[Population_Information_Id] Population_Information.[Population_Information_id]
MDS_Metric_Score.[Source_System_Id] Source_System.[Source_System_id]
PARTY.[Population_Information_Id] Population_Information.[Population_Information_id]
PARTY.[Source_System_Id] Source_System.[Source_System_id]
PCC_Cache_FacID_20220301.[FacilityID] PCC_Cache_FacID.[FacilityID]
PCC_MDS_Patient_Facility.[facility_id] ROX_Cache_Fac.[Facility_ID]
PCC_Stays.[FacilityId] PCC_Cache_FacID.[FacilityID]
PCC_Stays_Old.[FacilityId] PCC_Cache_FacID.[FacilityID]
PCC_Stays_Old.[FirstCensusId] Continuum_PCC_Stays.[FirstCensusID]
PCC_view_ods_patient_contact.[FacilityID] PCC_Cache_FacID.[FacilityID]
Person.[Population_Information_Id] Population_Information.[Population_Information_id]
Person.[Source_System_Id] Source_System.[Source_System_id]
Physician.[Population_Information_Id] Population_Information.[Population_Information_id]
Physician.[Source_System_Id] Source_System.[Source_System_id]
Postal_Address.[Population_Information_Id] Population_Information.[Population_Information_id]
Postal_Address.[Source_System_Id] Source_System.[Source_System_id]
Reach_Out.[Population_Information_Id] Population_Information.[Population_Information_id]
Reach_Out.[Source_System_Id] Source_System.[Source_System_id]
Reach_Out.[Type_Id] Type.[Type_id]
Ref_Signature_Branch.[branch_groupname] Ref_Signature_BranchGroup.[branch_groupname]
Resident.[Population_Information_Id] Population_Information.[Population_Information_id]
Resident.[Source_System_Id] Source_System.[Source_System_id]
Resident_Facility.[Facility_Id] ROX_Cache_Fac.[Facility_ID]
Resident_Facility.[Population_Information_Id] Population_Information.[Population_Information_id]
Resident_Facility.[Resident_Facility_Id] ROX_Cache_Fac.[Facility_ID]
Resident_Facility.[Source_System_Id] Source_System.[Source_System_id]
ROX_Monthly_Revenue.[Facility_ID] ROX_Cache_Fac.[Facility_ID]
ROX_Patient_Billings.[Facility_ID] ROX_Cache_Fac.[Facility_ID]
stage_facility_attributes.[facilityid] PCC_Cache_FacID.[FacilityID]
stage_level_of_skilled_care.[dim_facility_key] dim_facility.[dim_facility_key]
stage_level_of_skilled_care.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_census.[dim_bed_key] dim_bed.[dim_bed_key]
stage_patient_census.[dim_date_key] dim_date.[dim_date_key]
stage_patient_census.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_census.[dim_location_key] dim_location.[dim_location_key]
stage_patient_census.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_census.[dim_payer_key] dim_payer.[dim_payer_key]
stage_patient_census.[facilityid] PCC_Cache_FacID.[FacilityID]
stage_patient_diagnosis.[dim_date_key] dim_date.[dim_date_key]
stage_patient_diagnosis.[dim_diagnosis_key] dim_diagnosis.[dim_diagnosis_key]
stage_patient_diagnosis.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_diagnosis.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_diagnosis.[facilityid] PCC_Cache_FacID.[FacilityID]
stage_patient_insurance.[dim_date_key] dim_date.[dim_date_key]
stage_patient_insurance.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_insurance.[dim_insurance_key] dim_insurance.[dim_insurance_key]
stage_patient_insurance.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_insurance.[dim_payer_key] dim_payer.[dim_payer_key]
stage_patient_insurance.[facilityid] PCC_Cache_FacID.[FacilityID]
stage_patient_stay_1.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_stay_1.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_stay_2.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_stay_2.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_stay_3.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_stay_3.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_stay_3.[dim_payer_key] dim_payer.[dim_payer_key]
stage_patient_stay_3_diagnosis.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_stay_3_diagnosis.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_stay_3_duration.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_stay_3_duration.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_stay_4.[dim_diagnosis_key] dim_diagnosis.[dim_diagnosis_key]
stage_patient_stay_4.[dim_facility_key] dim_facility.[dim_facility_key]
stage_patient_stay_4.[dim_patient_key] dim_patient.[dim_patient_key]
stage_patient_stay_4.[dim_payer_key] dim_payer.[dim_payer_key]
Telephone_Address.[Population_Information_Id] Population_Information.[Population_Information_id]
Telephone_Address.[Source_System_Id] Source_System.[Source_System_id]
Theraphy_Diagnosis.[Diagnosis_Code_Id] Code_With_Categories.[Code_id]
Theraphy_Diagnosis.[Population_Information_Id] Population_Information.[Population_Information_id]
Theraphy_Diagnosis.[Source_System_Id] Source_System.[Source_System_id]

Tables without indexes

Table Rows
Abaqis_API_s2_ftag_data 6730
Abaqis_Stage 0
Avamere_JobVacancy_Stage 356
AvamereAugust2019TestFile 28135
Base10_Export_Employees 7241
Base10_Export_Residents 0
Base10_UltiPro_EmpStatus 55233
Base10_UltiPro_LicensesVaccines 88058
Base10_UltiPro_Tests 137767
Champions_Level1_stage 3235
Champions_Level2_3_stage 329
CL_Clinical_Log 47801
CL_Hospital_name 74
CL_SNF 58
Clinicient_ImportLog 4
Clinicient_PayDetail 22952
Clinicient_Stage_PayDetail 22953
CMed_EDObsIPVisits 0
Code 217316
Code_Category 197
Code_Code_Map 13876
Continuum_PCC_discharge_HCHB 3912
CTM_Clients 337
CTM_Notes 14141
CTM_Temps 9295
dim_stay_length 52
DobsonData_Stage 429247
ds_payer_skill_level 218
ds_pcc_bed 9760
ds_pcc_facility 108
ds_pcc_facility_common_codes 408
ds_pcc_facility_patient 262150
ds_pcc_level_of_care 71759
ds_pcc_master_patient 129282
ds_pcc_patient_ar_insurance 178327
ds_pcc_patient_census 407275
ds_pcc_patient_diagnosis 1511543
ds_pcc_payer 436
Electronic_Address 0
Employee 0
Employee_Hist 0
Employee_Journaling 16012
Employee_Journaling_stage 87659
Error_Log_Message 7
Espresso_Stage 0
EspRpt_InfARAging 4575
EspRpt_InfARAging_Log 13
EspRpt_Stage_InfARAging 0
Facility 0
fact_patient_census 407275
fact_patient_diagnosis 1511543
fact_patient_facility_stay 132152
fact_patient_insurance_active 0
Glint_UltiProExport_Stage 54690
HCHB_MonthEnd_CurrMonth 1
HCHB_MonthEndCloseAR_BAK 117709
HCHB_SOCSnapshot_20190930 10325
HCHB_SOCSnapshot_Abandoned 0
ICD_Category 40924
INF_OutPatientOutcome 3372
INF_OutPatientOutcome_OLD 3245
InOut_patient_facility_stay_newer 0
Kashi_UltiPro_EmpStatus 50814
load_payer_skill_level 0
load_pcc_bed 9760
load_pcc_facility 108
load_pcc_facility_common_codes 408
load_pcc_facility_patient 0
load_pcc_level_of_care 71759
load_pcc_master_patient 129282
load_pcc_patient_ar_insurance 178765
load_pcc_patient_census 407896
load_pcc_patient_diagnosis 0
load_pcc_payer 436
MDS_Metric 137
MDS_Metric_Score 0
Medicare_201802_StateAverages_Display 55
Medicare_Stage_HealthDeficiencies 369210
Medicare_Stage_ProviderInfo 0
Medicare_Stage_QualityMsrClaims 61064
Medicare_Stage_QualityMsrMDS 274788
Medicare_Stage_SNF_QRP_National 19
Medicare_Stage_SNF_QRP_Provider 625906
Medicare_Stage_StateUSAverages 0
Medicare_StateAverages_Download_201801 52
Medicare_StateAverages_Download_201903 52
mfk_Aged Accounts Receivable 852
PARTY 276859
PCC_Cache_FacID_20220301 102
PCC_In_Out 139329
PCC_MDS_Outcome 0
PCC_MDS_Outcome_test 22
PCC_MDS_Patient_Facility 86521
PCC_MDS_Section_B 322649
PCC_MDS_Section_C 322764
PCC_PayerList 218
PCS_Category 49819
Person 0
Physician 0
PointInTime_HeadCount_Stage 0
PointInTime_Terminations_stage 1622
PointInTime_Transfers_Stage 0
PointInTime_YearStart_Stage 23298
Postal_Address 0
Reach_Out 0
Resident 0
Resident_Facility 0
ROX_Care_Clinical_Outcome 0
ROX_Care_Clinical_Progress_Outcome 0
ROX_Care_Clinical_Progress_Outcome_PR 7135202
ROX_ClinicalProcessMeasure 2174575
ROX_ClinicalProcessMeasure_Test 1803043
ROX_Core_Clinical_Outcome 6274671
ROX_Core_Clinical_Progress_Outcome 0
ROX_Core_Clinical_Progress_Outcome_PR 0
ROX_DiagnosisCodeMap 0
ROX_Facility 242
ROX_ICD_Code 2179
ROX_Library 124
sample 167
SHP_30Day_Rehosp_stage 0
SHP_Dyspnea_Screening_stage 33
SHP_Dyspnea_Treatment_stage 32
SHP_ExcelTabs 0
SHP_Opiod_Bowel_Regimen_stage 32
SHP_Pain_Assessment_stage 33
SHP_Pain_Screening_stage 33
SHP_QualityofCare_stage 540
SHP_Rehosp_stage 81
SHP_Star_Rating_Stage 48
SHP_Visit3DaysPriortoDeath_stage 32
SHP_Visit7DaysPriortoDeath_stage 32
SNF_ChartAudits 9378
SNF_VBP_Payment_Multiplier_Ranking 15306
SP_Covid19 802991
SP_Covid19_hist 66300
stage_facility_attributes 102
stage_level_of_skilled_care 60422
stage_patient_census 407275
stage_patient_diagnosis 1511543
stage_patient_insurance 178327
stage_patient_stay_1 132151
stage_patient_stay_2 132151
stage_patient_stay_3 132164
stage_patient_stay_3_diagnosis 105180
stage_patient_stay_3_duration 362646
stage_patient_stay_4 132151
Telephone_Address 0
Ultipro_EmployeeComp_stage 77585
UltiPro_PayHistory_by_JobTitle_stage 0
WageRatio_2018 58

Tables that contain a single column

Table Column
SHP_ExcelTabs

Tables with incrementing column names, potentially indicating denormalization

Table
Base10_Export_Employees
Base10_Export_Residents
Base10_UltiPro_EmpStatus
Calendar_Date
ContinuumPatients
ContinuumPatients_PreMatch
ContinuumPatients_PreMatch_History
CTM_Temps
dim_patient
dim_payer
ds_pcc_facility_patient
ds_pcc_master_patient
ds_pcc_payer
Employee_Journaling
Employee_Journaling_stage
HCHB_CLIENT_EPISODE_FS
HCHB_CLIENT_EPISODES
HCHB_PAYOR_SOURCES
load_pcc_facility_patient
load_pcc_master_patient
load_pcc_payer
Medicare_StateAverages
Medicare_StateAverages_Download_201801
Medicare_StateAverages_Download_201903
Medicare_StateUSAverages
PCC_ar_baddebt
PCC_Census_Reimb
PCC_view_ods_contact
PCC_view_ods_external_facility
PointInTime_HeadCount
PointInTime_HeadCount_Stage
PointInTime_Terminations
PointInTime_Terminations_stage
PointInTime_Transfers
PointInTime_Transfers_Stage
PointInTime_YearStart
PointInTime_YearStart_DELETE
PointInTime_YearStart_Stage
PointInTimeReport
SHP_30Day_Rehosp_stage
SHP_Dyspnea_Screening_stage
SHP_Dyspnea_Treatment_stage
SHP_Opiod_Bowel_Regimen_stage
SHP_Pain_Assessment_stage
SHP_Pain_Screening_stage
SHP_QualityofCare_stage
SHP_Rehosp_stage
SHP_Star_Rating_Stage
SHP_Visit3DaysPriortoDeath_stage
TerminationListReport
Ultipro_EmployeeComp
Ultipro_EmployeeComp_stage
UltiPro_LeaveofAbscence

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

Table
Anomaly not detected