Main Content

RMHC version 05.51: Rules

Table detailing the rules for specification: RMHC
Name Class Priority Bulk Message Mark Description SQL
HrGenDtMissing Missing High No Missing data - GenDt $GenDt.q HR.GenDt Missing data - Data File Generation Date (GenDt) select State, GenDt from HR where GenDt is null
RegRegNameMissing Missing High No Missing data - RegName $RegName.q REG.RegName Missing data - Region Name (RegName) select State, RegId, RegName from REG where RegName is null
OrgOrgNameMissing Missing High No Missing data - OrgName $OrgName.q ORG.OrgName Missing data - Organisation Name (OrgName) select State, RegId, OrgId, OrgName from ORG where OrgName is null
ClusClusNameMissing Missing High No Missing data - ClusName $ClusName.q CLUS.ClusName Missing data - Service Unit Cluster Name (ClusName) select State, RegId, OrgId, ClusId, ClusName from CLUS where ClusName is null
ServSUNameMissing Missing High No Missing data - SUName $SUName.q SERV.SUName Missing data - Residential Service Unit Name (SUName) select State, RegId, OrgId, ClusId, SUId, SUName from SERV where SUName is null
ServSectorMissing Missing High No Missing data - Sector $Sector.q SERV.Sector Missing data - Sector (Sector) select State, RegId, OrgId, ClusId, SUId, Sector from SERV where Sector is null
PerSexMissing Missing High No Missing data - Sex $Sex.q PER.Sex Missing data - Sex (Sex) select State, RegId, OrgId, ClusId, SUId, PersId, Sex from PER where Sex is null
PerDoBFlagMissing Missing High No Missing data - DoBFlag $DoBFlag.q PER.DoBFlag Missing data - Estimated Date of Birth Flag (DoBFlag) select State, RegId, OrgId, ClusId, SUId, PersId, DoBFlag from PER where DoBFlag is null
PerCoBMissing Missing High No Missing data - CoB $CoB.q PER.CoB Missing data - Country of Birth (CoB) select State, RegId, OrgId, ClusId, SUId, PersId, CoB from PER where CoB is null
PerDoBMissing Missing High No Missing data - DoB $DoB.q PER.DoB Missing data - Date of Birth (DoB) select State, RegId, OrgId, ClusId, SUId, PersId, DoB from PER where DoB is null
PerIndigStMissing Missing High No Missing data - IndigSt $IndigSt.q PER.IndigSt Missing data - Indigenous Status (IndigSt) select State, RegId, OrgId, ClusId, SUId, PersId, IndigSt from PER where IndigSt is null
EpiEpiStartModeMissing Missing High No Missing data - EpiStartMode $EpiStartMode.q EPI.EpiStartMode Missing data - Episode of Residential Care Start Mode (EpiStartMode) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiStartMode from EPI where EpiStartMode is null
EpiEpiEndModeMissing Missing High No Missing data - EpiEndMode $EpiEndMode.q EPI.EpiEndMode Missing data - Episode of Residential Care End Mode (EpiEndMode) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiEndMode from EPI where EpiEndMode is null
EpiDxPrincMissing Missing High No Missing data - DxPrinc $DxPrinc.q EPI.DxPrinc Missing data - Principal Diagnosis (DxPrinc) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxPrinc from EPI where DxPrinc is null
EpiLegalStMissing Missing High No Missing data - LegalSt $LegalSt.q EPI.LegalSt Missing data - Mental Health Legal Status (LegalSt) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, LegalSt from EPI where LegalSt is null
EpiMaritalStMissing Missing High No Missing data - MaritalSt $MaritalSt.q EPI.MaritalSt Missing data - Marital Status (MaritalSt) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, MaritalSt from EPI where MaritalSt is null
EpiResAreaMissing Missing High No Missing data - ResArea $ResArea.q EPI.ResArea Missing data - Area of Usual Residence (ResArea) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, ResArea from EPI where ResArea is null
EpiReferralMHRCMissing Missing High No Missing data - ReferralMHRC $ReferralMHRC.q EPI.ReferralMHRC Missing data - Mental Health Care Referral Destination (ReferralMHRC) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, ReferralMHRC from EPI where ReferralMHRC is null
EpiEpiEndDtMissing Missing High No Missing data - EpiEndDt $EpiEndDt.q EPI.EpiEndDt Missing data - Episode of Residential Care End Date (EpiEndDt) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiEndDt from EPI where EpiEndDt is null
EpiEpiStartDtMissing Missing High No Missing data - EpiStartDt $EpiStartDt.q EPI.EpiStartDt Missing data - Episode of Residential Care Start Date (EpiStartDt) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiStartDt from EPI where EpiStartDt is null
EpiNLeaveDaysMissing Missing High No Missing data - NLeaveDays $NLeaveDays.q EPI.NLeaveDays Missing data - Leave Days From Residential Care (NLeaveDays) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, NLeaveDays from EPI where NLeaveDays is null
EpiResStartDtMissing Missing High No Missing data - ResStartDt $ResStartDt.q EPI.ResStartDt Missing data - Residential Stay Start Date (ResStartDt) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, ResStartDt from EPI where ResStartDt is null
PerDoBCount No select sum(DoBCount) as PerDoBCountTotal, avg(DoBCount) as PerDoBCountAvg from ( select count(*) as DoBCount from PER where DoB != '9999-09-09' group by DoB ) as tmpcounts
LowAge Anomaly Low Yes Age is less than 10 years ($Age) EPI Age at Episode End is less than 10 years select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, Age from EpiAge where Age < 10
HighAge Anomaly Low Yes Age is greater than 124 years ($Age) EPI Age is greater than 124 years select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, Age from EpiAge where Age > 124
LowAgeMarriage Anomaly Low No Age is less than 16 years ($Age) and MaritalSt is $MaritalSt EPI.MaritalSt Age is less than 16 years and Marital Status is not 1 (Never married) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, Age, MaritalSt from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where Age < 16 and MaritalSt != '1'
BadSA2Prop Anomaly Low No Greater than 5% ($prop.perc) of SA2s are invalid ($BadCount in total) HR.State Greater than 5% of SA2s (ResArea) are invalid select State, count(*) as AllCount, bad.BadCount, (bad.BadCount) / count(*)::FLOAT as prop from EPI cross join ( select count(*) as BadCount from error join rule on (rule.id = error.rule) where rule.name = 'Domain' and error.field = 'ResArea' ) as bad group by State, bad.BadCount having (bad.BadCount) / count(*)::FLOAT > 0.05
BadMode5EndDt Inconsistent High No EndMode is $EpiEndMode and EpiEndDt is not 30/June ($EpiEndDt.dmy) EPI.EpiEndDt EndMode is 5 (End of reference period) and EpiEndDt is not 30/June select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiEndDt, EpiEndMode from EPI where EpiEndMode = '5' and not ( (extract(month FROM EpiEndDt) = 6 ) and (extract(day FROM EpiEndDt) = 30) )
BadMode5Ref Inconsistent High Yes EndMode is 5 and ReferralMHRC is not 8 ($ReferralMHRC) EPI.ReferralMHRC EndMode is 5 (End of reference period) and ReferralMHRC is not 8 select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, ReferralMHRC from EPI where EpiEndMode = '5' and ReferralMHRC != '8'
BadMode1Ref Inconsistent High No EpiEndMode is $EpiEndMode and ReferralMHRC is not 8 ($ReferralMHRC.qt) EPI.EpiEndDt EpiEndMode is 1 (Died) and ReferralMHRC is not 8 (Not applicable) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiEndDt, ReferralMHRC from EPI where EpiEndMode = '1' and ReferralMHRC != '8'
BadMode3StartDt Inconsistent High No EpiStartMode is $EpiStartMode and EpiStartDt is not 1/July ($EpiStartDt.dmy) EPI.EpiStartDt EpiStartMode is 3 (End of reference period) and EpiStartDt is not 1/July select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiStartDt, EpiStartMode from EPI where EpiStartMode = '3' and not ((extract(month FROM EpiStartDt) = 7) and (extract(day FROM EpiStartDt) = 1))
EpiEndModeNot5 Anomaly High Yes EpiEndDt is 30/June and EpiEndMode is not 5 EPI.EpiEndMode EpiEndDt is 30/June EpiEndMode is not 5 (End of reference period) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId from EPI where EpiEndMode != '5' and ((extract(month FROM EpiEndDt) = 6 ) and (extract( day FROM EpiEndDt) = 30))
EpiStartModeNot3 Anomaly High Yes EpiStartDt is 1/July and EpiStartMode is not 3 EPI.EpiStartMode EpiStartDt is 1/July and EpiStartMode is not 3 (Start of a new reference period) select State, RegId, OrgId, ClusId, SUId, PersId, RecordId from EPI where EpiStartMode != '3' and ((extract(month FROM EpiStartDt) = 7) and (extract( day FROM EpiStartDt) = 1))
InvalidZeroEpiDays Inconsistent Low Yes Episode length is equal to zero without valid EpiStartMode and EpiEndMode. EPI Episode length is equal to zero, with EpiStartMode!=3 and if EpiEndMode=5 then the start date is not 30 June. select State, RegId, OrgId, ClusId, SUId, PersId, RecordId from EPI where ( (EpiEndDt - EpiStartDt - NLeaveDays = 0) and EpiStartMode != '3' and ( EpiEndMode != '5' or ( EpiEndMode='5' and not (extract(month FROM EpiStartDt)::INTEGER = 6 and extract(day FROM EpiStartDt)::INTEGER = 30) ) ) );
LowEpiDays Inconsistent High No Episode Days is less than 0 days ($Days) EPI.NLeaveDays Episode Days is less than 0 days select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, Days from EpiDays where Days < 0
EpiDateOverlap Inconsistent High No EpiStartDt $EpiStartDt.dmy on/before EpiEndDt $prevEpiEndDt.dmy of earlier EPI EPI.StartDt Start date for and episode of care is before or equal to the end date for another episode of care for a unique PersId (within a unit). select * from EpiPrevGap where EpiStartDt <= prevEpiEndDt
EpiAdjacentDate Anomaly High Yes EpiStartDt $EpiStartDt.dmy adjacent to EpiEndDt $prevEpiEndDt.dmy of earlier EPI EPI.StartDt Start date for and episode of care is immediately adjacent to the end date of the preceding episode of care for a unique PersId (within a unit). select * from EpiPrevGap where EpiStartDt = 1 + prevEpiEndDt
EpiStartDtBeforeDoB Inconsistent High No EpiStartDt ($EpiStartDt.dmy) is before DoB ($DoB.dmy) EPI.EpiStartDt EpiStartDt is before DoB select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiStartDt, DoB from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DoB != '9999-09-09' and EpiStartDt < DoB
EpiEndDtBeforeDoB Inconsistent High No EpiEndDt ($EpiEndDt.dmy) is before DoB ($DoB.dmy) EPI.EpiEndDt EpiEndDt is before DoB select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiEndDt, DoB from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DoB != '9999-09-09' and EpiEndDt < DoB
ResStartDtBeforeDoB Inconsistent High No ResStartDt ($ResStartDt.dmy) is before DoB ($DoB.dmy) EPI.ResStartDt ResStartDt is before DoB select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, ResStartDt, DoB from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DoB != '9999-09-09' and ResStartDt < DoB
EpiEndBeforeResStart Inconsistent High No EpiEndDt ($EpiEndDt) is before ResStartDt ($ResStartDt) EPI.EpiEndDt The EpiStartDt cannot be after the ResEndDt select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiEndDt, ResStartDt from EPI where EpiEndDt < ResStartDt
ResStartBeforeEpiStart Inconsistent High No ResStartDt ($ResStartDt) must not be later than EpiStartDt ($EpiStartDt) EPI.ResStartDt The ResStartDt cannot be after the EpiStartDt select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiStartDt, ResStartDt from EPI where ResStartDt > EpiStartDt
BadDxPrincF Inconsistent High No Diagnosis ($DxPrinc) and Sex ($Sex) is not female EPI.DxPrinc The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxPrinc, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxPrinc in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxPrincM Inconsistent High No Diagnosis ($DxPrinc) and Sex ($Sex) is not male EPI.DxPrinc The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxPrinc, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxPrinc in ('F52.4 ') and Sex != '1'
BadDxPrincPpm Inconsistent Low No Diagnosis ($DxPrinc) and Age ($Age) not between 10 and 60 EPI.DxPrinc The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxPrinc, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxPrinc in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxPrincAd Inconsistent Low No Diagnosis ($DxPrinc) and Age ($Age) less than 15 EPI.DxPrinc The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxPrinc, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxPrinc in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxPrincLowAge Inconsistent Low No Diagnosis ($DxPrinc) and Age ($Age) less than 1 EPI.DxPrinc The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxPrinc, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxPrinc in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd01F Inconsistent High No Diagnosis ($DxAdd01) and Sex ($Sex) is not female EPI.DxAdd01 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd01, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd01 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd01M Inconsistent High No Diagnosis ($DxAdd01) and Sex ($Sex) is not male EPI.DxAdd01 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd01, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd01 in ('F52.4 ') and Sex != '1'
BadDxAdd01Ppm Inconsistent Low No Diagnosis ($DxAdd01) and Age ($Age) not between 10 and 60 EPI.DxAdd01 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd01, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd01 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd01Ad Inconsistent Low No Diagnosis ($DxAdd01) and Age ($Age) less than 15 EPI.DxAdd01 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd01, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd01 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd01LowAge Inconsistent Low No Diagnosis ($DxAdd01) and Age ($Age) less than 1 EPI.DxAdd01 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd01, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd01 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd02F Inconsistent High No Diagnosis ($DxAdd02) and Sex ($Sex) is not female EPI.DxAdd02 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd02, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd02 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd02M Inconsistent High No Diagnosis ($DxAdd02) and Sex ($Sex) is not male EPI.DxAdd02 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd02, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd02 in ('F52.4 ') and Sex != '1'
BadDxAdd02Ppm Inconsistent Low No Diagnosis ($DxAdd02) and Age ($Age) not between 10 and 60 EPI.DxAdd02 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd02, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd02 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd02Ad Inconsistent Low No Diagnosis ($DxAdd02) and Age ($Age) less than 15 EPI.DxAdd02 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd02, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd02 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd02LowAge Inconsistent Low No Diagnosis ($DxAdd02) and Age ($Age) less than 1 EPI.DxAdd02 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd02, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd02 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd03F Inconsistent High No Diagnosis ($DxAdd03) and Sex ($Sex) is not female EPI.DxAdd03 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd03, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd03 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd03M Inconsistent High No Diagnosis ($DxAdd03) and Sex ($Sex) is not male EPI.DxAdd03 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd03, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd03 in ('F52.4 ') and Sex != '1'
BadDxAdd03Ppm Inconsistent Low No Diagnosis ($DxAdd03) and Age ($Age) not between 10 and 60 EPI.DxAdd03 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd03, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd03 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd03Ad Inconsistent Low No Diagnosis ($DxAdd03) and Age ($Age) less than 15 EPI.DxAdd03 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd03, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd03 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd03LowAge Inconsistent Low No Diagnosis ($DxAdd03) and Age ($Age) less than 1 EPI.DxAdd03 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd03, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd03 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd04F Inconsistent High No Diagnosis ($DxAdd04) and Sex ($Sex) is not female EPI.DxAdd04 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd04, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd04 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd04M Inconsistent High No Diagnosis ($DxAdd04) and Sex ($Sex) is not male EPI.DxAdd04 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd04, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd04 in ('F52.4 ') and Sex != '1'
BadDxAdd04Ppm Inconsistent Low No Diagnosis ($DxAdd04) and Age ($Age) not between 10 and 60 EPI.DxAdd04 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd04, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd04 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd04Ad Inconsistent Low No Diagnosis ($DxAdd04) and Age ($Age) less than 15 EPI.DxAdd04 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd04, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd04 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd04LowAge Inconsistent Low No Diagnosis ($DxAdd04) and Age ($Age) less than 1 EPI.DxAdd04 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd04, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd04 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd05F Inconsistent High No Diagnosis ($DxAdd05) and Sex ($Sex) is not female EPI.DxAdd05 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd05, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd05 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd05M Inconsistent High No Diagnosis ($DxAdd05) and Sex ($Sex) is not male EPI.DxAdd05 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd05, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd05 in ('F52.4 ') and Sex != '1'
BadDxAdd05Ppm Inconsistent Low No Diagnosis ($DxAdd05) and Age ($Age) not between 10 and 60 EPI.DxAdd05 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd05, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd05 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd05Ad Inconsistent Low No Diagnosis ($DxAdd05) and Age ($Age) less than 15 EPI.DxAdd05 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd05, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd05 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd05LowAge Inconsistent Low No Diagnosis ($DxAdd05) and Age ($Age) less than 1 EPI.DxAdd05 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd05, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd05 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd06F Inconsistent High No Diagnosis ($DxAdd06) and Sex ($Sex) is not female EPI.DxAdd06 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd06, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd06 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd06M Inconsistent High No Diagnosis ($DxAdd06) and Sex ($Sex) is not male EPI.DxAdd06 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd06, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd06 in ('F52.4 ') and Sex != '1'
BadDxAdd06Ppm Inconsistent Low No Diagnosis ($DxAdd06) and Age ($Age) not between 10 and 60 EPI.DxAdd06 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd06, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd06 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd06Ad Inconsistent Low No Diagnosis ($DxAdd06) and Age ($Age) less than 15 EPI.DxAdd06 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd06, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd06 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd06LowAge Inconsistent Low No Diagnosis ($DxAdd06) and Age ($Age) less than 1 EPI.DxAdd06 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd06, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd06 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd07F Inconsistent High No Diagnosis ($DxAdd07) and Sex ($Sex) is not female EPI.DxAdd07 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd07, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd07 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd07M Inconsistent High No Diagnosis ($DxAdd07) and Sex ($Sex) is not male EPI.DxAdd07 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd07, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd07 in ('F52.4 ') and Sex != '1'
BadDxAdd07Ppm Inconsistent Low No Diagnosis ($DxAdd07) and Age ($Age) not between 10 and 60 EPI.DxAdd07 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd07, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd07 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd07Ad Inconsistent Low No Diagnosis ($DxAdd07) and Age ($Age) less than 15 EPI.DxAdd07 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd07, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd07 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd07LowAge Inconsistent Low No Diagnosis ($DxAdd07) and Age ($Age) less than 1 EPI.DxAdd07 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd07, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd07 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd08F Inconsistent High No Diagnosis ($DxAdd08) and Sex ($Sex) is not female EPI.DxAdd08 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd08, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd08 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd08M Inconsistent High No Diagnosis ($DxAdd08) and Sex ($Sex) is not male EPI.DxAdd08 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd08, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd08 in ('F52.4 ') and Sex != '1'
BadDxAdd08Ppm Inconsistent Low No Diagnosis ($DxAdd08) and Age ($Age) not between 10 and 60 EPI.DxAdd08 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd08, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd08 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd08Ad Inconsistent Low No Diagnosis ($DxAdd08) and Age ($Age) less than 15 EPI.DxAdd08 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd08, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd08 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd08LowAge Inconsistent Low No Diagnosis ($DxAdd08) and Age ($Age) less than 1 EPI.DxAdd08 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd08, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd08 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd09F Inconsistent High No Diagnosis ($DxAdd09) and Sex ($Sex) is not female EPI.DxAdd09 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd09, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd09 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd09M Inconsistent High No Diagnosis ($DxAdd09) and Sex ($Sex) is not male EPI.DxAdd09 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd09, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd09 in ('F52.4 ') and Sex != '1'
BadDxAdd09Ppm Inconsistent Low No Diagnosis ($DxAdd09) and Age ($Age) not between 10 and 60 EPI.DxAdd09 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd09, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd09 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd09Ad Inconsistent Low No Diagnosis ($DxAdd09) and Age ($Age) less than 15 EPI.DxAdd09 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd09, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd09 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd09LowAge Inconsistent Low No Diagnosis ($DxAdd09) and Age ($Age) less than 1 EPI.DxAdd09 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd09, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd09 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDxAdd10F Inconsistent High No Diagnosis ($DxAdd10) and Sex ($Sex) is not female EPI.DxAdd10 The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd10, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd10 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2'
BadDxAdd10M Inconsistent High No Diagnosis ($DxAdd10) and Sex ($Sex) is not male EPI.DxAdd10 The following diagnosis codes should only apply to males: 'F52.4 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd10, Sex from EPI join PER using (State, RegId, OrgId, ClusId, SUId, PersId) where DxAdd10 in ('F52.4 ') and Sex != '1'
BadDxAdd10Ppm Inconsistent Low No Diagnosis ($DxAdd10) and Age ($Age) not between 10 and 60 EPI.DxAdd10 The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd10, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd10 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDxAdd10Ad Inconsistent Low No Diagnosis ($DxAdd10) and Age ($Age) less than 15 EPI.DxAdd10 The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd10, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd10 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDxAdd10LowAge Inconsistent Low No Diagnosis ($DxAdd10) and Age ($Age) less than 1 EPI.DxAdd10 The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ' select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, DxAdd10, Age from EPI join EpiAge using (State, RegId, OrgId, ClusId, SUId, PersId, RecordId) where DxAdd10 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
HighExtSA2Prop Anomaly Low No Greater than 5% ($prop.perc) of Episodes have a ResArea out of state HR.State Greater than 5% of Episodes a ResArea out of state. (This check does not apply to ACT) select State, prop from HrResAreaProp where State != '8' and prop > 0.05
HighEstDoBFlagProp Anomaly Low No Greater than 5% ($prop.perc) of Persons have an Estimated Date of Birth HR.State Greater than 5% of Persons have an Estimated Date of Birth select State, prop from HrDoBFlagProp where prop > 0.05
HighExtCoBProp Anomaly High No Greater than 50% ($prop.perc) of Persons have a CoB other than Australia HR.State Greater than 50% of Persons have a CoB other than Australia select State, prop from HrCoBPropNotAus where prop > 0.5
HighSuppCoBProp Anomaly Low No Greater than 10% ($prop.perc) of Persons have a CoB with Supplementary code HR.State Greater than 10% of Persons have a CoB with Supplementary code select State, prop from HrCoBPropSupp where prop > 0.10
SussHrDoBCount Anomaly Low No More than double the average birthrate ($DoBCount vs $PerDoBCountAvg) on a suspicious date ($DoB) HR.State There are greater than double the average number of births for a date which is likely to be a default or erroneous, selected from 9/9/9, 9/9/99, 1/1/1970, 1/1/11 select State, DoB, count(*) AS DoBCount, round(PerDoBCountAvg,1) as PerDoBCountAvg from PER, PerDoBCount where DoB in ( '1970-01-01', '1911-01-01', '2011-01-01', '1909-09-09', '1999-09-09' ) and DoBFlag = '1' group by State, DoB, PerDoBCountAvg having count(*) > PerDoBCountAvg * 2
HighIndigNonAustProp Anomaly High No Proportion of IndigSt not born in Australia is greater than 5% ($prop.perc) HR.State Proportion of Indigenous Australians not born in Australia is greater than 5% select State, prop from HrIndigStPropNonAus where prop > 0.05
HighRefProp9Mode4 Anomaly High No Proportion of EpiEndMode=4 with ReferralMHRC=9 is over than 50% ($prop.perc) SERV Proportion of Episodes with EpiEndMode 4 (Formal discharge from residential care at this establishm...) having ReferralMHRC 9 (Unknown/not stated/inadequately described) at Service unit level is greater than 50% select State, RegId, OrgId, ClusId, SUId, prop from ServRefProp9Mode4 where prop > 0.5
PerSexDiffers Inconsistent High No Person has $attr_count values for Sex ($attr_vals) PER.Sex Person has multiple values for Sex (Sex) across one organisation select State, RegId, OrgId, ClusId, SUId, PersId, attr_count, attr_vals from PER join ( select State, RegId, OrgId, PersId, count(DISTINCT Sex) as attr_count, string_agg(DISTINCT Sex::TEXT, ',') as attr_vals from PER group by State, RegId, OrgId, PersId having count(DISTINCT Sex) > 1 ) counts using (State, RegId, OrgId, PersId)
PerDoBDiffers Inconsistent High No Person has $attr_count values for DoB ($attr_vals) PER.DoB Person has multiple values for DoB (Date of Birth) across one organisation select State, RegId, OrgId, ClusId, SUId, PersId, attr_count, attr_vals from PER join ( select State, RegId, OrgId, PersId, count(DISTINCT DoB) as attr_count, string_agg(DISTINCT DoB::TEXT, ',') as attr_vals from PER group by State, RegId, OrgId, PersId having count(DISTINCT DoB) > 1 ) counts using (State, RegId, OrgId, PersId)
PerDoBFlagDiffers Inconsistent High No Person has $attr_count values for DoBFlag ($attr_vals) PER.DoBFlag Person has multiple values for DoBFlag (Estimated Date of Birth Flag) across one organisation select State, RegId, OrgId, ClusId, SUId, PersId, attr_count, attr_vals from PER join ( select State, RegId, OrgId, PersId, count(DISTINCT DoBFlag) as attr_count, string_agg(DISTINCT DoBFlag::TEXT, ',') as attr_vals from PER group by State, RegId, OrgId, PersId having count(DISTINCT DoBFlag) > 1 ) counts using (State, RegId, OrgId, PersId)
PerCoBDiffers Inconsistent High No Person has $attr_count values for CoB ($attr_vals) PER.CoB Person has multiple values for CoB (Country of Birth) across one organisation select State, RegId, OrgId, ClusId, SUId, PersId, attr_count, attr_vals from PER join ( select State, RegId, OrgId, PersId, count(DISTINCT CoB) as attr_count, string_agg(DISTINCT CoB::TEXT, ',') as attr_vals from PER group by State, RegId, OrgId, PersId having count(DISTINCT CoB) > 1 ) counts using (State, RegId, OrgId, PersId)
PerIndigStDiffers Inconsistent High No Person has $attr_count values for IndigSt ($attr_vals) PER.IndigSt Person has multiple values for IndigSt (Indigenous Status) across one organisation select State, RegId, OrgId, ClusId, SUId, PersId, attr_count, attr_vals from PER join ( select State, RegId, OrgId, PersId, count(DISTINCT IndigSt) as attr_count, string_agg(DISTINCT IndigSt::TEXT, ',') as attr_vals from PER group by State, RegId, OrgId, PersId having count(DISTINCT IndigSt) > 1 ) counts using (State, RegId, OrgId, PersId)
BadHrLegalSt12Counts Anomaly High No LegalSt '1' count ($LowCount) exceeds '2' count ($HighCount) HR Mental Health Legal Status (LegalSt) '1' (Involuntary patient) count exceeds '2' (Voluntary patient) count select State, sum( (LegalSt = '1')::INT ) LowCount, sum( (LegalSt = '2')::INT ) HighCount from EPI group by State having sum( (LegalSt = '1')::INT ) > sum( (LegalSt = '2')::INT )
OrgInvolPropVaries Historical Medium No OrgLegalSt1Prop variation of $PercChange percent. ORG Variation over 10 percentage points in organisation-wide ratio of Involuntary legal status. select State, RegId, OrgId, round(100::float * abs(New.prop - Old.prop)) as PercChange from OrgLegalSt1Prop as New join hist.OrgLegalSt1Prop as Old using(State, RegId, OrgId) where abs(New.prop - Old.prop) > 0.10;
ResiStayLessThanZero Anomaly Low No Residential stay is less than zero ($days days). EPI Residential stay is less than zero. select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, days from ResiStayDays where days < 0;
EpiStartModeMismatch Anomaly High Yes EpiEndMode 6 but EpiStartMode is not 4 ($EpiStartMode). EPI.EpiStartMode EpiEndMode 6 but EpiStartMode is not 4. select State, RegId, OrgId, ClusId, SUId, PersId, RecordId, EpiStartMode from EPI where EpiEndMode='6' and EpiStartMode != '4';
PropResAreaUnknown Anomaly Low Yes Greater than 10% of episodes within a service unit have a ResArea that is coded as unknown or no usual address ($unknowns of $total). SERV Greater than 10% of episodes within a service unit have a ResArea that is coded as unknown or no usual address. with epi_counts as( select State, RegId, OrgId, ClusId, SUId, count(*) as total, sum( CASE WHEN ResArea ~ '^.99999(497|498|499|999)$' THEN 1 ELSE 0 END ) as unknowns from EPI group by State, RegId, OrgId, ClusId, SUId ) select State, RegId, OrgId, ClusId, SUId, unknowns, total from epi_counts where unknowns > 0 and total > 0 and sd_div(unknowns, total, 3) > 0.10;
ServOpened Historical High No Serv opened, $SUName.qt (SUId: $SUId) not in historical data SERV Service Unit Opened - A matching Service Unit was not found in the historical data select State, RegId, OrgId, ClusId, SUId, SERV.SUName from main.SERV left join hist.SERV as hist_entity using (State, RegId, OrgId, ClusId, SUId) where hist_entity.SUId is null
ServClosed Historical High No Serv closed, historical $hist_name.qt (SUId: $hist_SUId) no longer exists HR.State Service Unit Closed - A historical Service Unit was not found in current data select State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.ClusId as hist_ClusId, hist_entity.SUId as hist_SUId, hist_entity.SUName as hist_name from hist.SERV as hist_entity left join main.SERV using (State, RegId, OrgId, ClusId, SUId) where SERV.SUId is null
ServRenamed Historical High No Serv renamed from $hist_name.qt to $SUName.qt SERV.SUName Service Unit Renamed - Service Unit Name differs between historical and current data select State, RegId, OrgId, ClusId, SUId, SERV.SUName, hist_entity.SUName as hist_name from SERV join hist.SERV as hist_entity using(State, RegId, OrgId, ClusId, SUId) where not sloppy_match(SERV.SUName, hist_entity.SUName)
RegNotInSkl Skeleton High No Reg $name not in SKL data Region not in skeleton reference data - A matching Residential Region (REG) was not found in the skeleton data
RegInSklOnly Skeleton High No Reg $name expected from SKL is missing Region (REG) appears in skeleton data only - A Region (REG) with matching Ids is expected based on the SKL data but is not present in this file
OrgNotInSkl Skeleton High No Org $name not in SKL data Organisation not in skeleton reference data - A matching Residential Organisation (ORG) was not found in the skeleton data
OrgInSklOnly Skeleton High No Org $name expected from SKL is missing Organisation (ORG) appears in skeleton data only - A Organisation (ORG) with matching Ids is expected based on the SKL data but is not present in this file
ClusNotInSkl Skeleton High No Clus $name not in SKL data Service Unit Cluster not in skeleton reference data - A matching Residential Service Unit Cluster (CLUS) was not found in the skeleton data
ClusInSklOnly Skeleton High No Clus $name expected from SKL is missing Service Unit Cluster (CLUS) appears in skeleton data only - A Service Unit Cluster (CLUS) with matching Ids is expected based on the SKL data but is not present in this file
ServNotInSkl Skeleton High No Serv $name not in SKL data Service Unit not in skeleton reference data - A matching Residential Service Unit (RESI) was not found in the skeleton data
ServInSklOnly Skeleton High No Serv $name expected from SKL is missing Service Unit (RESI) appears in skeleton data only - A Service Unit (SERV) with matching Ids is expected based on the SKL data but is not present in this file