Mental Health Establishments National Minimum Data Set — Version 02.01
Main Content
MHE version 02.01: Rules
| Name | Class | Priority | Bulk | Message | Mark | Description | SQL |
|---|---|---|---|---|---|---|---|
| StNHousePlacesSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NHousePlaces | ST.NHousePlaces | Non-numbers (spaces) in Number field NHousePlaces | select State, NHousePlaces from ST where NHousePlaces IS NULL |
| StNgoOtherDeptsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoOtherDepts | ST.NgoOtherDepts | Non-numbers (spaces) in Number field NgoOtherDepts | select State, NgoOtherDepts from ST where NgoOtherDepts IS NULL |
| StRevDVASpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevDVA | ST.RevDVA | Non-numbers (spaces) in Number field RevDVA | select State, RevDVA from ST where RevDVA IS NULL |
| StRevRecovSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevRecov | ST.RevRecov | Non-numbers (spaces) in Number field RevRecov | select State, RevRecov from ST where RevRecov IS NULL |
| StRevStateHealthSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevStateHealth | ST.RevStateHealth | Non-numbers (spaces) in Number field RevStateHealth | select State, RevStateHealth from ST where RevStateHealth IS NULL |
| StRevCwlthOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevCwlthOther | ST.RevCwlthOther | Non-numbers (spaces) in Number field RevCwlthOther | select State, RevCwlthOther from ST where RevCwlthOther IS NULL |
| StRevPatientsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevPatients | ST.RevPatients | Non-numbers (spaces) in Number field RevPatients | select State, RevPatients from ST where RevPatients IS NULL |
| StRevOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevOther | ST.RevOther | Non-numbers (spaces) in Number field RevOther | select State, RevOther from ST where RevOther IS NULL |
| StRevStateOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevStateOther | ST.RevStateOther | Non-numbers (spaces) in Number field RevStateOther | select State, RevStateOther from ST where RevStateOther IS NULL |
| StExpNerAcademicSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerAcademic | ST.ExpNerAcademic | Non-numbers (spaces) in Number field ExpNerAcademic | select State, ExpNerAcademic from ST where ExpNerAcademic IS NULL |
| StExpNerTrainingSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerTraining | ST.ExpNerTraining | Non-numbers (spaces) in Number field ExpNerTraining | select State, ExpNerTraining from ST where ExpNerTraining IS NULL |
| StExpNerInsurSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerInsur | ST.ExpNerInsur | Non-numbers (spaces) in Number field ExpNerInsur | select State, ExpNerInsur from ST where ExpNerInsur IS NULL |
| StExpNerMHActSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerMHAct | ST.ExpNerMHAct | Non-numbers (spaces) in Number field ExpNerMHAct | select State, ExpNerMHAct from ST where ExpNerMHAct IS NULL |
| StExpNerPromoSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerPromo | ST.ExpNerPromo | Non-numbers (spaces) in Number field ExpNerPromo | select State, ExpNerPromo from ST where ExpNerPromo IS NULL |
| StExpNerResearchSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerResearch | ST.ExpNerResearch | Non-numbers (spaces) in Number field ExpNerResearch | select State, ExpNerResearch from ST where ExpNerResearch IS NULL |
| StExpNerTranspSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerTransp | ST.ExpNerTransp | Non-numbers (spaces) in Number field ExpNerTransp | select State, ExpNerTransp from ST where ExpNerTransp IS NULL |
| StExpNerProgAdminSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerProgAdmin | ST.ExpNerProgAdmin | Non-numbers (spaces) in Number field ExpNerProgAdmin | select State, ExpNerProgAdmin from ST where ExpNerProgAdmin IS NULL |
| StExpNerPropLeaseSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerPropLease | ST.ExpNerPropLease | Non-numbers (spaces) in Number field ExpNerPropLease | select State, ExpNerPropLease from ST where ExpNerPropLease IS NULL |
| StExpNerServDevSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerServDev | ST.ExpNerServDev | Non-numbers (spaces) in Number field ExpNerServDev | select State, ExpNerServDev from ST where ExpNerServDev IS NULL |
| StExpNerSuperSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerSuper | ST.ExpNerSuper | Non-numbers (spaces) in Number field ExpNerSuper | select State, ExpNerSuper from ST where ExpNerSuper IS NULL |
| StExpNerWorkCompSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerWorkComp | ST.ExpNerWorkComp | Non-numbers (spaces) in Number field ExpNerWorkComp | select State, ExpNerWorkComp from ST where ExpNerWorkComp IS NULL |
| StExpNerOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerOther | ST.ExpNerOther | Non-numbers (spaces) in Number field ExpNerOther | select State, ExpNerOther from ST where ExpNerOther IS NULL |
| StngoeMHNGOEGrantsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field MHNGOEGrants | STNGOE.MHNGOEGrants | Non-numbers (spaces) in Number field MHNGOEGrants | select State, MHNGOServType, MHNGOEGrants from STNGOE where MHNGOEGrants IS NULL |
| RegRevDVASpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevDVA | REG.RevDVA | Non-numbers (spaces) in Number field RevDVA | select State, RegId, RevDVA from REG where RevDVA IS NULL |
| RegRevRecovSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevRecov | REG.RevRecov | Non-numbers (spaces) in Number field RevRecov | select State, RegId, RevRecov from REG where RevRecov IS NULL |
| RegRevStateHealthSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevStateHealth | REG.RevStateHealth | Non-numbers (spaces) in Number field RevStateHealth | select State, RegId, RevStateHealth from REG where RevStateHealth IS NULL |
| RegRevCwlthOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevCwlthOther | REG.RevCwlthOther | Non-numbers (spaces) in Number field RevCwlthOther | select State, RegId, RevCwlthOther from REG where RevCwlthOther IS NULL |
| RegRevPatientsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevPatients | REG.RevPatients | Non-numbers (spaces) in Number field RevPatients | select State, RegId, RevPatients from REG where RevPatients IS NULL |
| RegRevOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevOther | REG.RevOther | Non-numbers (spaces) in Number field RevOther | select State, RegId, RevOther from REG where RevOther IS NULL |
| RegRevStateOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevStateOther | REG.RevStateOther | Non-numbers (spaces) in Number field RevStateOther | select State, RegId, RevStateOther from REG where RevStateOther IS NULL |
| RegExpNerAcademicSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerAcademic | REG.ExpNerAcademic | Non-numbers (spaces) in Number field ExpNerAcademic | select State, RegId, ExpNerAcademic from REG where ExpNerAcademic IS NULL |
| RegExpNerTrainingSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerTraining | REG.ExpNerTraining | Non-numbers (spaces) in Number field ExpNerTraining | select State, RegId, ExpNerTraining from REG where ExpNerTraining IS NULL |
| RegExpNerInsurSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerInsur | REG.ExpNerInsur | Non-numbers (spaces) in Number field ExpNerInsur | select State, RegId, ExpNerInsur from REG where ExpNerInsur IS NULL |
| RegExpNerMHActSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerMHAct | REG.ExpNerMHAct | Non-numbers (spaces) in Number field ExpNerMHAct | select State, RegId, ExpNerMHAct from REG where ExpNerMHAct IS NULL |
| RegExpNerPromoSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerPromo | REG.ExpNerPromo | Non-numbers (spaces) in Number field ExpNerPromo | select State, RegId, ExpNerPromo from REG where ExpNerPromo IS NULL |
| RegExpNerResearchSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerResearch | REG.ExpNerResearch | Non-numbers (spaces) in Number field ExpNerResearch | select State, RegId, ExpNerResearch from REG where ExpNerResearch IS NULL |
| RegExpNerTranspSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerTransp | REG.ExpNerTransp | Non-numbers (spaces) in Number field ExpNerTransp | select State, RegId, ExpNerTransp from REG where ExpNerTransp IS NULL |
| RegExpNerProgAdminSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerProgAdmin | REG.ExpNerProgAdmin | Non-numbers (spaces) in Number field ExpNerProgAdmin | select State, RegId, ExpNerProgAdmin from REG where ExpNerProgAdmin IS NULL |
| RegExpNerPropLeaseSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerPropLease | REG.ExpNerPropLease | Non-numbers (spaces) in Number field ExpNerPropLease | select State, RegId, ExpNerPropLease from REG where ExpNerPropLease IS NULL |
| RegExpNerServDevSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerServDev | REG.ExpNerServDev | Non-numbers (spaces) in Number field ExpNerServDev | select State, RegId, ExpNerServDev from REG where ExpNerServDev IS NULL |
| RegExpNerSuperSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerSuper | REG.ExpNerSuper | Non-numbers (spaces) in Number field ExpNerSuper | select State, RegId, ExpNerSuper from REG where ExpNerSuper IS NULL |
| RegExpNerSuppServSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerSuppServ | REG.ExpNerSuppServ | Non-numbers (spaces) in Number field ExpNerSuppServ | select State, RegId, ExpNerSuppServ from REG where ExpNerSuppServ IS NULL |
| RegExpNerWorkCompSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerWorkComp | REG.ExpNerWorkComp | Non-numbers (spaces) in Number field ExpNerWorkComp | select State, RegId, ExpNerWorkComp from REG where ExpNerWorkComp IS NULL |
| RegExpNerOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerOther | REG.ExpNerOther | Non-numbers (spaces) in Number field ExpNerOther | select State, RegId, ExpNerOther from REG where ExpNerOther IS NULL |
| RegngoeMHNGOEGrantsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field MHNGOEGrants | REGNGOE.MHNGOEGrants | Non-numbers (spaces) in Number field MHNGOEGrants | select State, RegId, MHNGOServType, MHNGOEGrants from REGNGOE where MHNGOEGrants IS NULL |
| OrgRevDVASpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevDVA | ORG.RevDVA | Non-numbers (spaces) in Number field RevDVA | select State, RegId, OrgId, RevDVA from ORG where RevDVA IS NULL |
| OrgRevRecovSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevRecov | ORG.RevRecov | Non-numbers (spaces) in Number field RevRecov | select State, RegId, OrgId, RevRecov from ORG where RevRecov IS NULL |
| OrgRevStateHealthSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevStateHealth | ORG.RevStateHealth | Non-numbers (spaces) in Number field RevStateHealth | select State, RegId, OrgId, RevStateHealth from ORG where RevStateHealth IS NULL |
| OrgRevCwlthOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevCwlthOther | ORG.RevCwlthOther | Non-numbers (spaces) in Number field RevCwlthOther | select State, RegId, OrgId, RevCwlthOther from ORG where RevCwlthOther IS NULL |
| OrgRevPatientsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevPatients | ORG.RevPatients | Non-numbers (spaces) in Number field RevPatients | select State, RegId, OrgId, RevPatients from ORG where RevPatients IS NULL |
| OrgRevOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevOther | ORG.RevOther | Non-numbers (spaces) in Number field RevOther | select State, RegId, OrgId, RevOther from ORG where RevOther IS NULL |
| OrgRevStateOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field RevStateOther | ORG.RevStateOther | Non-numbers (spaces) in Number field RevStateOther | select State, RegId, OrgId, RevStateOther from ORG where RevStateOther IS NULL |
| OrgDeprecSpaces | Invalid | Low | No | Non-numbers (spaces) in Number field Deprec | ORG.Deprec | Non-numbers (spaces) in Number field Deprec | select State, RegId, OrgId, Deprec from ORG where Deprec IS NULL |
| OrgExpNonSalAdminSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalAdmin | ORG.ExpNonSalAdmin | Non-numbers (spaces) in Number field ExpNonSalAdmin | select State, RegId, OrgId, ExpNonSalAdmin from ORG where ExpNonSalAdmin IS NULL |
| OrgExpNonSalDomestSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalDomest | ORG.ExpNonSalDomest | Non-numbers (spaces) in Number field ExpNonSalDomest | select State, RegId, OrgId, ExpNonSalDomest from ORG where ExpNonSalDomest IS NULL |
| OrgExpNonSalDrugSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalDrug | ORG.ExpNonSalDrug | Non-numbers (spaces) in Number field ExpNonSalDrug | select State, RegId, OrgId, ExpNonSalDrug from ORG where ExpNonSalDrug IS NULL |
| OrgExpNonSalFoodSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalFood | ORG.ExpNonSalFood | Non-numbers (spaces) in Number field ExpNonSalFood | select State, RegId, OrgId, ExpNonSalFood from ORG where ExpNonSalFood IS NULL |
| OrgExpNonSalInterestSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalInterest | ORG.ExpNonSalInterest | Non-numbers (spaces) in Number field ExpNonSalInterest | select State, RegId, OrgId, ExpNonSalInterest from ORG where ExpNonSalInterest IS NULL |
| OrgExpNonSalMedSupplSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalMedSuppl | ORG.ExpNonSalMedSuppl | Non-numbers (spaces) in Number field ExpNonSalMedSuppl | select State, RegId, OrgId, ExpNonSalMedSuppl from ORG where ExpNonSalMedSuppl IS NULL |
| OrgExpNonSalTranspSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalTransp | ORG.ExpNonSalTransp | Non-numbers (spaces) in Number field ExpNonSalTransp | select State, RegId, OrgId, ExpNonSalTransp from ORG where ExpNonSalTransp IS NULL |
| OrgExpNonSalVMOSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalVMO | ORG.ExpNonSalVMO | Non-numbers (spaces) in Number field ExpNonSalVMO | select State, RegId, OrgId, ExpNonSalVMO from ORG where ExpNonSalVMO IS NULL |
| OrgExpNonSalRepairsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalRepairs | ORG.ExpNonSalRepairs | Non-numbers (spaces) in Number field ExpNonSalRepairs | select State, RegId, OrgId, ExpNonSalRepairs from ORG where ExpNonSalRepairs IS NULL |
| OrgExpNonSalSuperSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalSuper | ORG.ExpNonSalSuper | Non-numbers (spaces) in Number field ExpNonSalSuper | select State, RegId, OrgId, ExpNonSalSuper from ORG where ExpNonSalSuper IS NULL |
| OrgExpNonSalOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalOther | ORG.ExpNonSalOther | Non-numbers (spaces) in Number field ExpNonSalOther | select State, RegId, OrgId, ExpNonSalOther from ORG where ExpNonSalOther IS NULL |
| OrgExpSalCnsltPsychSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalCnsltPsych | ORG.ExpSalCnsltPsych | Non-numbers (spaces) in Number field ExpSalCnsltPsych | select State, RegId, OrgId, ExpSalCnsltPsych from ORG where ExpSalCnsltPsych IS NULL |
| OrgExpSalPsyRegSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalPsyReg | ORG.ExpSalPsyReg | Non-numbers (spaces) in Number field ExpSalPsyReg | select State, RegId, OrgId, ExpSalPsyReg from ORG where ExpSalPsyReg IS NULL |
| OrgExpSalMedOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalMedOther | ORG.ExpSalMedOther | Non-numbers (spaces) in Number field ExpSalMedOther | select State, RegId, OrgId, ExpSalMedOther from ORG where ExpSalMedOther IS NULL |
| OrgExpSalNursesRegSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalNursesReg | ORG.ExpSalNursesReg | Non-numbers (spaces) in Number field ExpSalNursesReg | select State, RegId, OrgId, ExpSalNursesReg from ORG where ExpSalNursesReg IS NULL |
| OrgExpSalNursesEnrlSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalNursesEnrl | ORG.ExpSalNursesEnrl | Non-numbers (spaces) in Number field ExpSalNursesEnrl | select State, RegId, OrgId, ExpSalNursesEnrl from ORG where ExpSalNursesEnrl IS NULL |
| OrgExpSalOTSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalOT | ORG.ExpSalOT | Non-numbers (spaces) in Number field ExpSalOT | select State, RegId, OrgId, ExpSalOT from ORG where ExpSalOT IS NULL |
| OrgExpSalSocialWkSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalSocialWk | ORG.ExpSalSocialWk | Non-numbers (spaces) in Number field ExpSalSocialWk | select State, RegId, OrgId, ExpSalSocialWk from ORG where ExpSalSocialWk IS NULL |
| OrgExpSalPsycholSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalPsychol | ORG.ExpSalPsychol | Non-numbers (spaces) in Number field ExpSalPsychol | select State, RegId, OrgId, ExpSalPsychol from ORG where ExpSalPsychol IS NULL |
| OrgExpSalDHPOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalDHPOther | ORG.ExpSalDHPOther | Non-numbers (spaces) in Number field ExpSalDHPOther | select State, RegId, OrgId, ExpSalDHPOther from ORG where ExpSalDHPOther IS NULL |
| OrgExpSalAdminSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalAdmin | ORG.ExpSalAdmin | Non-numbers (spaces) in Number field ExpSalAdmin | select State, RegId, OrgId, ExpSalAdmin from ORG where ExpSalAdmin IS NULL |
| OrgExpSalDomestSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalDomest | ORG.ExpSalDomest | Non-numbers (spaces) in Number field ExpSalDomest | select State, RegId, OrgId, ExpSalDomest from ORG where ExpSalDomest IS NULL |
| OrgExpSalCarerWrkrSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalCarerWrkr | ORG.ExpSalCarerWrkr | Non-numbers (spaces) in Number field ExpSalCarerWrkr | select State, RegId, OrgId, ExpSalCarerWrkr from ORG where ExpSalCarerWrkr IS NULL |
| OrgExpSalConsrWrkrSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalConsrWrkr | ORG.ExpSalConsrWrkr | Non-numbers (spaces) in Number field ExpSalConsrWrkr | select State, RegId, OrgId, ExpSalConsrWrkr from ORG where ExpSalConsrWrkr IS NULL |
| OrgExpSalPCareSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalPCare | ORG.ExpSalPCare | Non-numbers (spaces) in Number field ExpSalPCare | select State, RegId, OrgId, ExpSalPCare from ORG where ExpSalPCare IS NULL |
| OrgFteCnsltPsychSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteCnsltPsych | ORG.FteCnsltPsych | Non-numbers (spaces) in Number field FteCnsltPsych | select State, RegId, OrgId, FteCnsltPsych from ORG where FteCnsltPsych IS NULL |
| OrgFtePsyRegSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FtePsyReg | ORG.FtePsyReg | Non-numbers (spaces) in Number field FtePsyReg | select State, RegId, OrgId, FtePsyReg from ORG where FtePsyReg IS NULL |
| OrgFteMedOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteMedOther | ORG.FteMedOther | Non-numbers (spaces) in Number field FteMedOther | select State, RegId, OrgId, FteMedOther from ORG where FteMedOther IS NULL |
| OrgFteNursesRegSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteNursesReg | ORG.FteNursesReg | Non-numbers (spaces) in Number field FteNursesReg | select State, RegId, OrgId, FteNursesReg from ORG where FteNursesReg IS NULL |
| OrgFteNursesEnrlSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteNursesEnrl | ORG.FteNursesEnrl | Non-numbers (spaces) in Number field FteNursesEnrl | select State, RegId, OrgId, FteNursesEnrl from ORG where FteNursesEnrl IS NULL |
| OrgFteOTSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteOT | ORG.FteOT | Non-numbers (spaces) in Number field FteOT | select State, RegId, OrgId, FteOT from ORG where FteOT IS NULL |
| OrgFteSocialWkSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteSocialWk | ORG.FteSocialWk | Non-numbers (spaces) in Number field FteSocialWk | select State, RegId, OrgId, FteSocialWk from ORG where FteSocialWk IS NULL |
| OrgFtePsycholSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FtePsychol | ORG.FtePsychol | Non-numbers (spaces) in Number field FtePsychol | select State, RegId, OrgId, FtePsychol from ORG where FtePsychol IS NULL |
| OrgFteDHPOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteDHPOther | ORG.FteDHPOther | Non-numbers (spaces) in Number field FteDHPOther | select State, RegId, OrgId, FteDHPOther from ORG where FteDHPOther IS NULL |
| OrgFteAdminSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteAdmin | ORG.FteAdmin | Non-numbers (spaces) in Number field FteAdmin | select State, RegId, OrgId, FteAdmin from ORG where FteAdmin IS NULL |
| OrgFteDomestSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteDomest | ORG.FteDomest | Non-numbers (spaces) in Number field FteDomest | select State, RegId, OrgId, FteDomest from ORG where FteDomest IS NULL |
| OrgFteCarerWrkrSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteCarerWrkr | ORG.FteCarerWrkr | Non-numbers (spaces) in Number field FteCarerWrkr | select State, RegId, OrgId, FteCarerWrkr from ORG where FteCarerWrkr IS NULL |
| OrgFteConsrWrkrSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteConsrWrkr | ORG.FteConsrWrkr | Non-numbers (spaces) in Number field FteConsrWrkr | select State, RegId, OrgId, FteConsrWrkr from ORG where FteConsrWrkr IS NULL |
| OrgFtePCareSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FtePCare | ORG.FtePCare | Non-numbers (spaces) in Number field FtePCare | select State, RegId, OrgId, FtePCare from ORG where FtePCare IS NULL |
| OrgExpNerAcademicSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerAcademic | ORG.ExpNerAcademic | Non-numbers (spaces) in Number field ExpNerAcademic | select State, RegId, OrgId, ExpNerAcademic from ORG where ExpNerAcademic IS NULL |
| OrgExpNerTrainingSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerTraining | ORG.ExpNerTraining | Non-numbers (spaces) in Number field ExpNerTraining | select State, RegId, OrgId, ExpNerTraining from ORG where ExpNerTraining IS NULL |
| OrgExpNerInsurSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerInsur | ORG.ExpNerInsur | Non-numbers (spaces) in Number field ExpNerInsur | select State, RegId, OrgId, ExpNerInsur from ORG where ExpNerInsur IS NULL |
| OrgExpNerMHActSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerMHAct | ORG.ExpNerMHAct | Non-numbers (spaces) in Number field ExpNerMHAct | select State, RegId, OrgId, ExpNerMHAct from ORG where ExpNerMHAct IS NULL |
| OrgExpNerPromoSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerPromo | ORG.ExpNerPromo | Non-numbers (spaces) in Number field ExpNerPromo | select State, RegId, OrgId, ExpNerPromo from ORG where ExpNerPromo IS NULL |
| OrgExpNerResearchSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerResearch | ORG.ExpNerResearch | Non-numbers (spaces) in Number field ExpNerResearch | select State, RegId, OrgId, ExpNerResearch from ORG where ExpNerResearch IS NULL |
| OrgExpNerTranspSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerTransp | ORG.ExpNerTransp | Non-numbers (spaces) in Number field ExpNerTransp | select State, RegId, OrgId, ExpNerTransp from ORG where ExpNerTransp IS NULL |
| OrgExpNerProgAdminSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerProgAdmin | ORG.ExpNerProgAdmin | Non-numbers (spaces) in Number field ExpNerProgAdmin | select State, RegId, OrgId, ExpNerProgAdmin from ORG where ExpNerProgAdmin IS NULL |
| OrgExpNerPropLeaseSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerPropLease | ORG.ExpNerPropLease | Non-numbers (spaces) in Number field ExpNerPropLease | select State, RegId, OrgId, ExpNerPropLease from ORG where ExpNerPropLease IS NULL |
| OrgExpNerServDevSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerServDev | ORG.ExpNerServDev | Non-numbers (spaces) in Number field ExpNerServDev | select State, RegId, OrgId, ExpNerServDev from ORG where ExpNerServDev IS NULL |
| OrgExpNerSuperSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerSuper | ORG.ExpNerSuper | Non-numbers (spaces) in Number field ExpNerSuper | select State, RegId, OrgId, ExpNerSuper from ORG where ExpNerSuper IS NULL |
| OrgExpNerSuppServSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerSuppServ | ORG.ExpNerSuppServ | Non-numbers (spaces) in Number field ExpNerSuppServ | select State, RegId, OrgId, ExpNerSuppServ from ORG where ExpNerSuppServ IS NULL |
| OrgExpNerWorkCompSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerWorkComp | ORG.ExpNerWorkComp | Non-numbers (spaces) in Number field ExpNerWorkComp | select State, RegId, OrgId, ExpNerWorkComp from ORG where ExpNerWorkComp IS NULL |
| OrgExpNerOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNerOther | ORG.ExpNerOther | Non-numbers (spaces) in Number field ExpNerOther | select State, RegId, OrgId, ExpNerOther from ORG where ExpNerOther IS NULL |
| FteorgFteMedSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteMed | FTEORG.FteMed | Non-numbers (spaces) in Number field FteMed | select State, RegId, OrgId, Setting, TargetPop, FteMed from FTEORG where FteMed IS NULL |
| FteorgFteNursesSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteNurses | FTEORG.FteNurses | Non-numbers (spaces) in Number field FteNurses | select State, RegId, OrgId, Setting, TargetPop, FteNurses from FTEORG where FteNurses IS NULL |
| FteorgFteDHPSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteDHP | FTEORG.FteDHP | Non-numbers (spaces) in Number field FteDHP | select State, RegId, OrgId, Setting, TargetPop, FteDHP from FTEORG where FteDHP IS NULL |
| FteorgFteAdminSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteAdmin | FTEORG.FteAdmin | Non-numbers (spaces) in Number field FteAdmin | select State, RegId, OrgId, Setting, TargetPop, FteAdmin from FTEORG where FteAdmin IS NULL |
| FteorgFteDomestSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteDomest | FTEORG.FteDomest | Non-numbers (spaces) in Number field FteDomest | select State, RegId, OrgId, Setting, TargetPop, FteDomest from FTEORG where FteDomest IS NULL |
| FteorgFteCCWrkrSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteCCWrkr | FTEORG.FteCCWrkr | Non-numbers (spaces) in Number field FteCCWrkr | select State, RegId, OrgId, Setting, TargetPop, FteCCWrkr from FTEORG where FteCCWrkr IS NULL |
| FteorgFtePCareSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FtePCare | FTEORG.FtePCare | Non-numbers (spaces) in Number field FtePCare | select State, RegId, OrgId, Setting, TargetPop, FtePCare from FTEORG where FtePCare IS NULL |
| AdmiLHNIDSpaces | Invalid | High | No | Non-numbers (spaces) in Number field LHNID | ADMI.LHNID | Non-numbers (spaces) in Number field LHNID | select State, RegId, OrgId, HospId, AdmiId, LHNID from ADMI where LHNID IS NULL |
| AdmiDeprecSpaces | Invalid | Low | No | Non-numbers (spaces) in Number field Deprec | ADMI.Deprec | Non-numbers (spaces) in Number field Deprec | select State, RegId, OrgId, HospId, AdmiId, Deprec from ADMI where Deprec IS NULL |
| AdmiExpNonSalTotSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalTot | ADMI.ExpNonSalTot | Non-numbers (spaces) in Number field ExpNonSalTot | select State, RegId, OrgId, HospId, AdmiId, ExpNonSalTot from ADMI where ExpNonSalTot IS NULL |
| AdmiExpSalTotSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalTot | ADMI.ExpSalTot | Non-numbers (spaces) in Number field ExpSalTot | select State, RegId, OrgId, HospId, AdmiId, ExpSalTot from ADMI where ExpSalTot IS NULL |
| AdmiAdmiNBedsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field AdmiNBeds | ADMI.AdmiNBeds | Non-numbers (spaces) in Number field AdmiNBeds | select State, RegId, OrgId, HospId, AdmiId, AdmiNBeds from ADMI where AdmiNBeds IS NULL |
| AdmiMHCareDaysSpaces | Invalid | High | No | Non-numbers (spaces) in Number field MHCareDays | ADMI.MHCareDays | Non-numbers (spaces) in Number field MHCareDays | select State, RegId, OrgId, HospId, AdmiId, MHCareDays from ADMI where MHCareDays IS NULL |
| AdmiNSepsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NSeps | ADMI.NSeps | Non-numbers (spaces) in Number field NSeps | select State, RegId, OrgId, HospId, AdmiId, NSeps from ADMI where NSeps IS NULL |
| AmbuLHNIDSpaces | Invalid | High | No | Non-numbers (spaces) in Number field LHNID | AMBU.LHNID | Non-numbers (spaces) in Number field LHNID | select State, RegId, OrgId, ClusId, AmbuId, LHNID from AMBU where LHNID IS NULL |
| AmbuDeprecSpaces | Invalid | Low | No | Non-numbers (spaces) in Number field Deprec | AMBU.Deprec | Non-numbers (spaces) in Number field Deprec | select State, RegId, OrgId, ClusId, AmbuId, Deprec from AMBU where Deprec IS NULL |
| AmbuExpNonSalTotSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalTot | AMBU.ExpNonSalTot | Non-numbers (spaces) in Number field ExpNonSalTot | select State, RegId, OrgId, ClusId, AmbuId, ExpNonSalTot from AMBU where ExpNonSalTot IS NULL |
| AmbuExpSalTotSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalTot | AMBU.ExpSalTot | Non-numbers (spaces) in Number field ExpSalTot | select State, RegId, OrgId, ClusId, AmbuId, ExpSalTot from AMBU where ExpSalTot IS NULL |
| AmbuNClientsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NClients | AMBU.NClients | Non-numbers (spaces) in Number field NClients | select State, RegId, OrgId, ClusId, AmbuId, NClients from AMBU where NClients IS NULL |
| AmbuNContSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NCont | AMBU.NCont | Non-numbers (spaces) in Number field NCont | select State, RegId, OrgId, ClusId, AmbuId, NCont from AMBU where NCont IS NULL |
| ResiLHNIDSpaces | Invalid | High | No | Non-numbers (spaces) in Number field LHNID | RESI.LHNID | Non-numbers (spaces) in Number field LHNID | select State, RegId, OrgId, ClusId, ResiId, LHNID from RESI where LHNID IS NULL |
| ResiHrsStaffedSpaces | Invalid | High | No | Non-numbers (spaces) in Number field HrsStaffed | RESI.HrsStaffed | Non-numbers (spaces) in Number field HrsStaffed | select State, RegId, OrgId, ClusId, ResiId, HrsStaffed from RESI where HrsStaffed IS NULL |
| ResiDeprecSpaces | Invalid | Low | No | Non-numbers (spaces) in Number field Deprec | RESI.Deprec | Non-numbers (spaces) in Number field Deprec | select State, RegId, OrgId, ClusId, ResiId, Deprec from RESI where Deprec IS NULL |
| ResiExpNonSalTotSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpNonSalTot | RESI.ExpNonSalTot | Non-numbers (spaces) in Number field ExpNonSalTot | select State, RegId, OrgId, ClusId, ResiId, ExpNonSalTot from RESI where ExpNonSalTot IS NULL |
| ResiExpSalTotSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalTot | RESI.ExpSalTot | Non-numbers (spaces) in Number field ExpSalTot | select State, RegId, OrgId, ClusId, ResiId, ExpSalTot from RESI where ExpSalTot IS NULL |
| ResiResiNBedsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ResiNBeds | RESI.ResiNBeds | Non-numbers (spaces) in Number field ResiNBeds | select State, RegId, OrgId, ClusId, ResiId, ResiNBeds from RESI where ResiNBeds IS NULL |
| ResiMHCareDaysSpaces | Invalid | High | No | Non-numbers (spaces) in Number field MHCareDays | RESI.MHCareDays | Non-numbers (spaces) in Number field MHCareDays | select State, RegId, OrgId, ClusId, ResiId, MHCareDays from RESI where MHCareDays IS NULL |
| ResiNEpiSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NEpi | RESI.NEpi | Non-numbers (spaces) in Number field NEpi | select State, RegId, OrgId, ClusId, ResiId, NEpi from RESI where NEpi IS NULL |
| 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 |
| StStateNameMissing | Missing | High | No | Missing data - StateName $StateName.q | ST.StateName | Missing data - State/Territory Name (StateName) | select State, StateName from ST where StateName 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 |
| OrgCmteeRepMissing | Missing | High | No | Missing data - CmteeRep $CmteeRep.q | ORG.CmteeRep | Missing data - Consumer Committee Representation Arrangements (CmteeRep) | select State, RegId, OrgId, CmteeRep from ORG where CmteeRep is null |
| HospSectorMissing | Missing | High | No | Missing data - Sector $Sector.q | HOSP.Sector | Missing data - Sector (Sector) | select State, RegId, OrgId, HospId, Sector from HOSP where Sector is null |
| HospHospNameMissing | Missing | High | No | Missing data - HospName $HospName.q | HOSP.HospName | Missing data - Hospital Name (HospName) | select State, RegId, OrgId, HospId, HospName from HOSP where HospName is null |
| HospEstAreaMissing | Missing | High | No | Missing data - EstArea $EstArea.q | HOSP.EstArea | Missing data - Geographical Location of Establishment (EstArea) | select State, RegId, OrgId, HospId, EstArea from HOSP where EstArea is null |
| HospCoLocStatusMissing | Missing | High | No | Missing data - CoLocStatus $CoLocStatus.q | HOSP.CoLocStatus | Missing data - Co-Location Status (CoLocStatus) | select State, RegId, OrgId, HospId, CoLocStatus from HOSP where CoLocStatus 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 |
| AdmiTargetPopMissing | Missing | High | No | Missing data - TargetPop $TargetPop.q | ADMI.TargetPop | Missing data - Target Population (TargetPop) | select State, RegId, OrgId, HospId, AdmiId, TargetPop from ADMI where TargetPop is null |
| AdmiProgTypeMissing | Missing | High | No | Missing data - ProgType $ProgType.q | ADMI.ProgType | Missing data - Program Type (ProgType) | select State, RegId, OrgId, HospId, AdmiId, ProgType from ADMI where ProgType is null |
| AdmiAdmiNameMissing | Missing | High | No | Missing data - AdmiName $AdmiName.q | ADMI.AdmiName | Missing data - Admitted Patient Service Unit Name (AdmiName) | select State, RegId, OrgId, HospId, AdmiId, AdmiName from ADMI where AdmiName is null |
| AdmiStdsReviewStMissing | Missing | High | No | Missing data - StdsReviewSt $StdsReviewSt.q | ADMI.StdsReviewSt | Missing data - National Standards for Mental Health Services Review Status (StdsReviewSt) | select State, RegId, OrgId, HospId, AdmiId, StdsReviewSt from ADMI where StdsReviewSt is null |
| AmbuTargetPopMissing | Missing | High | No | Missing data - TargetPop $TargetPop.q | AMBU.TargetPop | Missing data - Target Population (TargetPop) | select State, RegId, OrgId, ClusId, AmbuId, TargetPop from AMBU where TargetPop is null |
| AmbuSectorMissing | Missing | High | No | Missing data - Sector $Sector.q | AMBU.Sector | Missing data - Sector (Sector) | select State, RegId, OrgId, ClusId, AmbuId, Sector from AMBU where Sector is null |
| AmbuAmbuNameMissing | Missing | High | No | Missing data - AmbuName $AmbuName.q | AMBU.AmbuName | Missing data - Ambulatory Service Unit Name (AmbuName) | select State, RegId, OrgId, ClusId, AmbuId, AmbuName from AMBU where AmbuName is null |
| AmbuEstAreaMissing | Missing | Low | No | Missing data - EstArea $EstArea.q | AMBU.EstArea | Missing data - Geographical Location of Establishment (EstArea) | select State, RegId, OrgId, ClusId, AmbuId, EstArea from AMBU where EstArea is null |
| AmbuStdsReviewStMissing | Missing | High | No | Missing data - StdsReviewSt $StdsReviewSt.q | AMBU.StdsReviewSt | Missing data - National Standards for Mental Health Services Review Status (StdsReviewSt) | select State, RegId, OrgId, ClusId, AmbuId, StdsReviewSt from AMBU where StdsReviewSt is null |
| ResiTargetPopMissing | Missing | High | No | Missing data - TargetPop $TargetPop.q | RESI.TargetPop | Missing data - Target Population (TargetPop) | select State, RegId, OrgId, ClusId, ResiId, TargetPop from RESI where TargetPop is null |
| ResiSectorMissing | Missing | High | No | Missing data - Sector $Sector.q | RESI.Sector | Missing data - Sector (Sector) | select State, RegId, OrgId, ClusId, ResiId, Sector from RESI where Sector is null |
| ResiResiNameMissing | Missing | High | No | Missing data - ResiName $ResiName.q | RESI.ResiName | Missing data - Residential Service Unit Name (ResiName) | select State, RegId, OrgId, ClusId, ResiId, ResiName from RESI where ResiName is null |
| ResiEstAreaMissing | Missing | Low | No | Missing data - EstArea $EstArea.q | RESI.EstArea | Missing data - Geographical Location of Establishment (EstArea) | select State, RegId, OrgId, ClusId, ResiId, EstArea from RESI where EstArea is null |
| ResiStdsReviewStMissing | Missing | High | No | Missing data - StdsReviewSt $StdsReviewSt.q | RESI.StdsReviewSt | Missing data - National Standards for Mental Health Services Review Status (StdsReviewSt) | select State, RegId, OrgId, ClusId, ResiId, StdsReviewSt from RESI where StdsReviewSt is null |
| OrgCarerSurveyMissing | Missing | High | No | Missing data - CarerSurvey $CarerSurvey.q | ORG.CarerSurvey | Missing data - Carer Participation Arrangements Indicator - Carer Experience Surveys (CarerSurvey) | select State, RegId, OrgId, CarerSurvey from ORG where CarerSurvey is null or CarerSurvey = '9' |
| OrgCarerComplMissing | Missing | High | No | Missing data - CarerCompl $CarerCompl.q | ORG.CarerCompl | Missing data - Carer Participation Arrangements Indicator - Formal Complaints Mechanism (CarerCompl) | select State, RegId, OrgId, CarerCompl from ORG where CarerCompl is null or CarerCompl = '9' |
| OrgCarerPolicyMissing | Missing | High | No | Missing data - CarerPolicy $CarerPolicy.q | ORG.CarerPolicy | Missing data - Carer Participation Arrangements Indicator - Formal Participation Policy (CarerPolicy) | select State, RegId, OrgId, CarerPolicy from ORG where CarerPolicy is null or CarerPolicy = '9' |
| OrgCarerDiscGrpMissing | Missing | High | No | Missing data - CarerDiscGrp $CarerDiscGrp.q | ORG.CarerDiscGrp | Missing data - Carer Participation Arrangements Indicator - Regular Discussion Groups (CarerDiscGrp) | select State, RegId, OrgId, CarerDiscGrp from ORG where CarerDiscGrp is null or CarerDiscGrp = '9' |
| OrgConsrSurveyMissing | Missing | High | No | Missing data - ConsrSurvey $ConsrSurvey.q | ORG.ConsrSurvey | Missing data - Consumer Participation Arrangements Indicator - Consumer Experience Surveys (ConsrSurvey) | select State, RegId, OrgId, ConsrSurvey from ORG where ConsrSurvey is null or ConsrSurvey = '9' |
| OrgConsrComplMissing | Missing | High | No | Missing data - ConsrCompl $ConsrCompl.q | ORG.ConsrCompl | Missing data - Consumer Participation Arrangements Indicator - Formal Complaints Mechanism (ConsrCompl) | select State, RegId, OrgId, ConsrCompl from ORG where ConsrCompl is null or ConsrCompl = '9' |
| OrgConsrPolicyMissing | Missing | High | No | Missing data - ConsrPolicy $ConsrPolicy.q | ORG.ConsrPolicy | Missing data - Consumer Participation Arrangements Indicator - Formal Participation Policy (ConsrPolicy) | select State, RegId, OrgId, ConsrPolicy from ORG where ConsrPolicy is null or ConsrPolicy = '9' |
| OrgConsrDiscGrpMissing | Missing | High | No | Missing data - ConsrDiscGrp $ConsrDiscGrp.q | ORG.ConsrDiscGrp | Missing data - Consumer Participation Arrangements - Regular Discussion Groups (ConsrDiscGrp) | select State, RegId, OrgId, ConsrDiscGrp from ORG where ConsrDiscGrp is null or ConsrDiscGrp = '9' |
| OrgCarerRepMissing | Missing | High | No | Missing data - CarerRep $CarerRep.q | ORG.CarerRep | Missing data - Carer Representation Arrangements Indicator (CarerRep) | select State, RegId, OrgId, CarerRep from ORG where CarerRep is null or CarerRep = '9' |
| OrgConsrRepMissing | Missing | High | No | Missing data - ConsrRep $ConsrRep.q | ORG.ConsrRep | Missing data - Consumer Representation Arrangements Indicator (ConsrRep) | select State, RegId, OrgId, ConsrRep from ORG where ConsrRep is null or ConsrRep = '9' |
| AdmiLHNIDMissing | Missing | High | No | Missing data - LHNID $LHNID.q | ADMI.LHNID | Missing data - Local Hospital Network Identifier (LHNID) | select State, RegId, OrgId, HospId, AdmiId, LHNID from ADMI where LHNID is null |
| AmbuLHNIDMissing | Missing | High | No | Missing data - LHNID $LHNID.q | AMBU.LHNID | Missing data - Local Hospital Network Identifier (LHNID) | select State, RegId, OrgId, ClusId, AmbuId, LHNID from AMBU where LHNID is null |
| ResiLHNIDMissing | Missing | High | No | Missing data - LHNID $LHNID.q | RESI.LHNID | Missing data - Local Hospital Network Identifier (LHNID) | select State, RegId, OrgId, ClusId, ResiId, LHNID from RESI where LHNID is null |
| StNHousePlacesZero | Anomaly | High | No | Zero reported for NHousePlaces | ST.NHousePlaces | Zero reported for Number of Supported Mental Health Housing Places | select State, NHousePlaces as value from ST where coalesce(NHousePlaces, 0) = 0 |
| StRevStateHealthZero | Anomaly | High | No | Zero reported for RevStateHealth | ST.RevStateHealth | Zero reported for Revenue - State or Territory Health Authority | select State, RevStateHealth as value from ST where coalesce(RevStateHealth, 0) = 0 |
| StExpNerProgAdminZero | Anomaly | High | No | Zero reported for ExpNerProgAdmin | ST.ExpNerProgAdmin | Zero reported for Expenditure Not Elsewhere Reported - Program Administration | select State, ExpNerProgAdmin as value from ST where coalesce(ExpNerProgAdmin, 0) = 0 |
| StRevTotalZero | Anomaly | High | No | Zero reported for StRevTotal | ST | Zero reported for Total Revenue at State/Territory Level | select State, Total as value from StRevTotal where coalesce(Total, 0) = 0 |
| StExpNerTotalZero | Anomaly | High | No | Zero reported for StExpNerTotal | ST | Zero reported for Total Residual Expenditure at State/Territory Level | select State, Total as value from StExpNerTotal where coalesce(Total, 0) = 0 |
| StExpNerMHActZero | Anomaly | High | No | Zero reported for ExpNerMHAct | ST.ExpNerMHAct | Zero reported for Expenditure Not Elsewhere Reported - Mental Health Act Regulation or related legislation | select State, ExpNerMHAct as value from ST where coalesce(ExpNerMHAct, 0) = 0 |
| OrgRevStateHealthZero | Anomaly | High | No | Zero reported for RevStateHealth | ORG.RevStateHealth | Zero reported for Revenue - State or Territory Health Authority | select State, RegId, OrgId, RevStateHealth as value from ORG where coalesce(RevStateHealth, 0) = 0 |
| OrgRevTotalZero | Anomaly | High | No | Zero reported for OrgRevTotal | ORG | Zero reported for Total Revenue at Organisation Level | select State, RegId, OrgId, Total as value from OrgRevTotal where coalesce(Total, 0) = 0 |
| OrgExpSNSTotalZero | Anomaly | High | No | Zero reported for OrgExpSNSTotal | ORG | Zero reported for Total Salary and Non-Salary Expenditure at Organisation Level | select State, RegId, OrgId, Total as value from OrgExpSNSTotal where coalesce(Total, 0) = 0 |
| FteorgFteTotalZero | Anomaly | High | No | Zero reported for FteorgFteTotal | FTEORG | Zero reported for Total FTE at Organisation Full-time Equivalent Staff by Setting/TargetPop Level | select State, RegId, OrgId, Setting, TargetPop, Total as value from FteorgFteTotal where coalesce(Total, 0) = 0 |
| AdmiAdmiNBedsZero | Anomaly | High | No | Zero reported for AdmiNBeds | ADMI.AdmiNBeds | Zero reported for Average Available Beds for Overnight-stay Patients | select State, RegId, OrgId, HospId, AdmiId, AdmiNBeds as value from ADMI where coalesce(AdmiNBeds, 0) = 0 |
| AdmiMHCareDaysZero | Anomaly | High | No | Zero reported for MHCareDays | ADMI.MHCareDays | Zero reported for Accrued Mental Health Care Days | select State, RegId, OrgId, HospId, AdmiId, MHCareDays as value from ADMI where coalesce(MHCareDays, 0) = 0 |
| AdmiNSepsZero | Anomaly | High | No | Zero reported for NSeps | ADMI.NSeps | Zero reported for Number of Separations | select State, RegId, OrgId, HospId, AdmiId, NSeps as value from ADMI where coalesce(NSeps, 0) = 0 |
| AdmiExpTotalZero | Anomaly | High | No | Zero reported for AdmiExpTotal | ADMI | Zero reported for Total Expenditure at Admitted Patient Service Unit Level | select State, RegId, OrgId, HospId, AdmiId, Total as value from AdmiExpTotal where coalesce(Total, 0) = 0 |
| ResiHrsStaffedZero | Anomaly | High | No | Zero reported for HrsStaffed | RESI.HrsStaffed | Zero reported for Hours Staffed | select State, RegId, OrgId, ClusId, ResiId, HrsStaffed as value from RESI where coalesce(HrsStaffed, 0) = 0 |
| ResiResiNBedsZero | Anomaly | High | No | Zero reported for ResiNBeds | RESI.ResiNBeds | Zero reported for Average Available Beds for Residential Mental Health Patients | select State, RegId, OrgId, ClusId, ResiId, ResiNBeds as value from RESI where coalesce(ResiNBeds, 0) = 0 |
| ResiMHCareDaysZero | Anomaly | High | No | Zero reported for MHCareDays | RESI.MHCareDays | Zero reported for Accrued Mental Health Care Days | select State, RegId, OrgId, ClusId, ResiId, MHCareDays as value from RESI where coalesce(MHCareDays, 0) = 0 |
| ResiNEpiZero | Anomaly | High | No | Zero reported for NEpi | RESI.NEpi | Zero reported for Number of Episodes of Residential Care | select State, RegId, OrgId, ClusId, ResiId, NEpi as value from RESI where coalesce(NEpi, 0) = 0 |
| ResiExpTotalZero | Anomaly | High | No | Zero reported for ResiExpTotal | RESI | Zero reported for Total Expenditure at Residential Service Unit Level | select State, RegId, OrgId, ClusId, ResiId, Total as value from ResiExpTotal where coalesce(Total, 0) = 0 |
| AmbuNClientsZero | Anomaly | High | No | Zero reported for NClients | AMBU.NClients | Zero reported for Number of Clients Receiving Services | select State, RegId, OrgId, ClusId, AmbuId, NClients as value from AMBU where coalesce(NClients, 0) = 0 |
| AmbuNContZero | Anomaly | High | No | Zero reported for NCont | AMBU.NCont | Zero reported for Number of Service Contacts | select State, RegId, OrgId, ClusId, AmbuId, NCont as value from AMBU where coalesce(NCont, 0) = 0 |
| AmbuExpTotalZero | Anomaly | High | No | Zero reported for AmbuExpTotal | AMBU | Zero reported for Total Expenditure at Ambulatory Service Unit Level | select State, RegId, OrgId, ClusId, AmbuId, Total as value from AmbuExpTotal where coalesce(Total, 0) = 0 |
| AdmiAllZero | Missing | High | No | All $ENTITY Number fields are zero | ADMI | All Number fields are zero for this service unit. This usually indicates the record should be deleted. Zero fields were: LHNID, Deprec, ExpNonSalTot, ExpSalTot, AdmiNBeds, MHCareDays, NSeps | select State, RegId, OrgId, HospId, AdmiId from ADMI where coalesce(LHNID,0) = 0 and coalesce(Deprec,0) = 0 and coalesce(ExpNonSalTot,0) = 0 and coalesce(ExpSalTot,0) = 0 and coalesce(AdmiNBeds,0) = 0 and coalesce(MHCareDays,0) = 0 and coalesce(NSeps,0) = 0 |
| AmbuAllZero | Missing | High | No | All $ENTITY Number fields are zero | AMBU | All Number fields are zero for this service unit. This usually indicates the record should be deleted. Zero fields were: LHNID, Deprec, ExpNonSalTot, ExpSalTot, NClients, NCont | select State, RegId, OrgId, ClusId, AmbuId from AMBU where coalesce(LHNID,0) = 0 and coalesce(Deprec,0) = 0 and coalesce(ExpNonSalTot,0) = 0 and coalesce(ExpSalTot,0) = 0 and coalesce(NClients,0) = 0 and coalesce(NCont,0) = 0 |
| ResiAllZero | Missing | High | No | All $ENTITY Number fields are zero | RESI | All Number fields are zero for this service unit. This usually indicates the record should be deleted. Zero fields were: LHNID, HrsStaffed, Deprec, ExpNonSalTot, ExpSalTot, ResiNBeds, MHCareDays, NEpi | select State, RegId, OrgId, ClusId, ResiId from RESI where coalesce(LHNID,0) = 0 and coalesce(HrsStaffed,0) = 0 and coalesce(Deprec,0) = 0 and coalesce(ExpNonSalTot,0) = 0 and coalesce(ExpSalTot,0) = 0 and coalesce(ResiNBeds,0) = 0 and coalesce(MHCareDays,0) = 0 and coalesce(NEpi,0) = 0 |
| AdmiTargetPopNA | Invalid | High | No | TargetPop Code "7" not applicable on ADMI | ADMI.TargetPop | TargetPop "7" ("Not applicable") is appropriate only on FTEORG records | select State, RegId, OrgId, HospId, AdmiId from ADMI where TargetPop = '7' |
| ResiTargetPopNA | Invalid | High | No | TargetPop Code "7" not applicable on RESI | RESI.TargetPop | TargetPop "7" ("Not applicable") is appropriate only on FTEORG records | select State, RegId, OrgId, ClusId, ResiId from RESI where TargetPop = '7' |
| AmbuTargetPopNA | Invalid | High | No | TargetPop Code "7" not applicable on AMBU | AMBU.TargetPop | TargetPop "7" ("Not applicable") is appropriate only on FTEORG records | select State, RegId, OrgId, ClusId, AmbuId from AMBU where TargetPop = '7' |
| FteorgTargetPopSettingNA | Inconsistent | High | No | TargetPop $TargetPop.qt and Setting $Setting.qt cannot be used together | FTEORG.TargetPop | TargetPop "7" ("Not applicable") must only be used together with Setting "4" ("Organisational overhead setting") and vice versa | select State, RegId, OrgId, Setting, TargetPop from FTEORG where ( TargetPop != '7' and Setting = '4' ) or ( TargetPop = '7' and Setting != '4' ) |
| ResiStdsReviewNA | Anomaly | High | No | StdsReviewSt Code "8" usually not applicable | RESI.StdsReviewSt | National Standards for Mental Health Services implementation status code ('not applicable') is applicable only to residential service units with older persons target population | select State, RegId, OrgId, ClusId, ResiId, StdsReviewSt, TargetPop, Sector from RESI where StdsReviewSt = '8' and TargetPop != '2' and Sector = '1' |
| AmbuStdsReviewNA | Anomaly | High | No | StdsReviewSt Code "8" usually not applicable | AMBU.StdsReviewSt | National Standards for Mental Health Services implementation status code ('not applicable') applicable only to ambulatory service units in the private sector | select State, RegId, OrgId, ClusId, AmbuId, StdsReviewSt, Sector from AMBU where StdsReviewSt = '8' and Sector = '1' |
| AmbuSectorNA | Anomaly | High | No | Sector Code 2 (private) not in scope for Setting 3 (ambulatory) | AMBU.Sector | Ambulatory services managed by non-government organisations (NGOs) are not defined as statistical units for this NMDS. | select State, RegId, OrgId, ClusId, AmbuId, Sector from AMBU where Sector = '2' |
| AdmiStdsReviewNA | Anomaly | High | No | StdsReviewSt Code "8" usually not applicable | ADMI.StdsReviewSt | National Standards for Mental Health Services implementation status code ('not applicable') applicable only to admitted service units in the private sector | select State, RegId, OrgId, HospId, AdmiId, StdsReviewSt, Sector from ADMI join HOSP using(State, RegId, OrgId, HospId) where StdsReviewSt = '8' and Sector = '1' |
| LowHrsStaffed | Anomaly | High | No | Residential Service staffed $HrsStaffed hours/day, less than 7 | RESI.HrsStaffed | Average daily staffed hours for a residential mental health service is less than the required minimum for reporting | select State, RegId, OrgId, ClusId, ResiId, HrsStaffed from RESI where HrsStaffed < 7 |
| OrgBarrenFteOrg | Barren | High | No | ORG has no FTEORG records | ORG | Barren Organisation - has no associated record providing FTE by Service Setting | select State, RegId, OrgId, Count from OrgFteorgCount where Count = 0 |
| OrgBarren | Barren | High | No | ORG has no CLUS or HOSP records | ORG | Barren Organisation - has no associated Hospitals or Service Unit Clusters | select State, RegId, OrgId from OrgHospCount join OrgClusCount using(State, RegId, OrgId) where OrgHospCount.Count = 0 and OrgClusCount.Count = 0 |
| ClusBarren | Barren | High | No | CLUS has no AMBU or RESI records | CLUS | Barren Cluster - has no associated Residential or Ambulatory service units | select State, RegId, OrgId, ClusId from ClusAmbuCount join ClusResiCount using(State, RegId, OrgId, ClusId) where ClusAmbuCount.Count = 0 and ClusResiCount.Count = 0 |
| HospCoLocStatusChanged | Historical | High | No | Hospital CoLocStatus changed from $hist_CoLocStatus to $CoLocStatus | HOSP.CoLocStatus | Co-Location Status Changed - Co-Location Status value for Hospital differs between historical and current data | select State, RegId, OrgId, HospId, HOSP.CoLocStatus, hist_HOSP.CoLocStatus as hist_CoLocStatus from HOSP join hist.HOSP as hist_HOSP using(State, RegId, OrgId, HospId) where HOSP.CoLocStatus != hist_HOSP.CoLocStatus |
| AdmiProgTypeChanged | Historical | High | No | Admitted Patient Service Unit ProgType changed from $hist_ProgType to $ProgType | ADMI.ProgType | Program Type Changed - Program Type value for Admitted Patient Service Unit differs between historical and current data | select State, RegId, OrgId, HospId, AdmiId, ADMI.ProgType, hist_ADMI.ProgType as hist_ProgType from ADMI join hist.ADMI as hist_ADMI using(State, RegId, OrgId, HospId, AdmiId) where ADMI.ProgType != hist_ADMI.ProgType |
| ResiHrsStaffed24Changed | Historical | High | No | Residential Service Unit HrsStaffed changed from $hist_HrsStaffed to $HrsStaffed | RESI.HrsStaffed | Hours Staffed Changed - Hours Staffed value for Residential Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, ResiId, RESI.HrsStaffed, hist_RESI.HrsStaffed as hist_HrsStaffed from RESI join hist.RESI as hist_RESI using(State, RegId, OrgId, ClusId, ResiId) where (RESI.HrsStaffed = '24') != (hist_RESI.HrsStaffed = '24') |
| StRevGtExp | Inconsistent | Low | No | ST revenue ($RevTotal.commas) is greater than expenditure ($ExpTotal.commas) by more than 5% ($diff.perc) | ST.RevTotal | Total Revenue at State/Territory Level is greater than State/Territory Level Total Expenditure by more than 5% | select * from ( select State, Rev.Total as RevTotal, Exp.Total as ExpTotal, sd_div_safe(abs(Rev.Total - Exp.Total)::NUMERIC, sd_min(Rev.Total, Exp.Total), 3) as diff from StRevTotal as Rev join StExpTotal as Exp using (State) where Rev.Total > Exp.Total ) tmpinner where diff > 0.05 |
| RegRevGtExp | Inconsistent | Low | No | REG revenue ($RevTotal.commas) is greater than expenditure ($ExpTotal.commas) by more than 5% ($diff.perc) | REG.RevTotal | Total Revenue at Region Level is greater than Region Level Total Expenditure by more than 5% | select * from ( select State, RegId, Rev.Total as RevTotal, Exp.Total as ExpTotal, sd_div_safe(abs(Rev.Total - Exp.Total)::NUMERIC, sd_min(Rev.Total, Exp.Total), 3) as diff from RegRevTotal as Rev join RegExpTotal as Exp using (State, RegId) where Rev.Total > Exp.Total ) tmpinner where diff > 0.05 |
| CnsltPsychSalAndNoFte | Inconsistent | High | No | ExpSalCnsltPsych ($ExpSalCnsltPsych) with no corresponding FteCnsltPsych ($FteCnsltPsych) | ORG.ExpSalCnsltPsych | Salary data with no corresponding FTE - Consultant Psychiatrists and Psychiatrists | select State, RegId, OrgId, ExpSalCnsltPsych, FteCnsltPsych from ORG where (ExpSalCnsltPsych > 5000) and (FteCnsltPsych = 0) |
| CnsltPsychFteAndNoExp | Inconsistent | High | No | FteCnsltPsych ($FteCnsltPsych) with no corresponding ExpSalCnsltPsych or ExpNonSalVMO | ORG.FteCnsltPsych | FTE data with no corresponding Expenditure - Consultant Psychiatrists and Psychiatrists (The expenditure for this may be in the ExpSalCnsltPsych or ExpNonSalVMO fields) | select State, RegId, OrgId, ExpSalCnsltPsych, FteCnsltPsych from ORG where FteCnsltPsych > 0.1 and (ExpSalCnsltPsych + ExpNonSalVMO) = 0 |
| PsyRegSalAndNoFte | Inconsistent | High | No | ExpSalPsyReg ($ExpSalPsyReg) with no corresponding FtePsyReg ($FtePsyReg) | ORG.ExpSalPsyReg | Salary data with no corresponding FTE - Psychiatry Registrars and Trainees | select State, RegId, OrgId, ExpSalPsyReg, FtePsyReg from ORG where (ExpSalPsyReg > 5000) and (FtePsyReg = 0) |
| PsyRegFteAndNoSal | Inconsistent | High | No | FtePsyReg ($FtePsyReg) with no corresponding ExpSalPsyReg (0) | ORG.FtePsyReg | FTE data with no corresponding Salary - Psychiatry Registrars and Trainees | select State, RegId, OrgId, coalesce(ExpSalPsyReg, 0), FtePsyReg from ORG where FtePsyReg > 0.1 and coalesce(ExpSalPsyReg, 0) = 0 |
| MedOtherSalAndNoFte | Inconsistent | High | No | ExpSalMedOther ($ExpSalMedOther) with no corresponding FteMedOther ($FteMedOther) | ORG.ExpSalMedOther | Salary data with no corresponding FTE - Other Medical Officers | select State, RegId, OrgId, ExpSalMedOther, FteMedOther from ORG where (ExpSalMedOther > 5000) and (FteMedOther = 0) |
| MedOtherFteAndNoSal | Inconsistent | High | No | FteMedOther ($FteMedOther) with no corresponding ExpSalMedOther (0) | ORG.FteMedOther | FTE data with no corresponding Salary - Other Medical Officers | select State, RegId, OrgId, coalesce(ExpSalMedOther, 0), FteMedOther from ORG where FteMedOther > 0.1 and coalesce(ExpSalMedOther, 0) = 0 |
| NursesRegSalAndNoFte | Inconsistent | High | No | ExpSalNursesReg ($ExpSalNursesReg) with no corresponding FteNursesReg ($FteNursesReg) | ORG.ExpSalNursesReg | Salary data with no corresponding FTE - Registered Nurses | select State, RegId, OrgId, ExpSalNursesReg, FteNursesReg from ORG where (ExpSalNursesReg > 5000) and (FteNursesReg = 0) |
| NursesRegFteAndNoSal | Inconsistent | High | No | FteNursesReg ($FteNursesReg) with no corresponding ExpSalNursesReg (0) | ORG.FteNursesReg | FTE data with no corresponding Salary - Registered Nurses | select State, RegId, OrgId, coalesce(ExpSalNursesReg, 0), FteNursesReg from ORG where FteNursesReg > 0.1 and coalesce(ExpSalNursesReg, 0) = 0 |
| NursesEnrlSalAndNoFte | Inconsistent | High | No | ExpSalNursesEnrl ($ExpSalNursesEnrl) with no corresponding FteNursesEnrl ($FteNursesEnrl) | ORG.ExpSalNursesEnrl | Salary data with no corresponding FTE - Enrolled Nurses | select State, RegId, OrgId, ExpSalNursesEnrl, FteNursesEnrl from ORG where (ExpSalNursesEnrl > 5000) and (FteNursesEnrl = 0) |
| NursesEnrlFteAndNoSal | Inconsistent | High | No | FteNursesEnrl ($FteNursesEnrl) with no corresponding ExpSalNursesEnrl (0) | ORG.FteNursesEnrl | FTE data with no corresponding Salary - Enrolled Nurses | select State, RegId, OrgId, coalesce(ExpSalNursesEnrl, 0), FteNursesEnrl from ORG where FteNursesEnrl > 0.1 and coalesce(ExpSalNursesEnrl, 0) = 0 |
| OTSalAndNoFte | Inconsistent | High | No | ExpSalOT ($ExpSalOT) with no corresponding FteOT ($FteOT) | ORG.ExpSalOT | Salary data with no corresponding FTE - Occupational Therapists | select State, RegId, OrgId, ExpSalOT, FteOT from ORG where (ExpSalOT > 5000) and (FteOT = 0) |
| OTFteAndNoSal | Inconsistent | High | No | FteOT ($FteOT) with no corresponding ExpSalOT (0) | ORG.FteOT | FTE data with no corresponding Salary - Occupational Therapists | select State, RegId, OrgId, coalesce(ExpSalOT, 0), FteOT from ORG where FteOT > 0.1 and coalesce(ExpSalOT, 0) = 0 |
| SocialWkSalAndNoFte | Inconsistent | High | No | ExpSalSocialWk ($ExpSalSocialWk) with no corresponding FteSocialWk ($FteSocialWk) | ORG.ExpSalSocialWk | Salary data with no corresponding FTE - Social Workers | select State, RegId, OrgId, ExpSalSocialWk, FteSocialWk from ORG where (ExpSalSocialWk > 5000) and (FteSocialWk = 0) |
| SocialWkFteAndNoSal | Inconsistent | High | No | FteSocialWk ($FteSocialWk) with no corresponding ExpSalSocialWk (0) | ORG.FteSocialWk | FTE data with no corresponding Salary - Social Workers | select State, RegId, OrgId, coalesce(ExpSalSocialWk, 0), FteSocialWk from ORG where FteSocialWk > 0.1 and coalesce(ExpSalSocialWk, 0) = 0 |
| PsycholSalAndNoFte | Inconsistent | High | No | ExpSalPsychol ($ExpSalPsychol) with no corresponding FtePsychol ($FtePsychol) | ORG.ExpSalPsychol | Salary data with no corresponding FTE - Psychologists | select State, RegId, OrgId, ExpSalPsychol, FtePsychol from ORG where (ExpSalPsychol > 5000) and (FtePsychol = 0) |
| PsycholFteAndNoSal | Inconsistent | High | No | FtePsychol ($FtePsychol) with no corresponding ExpSalPsychol (0) | ORG.FtePsychol | FTE data with no corresponding Salary - Psychologists | select State, RegId, OrgId, coalesce(ExpSalPsychol, 0), FtePsychol from ORG where FtePsychol > 0.1 and coalesce(ExpSalPsychol, 0) = 0 |
| DHPOtherSalAndNoFte | Inconsistent | High | No | ExpSalDHPOther ($ExpSalDHPOther) with no corresponding FteDHPOther ($FteDHPOther) | ORG.ExpSalDHPOther | Salary data with no corresponding FTE - Other Diagnostic and Health Professionals | select State, RegId, OrgId, ExpSalDHPOther, FteDHPOther from ORG where (ExpSalDHPOther > 5000) and (FteDHPOther = 0) |
| DHPOtherFteAndNoSal | Inconsistent | High | No | FteDHPOther ($FteDHPOther) with no corresponding ExpSalDHPOther (0) | ORG.FteDHPOther | FTE data with no corresponding Salary - Other Diagnostic and Health Professionals | select State, RegId, OrgId, coalesce(ExpSalDHPOther, 0), FteDHPOther from ORG where FteDHPOther > 0.1 and coalesce(ExpSalDHPOther, 0) = 0 |
| AdminSalAndNoFte | Inconsistent | High | No | ExpSalAdmin ($ExpSalAdmin) with no corresponding FteAdmin ($FteAdmin) | ORG.ExpSalAdmin | Salary data with no corresponding FTE - Administrative and Clerical Staff | select State, RegId, OrgId, ExpSalAdmin, FteAdmin from ORG where (ExpSalAdmin > 5000) and (FteAdmin = 0) |
| AdminFteAndNoSal | Inconsistent | High | No | FteAdmin ($FteAdmin) with no corresponding ExpSalAdmin (0) | ORG.FteAdmin | FTE data with no corresponding Salary - Administrative and Clerical Staff | select State, RegId, OrgId, coalesce(ExpSalAdmin, 0), FteAdmin from ORG where FteAdmin > 0.1 and coalesce(ExpSalAdmin, 0) = 0 |
| DomestSalAndNoFte | Inconsistent | High | No | ExpSalDomest ($ExpSalDomest) with no corresponding FteDomest ($FteDomest) | ORG.ExpSalDomest | Salary data with no corresponding FTE - Domestic and Other Staff | select State, RegId, OrgId, ExpSalDomest, FteDomest from ORG where (ExpSalDomest > 5000) and (FteDomest = 0) |
| DomestFteAndNoSal | Inconsistent | High | No | FteDomest ($FteDomest) with no corresponding ExpSalDomest (0) | ORG.FteDomest | FTE data with no corresponding Salary - Domestic and Other Staff | select State, RegId, OrgId, coalesce(ExpSalDomest, 0), FteDomest from ORG where FteDomest > 0.1 and coalesce(ExpSalDomest, 0) = 0 |
| PCareSalAndNoFte | Inconsistent | High | No | ExpSalPCare ($ExpSalPCare) with no corresponding FtePCare ($FtePCare) | ORG.ExpSalPCare | Salary data with no corresponding FTE - Other Personal Care Staff | select State, RegId, OrgId, ExpSalPCare, FtePCare from ORG where (ExpSalPCare > 5000) and (FtePCare = 0) |
| PCareFteAndNoSal | Inconsistent | High | No | FtePCare ($FtePCare) with no corresponding ExpSalPCare (0) | ORG.FtePCare | FTE data with no corresponding Salary - Other Personal Care Staff | select State, RegId, OrgId, coalesce(ExpSalPCare, 0), FtePCare from ORG where FtePCare > 0.1 and coalesce(ExpSalPCare, 0) = 0 |
| CarerWrkrSalAndNoFte | Inconsistent | High | No | ExpSalCarerWrkr ($ExpSalCarerWrkr) with no corresponding FteCarerWrkr ($FteCarerWrkr) | ORG.ExpSalCarerWrkr | Salary data with no corresponding FTE - Carer Workers | select State, RegId, OrgId, ExpSalCarerWrkr, FteCarerWrkr from ORG where (ExpSalCarerWrkr > 5000) and (FteCarerWrkr = 0) |
| CarerWrkrFteAndNoSal | Inconsistent | High | No | FteCarerWrkr ($FteCarerWrkr) with no corresponding ExpSalCarerWrkr (0) | ORG.FteCarerWrkr | FTE data with no corresponding Salary - Carer Workers | select State, RegId, OrgId, coalesce(ExpSalCarerWrkr, 0), FteCarerWrkr from ORG where FteCarerWrkr > 0.1 and coalesce(ExpSalCarerWrkr, 0) = 0 |
| ConsrWrkrSalAndNoFte | Inconsistent | High | No | ExpSalConsrWrkr ($ExpSalConsrWrkr) with no corresponding FteConsrWrkr ($FteConsrWrkr) | ORG.ExpSalConsrWrkr | Salary data with no corresponding FTE - Consumer Workers | select State, RegId, OrgId, ExpSalConsrWrkr, FteConsrWrkr from ORG where (ExpSalConsrWrkr > 5000) and (FteConsrWrkr = 0) |
| ConsrWrkrFteAndNoSal | Inconsistent | High | No | FteConsrWrkr ($FteConsrWrkr) with no corresponding ExpSalConsrWrkr (0) | ORG.FteConsrWrkr | FTE data with no corresponding Salary - Consumer Workers | select State, RegId, OrgId, coalesce(ExpSalConsrWrkr, 0), FteConsrWrkr from ORG where FteConsrWrkr > 0.1 and coalesce(ExpSalConsrWrkr, 0) = 0 |
| AdmiAndNoMedFte | Anomaly | High | No | Admitted Setting (1) with zero Medical FTE (FteMed) | ORG | Inconsistent FTEORG Admitted data - Medical - Admitted service setting with zero total FteMed | with SummedOrgFteMed as ( select State, RegId, OrgId, coalesce(sum(FteMed),0) as SumFteMed from FTEORG where Setting = '1' group by State, RegId, OrgId ) select State, RegId, OrgId from SummedOrgFteMed where SumFteMed = 0 |
| OrgFteAdminDiffers | Inconsistent | High | No | FteAdminSum ($FteAdminSum.commas) is not equal to OrgFteAdminSum ($OrgFteAdminSum.commas) | ORG | Inconsistent FTE data - Administrative and Clerical - Total Administrative and Clerical FTE reported at Setting Level is not equal to Total Administrative and Clerical FTE reported at Organisation Level | select State, RegId, OrgId, Org.Total as OrgFteAdminSum, Fte.Total as FteAdminSum from OrgFteAdminSum as Org join FteAdminSum as Fte using (State, RegId, OrgId) where abs(Fte.Total - Org.Total) > 1 |
| OrgFteCCWrkrDiffers | Inconsistent | High | No | FteCCWrkrSum ($FteCCWrkrSum.commas) is not equal to OrgFteCCWrkrSum ($OrgFteCCWrkrSum.commas) | ORG | Inconsistent FTE data - Carer and Consumer Workers - Total Carer and Consumer Workers FTE reported at Setting Level is not equal to Total Carer and Consumer Workers FTE reported at Organisation Level | select State, RegId, OrgId, Org.Total as OrgFteCCWrkrSum, Fte.Total as FteCCWrkrSum from OrgFteCCWrkrSum as Org join FteCCWrkrSum as Fte using (State, RegId, OrgId) where abs(Fte.Total - Org.Total) > 1 |
| OrgFteDHPDiffers | Inconsistent | High | No | FteDHPSum ($FteDHPSum.commas) is not equal to OrgFteDHPSum ($OrgFteDHPSum.commas) | ORG | Inconsistent FTE data - Diagnostic and Health Professionals - Total Diagnostic and Health Professionals FTE reported at Setting Level is not equal to Total Diagnostic and Health Professionals FTE reported at Organisation Level | select State, RegId, OrgId, Org.Total as OrgFteDHPSum, Fte.Total as FteDHPSum from OrgFteDHPSum as Org join FteDHPSum as Fte using (State, RegId, OrgId) where abs(Fte.Total - Org.Total) > 1 |
| OrgFteDomestDiffers | Inconsistent | High | No | FteDomestSum ($FteDomestSum.commas) is not equal to OrgFteDomestSum ($OrgFteDomestSum.commas) | ORG | Inconsistent FTE data - Domestic - Total Domestic FTE reported at Setting Level is not equal to Total Domestic FTE reported at Organisation Level | select State, RegId, OrgId, Org.Total as OrgFteDomestSum, Fte.Total as FteDomestSum from OrgFteDomestSum as Org join FteDomestSum as Fte using (State, RegId, OrgId) where abs(Fte.Total - Org.Total) > 1 |
| OrgFteMedDiffers | Inconsistent | High | No | FteMedSum ($FteMedSum.commas) is not equal to OrgFteMedSum ($OrgFteMedSum.commas) | ORG | Inconsistent FTE data - Medical - Total Medical FTE reported at Setting Level is not equal to Total Medical FTE reported at Organisation Level | select State, RegId, OrgId, Org.Total as OrgFteMedSum, Fte.Total as FteMedSum from OrgFteMedSum as Org join FteMedSum as Fte using (State, RegId, OrgId) where abs(Fte.Total - Org.Total) > 1 |
| OrgFteNursesDiffers | Inconsistent | High | No | FteNursesSum ($FteNursesSum.commas) is not equal to OrgFteNursesSum ($OrgFteNursesSum.commas) | ORG | Inconsistent FTE data - Nursing - Total Nursing FTE reported at Setting Level is not equal to Total Nursing FTE reported at Organisation Level | select State, RegId, OrgId, Org.Total as OrgFteNursesSum, Fte.Total as FteNursesSum from OrgFteNursesSum as Org join FteNursesSum as Fte using (State, RegId, OrgId) where abs(Fte.Total - Org.Total) > 1 |
| OrgFtePCareDiffers | Inconsistent | High | No | FtePCareSum ($FtePCareSum.commas) is not equal to OrgFtePCareSum ($OrgFtePCareSum.commas) | ORG | Inconsistent FTE data - Other Personal Care - Total Other Personal Care FTE reported at Setting Level is not equal to Total Other Personal Care FTE reported at Organisation Level | select State, RegId, OrgId, Org.Total as OrgFtePCareSum, Fte.Total as FtePCareSum from OrgFtePCareSum as Org join FtePCareSum as Fte using (State, RegId, OrgId) where abs(Fte.Total - Org.Total) > 1 |
| UnitUnion | No | SELECT ADMI.RecType, State, RegId, OrgId, HospId as HospClusId, AdmiId as UnitId, TargetPop, StdsReviewSt, Deprec, ExpNonSalTot, ExpSalTot, HOSP.Sector, HOSP.EstArea, HOSP.NonProfitNGO, AdmiName as UnitName, '1' as Setting FROM ADMI JOIN HOSP USING (State, RegId, OrgId, HospId) UNION SELECT RecType, State, RegId, OrgId, ClusId as HospClusId, ResiId as UnitId, TargetPop, StdsReviewSt, Deprec, ExpNonSalTot, ExpSalTot, Sector, EstArea, NonProfitNGO, ResiName as UnitName, '2' as Setting FROM RESI UNION SELECT RecType, State, RegId, OrgId, ClusId, AmbuId as UnitId, TargetPop, StdsReviewSt, Deprec, ExpNonSalTot, ExpSalTot, Sector, EstArea, NonProfitNGO, AmbuName as UnitName, '3' as Setting FROM AMBU | |||||
| FteorgUnit | No | SELECT State, RegId, OrgId, Setting, TargetPop, FTEORG.RecType IS NOT NULL as FteorgExists, COALESCE(UnitCount, 0) as UnitCount FROM FTEORG FULL OUTER JOIN ( SELECT State, RegId, OrgId, Setting, TargetPop, count(*) AS UnitCount FROM UnitUnion GROUP BY State, RegId, OrgId, Setting, TargetPop ) as UnitCount USING (State, RegId, OrgId, Setting, TargetPop) WHERE Setting != '4' and TargetPop != '7' -- FTEORG only | |||||
| OrgFteNoAdmi | Inconsistent | High | No | ORG has an FTEORG record for Setting 1 and TargetPop $TargetPop but no ADMI records | ORG | Organisation has an FTEORG record for Setting 1 but no Admitted Patient Service Unit records for a matching Target Population | select State, RegId, OrgId, Setting, TargetPop from FteorgUnit where Setting = '1' and FteorgExists and UnitCount = 0 |
| OrgAdmiNoFte | Inconsistent | High | No | ORG has $UnitCount ADMI records but no FTEORG record for Setting 1 and TargetPop $TargetPop | ORG | Organisation has Admitted Patient Service Unit records but no FTEORG record for Setting 1 with a matching Target Population | select State, RegId, OrgId, Setting, TargetPop, UnitCount from FteorgUnit where Setting = '1' and UnitCount > 0 and not FteorgExists |
| OrgFteNoResi | Inconsistent | High | No | ORG has an FTEORG record for Setting 2 and TargetPop $TargetPop but no RESI records | ORG | Organisation has an FTEORG record for Setting 2 but no Residential Service Unit records for a matching Target Population | select State, RegId, OrgId, Setting, TargetPop from FteorgUnit where Setting = '2' and FteorgExists and UnitCount = 0 |
| OrgResiNoFte | Inconsistent | High | No | ORG has $UnitCount RESI records but no FTEORG record for Setting 2 and TargetPop $TargetPop | ORG | Organisation has Residential Service Unit records but no FTEORG record for Setting 2 with a matching Target Population | select State, RegId, OrgId, Setting, TargetPop, UnitCount from FteorgUnit where Setting = '2' and UnitCount > 0 and not FteorgExists |
| OrgFteNoAmbu | Inconsistent | High | No | ORG has an FTEORG record for Setting 3 and TargetPop $TargetPop but no AMBU records | ORG | Organisation has an FTEORG record for Setting 3 but no Ambulatory Service Unit records for a matching Target Population | select State, RegId, OrgId, Setting, TargetPop from FteorgUnit where Setting = '3' and FteorgExists and UnitCount = 0 |
| OrgAmbuNoFte | Inconsistent | High | No | ORG has $UnitCount AMBU records but no FTEORG record for Setting 3 and TargetPop $TargetPop | ORG | Organisation has Ambulatory Service Unit records but no FTEORG record for Setting 3 with a matching Target Population | select State, RegId, OrgId, Setting, TargetPop, UnitCount from FteorgUnit where Setting = '3' and UnitCount > 0 and not FteorgExists |
| OrgWideExpZero | Anomaly | High | No | Zero reported for OrgWideExp | ORG | Zero reported for Organisation Wide Expenditure | select State, RegId, OrgId, Total as value from OrgWideExp where coalesce(Total, 0) = 0 |
| OrgExpSalUnitGtOrg | Inconsistent | High | No | OrgUnitExpSal ($OrgUnitExpSal.dollars) is greater than OrgExpSalTotal ($OrgExpSalTotal.dollars) by more than \$10,000 ($diff.dollars) | ORG.OrgUnitExpSal | Total Salary and Wages Expenditure at Service Unit Level is greater than Total Salary and Wages Expenditure at Organisation Level by more than $10,000 | select State, RegId, OrgId, Org.Total as OrgExpSalTotal, Unit.Total as OrgUnitExpSal, abs(Unit.Total - Org.Total) as diff from OrgExpSalTotal as Org join OrgUnitExpSal as Unit using (State, RegId, OrgId) where Unit.Total > Org.Total and abs(Unit.Total - Org.Total) > 10000 |
| OrgExpNonSalUnitGtOrg | Inconsistent | High | No | OrgUnitExpNonSal ($OrgUnitExpNonSal.dollars) is greater than OrgExpNonSalTotal ($OrgExpNonSalTotal.dollars) by more than \$10,000 ($diff.dollars) | ORG.OrgUnitExpNonSal | Total Non-salary Expenditure at Service Unit Level is greater than Total Non-salary Expenditure at Organisation Level by more than $10,000 | select State, RegId, OrgId, Org.Total as OrgExpNonSalTotal, Unit.Total as OrgUnitExpNonSal, abs(Unit.Total - Org.Total) as diff from OrgExpNonSalTotal as Org join OrgUnitExpNonSal as Unit using (State, RegId, OrgId) where Unit.Total > Org.Total and abs(Unit.Total - Org.Total) > 10000 |
| OrgRevExpDiff | No | select Rev.State as State, Rev.RegId as RegId, Rev.OrgId as OrgId, Rev.Total as RevTotal, Ner.Total as NerTotal, Unit.Total as UnitTotal, Deprec.Total as DeprecTotal, Ner.Total + Unit.Total + Deprec.Total as ExpTotal, abs(Rev.Total - (Ner.Total + Unit.Total + Deprec.Total)) as abs_diff, sd_div_safe(abs(Rev.Total - (Ner.Total + Unit.Total + Deprec.Total)), sd_min(Rev.Total, (Ner.Total + Unit.Total + Deprec.Total)), 3) as prop_diff from OrgRevTotal as Rev join OrgExpNerTotal as Ner using (State, RegId, OrgId) join OrgUnitExp as Unit using (State, RegId, OrgId) join OrgUnitDeprec as Deprec using (State, RegId, OrgId) | |||||
| OrgRevGtExp | Inconsistent | Low | No | OrgRevTotal ($RevTotal.commas) exceeds OrgExpNerTotal + OrgUnitExpTotal + OrgUnitDeprec ($NerTotal.commas + $UnitTotal.commas + $DeprecTotal = $ExpTotal.commas) by more than 5% ($prop_diff.perc) | ORG.OrgRevTotal | Total Revenue at Organisation Level exceeds the sum of Total Residual Expenditure at Organisation Level, Total Expenditure at Service Unit Level and Total Depreciation at Service Unit Level by more than 5% | select State, RegId, OrgId, RevTotal, NerTotal, UnitTotal, DeprecTotal, ExpTotal, prop_diff from OrgRevExpDiff where RevTotal > ExpTotal and prop_diff > 0.05 |
| OrgSNSGtWideExp | Inconsistent | High | No | OrgExpSNSTotal ($OrgExpSNSTotal.dollars) exceeds OrgWideExp ($OrgWideExp.dollars) by more than \$10,000 ($diff.dollars) | ORG.OrgExpSNSTotal | Total Salary and Non-Salary Expenditure at Organisation Level exceeds the of Organisation Wide Expenditure by more than $10000.dollars | select State, RegId, OrgId, OrgExpSNSTotal.Total as OrgExpSNSTotal, OrgWideExp.Total as OrgWideExp, OrgExpSNSTotal.Total - OrgWideExp.Total as diff from OrgExpSNSTotal join OrgWideExp using (State, RegId, OrgId) where OrgExpSNSTotal.Total > (OrgWideExp.Total + 10000) |
| AmbuNClientsGtNCont | Inconsistent | Low | No | NClients ($NClients.commas) exceeds NCont ($NCont.commas) | AMBU.NClients | Number of Clients Receiving Services (NClients) exceeds Number of Service Contacts (NCont) | select State, RegId, OrgId, ClusId, AmbuId, NClients, NCont from AMBU where NClients > NCont |
| AmbuAvgConRange | Exceptional | High | No | Contact Cost ($AvgCon.dollars) is outside the range \$30 to \$1,500 | AMBU.AmbuAvgCon | Exceptional Average Contact Cost - Average Contact Cost for Ambulatory Service Unit is outside the range $30 to $1,500. | select State, RegId, OrgId, ClusId, AmbuId, AvgCon from AMBU join AmbuAvgCon using(State, RegId, OrgId, ClusId, AmbuId) where (AvgCon < 30 or AvgCon > 1500) |
| AdmiOccupancyRangeCA | Exceptional | High | No | Occupancy ($Occupancy.perc) is outside the range 50% to 105% (AdmiNBeds $ADMI.AdmiNBeds.num, MHCareDays $ADMI.MHCareDays.num) | ADMI.MHCareDays | Exceptional Occupancy - Child and adolescent derived occupancy is outside the range 50% to 105% (Occupancy < 0.5 or Occupancy > 1.05) and TargetPop in ('1') | select State, RegId, OrgId, HospId, AdmiId, Occupancy, TargetPop from ADMI join AdmiOccupancy using(State, RegId, OrgId, HospId, AdmiId) where (Occupancy < 0.5 or Occupancy > 1.05) and TargetPop in ('1') |
| AdmiOccupancyRange | Exceptional | High | No | Occupancy ($Occupancy.perc) is outside the range 80% to 105% (AdmiNBeds $ADMI.AdmiNBeds.num, MHCareDays $ADMI.MHCareDays.num) | ADMI.MHCareDays | Exceptional Occupancy - Admitted Patient Service Unit derived occupancy is outside the range 80% to 105% (Occupancy < 0.8 or Occupancy > 1.05) and TargetPop in ('2','3','4','5') | select State, RegId, OrgId, HospId, AdmiId, Occupancy, TargetPop from ADMI join AdmiOccupancy using(State, RegId, OrgId, HospId, AdmiId) where (Occupancy < 0.8 or Occupancy > 1.05) and TargetPop in ('2','3','4','5') |
| ResiOccupancyRange | Exceptional | High | No | Occupancy ($Occupancy.perc) is outside the range 70% to 105% (ResiNBeds $RESI.ResiNBeds.num, MHCareDays $RESI.MHCareDays.num) | RESI.MHCareDays | Exceptional Occupancy - Residential Service Unit derived occupancy is outside the range 70% to 105% (Occupancy < 0.7 or Occupancy > 1.05) | select State, RegId, OrgId, ClusId, ResiId, Occupancy from RESI join ResiOccupancy using(State, RegId, OrgId, ClusId, ResiId) where (Occupancy < 0.7 or Occupancy > 1.05) |
| AdmiAvgStayGenAcRangeL | Exceptional | High | No | General Acute AdmiAvgStay ($AvgStay) is outside the range 6.4 to 25.6 (NBeds: $ADMI.AdmiNBeds) | ADMI.AvgStay | Exceptional Average Length of Stay - General Acute Average Length of Stay for Admitted Patient Service Unit is outside the range 6.4 to 25.6. The previous year's national average is 12.8 | select State, RegId, OrgId, HospId, AdmiId, AvgStay from ADMI join AvgStay using(State, RegId, OrgId, HospId, AdmiId) where (AvgStay < 6.4 or AvgStay > 25.6) and ProgType = '1' and TargetPop = '4' and AdmiNBeds >= 5 |
| AdmiAvgStayOldAcRangeL | Exceptional | High | No | Older person Acute AdmiAvgStay ($AvgStay) is outside the range 17.2 to 68.8 (NBeds: $ADMI.AdmiNBeds) | ADMI.AvgStay | Exceptional Average Length of Stay - Older person Acute Average Length of Stay for Admitted Patient Service Unit is outside the range 17.2 to 68.8. The previous year's national average is 34.4 | select State, RegId, OrgId, HospId, AdmiId, AvgStay from ADMI join AvgStay using(State, RegId, OrgId, HospId, AdmiId) where (AvgStay < 17.2 or AvgStay > 68.8) and ProgType = '1' and TargetPop = '2' and AdmiNBeds >= 5 |
| AdmiAvgStayCAAcRangeL | Exceptional | High | No | Child and adolescent Acute AdmiAvgStay ($AvgStay) is outside the range 5.2 to 20.7 (NBeds: $ADMI.AdmiNBeds) | ADMI.AvgStay | Exceptional Average Length of Stay - Child and adolescent Acute Average Length of Stay for Admitted Patient Service Unit is outside the range 5.2 to 20.7. The previous year's national average is 10.3 | select State, RegId, OrgId, HospId, AdmiId, AvgStay from ADMI join AvgStay using(State, RegId, OrgId, HospId, AdmiId) where (AvgStay < 5.2 or AvgStay > 20.7) and ProgType = '1' and TargetPop = '1' and AdmiNBeds >= 5 |
| AdmiAvgStayYthAcRangeL | Exceptional | High | No | Youth Acute AdmiAvgStay ($AvgStay) is outside the range 6.8 to 27.4 (NBeds: $ADMI.AdmiNBeds) | ADMI.AvgStay | Exceptional Average Length of Stay - Youth Acute Average Length of Stay for Admitted Patient Service Unit is outside the range 6.8 to 27.4. The previous year's national average is 13.7 | select State, RegId, OrgId, HospId, AdmiId, AvgStay from ADMI join AvgStay using(State, RegId, OrgId, HospId, AdmiId) where (AvgStay < 6.8 or AvgStay > 27.4) and ProgType = '1' and TargetPop = '5' and AdmiNBeds >= 5 |
| AdmiPDayCARangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$852 to \$2,555 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Child and adolescent Average Patient Day Cost for Admitted Patient Service Unit is outside the range $852 to $2,555. The previous year's national average is $1,703 (PDay < 852 or PDay > 2555) and TargetPop = '1' and AdmiNBeds >= 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 852 or PDay > 2555) and TargetPop = '1' and AdmiNBeds >= 5 |
| AdmiPDayCARangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$852 to \$2,555 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Child and adolescent Average Patient Day Cost for Admitted Patient Service Unit is outside the range $852 to $2,555. The previous year's national average is $1,703 (PDay < 852 or PDay > 2555) and TargetPop = '1' and AdmiNBeds < 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 852 or PDay > 2555) and TargetPop = '1' and AdmiNBeds < 5 |
| AdmiPDayOldAcRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$408 to \$1,225 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Older person Acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $408 to $1,225. The previous year's national average is $817 (PDay < 408 or PDay > 1225) and ProgType = '1' and TargetPop = '2' and AdmiNBeds >= 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 408 or PDay > 1225) and ProgType = '1' and TargetPop = '2' and AdmiNBeds >= 5 |
| AdmiPDayOldAcRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$408 to \$1,225 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Older person Acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $408 to $1,225. The previous year's national average is $817 (PDay < 408 or PDay > 1225) and ProgType = '1' and TargetPop = '2' and AdmiNBeds < 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 408 or PDay > 1225) and ProgType = '1' and TargetPop = '2' and AdmiNBeds < 5 |
| AdmiPDayOldRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$292 to \$875 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Older person Non-acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $292 to $875. The previous year's national average is $583 (PDay < 292 or PDay > 875) and ProgType = '2' and TargetPop = '2' and AdmiNBeds >= 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 292 or PDay > 875) and ProgType = '2' and TargetPop = '2' and AdmiNBeds >= 5 |
| AdmiPDayOldRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$292 to \$875 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Older person Non-acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $292 to $875. The previous year's national average is $583 (PDay < 292 or PDay > 875) and ProgType = '2' and TargetPop = '2' and AdmiNBeds < 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 292 or PDay > 875) and ProgType = '2' and TargetPop = '2' and AdmiNBeds < 5 |
| AdmiPDayForRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$488 to \$1,465 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Forensic Average Patient Day Cost for Admitted Patient Service Unit is outside the range $488 to $1,465. The previous year's national average is $977 (PDay < 488 or PDay > 1465) and TargetPop = '3' and AdmiNBeds >= 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 488 or PDay > 1465) and TargetPop = '3' and AdmiNBeds >= 5 |
| AdmiPDayForRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$488 to \$1,465 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Forensic Average Patient Day Cost for Admitted Patient Service Unit is outside the range $488 to $1,465. The previous year's national average is $977 (PDay < 488 or PDay > 1465) and TargetPop = '3' and AdmiNBeds < 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 488 or PDay > 1465) and TargetPop = '3' and AdmiNBeds < 5 |
| AdmiPDayGenAcRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$476 to \$1,428 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - General Acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $476 to $1,428. The previous year's national average is $952 (PDay < 476 or PDay > 1428) and ProgType = '1' and TargetPop = '4' and AdmiNBeds >= 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 476 or PDay > 1428) and ProgType = '1' and TargetPop = '4' and AdmiNBeds >= 5 |
| AdmiPDayGenAcRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$476 to \$1,428 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - General Acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $476 to $1,428. The previous year's national average is $952 (PDay < 476 or PDay > 1428) and ProgType = '1' and TargetPop = '4' and AdmiNBeds < 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 476 or PDay > 1428) and ProgType = '1' and TargetPop = '4' and AdmiNBeds < 5 |
| AdmiPDayGenRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$352 to \$1,057 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - General Non-acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $352 to $1,057. The previous year's national average is $705 (PDay < 352 or PDay > 1057) and ProgType = '2' and TargetPop = '4' and AdmiNBeds >= 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 352 or PDay > 1057) and ProgType = '2' and TargetPop = '4' and AdmiNBeds >= 5 |
| AdmiPDayGenRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$352 to \$1,057 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - General Non-acute Average Patient Day Cost for Admitted Patient Service Unit is outside the range $352 to $1,057. The previous year's national average is $705 (PDay < 352 or PDay > 1057) and ProgType = '2' and TargetPop = '4' and AdmiNBeds < 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 352 or PDay > 1057) and ProgType = '2' and TargetPop = '4' and AdmiNBeds < 5 |
| AdmiPDayYthRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$623 to \$1,868 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Youth Average Patient Day Cost for Admitted Patient Service Unit is outside the range $623 to $1,868. The previous year's national average is $1,246 (PDay < 623 or PDay > 1868) and TargetPop = '5' and AdmiNBeds >= 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 623 or PDay > 1868) and TargetPop = '5' and AdmiNBeds >= 5 |
| AdmiPDayYthRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$623 to \$1,868 (Occupancy $ADMI.AdmiOccupancy.perc, AdmiNBeds $ADMI.AdmiNBeds.num, AdmiExpTotal $ADMI.AdmiExpTotal.dollars) | ADMI.AdmiPDay | Exceptional Average Patient Day Cost - Youth Average Patient Day Cost for Admitted Patient Service Unit is outside the range $623 to $1,868. The previous year's national average is $1,246 (PDay < 623 or PDay > 1868) and TargetPop = '5' and AdmiNBeds < 5 | select State, RegId, OrgId, HospId, AdmiId, PDay from ADMI join AdmiPDay using(State, RegId, OrgId, HospId, AdmiId) where (PDay < 623 or PDay > 1868) and TargetPop = '5' and AdmiNBeds < 5 |
| ResiPDay24RangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$220 to \$880 (Occupancy $RESI.ResiOccupancy.perc, ResiNBeds $RESI.ResiNBeds.num, ResiExpTotal $RESI.ResiExpTotal.dollars) | RESI.ResiPDay | Exceptional Average Patient Day Cost - 24hr staffed Average Patient Day Cost for Residential Service Unit is outside the range $220 to $880. The previous year's national average is $440 (PDay < 220 or PDay > 880) and HrsStaffed = 24 and ResiNBeds >= 5 | select State, RegId, OrgId, ClusId, ResiId, PDay from RESI join ResiPDay using(State, RegId, OrgId, ClusId, ResiId) where (PDay < 220 or PDay > 880) and HrsStaffed = 24 and ResiNBeds >= 5 |
| ResiPDay24RangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$220 to \$880 (Occupancy $RESI.ResiOccupancy.perc, ResiNBeds $RESI.ResiNBeds.num, ResiExpTotal $RESI.ResiExpTotal.dollars) | RESI.ResiPDay | Exceptional Average Patient Day Cost - 24hr staffed Average Patient Day Cost for Residential Service Unit is outside the range $220 to $880. The previous year's national average is $440 (PDay < 220 or PDay > 880) and HrsStaffed = 24 and ResiNBeds < 5 | select State, RegId, OrgId, ClusId, ResiId, PDay from RESI join ResiPDay using(State, RegId, OrgId, ClusId, ResiId) where (PDay < 220 or PDay > 880) and HrsStaffed = 24 and ResiNBeds < 5 |
| ResiPDayN24RangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$88 to \$354 (Occupancy $RESI.ResiOccupancy.perc, ResiNBeds $RESI.ResiNBeds.num, ResiExpTotal $RESI.ResiExpTotal.dollars) | RESI.ResiPDay | Exceptional Average Patient Day Cost - non-24hr staffed Average Patient Day Cost for Residential Service Unit is outside the range $88 to $354. The previous year's national average is $177 (PDay < 88 or PDay > 354) and HrsStaffed < 24 and ResiNBeds >= 5 | select State, RegId, OrgId, ClusId, ResiId, PDay from RESI join ResiPDay using(State, RegId, OrgId, ClusId, ResiId) where (PDay < 88 or PDay > 354) and HrsStaffed < 24 and ResiNBeds >= 5 |
| ResiPDayN24RangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$88 to \$354 (Occupancy $RESI.ResiOccupancy.perc, ResiNBeds $RESI.ResiNBeds.num, ResiExpTotal $RESI.ResiExpTotal.dollars) | RESI.ResiPDay | Exceptional Average Patient Day Cost - non-24hr staffed Average Patient Day Cost for Residential Service Unit is outside the range $88 to $354. The previous year's national average is $177 (PDay < 88 or PDay > 354) and HrsStaffed < 24 and ResiNBeds < 5 | select State, RegId, OrgId, ClusId, ResiId, PDay from RESI join ResiPDay using(State, RegId, OrgId, ClusId, ResiId) where (PDay < 88 or PDay > 354) and HrsStaffed < 24 and ResiNBeds < 5 |
| AdmiAvgSalRange | Exceptional | High | No | Average Admi Salary ($AvgSal.dollars) is outside the range \$54,066 to \$162,198 | ORG.FteorgAdmiTotal | Exceptional Average Service Setting Salaries - Average Salary for Admitted Patient Service Unit at Organisation Level is outside the range $54,066 to $162,198. The previous year's national average is $108,132 | select State, RegId, OrgId, AvgSal from OrgAdmiAvgSal where AvgSal < 54066 or AvgSal > 162198 |
| ResiAvgSalRange | Exceptional | High | No | Average Resi Salary ($AvgSal.dollars) is outside the range \$43,055 to \$129,165 | ORG.FteorgResiTotal | Exceptional Average Service Setting Salaries - Average Salary for Residential Service Unit at Organisation Level is outside the range $43,055 to $129,165. The previous year's national average is $86,110 | select State, RegId, OrgId, AvgSal from OrgResiAvgSal where AvgSal < 43055 or AvgSal > 129165 |
| AmbuAvgSalRange | Exceptional | High | No | Average Ambu Salary ($AvgSal.dollars) is outside the range \$55,961 to \$167,883 | ORG.FteorgAmbuTotal | Exceptional Average Service Setting Salaries - Average Salary for Ambulatory Service Unit at Organisation Level is outside the range $55,961 to $167,883. The previous year's national average is $111,922 | select State, RegId, OrgId, AvgSal from OrgAmbuAvgSal where AvgSal < 55961 or AvgSal > 167883 |
| AdminAvgSalRange | Exceptional | High | No | Average Administrative and Clerical Salary ($AvgSal.dollars) is outside the range \$37,328 to \$111,985 | ORG.OrgAdminAvgSal | Exceptional Average Salary - Average Administrative and Clerical Salary reported at Organisation Level is outside the range $37,328 to $111,985. The previous year's national average is $74,657 | select State, RegId, OrgId, AvgSal from OrgAdminAvgSal where AvgSal < 37328 or AvgSal > 111985 |
| CarerWrkrAvgSalRange | Exceptional | High | No | Average Carer Workers Salary ($AvgSal.dollars) is outside the range \$32,017 to \$96,050 | ORG.OrgCarerWrkrAvgSal | Exceptional Average Salary - Average Carer Workers Salary reported at Organisation Level is outside the range $32,017 to $96,050. The previous year's national average is $64,033 | select State, RegId, OrgId, AvgSal from OrgCarerWrkrAvgSal where AvgSal < 32017 or AvgSal > 96050 |
| ConsrWrkrAvgSalRange | Exceptional | High | No | Average Consumer Workers Salary ($AvgSal.dollars) is outside the range \$34,275 to \$102,824 | ORG.OrgConsrWrkrAvgSal | Exceptional Average Salary - Average Consumer Workers Salary reported at Organisation Level is outside the range $34,275 to $102,824. The previous year's national average is $68,550 | select State, RegId, OrgId, AvgSal from OrgConsrWrkrAvgSal where AvgSal < 34275 or AvgSal > 102824 |
| DHPAvgSalRange | Exceptional | High | No | Average Diagnostic and Health Professionals Salary ($AvgSal.dollars) is outside the range \$46,707 to \$140,122 | ORG.OrgDHPAvgSal | Exceptional Average Salary - Average Diagnostic and Health Professionals Salary reported at Organisation Level is outside the range $46,707 to $140,122. The previous year's national average is $93,414 | select State, RegId, OrgId, AvgSal from OrgDHPAvgSal where AvgSal < 46707 or AvgSal > 140122 |
| DomestAvgSalRange | Exceptional | High | No | Average Domestic Salary ($AvgSal.dollars) is outside the range \$30,077 to \$90,232 | ORG.OrgDomestAvgSal | Exceptional Average Salary - Average Domestic Salary reported at Organisation Level is outside the range $30,077 to $90,232. The previous year's national average is $60,155 | select State, RegId, OrgId, AvgSal from OrgDomestAvgSal where AvgSal < 30077 or AvgSal > 90232 |
| NursesAvgSalRange | Exceptional | High | No | Average Nursing Salary ($AvgSal.dollars) is outside the range \$48,816 to \$146,448 | ORG.OrgNursesAvgSal | Exceptional Average Salary - Average Nursing Salary reported at Organisation Level is outside the range $48,816 to $146,448. The previous year's national average is $97,632 | select State, RegId, OrgId, AvgSal from OrgNursesAvgSal where AvgSal < 48816 or AvgSal > 146448 |
| PCareAvgSalRange | Exceptional | High | No | Average Other Personal Care Salary ($AvgSal.dollars) is outside the range \$32,603 to \$97,810 | ORG.OrgPCareAvgSal | Exceptional Average Salary - Average Other Personal Care Salary reported at Organisation Level is outside the range $32,603 to $97,810. The previous year's national average is $65,207 | select State, RegId, OrgId, AvgSal from OrgPCareAvgSal where AvgSal < 32603 or AvgSal > 97810 |
| RealMedAvgExpRange | Exceptional | High | No | Average Medical and VMOs Expenditure ($AvgSal.dollars) is outside the range \$106,151 to \$318,454 | ORG.OrgRealMedAvgSal | Exceptional Average Expenditure - Average Medical and VMOs Expenditure reported at Organisation Level is outside the range $106,151 to $318,454. The previous year's national average is $212,302 | select State, RegId, OrgId, AvgSal from OrgRealMedAvgSal where AvgSal < 106151 or AvgSal > 318454 |
| OrgNerDiffL | Exceptional | High | No | Residual Expenditure ($OrgExpNerTotal.dollars) is over 25% ($prop.perc) of Expenditure ($OrgWideExp.dollars) | ORG.OrgExpNerTotal | Exceptional Residual Expenditure - Total Residual Expenditure at Organisation Level is over 25% of Organisation Wide Expenditure | select State, RegId, OrgId, Ner.Total as OrgExpNerTotal, Exp.Total as OrgWideExp, sd_div(Ner.Total, Exp.Total, 3) as prop from OrgExpNerTotal as Ner join OrgWideExp as Exp using (State, RegId, OrgId) where Ner.Total > 0.25 * Exp.Total and Exp.Total >= 1000000 |
| OrgNerDiffS | Exceptional | Low | No | Residual Expenditure ($OrgExpNerTotal.dollars) is over 25% ($prop.perc) of Expenditure ($OrgWideExp.dollars) | ORG.OrgExpNerTotal | Exceptional Residual Expenditure - Total Residual Expenditure at Organisation Level is over 25% of Organisation Wide Expenditure | select State, RegId, OrgId, Ner.Total as OrgExpNerTotal, Exp.Total as OrgWideExp, sd_div(Ner.Total, Exp.Total, 3) as prop from OrgExpNerTotal as Ner join OrgWideExp as Exp using (State, RegId, OrgId) where Ner.Total > 0.25 * Exp.Total and Exp.Total < 1000000 |
| RegNerDiffL | Exceptional | High | No | Residual Expenditure ($RegWideExpNer.dollars) is over 25% ($prop.perc) of Expenditure ($RegWideExp.dollars) | REG.RegWideExpNer | Exceptional Residual Expenditure - Region Wide Residual Expenditure is over 25% of Region Wide Expenditure | select State, RegId, Ner.Total as RegWideExpNer, Exp.Total as RegWideExp, sd_div(Ner.Total, Exp.Total, 3) as prop from RegWideExpNer as Ner join RegWideExp as Exp using (State, RegId) where Ner.Total > 0.25 * Exp.Total and Exp.Total >= 1000000 |
| RegNerDiffS | Exceptional | Low | No | Residual Expenditure ($RegWideExpNer.dollars) is over 25% ($prop.perc) of Expenditure ($RegWideExp.dollars) | REG.RegWideExpNer | Exceptional Residual Expenditure - Region Wide Residual Expenditure is over 25% of Region Wide Expenditure | select State, RegId, Ner.Total as RegWideExpNer, Exp.Total as RegWideExp, sd_div(Ner.Total, Exp.Total, 3) as prop from RegWideExpNer as Ner join RegWideExp as Exp using (State, RegId) where Ner.Total > 0.25 * Exp.Total and Exp.Total < 1000000 |
| VMOExpAndNoMedFte | Inconsistent | High | No | ExpNonSalVMO $ExpNonSalVMO.dollars with zero Medical FTE (OrgFteMedSum) | ORG.FteMedSum | Non-Salary Recurrent Expenditure - Payments to Visiting Medical Officers is greater than zero, but zero Total Medical FTE reported at Organisation Level is reported | select State, RegId, OrgId from ORG join OrgFteMedSum as Fte using (State, RegId, OrgId) where ExpNonSalVMO > 0 and Fte.Total = 0 |
| OrgNerChanged | Historical | High | No | Residual Expenditure change ($OrgExpNerChange.dollars or $OrgExpNerGrowth.perc) is over double Expenditure growth $OrgWideExpGrowth.perc | ORG.OrgExpNerTotal | Disproportionate change in Total Residual Expenditure at Organisation Level Growth - Total Residual Expenditure at Organisation Level change exceeds $1,000,000 and growth is both over 100% and more than double the growth in Organisation Wide Expenditure | select Growth.State as State, Growth.RegId as RegId, Growth.OrgId as OrgId, Growth.Growth as OrgExpNerGrowth, Change.Change as OrgExpNerChange, Exp.Growth as OrgWideExpGrowth from OrgExpNerGrowth as Growth join OrgExpNerChange as Change using (State, RegId, OrgId) join OrgWideExpGrowth as Exp using (State, RegId, OrgId) where Growth.Growth > 1.00 and Change.Change > 1000000 and Growth.Growth > 2 * Exp.Growth |
| RegNerChanged | Historical | High | No | Residual Expenditure change ($RegWideExpNerChange.dollars or $RegWideExpNerGrowth.perc) is over double Expenditure growth $RegWideExpGrowth.perc | REG.RegWideExpNer | Disproportionate change in Region Wide Residual Expenditure Growth - Region Wide Residual Expenditure change exceeds $1,000,000 and growth is both over 100% and more than double the growth in Region Wide Expenditure | select Growth.State as State, Growth.RegId as RegId, Growth.Growth as RegWideExpNerGrowth, Change.Change as RegWideExpNerChange, Exp.Growth as RegWideExpGrowth from RegWideExpNerGrowth as Growth join RegWideExpNerChange as Change using (State, RegId) join RegWideExpGrowth as Exp using (State, RegId) where Growth.Growth > 1.00 and Change.Change > 1000000 and Growth.Growth > 2 * Exp.Growth |
| RegNerReportingChanged | Historical | High | No | RegExpNerTotal is zero for this year and over \$1,000,000 ($OldTotal.dollars) last year | REG.ExpNerTotal | This Region reported zero Indirect expenditure for this submission compared to greater than $1,000,000 last year. Submitters should comment if there has been a change in Indirect expenditure reporting methodology. | select State, RegId, New.Total, Old.Total OldTotal from RegExpNerTotal as New join hist.RegExpNerTotal as Old using ( State, RegId ) where New.Total = 0 and Old.Total > 1000000 |
| OrgNerReportingChanged | Historical | High | No | OrgExpNerTotal is zero for this year and over \$1,000,000 ($OldTotal.dollars) last year | ORG.ExpNerTotal | This Organisation reported zero Indirect expenditure for this submission compared to greater than $1,000,000 last year. Submitters should comment if there has been a change in Indirect expenditure reporting methodology. | select State, RegId, OrgId, New.Total, Old.Total OldTotal from OrgExpNerTotal as New join hist.OrgExpNerTotal as Old using ( State, RegId, OrgId ) where New.Total = 0 and Old.Total > 1000000 |
| StStNerSumUnchanged | Historical | High | No | StStNerSum ($Total.commas) is identical to previous year | ST.StStNerSum | Total State/Territory Expenditure (NER) is identical to the previous year. | select State, New.Total from StStNerSum as New join hist.StStNerSum as Old using ( State ) where New.Total = Old.Total and New.Total > 0 |
| StNgoTotalUnchanged | Historical | High | No | StNgoTotal ($Total.commas) is identical to previous year | ST.StNgoTotal | Total NGO Expenditure at State/Territory Level is identical to the previous year. | select State, New.Total from StNgoTotal as New join hist.StNgoTotal as Old using ( State ) where New.Total = Old.Total and New.Total > 0 |
| RegExpNerTotalUnchanged | Historical | High | No | RegExpNerTotal ($Total.commas) is identical to previous year | REG.RegExpNerTotal | Total Residual Expenditure at Region Level is identical to the previous year. | select State, RegId, New.Total from RegExpNerTotal as New join hist.RegExpNerTotal as Old using ( State, RegId ) where New.Total = Old.Total and New.Total > 0 |
| RegNgoTotalUnchanged | Historical | High | No | RegNgoTotal ($Total.commas) is identical to previous year | REG.RegNgoTotal | Total NGO Expenditure at Region Level is identical to the previous year. | select State, RegId, New.Total from RegNgoTotal as New join hist.RegNgoTotal as Old using ( State, RegId ) where New.Total = Old.Total and New.Total > 0 |
| OrgExpNerTotalUnchanged | Historical | High | No | OrgExpNerTotal ($Total.commas) is identical to previous year | ORG.OrgExpNerTotal | Total Residual Expenditure at Organisation Level is identical to the previous year. | select State, RegId, OrgId, New.Total from OrgExpNerTotal as New join hist.OrgExpNerTotal as Old using ( State, RegId, OrgId ) where New.Total = Old.Total and New.Total > 0 |
| OrgFteDCareSumUnchanged | Historical | High | No | OrgFteDCareSum ($Total.commas) is identical to previous year | ORG.OrgFteDCareSum | Total Direct Care FTE reported at Organisation Level is identical to the previous year. | select State, RegId, OrgId, New.Total from OrgFteDCareSum as New join hist.OrgFteDCareSum as Old using ( State, RegId, OrgId ) where New.Total = Old.Total and New.Total > 20 |
| OrgAdmiGrowthVaries | Historical | High | No | Growth variation over 50% ($diff.perc) in OrgAdmiNBedsGrowth, OrgAdmiCDaysGrowth, OrgAdmiDCareFteGrowth, OrgAdmiExpGrowth ($OrgAdmiNBedsGrowth.perc, $OrgAdmiCDaysGrowth.perc, $OrgAdmiDCareFteGrowth.perc, $OrgAdmiExpGrowth.perc) | ORG | Disproportionate Change Pattern in Admitted Patient Service Unit Growth - The following historical growth fields are compared and differences greater than 50% are flagged: Total Average Available Beds for Overnight-stay Patients Growth, Total Accrued Mental Health Care Days Growth, Total Direct Care FTE for Admitted Patient Service Units Growth, Admitted Patient Service Unit Total Expenditure Growth | select OrgAdmiNBedsGrowth.State as State, OrgAdmiNBedsGrowth.RegId as RegId, OrgAdmiNBedsGrowth.OrgId as OrgId, sd_max(OrgAdmiNBedsGrowth.Growth, OrgAdmiCDaysGrowth.Growth, OrgAdmiDCareFteGrowth.Growth, OrgAdmiExpGrowth.Growth) as max, sd_min(OrgAdmiNBedsGrowth.Growth, OrgAdmiCDaysGrowth.Growth, OrgAdmiDCareFteGrowth.Growth, OrgAdmiExpGrowth.Growth) as min, abs( sd_max(OrgAdmiNBedsGrowth.Growth, OrgAdmiCDaysGrowth.Growth, OrgAdmiDCareFteGrowth.Growth, OrgAdmiExpGrowth.Growth) -sd_min(OrgAdmiNBedsGrowth.Growth, OrgAdmiCDaysGrowth.Growth, OrgAdmiDCareFteGrowth.Growth, OrgAdmiExpGrowth.Growth)) as diff, OrgAdmiNBedsGrowth.Growth as OrgAdmiNBedsGrowth, OrgAdmiCDaysGrowth.Growth as OrgAdmiCDaysGrowth, OrgAdmiDCareFteGrowth.Growth as OrgAdmiDCareFteGrowth, OrgAdmiExpGrowth.Growth as OrgAdmiExpGrowth, OrgAdmiNBedsChange.Change as OrgAdmiNBedsChange, OrgAdmiCDaysChange.Change as OrgAdmiCDaysChange, OrgAdmiDCareFteChange.Change as OrgAdmiDCareFteChange, OrgAdmiExpChange.Change as OrgAdmiExpChange from OrgAdmiNBedsGrowth join OrgAdmiNBedsChange using(State, RegId, OrgId) join OrgAdmiCDaysGrowth using(State, RegId, OrgId) join OrgAdmiCDaysChange using(State, RegId, OrgId) join OrgAdmiDCareFteGrowth using(State, RegId, OrgId) join OrgAdmiDCareFteChange using(State, RegId, OrgId) join OrgAdmiExpGrowth using(State, RegId, OrgId) join OrgAdmiExpChange using(State, RegId, OrgId) where abs( sd_max(OrgAdmiNBedsGrowth.Growth, OrgAdmiCDaysGrowth.Growth, OrgAdmiDCareFteGrowth.Growth, OrgAdmiExpGrowth.Growth) - sd_min(OrgAdmiNBedsGrowth.Growth, OrgAdmiCDaysGrowth.Growth, OrgAdmiDCareFteGrowth.Growth, OrgAdmiExpGrowth.Growth) ) > 0.50 |
| OrgResiGrowthVaries | Historical | High | No | Growth variation over 50% ($diff.perc) in OrgResiNBedsGrowth, OrgResiCDaysGrowth, OrgResiDCareFteGrowth, OrgResiExpGrowth ($OrgResiNBedsGrowth.perc, $OrgResiCDaysGrowth.perc, $OrgResiDCareFteGrowth.perc, $OrgResiExpGrowth.perc) | ORG | Disproportionate Change Pattern in Residential Service Unit Growth - The following historical growth fields are compared and differences greater than 50% are flagged: Total Average Available Beds for Residential Mental Health Patients Growth, Total Accrued Mental Health Care Days Growth, Total Direct Care FTE for Residential Service Units Growth, Residential Service Unit Total Expenditure Growth | select OrgResiNBedsGrowth.State as State, OrgResiNBedsGrowth.RegId as RegId, OrgResiNBedsGrowth.OrgId as OrgId, sd_max(OrgResiNBedsGrowth.Growth, OrgResiCDaysGrowth.Growth, OrgResiDCareFteGrowth.Growth, OrgResiExpGrowth.Growth) as max, sd_min(OrgResiNBedsGrowth.Growth, OrgResiCDaysGrowth.Growth, OrgResiDCareFteGrowth.Growth, OrgResiExpGrowth.Growth) as min, abs( sd_max(OrgResiNBedsGrowth.Growth, OrgResiCDaysGrowth.Growth, OrgResiDCareFteGrowth.Growth, OrgResiExpGrowth.Growth) -sd_min(OrgResiNBedsGrowth.Growth, OrgResiCDaysGrowth.Growth, OrgResiDCareFteGrowth.Growth, OrgResiExpGrowth.Growth)) as diff, OrgResiNBedsGrowth.Growth as OrgResiNBedsGrowth, OrgResiCDaysGrowth.Growth as OrgResiCDaysGrowth, OrgResiDCareFteGrowth.Growth as OrgResiDCareFteGrowth, OrgResiExpGrowth.Growth as OrgResiExpGrowth, OrgResiNBedsChange.Change as OrgResiNBedsChange, OrgResiCDaysChange.Change as OrgResiCDaysChange, OrgResiDCareFteChange.Change as OrgResiDCareFteChange, OrgResiExpChange.Change as OrgResiExpChange from OrgResiNBedsGrowth join OrgResiNBedsChange using(State, RegId, OrgId) join OrgResiCDaysGrowth using(State, RegId, OrgId) join OrgResiCDaysChange using(State, RegId, OrgId) join OrgResiDCareFteGrowth using(State, RegId, OrgId) join OrgResiDCareFteChange using(State, RegId, OrgId) join OrgResiExpGrowth using(State, RegId, OrgId) join OrgResiExpChange using(State, RegId, OrgId) where abs( sd_max(OrgResiNBedsGrowth.Growth, OrgResiCDaysGrowth.Growth, OrgResiDCareFteGrowth.Growth, OrgResiExpGrowth.Growth) - sd_min(OrgResiNBedsGrowth.Growth, OrgResiCDaysGrowth.Growth, OrgResiDCareFteGrowth.Growth, OrgResiExpGrowth.Growth) ) > 0.50 |
| OrgAmbuGrowthVaries | Historical | High | No | Growth variation over 50% ($diff.perc) in OrgAmbuDCareFteGrowth, OrgAmbuExpGrowth ($OrgAmbuDCareFteGrowth.perc, $OrgAmbuExpGrowth.perc) | ORG | Disproportionate Change Pattern in Ambulatory Service Unit Growth - The following historical growth fields are compared and differences greater than 50% are flagged: Total Direct Care FTE for Ambulatory Service Units Growth, Ambulatory Service Unit Total Expenditure Growth | select OrgAmbuDCareFteGrowth.State as State, OrgAmbuDCareFteGrowth.RegId as RegId, OrgAmbuDCareFteGrowth.OrgId as OrgId, sd_max(OrgAmbuDCareFteGrowth.Growth, OrgAmbuExpGrowth.Growth) as max, sd_min(OrgAmbuDCareFteGrowth.Growth, OrgAmbuExpGrowth.Growth) as min, abs( sd_max(OrgAmbuDCareFteGrowth.Growth, OrgAmbuExpGrowth.Growth) -sd_min(OrgAmbuDCareFteGrowth.Growth, OrgAmbuExpGrowth.Growth)) as diff, OrgAmbuDCareFteGrowth.Growth as OrgAmbuDCareFteGrowth, OrgAmbuExpGrowth.Growth as OrgAmbuExpGrowth, OrgAmbuDCareFteChange.Change as OrgAmbuDCareFteChange, OrgAmbuExpChange.Change as OrgAmbuExpChange from OrgAmbuDCareFteGrowth join OrgAmbuDCareFteChange using(State, RegId, OrgId) join OrgAmbuExpGrowth using(State, RegId, OrgId) join OrgAmbuExpChange using(State, RegId, OrgId) where abs( sd_max(OrgAmbuDCareFteGrowth.Growth, OrgAmbuExpGrowth.Growth) - sd_min(OrgAmbuDCareFteGrowth.Growth, OrgAmbuExpGrowth.Growth) ) > 0.50 |
| AdmiContentSame | Anomaly | High | Yes | $DupCount ADMI records with identical Number fields | ADMI | Multiple ADMI records found with identical Number fields: LHNID, Deprec, ExpNonSalTot, ExpSalTot, AdmiNBeds, MHCareDays, NSeps | select State, RegId, OrgId, HospId, AdmiId, LHNID,Deprec,ExpNonSalTot,ExpSalTot,AdmiNBeds,MHCareDays,NSeps, DupCount from ADMI join ( select LHNID,Deprec,ExpNonSalTot,ExpSalTot,AdmiNBeds,MHCareDays,NSeps,count(*) as DupCount from ADMI group by LHNID,Deprec,ExpNonSalTot,ExpSalTot,AdmiNBeds,MHCareDays,NSeps having count(*) > 1 ) as tmpinner using ( LHNID,Deprec,ExpNonSalTot,ExpSalTot,AdmiNBeds,MHCareDays,NSeps ) |
| AmbuContentSame | Anomaly | High | Yes | $DupCount AMBU records with identical Number fields | AMBU | Multiple AMBU records found with identical Number fields: LHNID, Deprec, ExpNonSalTot, ExpSalTot, NClients, NCont | select State, RegId, OrgId, ClusId, AmbuId, LHNID,Deprec,ExpNonSalTot,ExpSalTot,NClients,NCont, DupCount from AMBU join ( select LHNID,Deprec,ExpNonSalTot,ExpSalTot,NClients,NCont,count(*) as DupCount from AMBU group by LHNID,Deprec,ExpNonSalTot,ExpSalTot,NClients,NCont having count(*) > 1 ) as tmpinner using ( LHNID,Deprec,ExpNonSalTot,ExpSalTot,NClients,NCont ) |
| ResiContentSame | Anomaly | High | Yes | $DupCount RESI records with identical Number fields | RESI | Multiple RESI records found with identical Number fields: LHNID, HrsStaffed, Deprec, ExpNonSalTot, ExpSalTot, ResiNBeds, MHCareDays, NEpi | select State, RegId, OrgId, ClusId, ResiId, LHNID,HrsStaffed,Deprec,ExpNonSalTot,ExpSalTot,ResiNBeds,MHCareDays,NEpi, DupCount from RESI join ( select LHNID,HrsStaffed,Deprec,ExpNonSalTot,ExpSalTot,ResiNBeds,MHCareDays,NEpi,count(*) as DupCount from RESI group by LHNID,HrsStaffed,Deprec,ExpNonSalTot,ExpSalTot,ResiNBeds,MHCareDays,NEpi having count(*) > 1 ) as tmpinner using ( LHNID,HrsStaffed,Deprec,ExpNonSalTot,ExpSalTot,ResiNBeds,MHCareDays,NEpi ) |
| FteorgContentSame | Anomaly | High | Yes | $DupCount FTEORG records with identical Number fields | FTEORG | Multiple FTEORG records found with identical Number fields: FteMed, FteNurses, FteDHP, FteAdmin, FteDomest, FteCCWrkr, FtePCare | select State, RegId, OrgId, Setting, TargetPop, FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FteCCWrkr,FtePCare, DupCount from FTEORG join ( select FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FteCCWrkr,FtePCare,count(*) as DupCount from FTEORG group by FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FteCCWrkr,FtePCare having count(*) > 1 ) as tmpinner using ( FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FteCCWrkr,FtePCare ) |
| OrgFteCnsltPsychGrowthVaries | Historical | High | No | OrgFteCnsltPsychChange ($Change) size is over 10 FTE | ORG.FteCnsltPsych | Large historical change in Consultant Psychiatrists and Psychiatrists (FteCnsltPsych), over 10 FTE. This rules uses Full-Time Equivalent Staff - Consultant Psychiatrists and Psychiatrists Change and Growth fields (OrgFteCnsltPsychChange and OrgFteCnsltPsychGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteCnsltPsychChange join OrgFteCnsltPsychGrowth using (State, RegId, OrgId) where abs(Change) > 10 |
| OrgFtePsyRegGrowthVaries | Historical | High | No | OrgFtePsyRegChange ($Change) size is over 10 FTE | ORG.FtePsyReg | Large historical change in Psychiatry Registrars and Trainees (FtePsyReg), over 10 FTE. This rules uses Full-Time Equivalent Staff - Psychiatry Registrars and Trainees Change and Growth fields (OrgFtePsyRegChange and OrgFtePsyRegGrowth). | select State, RegId, OrgId, Change, Growth from OrgFtePsyRegChange join OrgFtePsyRegGrowth using (State, RegId, OrgId) where abs(Change) > 10 |
| OrgFteMedOtherGrowthVaries | Historical | High | No | OrgFteMedOtherChange ($Change) size is over 10 FTE | ORG.FteMedOther | Large historical change in Other Medical Officers (FteMedOther), over 10 FTE. This rules uses Full-Time Equivalent Staff - Other Medical Officers Change and Growth fields (OrgFteMedOtherChange and OrgFteMedOtherGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteMedOtherChange join OrgFteMedOtherGrowth using (State, RegId, OrgId) where abs(Change) > 10 |
| OrgFteNursesRegGrowthVaries | Historical | High | No | OrgFteNursesRegChange ($Change) size is over 10 FTE and OrgFteNursesRegGrowth ($Growth.perc) size is over 40% | ORG.FteNursesReg | Large historical change in Registered Nurses (FteNursesReg), over 10 FTE and over 40%. This rules uses Full-Time Equivalent Staff - Registered Nurses Change and Growth fields (OrgFteNursesRegChange and OrgFteNursesRegGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteNursesRegChange join OrgFteNursesRegGrowth using (State, RegId, OrgId) where abs(Change) > 10 and abs(Growth) > 0.40 |
| OrgFteNursesEnrlGrowthVaries | Historical | High | No | OrgFteNursesEnrlChange ($Change) size is over 10 FTE and OrgFteNursesEnrlGrowth ($Growth.perc) size is over 40% | ORG.FteNursesEnrl | Large historical change in Enrolled Nurses (FteNursesEnrl), over 10 FTE and over 40%. This rules uses Full-Time Equivalent Staff - Enrolled Nurses Change and Growth fields (OrgFteNursesEnrlChange and OrgFteNursesEnrlGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteNursesEnrlChange join OrgFteNursesEnrlGrowth using (State, RegId, OrgId) where abs(Change) > 10 and abs(Growth) > 0.40 |
| OrgFteOTGrowthVaries | Historical | High | No | OrgFteOTChange ($Change) size is over 10 FTE | ORG.FteOT | Large historical change in Occupational Therapists (FteOT), over 10 FTE. This rules uses Full-Time Equivalent Staff - Occupational Therapists Change and Growth fields (OrgFteOTChange and OrgFteOTGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteOTChange join OrgFteOTGrowth using (State, RegId, OrgId) where abs(Change) > 10 |
| OrgFteSocialWkGrowthVaries | Historical | High | No | OrgFteSocialWkChange ($Change) size is over 10 FTE | ORG.FteSocialWk | Large historical change in Social Workers (FteSocialWk), over 10 FTE. This rules uses Full-Time Equivalent Staff - Social Workers Change and Growth fields (OrgFteSocialWkChange and OrgFteSocialWkGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteSocialWkChange join OrgFteSocialWkGrowth using (State, RegId, OrgId) where abs(Change) > 10 |
| OrgFtePsycholGrowthVaries | Historical | High | No | OrgFtePsycholChange ($Change) size is over 10 FTE | ORG.FtePsychol | Large historical change in Psychologists (FtePsychol), over 10 FTE. This rules uses Full-Time Equivalent Staff - Psychologists Change and Growth fields (OrgFtePsycholChange and OrgFtePsycholGrowth). | select State, RegId, OrgId, Change, Growth from OrgFtePsycholChange join OrgFtePsycholGrowth using (State, RegId, OrgId) where abs(Change) > 10 |
| OrgFteDHPOtherGrowthVaries | Historical | High | No | OrgFteDHPOtherChange ($Change) size is over 10 FTE | ORG.FteDHPOther | Large historical change in Other Diagnostic and Health Professionals (FteDHPOther), over 10 FTE. This rules uses Full-Time Equivalent Staff - Other Diagnostic and Health Professionals Change and Growth fields (OrgFteDHPOtherChange and OrgFteDHPOtherGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteDHPOtherChange join OrgFteDHPOtherGrowth using (State, RegId, OrgId) where abs(Change) > 10 |
| OrgFteAdminGrowthVaries | Historical | High | No | OrgFteAdminChange ($Change) size is over 20 FTE and OrgFteAdminGrowth ($Growth.perc) size is over 50% | ORG.FteAdmin | Large historical change in Administrative and Clerical (FteAdmin), over 20 FTE and over 50%. This rules uses Full-Time Equivalent Staff - Administrative and Clerical Staff Change and Growth fields (OrgFteAdminChange and OrgFteAdminGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteAdminChange join OrgFteAdminGrowth using (State, RegId, OrgId) where abs(Change) > 20 and abs(Growth) > 0.50 |
| OrgFteDomestGrowthVaries | Historical | High | No | OrgFteDomestChange ($Change) size is over 20 FTE and OrgFteDomestGrowth ($Growth.perc) size is over 50% | ORG.FteDomest | Large historical change in Domestic (FteDomest), over 20 FTE and over 50%. This rules uses Full-Time Equivalent Staff - Domestic and Other Staff Change and Growth fields (OrgFteDomestChange and OrgFteDomestGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteDomestChange join OrgFteDomestGrowth using (State, RegId, OrgId) where abs(Change) > 20 and abs(Growth) > 0.50 |
| OrgFtePCareGrowthVaries | Historical | High | No | OrgFtePCareChange ($Change) size is over 10 FTE and OrgFtePCareGrowth ($Growth.perc) size is over 40% | ORG.FtePCare | Large historical change in Other Personal Care (FtePCare), over 10 FTE and over 40%. This rules uses Full-Time Equivalent Staff - Other Personal Care Staff Change and Growth fields (OrgFtePCareChange and OrgFtePCareGrowth). | select State, RegId, OrgId, Change, Growth from OrgFtePCareChange join OrgFtePCareGrowth using (State, RegId, OrgId) where abs(Change) > 10 and abs(Growth) > 0.40 |
| OrgFteCarerWrkrGrowthVaries | Historical | High | No | OrgFteCarerWrkrChange ($Change) size is over 20 FTE and OrgFteCarerWrkrGrowth ($Growth.perc) size is over 50% | ORG.FteCarerWrkr | Large historical change in Carer Workers (FteCarerWrkr), over 20 FTE and over 50%. This rules uses Full-Time Equivalent Staff - Mental Health Carer Workers Change and Growth fields (OrgFteCarerWrkrChange and OrgFteCarerWrkrGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteCarerWrkrChange join OrgFteCarerWrkrGrowth using (State, RegId, OrgId) where abs(Change) > 20 and abs(Growth) > 0.50 |
| OrgFteConsrWrkrGrowthVaries | Historical | High | No | OrgFteConsrWrkrChange ($Change) size is over 20 FTE and OrgFteConsrWrkrGrowth ($Growth.perc) size is over 50% | ORG.FteConsrWrkr | Large historical change in Consumer Workers (FteConsrWrkr), over 20 FTE and over 50%. This rules uses Full-Time Equivalent Staff - Mental Health Consumer Workers Change and Growth fields (OrgFteConsrWrkrChange and OrgFteConsrWrkrGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteConsrWrkrChange join OrgFteConsrWrkrGrowth using (State, RegId, OrgId) where abs(Change) > 20 and abs(Growth) > 0.50 |
| HospSectorSklDiffers | Skeleton | High | No | Hospital Sector is $Sector, not $skl_Sector from SKL | HOSP.Sector | Sector Skeleton Differs - Sector value for Hospital differs between skeleton and current data | select State, RegId, OrgId, HospId, mhe_ent.Sector, skl_ent.Sector as skl_Sector from HOSP as mhe_ent join skl.Hosp as skl_ent using (State, RegId, OrgId, HospId) where mhe_ent.Sector != skl_ent.Sector |
| AdmiTargetPopSklDiffers | Skeleton | High | No | Admitted Patient Service Unit TargetPop is $TargetPop, not $skl_TargetPop from SKL | ADMI.TargetPop | Target Population Skeleton Differs - Target Population value for Admitted Patient Service Unit differs between skeleton and current data | select State, RegId, OrgId, HospId, AdmiId, mhe_ent.TargetPop, skl_ent.TargetPop as skl_TargetPop from ADMI as mhe_ent join skl.Admi as skl_ent using (State, RegId, OrgId, HospId, AdmiId) where mhe_ent.TargetPop != skl_ent.TargetPop |
| ResiTargetPopSklDiffers | Skeleton | High | No | Residential Service Unit TargetPop is $TargetPop, not $skl_TargetPop from SKL | RESI.TargetPop | Target Population Skeleton Differs - Target Population value for Residential Service Unit differs between skeleton and current data | select State, RegId, OrgId, ClusId, ResiId, mhe_ent.TargetPop, skl_ent.TargetPop as skl_TargetPop from RESI as mhe_ent join skl.Resi as skl_ent using (State, RegId, OrgId, ClusId, ResiId) where mhe_ent.TargetPop != skl_ent.TargetPop |
| ResiSectorSklDiffers | Skeleton | High | No | Residential Service Unit Sector is $Sector, not $skl_Sector from SKL | RESI.Sector | Sector Skeleton Differs - Sector value for Residential Service Unit differs between skeleton and current data | select State, RegId, OrgId, ClusId, ResiId, mhe_ent.Sector, skl_ent.Sector as skl_Sector from RESI as mhe_ent join skl.Resi as skl_ent using (State, RegId, OrgId, ClusId, ResiId) where mhe_ent.Sector != skl_ent.Sector |
| AmbuTargetPopSklDiffers | Skeleton | High | No | Ambulatory Service Unit TargetPop is $TargetPop, not $skl_TargetPop from SKL | AMBU.TargetPop | Target Population Skeleton Differs - Target Population value for Ambulatory Service Unit differs between skeleton and current data | select State, RegId, OrgId, ClusId, AmbuId, mhe_ent.TargetPop, skl_ent.TargetPop as skl_TargetPop from AMBU as mhe_ent join skl.Ambu as skl_ent using (State, RegId, OrgId, ClusId, AmbuId) where mhe_ent.TargetPop != skl_ent.TargetPop |
| AmbuSectorSklDiffers | Skeleton | High | No | Ambulatory Service Unit Sector is $Sector, not $skl_Sector from SKL | AMBU.Sector | Sector Skeleton Differs - Sector value for Ambulatory Service Unit differs between skeleton and current data | select State, RegId, OrgId, ClusId, AmbuId, mhe_ent.Sector, skl_ent.Sector as skl_Sector from AMBU as mhe_ent join skl.Ambu as skl_ent using (State, RegId, OrgId, ClusId, AmbuId) where mhe_ent.Sector != skl_ent.Sector |
| StStdsReviewChange | Historical | Medium | No | Current proportion of National Standards for Mental Health Services Review Status code 1 ($currentPerc %) is at least 10% less than historical proportion of the same ($prevPerc %). | ST | Large (>= 10%) historical decrease in proportion of National Standards for Mental Health Services Review Status code 1. | select State, 100*current.value AS currentPerc, 100*previous.value AS prevPerc from StStdsReviewProp current JOIN hist.StStdsReviewProp previous using (State) where (current.value - previous.value) <= -0.1 |
| StNHousePlacesGrowth | Historical | Medium | No | Number of Public Supported Housing Places has changed by $percent_change % from $previous_amount to $current_amount . | ST | Large (>= 20%) historical change in number of Public Supported Housing Places. | select State, previous_amount, current_amount, percent_change from StNHousePlacesGrowthAmt where percent_change >= 20.0 |
| RegNotInSkl | Skeleton | High | No | Reg $name not in SKL data | Region not in skeleton reference data - A matching Region was not found in the skeleton data | ||
| RegInSklOnly | Skeleton | High | No | Reg $name expected from SKL is missing | Region appears in skeleton reference data only - A Region 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 Organisation was not found in the skeleton data | ||
| OrgInSklOnly | Skeleton | High | No | Org $name expected from SKL is missing | Organisation appears in skeleton reference data only - A Organisation with matching Ids is expected based on the SKL data but is not present in this file | ||
| HospNotInSkl | Skeleton | High | No | Hosp $name not in SKL data | Hospital not in skeleton reference data - A matching Hospital was not found in the skeleton data | ||
| HospInSklOnly | Skeleton | High | No | Hosp $name expected from SKL is missing | Hospital appears in skeleton reference data only - A Hospital 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 Service Unit Cluster was not found in the skeleton data | ||
| ClusInSklOnly | Skeleton | High | No | Clus $name expected from SKL is missing | Service Unit Cluster appears in skeleton reference data only - A Service Unit Cluster with matching Ids is expected based on the SKL data but is not present in this file | ||
| AdmiNotInSkl | Skeleton | High | No | Admi $name not in SKL data | Admitted Patient Service Unit not in skeleton reference data - A matching Admitted Patient Service Unit was not found in the skeleton data | ||
| AdmiInSklOnly | Skeleton | High | No | Admi $name expected from SKL is missing | Admitted Patient Service Unit appears in skeleton reference data only - A Admitted Patient Service Unit with matching Ids is expected based on the SKL data but is not present in this file | ||
| AmbuNotInSkl | Skeleton | High | No | Ambu $name not in SKL data | Ambulatory Service Unit not in skeleton reference data - A matching Ambulatory Service Unit was not found in the skeleton data | ||
| AmbuInSklOnly | Skeleton | High | No | Ambu $name expected from SKL is missing | Ambulatory Service Unit appears in skeleton reference data only - A Ambulatory Service Unit with matching Ids is expected based on the SKL data but is not present in this file | ||
| ResiNotInSkl | Skeleton | High | No | Resi $name not in SKL data | Residential Service Unit not in skeleton reference data - A matching Residential Service Unit was not found in the skeleton data | ||
| ResiInSklOnly | Skeleton | High | No | Resi $name expected from SKL is missing | Residential Service Unit appears in skeleton reference data only - A Residential Service Unit with matching Ids is expected based on the SKL data but is not present in this file |