Mental Health Establishments National Minimum Data Set — Version 01.40
Main Content
MHE version 01.40: 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 |
| StNgoAccomSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoAccom | ST.NgoAccom | Non-numbers (spaces) in Number field NgoAccom | select State, NgoAccom from ST where NgoAccom IS NULL |
| StNgoAdvocSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoAdvoc | ST.NgoAdvoc | Non-numbers (spaces) in Number field NgoAdvoc | select State, NgoAdvoc from ST where NgoAdvoc IS NULL |
| StNgoPromoSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoPromo | ST.NgoPromo | Non-numbers (spaces) in Number field NgoPromo | select State, NgoPromo from ST where NgoPromo IS NULL |
| StNgoCounsellSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoCounsell | ST.NgoCounsell | Non-numbers (spaces) in Number field NgoCounsell | select State, NgoCounsell from ST where NgoCounsell IS NULL |
| StNgoLivSkillsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoLivSkills | ST.NgoLivSkills | Non-numbers (spaces) in Number field NgoLivSkills | select State, NgoLivSkills from ST where NgoLivSkills IS NULL |
| StNgoPreVocatSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoPreVocat | ST.NgoPreVocat | Non-numbers (spaces) in Number field NgoPreVocat | select State, NgoPreVocat from ST where NgoPreVocat IS NULL |
| StNgoPsychosocSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoPsychosoc | ST.NgoPsychosoc | Non-numbers (spaces) in Number field NgoPsychosoc | select State, NgoPsychosoc from ST where NgoPsychosoc IS NULL |
| StNgoRecreationSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoRecreation | ST.NgoRecreation | Non-numbers (spaces) in Number field NgoRecreation | select State, NgoRecreation from ST where NgoRecreation IS NULL |
| StNgoRespiteSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoRespite | ST.NgoRespite | Non-numbers (spaces) in Number field NgoRespite | select State, NgoRespite from ST where NgoRespite IS NULL |
| StNgoSelfHelpSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoSelfHelp | ST.NgoSelfHelp | Non-numbers (spaces) in Number field NgoSelfHelp | select State, NgoSelfHelp from ST where NgoSelfHelp IS NULL |
| StNgoOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoOther | ST.NgoOther | Non-numbers (spaces) in Number field NgoOther | select State, NgoOther from ST where NgoOther 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 |
| 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 |
| 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 |
| RegNgoAccomSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoAccom | REG.NgoAccom | Non-numbers (spaces) in Number field NgoAccom | select State, RegId, NgoAccom from REG where NgoAccom IS NULL |
| RegNgoAdvocSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoAdvoc | REG.NgoAdvoc | Non-numbers (spaces) in Number field NgoAdvoc | select State, RegId, NgoAdvoc from REG where NgoAdvoc IS NULL |
| RegNgoPromoSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoPromo | REG.NgoPromo | Non-numbers (spaces) in Number field NgoPromo | select State, RegId, NgoPromo from REG where NgoPromo IS NULL |
| RegNgoCounsellSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoCounsell | REG.NgoCounsell | Non-numbers (spaces) in Number field NgoCounsell | select State, RegId, NgoCounsell from REG where NgoCounsell IS NULL |
| RegNgoLivSkillsSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoLivSkills | REG.NgoLivSkills | Non-numbers (spaces) in Number field NgoLivSkills | select State, RegId, NgoLivSkills from REG where NgoLivSkills IS NULL |
| RegNgoPreVocatSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoPreVocat | REG.NgoPreVocat | Non-numbers (spaces) in Number field NgoPreVocat | select State, RegId, NgoPreVocat from REG where NgoPreVocat IS NULL |
| RegNgoPsychosocSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoPsychosoc | REG.NgoPsychosoc | Non-numbers (spaces) in Number field NgoPsychosoc | select State, RegId, NgoPsychosoc from REG where NgoPsychosoc IS NULL |
| RegNgoRecreationSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoRecreation | REG.NgoRecreation | Non-numbers (spaces) in Number field NgoRecreation | select State, RegId, NgoRecreation from REG where NgoRecreation IS NULL |
| RegNgoRespiteSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoRespite | REG.NgoRespite | Non-numbers (spaces) in Number field NgoRespite | select State, RegId, NgoRespite from REG where NgoRespite IS NULL |
| RegNgoSelfHelpSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoSelfHelp | REG.NgoSelfHelp | Non-numbers (spaces) in Number field NgoSelfHelp | select State, RegId, NgoSelfHelp from REG where NgoSelfHelp IS NULL |
| RegNgoOtherSpaces | Invalid | High | No | Non-numbers (spaces) in Number field NgoOther | REG.NgoOther | Non-numbers (spaces) in Number field NgoOther | select State, RegId, NgoOther from REG where NgoOther 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 |
| 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 |
| 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 |
| OrgExpSalCarerCnsltSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalCarerCnslt | ORG.ExpSalCarerCnslt | Non-numbers (spaces) in Number field ExpSalCarerCnslt | select State, RegId, OrgId, ExpSalCarerCnslt from ORG where ExpSalCarerCnslt IS NULL |
| OrgExpSalConsrCnsltSpaces | Invalid | High | No | Non-numbers (spaces) in Number field ExpSalConsrCnslt | ORG.ExpSalConsrCnslt | Non-numbers (spaces) in Number field ExpSalConsrCnslt | select State, RegId, OrgId, ExpSalConsrCnslt from ORG where ExpSalConsrCnslt 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 |
| OrgFteCarerCnsltSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteCarerCnslt | ORG.FteCarerCnslt | Non-numbers (spaces) in Number field FteCarerCnslt | select State, RegId, OrgId, FteCarerCnslt from ORG where FteCarerCnslt IS NULL |
| OrgFteConsrCnsltSpaces | Invalid | High | No | Non-numbers (spaces) in Number field FteConsrCnslt | ORG.FteConsrCnslt | Non-numbers (spaces) in Number field FteConsrCnslt | select State, RegId, OrgId, FteConsrCnslt from ORG where FteConsrCnslt 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 |
| 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, 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, 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, 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, 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, FteDomest from FTEORG where FteDomest 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, FtePCare from FTEORG where FtePCare 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 |
| 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 |
| 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 |
| HospEstSLAMissing | Missing | High | No | Missing data - EstSLA $EstSLA.q | HOSP.EstSLA | Missing data - Geographical Location of Establishment (EstSLA) | select State, RegId, OrgId, HospId, EstSLA from HOSP where EstSLA 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 |
| AmbuEstSLAMissing | Missing | Low | No | Missing data - EstSLA $EstSLA.q | AMBU.EstSLA | Missing data - Geographical Location of Establishment (EstSLA) | select State, RegId, OrgId, ClusId, AmbuId, EstSLA from AMBU where EstSLA 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 |
| ResiEstSLAMissing | Missing | Low | No | Missing data - EstSLA $EstSLA.q | RESI.EstSLA | Missing data - Geographical Location of Establishment (EstSLA) | select State, RegId, OrgId, ClusId, ResiId, EstSLA from RESI where EstSLA 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 - Carer Satisfaction 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 - 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 - 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 - 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 - Consumer Satisfaction 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 - 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 - 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' |
| OrgCarerCnsltMissing | Missing | High | No | Missing data - CarerCnslt $CarerCnslt.q | ORG.CarerCnslt | Missing data - Carer Participation Arrangements - Carer Consultants Employed (CarerCnslt) | select State, RegId, OrgId, CarerCnslt from ORG where CarerCnslt is null or CarerCnslt = '9' |
| OrgConsrCnsltMissing | Missing | High | No | Missing data - ConsrCnslt $ConsrCnslt.q | ORG.ConsrCnslt | Missing data - Consumer Participation Arrangements - Consumer Consultants Employed (ConsrCnslt) | select State, RegId, OrgId, ConsrCnslt from ORG where ConsrCnslt is null or ConsrCnslt = '9' |
| StNHousePlacesZero | Anomaly | High | No | Zero reported for NHousePlaces | ST.NHousePlaces | Zero reported for Number of Supported Public 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 Including Review Tribunals | 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 Service Setting Level | select State, RegId, OrgId, Setting, 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 Treated | 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 |
| StNgoTotalZero | Anomaly | High | No | Zero reported for StNgoTotal | ST | Zero reported for Total NGO Expenditure at State/Territory Level | select State, Total as value from StNgoTotal 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: Deprec, ExpNonSalTot, ExpSalTot, AdmiNBeds, MHCareDays, NSeps | select State, RegId, OrgId, HospId, AdmiId from ADMI where 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: Deprec, ExpNonSalTot, ExpSalTot, NClients, NCont | select State, RegId, OrgId, ClusId, AmbuId from AMBU where 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: HrsStaffed, Deprec, ExpNonSalTot, ExpSalTot, ResiNBeds, MHCareDays, NEpi | select State, RegId, OrgId, ClusId, ResiId from RESI where 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 |
| 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' |
| 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 |
| RegOpened | Historical | High | No | Reg opened, $RegName.qt (RegId: $RegId) not in historical data | REG | Region Opened - A matching Region was not found in the historical data | select State, RegId, REG.RegName from main.REG left join hist.REG as hist_entity using (State, RegId) where hist_entity.RegId is null |
| RegClosed | Historical | High | Yes | Reg closed, historical $hist_name.qt (RegId: $hist_RegId) no longer exists $hist_context | ST | Region Closed - A historical Region was not found in current data | select hist_entity.State as State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.RegName as hist_name from hist.REG as hist_entity left join main.REG using (State, RegId) where REG.RegId is null |
| RegRenamed | Historical | High | No | Reg renamed from $hist_name.qt to $RegName.qt | REG.RegName | Region Renamed - Region Name differs between historical and current data | select State, RegId, REG.RegName, hist_entity.RegName as hist_name from REG join hist.REG as hist_entity using(State, RegId) where not sloppy_match(REG.RegName, hist_entity.RegName) |
| OrgOpened | Historical | High | No | Org opened, $OrgName.qt (OrgId: $OrgId) not in historical data | ORG | Organisation Opened - A matching Organisation was not found in the historical data | select State, RegId, OrgId, ORG.OrgName from main.ORG left join hist.ORG as hist_entity using (State, RegId, OrgId) where hist_entity.OrgId is null |
| OrgClosed | Historical | High | Yes | Org closed, historical $hist_name.qt (OrgId: $hist_OrgId) no longer exists $hist_context | ST | Organisation Closed - A historical Organisation was not found in current data | select hist_entity.State as State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, ' (' ||RegName || ')' as hist_context, hist_entity.OrgName as hist_name from hist.ORG as hist_entity left join main.ORG using (State, RegId, OrgId) join hist.REG using (State, RegId) where ORG.OrgId is null |
| OrgRenamed | Historical | High | No | Org renamed from $hist_name.qt to $OrgName.qt | ORG.OrgName | Organisation Renamed - Organisation Name differs between historical and current data | select State, RegId, OrgId, ORG.OrgName, hist_entity.OrgName as hist_name from ORG join hist.ORG as hist_entity using(State, RegId, OrgId) where not sloppy_match(ORG.OrgName, hist_entity.OrgName) |
| HospOpened | Historical | High | No | Hosp opened, $HospName.qt (HospId: $HospId) not in historical data | HOSP | Hospital Opened - A matching Hospital was not found in the historical data | select State, RegId, OrgId, HospId, HOSP.HospName from main.HOSP left join hist.HOSP as hist_entity using (State, RegId, OrgId, HospId) where hist_entity.HospId is null |
| HospClosed | Historical | High | Yes | Hosp closed, historical $hist_name.qt (HospId: $hist_HospId) no longer exists $hist_context | ST | Hospital Closed - A historical Hospital was not found in current data | select hist_entity.State as State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.HospId as hist_HospId, ' (' ||OrgName || '; ' || RegName || ')' as hist_context, hist_entity.HospName as hist_name from hist.HOSP as hist_entity left join main.HOSP using (State, RegId, OrgId, HospId) join hist.ORG using (State, RegId, OrgId) join hist.REG using (State, RegId) where HOSP.HospId is null |
| HospRenamed | Historical | High | No | Hosp renamed from $hist_name.qt to $HospName.qt | HOSP.HospName | Hospital Renamed - Hospital Name differs between historical and current data | select State, RegId, OrgId, HospId, HOSP.HospName, hist_entity.HospName as hist_name from HOSP join hist.HOSP as hist_entity using(State, RegId, OrgId, HospId) where not sloppy_match(HOSP.HospName, hist_entity.HospName) |
| ClusOpened | Historical | High | No | Clus opened, $ClusName.qt (ClusId: $ClusId) not in historical data | CLUS | Service Unit Cluster Opened - A matching Service Unit Cluster was not found in the historical data | select State, RegId, OrgId, ClusId, CLUS.ClusName from main.CLUS left join hist.CLUS as hist_entity using (State, RegId, OrgId, ClusId) where hist_entity.ClusId is null |
| ClusClosed | Historical | High | Yes | Clus closed, historical $hist_name.qt (ClusId: $hist_ClusId) no longer exists $hist_context | ST | Service Unit Cluster Closed - A historical Service Unit Cluster was not found in current data | select hist_entity.State as State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.ClusId as hist_ClusId, ' (' ||OrgName || '; ' || RegName || ')' as hist_context, hist_entity.ClusName as hist_name from hist.CLUS as hist_entity left join main.CLUS using (State, RegId, OrgId, ClusId) join hist.ORG using (State, RegId, OrgId) join hist.REG using (State, RegId) where CLUS.ClusId is null |
| ClusRenamed | Historical | High | No | Clus renamed from $hist_name.qt to $ClusName.qt | CLUS.ClusName | Service Unit Cluster Renamed - Service Unit Cluster Name differs between historical and current data | select State, RegId, OrgId, ClusId, CLUS.ClusName, hist_entity.ClusName as hist_name from CLUS join hist.CLUS as hist_entity using(State, RegId, OrgId, ClusId) where not sloppy_match(CLUS.ClusName, hist_entity.ClusName) |
| AdmiOpened | Historical | High | No | Admi opened, $AdmiName.qt (AdmiId: $AdmiId) not in historical data | ADMI | Admitted Patient Service Unit Opened - A matching Admitted Patient Service Unit was not found in the historical data | select State, RegId, OrgId, HospId, AdmiId, ADMI.AdmiName from main.ADMI left join hist.ADMI as hist_entity using (State, RegId, OrgId, HospId, AdmiId) where hist_entity.AdmiId is null |
| AdmiClosed | Historical | High | Yes | Admi closed, historical $hist_name.qt (AdmiId: $hist_AdmiId) no longer exists $hist_context | ST | Admitted Patient Service Unit Closed - A historical Admitted Patient Service Unit was not found in current data | select hist_entity.State as State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.HospId as hist_HospId, hist_entity.AdmiId as hist_AdmiId, ' (' ||HospName || '; ' || OrgName || '; ' || RegName || ')' as hist_context, hist_entity.AdmiName as hist_name from hist.ADMI as hist_entity left join main.ADMI using (State, RegId, OrgId, HospId, AdmiId) join hist.HOSP using (State, RegId, OrgId, HospId) join hist.ORG using (State, RegId, OrgId) join hist.REG using (State, RegId) where ADMI.AdmiId is null |
| AdmiRenamed | Historical | High | No | Admi renamed from $hist_name.qt to $AdmiName.qt | ADMI.AdmiName | Admitted Patient Service Unit Renamed - Admitted Patient Service Unit Name differs between historical and current data | select State, RegId, OrgId, HospId, AdmiId, ADMI.AdmiName, hist_entity.AdmiName as hist_name from ADMI join hist.ADMI as hist_entity using(State, RegId, OrgId, HospId, AdmiId) where not sloppy_match(ADMI.AdmiName, hist_entity.AdmiName) |
| ResiOpened | Historical | High | No | Resi opened, $ResiName.qt (ResiId: $ResiId) not in historical data | RESI | Residential Service Unit Opened - A matching Residential Service Unit was not found in the historical data | select State, RegId, OrgId, ClusId, ResiId, RESI.ResiName from main.RESI left join hist.RESI as hist_entity using (State, RegId, OrgId, ClusId, ResiId) where hist_entity.ResiId is null |
| ResiClosed | Historical | High | Yes | Resi closed, historical $hist_name.qt (ResiId: $hist_ResiId) no longer exists $hist_context | ST | Residential Service Unit Closed - A historical Residential Service Unit was not found in current data | select hist_entity.State as State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.ClusId as hist_ClusId, hist_entity.ResiId as hist_ResiId, ' (' ||ClusName || '; ' || OrgName || '; ' || RegName || ')' as hist_context, hist_entity.ResiName as hist_name from hist.RESI as hist_entity left join main.RESI using (State, RegId, OrgId, ClusId, ResiId) join hist.CLUS using (State, RegId, OrgId, ClusId) join hist.ORG using (State, RegId, OrgId) join hist.REG using (State, RegId) where RESI.ResiId is null |
| ResiRenamed | Historical | High | No | Resi renamed from $hist_name.qt to $ResiName.qt | RESI.ResiName | Residential Service Unit Renamed - Residential Service Unit Name differs between historical and current data | select State, RegId, OrgId, ClusId, ResiId, RESI.ResiName, hist_entity.ResiName as hist_name from RESI join hist.RESI as hist_entity using(State, RegId, OrgId, ClusId, ResiId) where not sloppy_match(RESI.ResiName, hist_entity.ResiName) |
| AmbuOpened | Historical | High | No | Ambu opened, $AmbuName.qt (AmbuId: $AmbuId) not in historical data | AMBU | Ambulatory Service Unit Opened - A matching Ambulatory Service Unit was not found in the historical data | select State, RegId, OrgId, ClusId, AmbuId, AMBU.AmbuName from main.AMBU left join hist.AMBU as hist_entity using (State, RegId, OrgId, ClusId, AmbuId) where hist_entity.AmbuId is null |
| AmbuClosed | Historical | High | Yes | Ambu closed, historical $hist_name.qt (AmbuId: $hist_AmbuId) no longer exists $hist_context | ST | Ambulatory Service Unit Closed - A historical Ambulatory Service Unit was not found in current data | select hist_entity.State as State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.ClusId as hist_ClusId, hist_entity.AmbuId as hist_AmbuId, ' (' ||ClusName || '; ' || OrgName || '; ' || RegName || ')' as hist_context, hist_entity.AmbuName as hist_name from hist.AMBU as hist_entity left join main.AMBU using (State, RegId, OrgId, ClusId, AmbuId) join hist.CLUS using (State, RegId, OrgId, ClusId) join hist.ORG using (State, RegId, OrgId) join hist.REG using (State, RegId) where AMBU.AmbuId is null |
| AmbuRenamed | Historical | High | No | Ambu renamed from $hist_name.qt to $AmbuName.qt | AMBU.AmbuName | Ambulatory Service Unit Renamed - Ambulatory Service Unit Name differs between historical and current data | select State, RegId, OrgId, ClusId, AmbuId, AMBU.AmbuName, hist_entity.AmbuName as hist_name from AMBU join hist.AMBU as hist_entity using(State, RegId, OrgId, ClusId, AmbuId) where not sloppy_match(AMBU.AmbuName, hist_entity.AmbuName) |
| 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 |
| HospSectorChanged | Historical | High | No | Hospital Sector changed from $hist_Sector to $Sector | HOSP.Sector | Sector Changed - Sector value for Hospital differs between historical and current data | select State, RegId, OrgId, HospId, HOSP.Sector, hist_HOSP.Sector as hist_Sector from HOSP join hist.HOSP as hist_HOSP using(State, RegId, OrgId, HospId) where HOSP.Sector != hist_HOSP.Sector |
| AdmiTargetPopChanged | Historical | High | No | Admitted Patient Service Unit TargetPop changed from $hist_TargetPop to $TargetPop | ADMI.TargetPop | Target Population Changed - Target Population value for Admitted Patient Service Unit differs between historical and current data | select State, RegId, OrgId, HospId, AdmiId, ADMI.TargetPop, hist_ADMI.TargetPop as hist_TargetPop from ADMI join hist.ADMI as hist_ADMI using(State, RegId, OrgId, HospId, AdmiId) where ADMI.TargetPop != hist_ADMI.TargetPop |
| ResiTargetPopChanged | Historical | High | No | Residential Service Unit TargetPop changed from $hist_TargetPop to $TargetPop | RESI.TargetPop | Target Population Changed - Target Population value for Residential Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, ResiId, RESI.TargetPop, hist_RESI.TargetPop as hist_TargetPop from RESI join hist.RESI as hist_RESI using(State, RegId, OrgId, ClusId, ResiId) where RESI.TargetPop != hist_RESI.TargetPop |
| ResiSectorChanged | Historical | High | No | Residential Service Unit Sector changed from $hist_Sector to $Sector | RESI.Sector | Sector Changed - Sector value for Residential Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, ResiId, RESI.Sector, hist_RESI.Sector as hist_Sector from RESI join hist.RESI as hist_RESI using(State, RegId, OrgId, ClusId, ResiId) where RESI.Sector != hist_RESI.Sector |
| AmbuTargetPopChanged | Historical | High | No | Ambulatory Service Unit TargetPop changed from $hist_TargetPop to $TargetPop | AMBU.TargetPop | Target Population Changed - Target Population value for Ambulatory Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, AmbuId, AMBU.TargetPop, hist_AMBU.TargetPop as hist_TargetPop from AMBU join hist.AMBU as hist_AMBU using(State, RegId, OrgId, ClusId, AmbuId) where AMBU.TargetPop != hist_AMBU.TargetPop |
| AmbuSectorChanged | Historical | High | No | Ambulatory Service Unit Sector changed from $hist_Sector to $Sector | AMBU.Sector | Sector Changed - Sector value for Ambulatory Service Unit differs between historical and current data | select State, RegId, OrgId, ClusId, AmbuId, AMBU.Sector, hist_AMBU.Sector as hist_Sector from AMBU join hist.AMBU as hist_AMBU using(State, RegId, OrgId, ClusId, AmbuId) where AMBU.Sector != hist_AMBU.Sector |
| 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 |
| CarerCnsltSalAndNoFte | Inconsistent | High | No | ExpSalCarerCnslt ($ExpSalCarerCnslt) with no corresponding FteCarerCnslt ($FteCarerCnslt) | ORG.ExpSalCarerCnslt | Salary data with no corresponding FTE - Carer Consultants | select State, RegId, OrgId, ExpSalCarerCnslt, FteCarerCnslt from ORG where (ExpSalCarerCnslt > 5000) and (FteCarerCnslt = 0) |
| CarerCnsltFteAndNoSal | Inconsistent | High | No | FteCarerCnslt ($FteCarerCnslt) with no corresponding ExpSalCarerCnslt (0) | ORG.FteCarerCnslt | FTE data with no corresponding Salary - Carer Consultants | select State, RegId, OrgId, coalesce(ExpSalCarerCnslt, 0), FteCarerCnslt from ORG where FteCarerCnslt > 0.1 and coalesce(ExpSalCarerCnslt, 0) = 0 |
| ConsrCnsltSalAndNoFte | Inconsistent | High | No | ExpSalConsrCnslt ($ExpSalConsrCnslt) with no corresponding FteConsrCnslt ($FteConsrCnslt) | ORG.ExpSalConsrCnslt | Salary data with no corresponding FTE - Consumer Consultants | select State, RegId, OrgId, ExpSalConsrCnslt, FteConsrCnslt from ORG where (ExpSalConsrCnslt > 5000) and (FteConsrCnslt = 0) |
| ConsrCnsltFteAndNoSal | Inconsistent | High | No | FteConsrCnslt ($FteConsrCnslt) with no corresponding ExpSalConsrCnslt (0) | ORG.FteConsrCnslt | FTE data with no corresponding Salary - Consumer Consultants | select State, RegId, OrgId, coalesce(ExpSalConsrCnslt, 0), FteConsrCnslt from ORG where FteConsrCnslt > 0.1 and coalesce(ExpSalConsrCnslt, 0) = 0 |
| CarerCnsltNoSalAndFte | Inconsistent | High | No | CarerCnslt is 1 (Yes), inconsistent with ExpSalCarerCnslt ($ExpSalCarerCnslt) and FteCarerCnslt ($FteCarerCnslt) | ORG.CarerCnslt | Carer Consultants flag is inconsistent with either FTE or Salary data | select State, RegId, OrgId, CarerCnslt, ExpSalCarerCnslt, FteCarerCnslt from ORG where CarerCnslt = '1' and (ExpSalCarerCnslt = 0 or FteCarerCnslt = 0) |
| NoCarerCnsltWithSalOrFte | Inconsistent | High | No | CarerCnslt is 2 (No), inconsistent with either ExpSalCarerCnslt ($ExpSalCarerCnslt) or FteCarerCnslt ($FteCarerCnslt) | ORG.CarerCnslt | Carer Consultants flag is inconsistent with either FTE or Salary data | select State, RegId, OrgId, CarerCnslt, ExpSalCarerCnslt, FteCarerCnslt from ORG where CarerCnslt = '2' and (ExpSalCarerCnslt > 0 or FteCarerCnslt > 0) |
| ConsrCnsltNoSalAndFte | Inconsistent | High | No | ConsrCnslt is 1 (Yes), inconsistent with ExpSalConsrCnslt ($ExpSalConsrCnslt) and FteConsrCnslt ($FteConsrCnslt) | ORG.ConsrCnslt | Consumer Consultants flag is inconsistent with either FTE or Salary data | select State, RegId, OrgId, ConsrCnslt, ExpSalConsrCnslt, FteConsrCnslt from ORG where ConsrCnslt = '1' and (ExpSalConsrCnslt = 0 or FteConsrCnslt = 0) |
| NoConsrCnsltWithSalOrFte | Inconsistent | High | No | ConsrCnslt is 2 (No), inconsistent with either ExpSalConsrCnslt ($ExpSalConsrCnslt) or FteConsrCnslt ($FteConsrCnslt) | ORG.ConsrCnslt | Consumer Consultants flag is inconsistent with either FTE or Salary data | select State, RegId, OrgId, ConsrCnslt, ExpSalConsrCnslt, FteConsrCnslt from ORG where ConsrCnslt = '2' and (ExpSalConsrCnslt > 0 or FteConsrCnslt > 0) |
| ProgAdminLtCnsltSal | Inconsistent | High | No | ExpNerProgAdmin ($ExpNerProgAdmin.dollars) is less than the sum of ExpSalCarerCnslt ($ExpSalCarerCnslt.dollars) and ExpSalConsrCnslt ($ExpSalConsrCnslt.dollars) | ORG.ExpNerProgAdmin | Sum of the Organisation-level "Salaries and Wages - Consumer Consultants" (ExpSalConsrCnslt) and "Salaries and Wages - Carer Consultants" (ExpSalCarerCnslt) is less than the "Expenditure Not Elsewhere Reported - Program Administration" (ExpNerProgAdmin). | select State, RegId, OrgId, ExpNerProgAdmin, ExpSalCarerCnslt, ExpSalConsrCnslt from ORG where ExpNerProgAdmin < ( ExpSalCarerCnslt + ExpSalConsrCnslt) |
| AdmiAndNoMedFte | Anomaly | High | No | Admitted Setting (1) with zero Medical FTE (FteMed) | FTEORG.FteMed | Inconsistent FTEORG Admitted data - Medical - Admitted service setting with zero Full-Time Equivalent Staff - Salaried Medical Officers (FteMed) | select State, RegId, OrgId, Setting from FTEORG where Setting = '1' and FteMed = 0 |
| OrgFteAdminHigh | Inconsistent | High | No | FteAdminSum ($FteAdminSum.commas) is greater than OrgFteAdminSum ($OrgFteAdminSum.commas) | ORG | Inconsistent FTE data - Administrative and Clerical - Total Administrative and Clerical FTE reported at Setting Level is greater than 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 Fte.Total > Org.Total + 1 |
| OrgFteDHPHigh | Inconsistent | High | No | FteDHPSum ($FteDHPSum.commas) is greater than OrgFteDHPSum ($OrgFteDHPSum.commas) | ORG | Inconsistent FTE data - Diagnostic and Health Professionals - Total Diagnostic and Health Professionals FTE reported at Setting Level is greater than 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 Fte.Total > Org.Total + 1 |
| OrgFteDomestHigh | Inconsistent | High | No | FteDomestSum ($FteDomestSum.commas) is greater than OrgFteDomestSum ($OrgFteDomestSum.commas) | ORG | Inconsistent FTE data - Domestic - Total Domestic FTE reported at Setting Level is greater than 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 Fte.Total > Org.Total + 1 |
| OrgFteMedHigh | Inconsistent | High | No | FteMedSum ($FteMedSum.commas) is greater than OrgFteMedSum ($OrgFteMedSum.commas) | ORG | Inconsistent FTE data - Medical - Total Medical FTE reported at Setting Level is greater than 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 Fte.Total > Org.Total + 1 |
| OrgFteNursesHigh | Inconsistent | High | No | FteNursesSum ($FteNursesSum.commas) is greater than OrgFteNursesSum ($OrgFteNursesSum.commas) | ORG | Inconsistent FTE data - Nursing - Total Nursing FTE reported at Setting Level is greater than 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 Fte.Total > Org.Total + 1 |
| OrgFtePCareHigh | Inconsistent | High | No | FtePCareSum ($FtePCareSum.commas) is greater than OrgFtePCareSum ($OrgFtePCareSum.commas) | ORG | Inconsistent FTE data - Other Personal Care - Total Other Personal Care FTE reported at Setting Level is greater than 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 Fte.Total > Org.Total + 1 |
| OrgFteNoAdmi | Inconsistent | High | No | ORG has an FTEORG record for Setting 1 but no ADMI records | ORG | Organisation has an FTEORG record for Setting 1 but no Admitted Patient Service Unit records | select State, RegId, OrgId from FTEORG join OrgAdmiCount using (State, RegId, OrgId) where Count = 0 and Setting = '1' |
| OrgAdmiNoFte | Inconsistent | High | No | ORG has $AdmiCount ADMI records but no FTEORG record for Setting 1 | ORG | Organisation has Admitted Patient Service Unit records but no FTEORG record for Setting 1 | select State, RegId, OrgId, Admi.Count as AdmiCount, Fte.Count as FteCount from OrgAdmiCount as Admi join OrgFteSet1Count as Fte using (State, RegId, OrgId) where Admi.Count > 0 and Fte.Count = 0 |
| OrgFteNoResi | Inconsistent | High | No | ORG has an FTEORG record for Setting 2 but no RESI records | ORG | Organisation has an FTEORG record for Setting 2 but no Residential Service Unit records | select State, RegId, OrgId from FTEORG join OrgResiCount using (State, RegId, OrgId) where Count = 0 and Setting = '2' |
| OrgResiNoFte | Inconsistent | High | No | ORG has $ResiCount RESI records but no FTEORG record for Setting 2 | ORG | Organisation has Residential Service Unit records but no FTEORG record for Setting 2 | select State, RegId, OrgId, Resi.Count as ResiCount, Fte.Count as FteCount from OrgResiCount as Resi join OrgFteSet2Count as Fte using (State, RegId, OrgId) where Resi.Count > 0 and Fte.Count = 0 |
| OrgFteNoAmbu | Inconsistent | High | No | ORG has an FTEORG record for Setting 3 but no AMBU records | ORG | Organisation has an FTEORG record for Setting 3 but no Ambulatory Service Unit records | select State, RegId, OrgId from FTEORG join OrgAmbuCount using (State, RegId, OrgId) where Count = 0 and Setting = '3' |
| OrgAmbuNoFte | Inconsistent | High | No | ORG has $AmbuCount AMBU records but no FTEORG record for Setting 3 | ORG | Organisation has Ambulatory Service Unit records but no FTEORG record for Setting 3 | select State, RegId, OrgId, Ambu.Count as AmbuCount, Fte.Count as FteCount from OrgAmbuCount as Ambu join OrgFteSet3Count as Fte using (State, RegId, OrgId) where Ambu.Count > 0 and Fte.Count = 0 |
| 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 Treated (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 \$20 to \$2,000 | AMBU.AmbuAvgCon | Exceptional Average Contact Cost - Average Contact Cost for Ambulatory Service Unit is outside the range $20 to $2,000. | select State, RegId, OrgId, ClusId, AmbuId, AvgCon from AMBU join AmbuAvgCon using(State, RegId, OrgId, ClusId, AmbuId) where (AvgCon < 20 or AvgCon > 2000) |
| 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') | 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') |
| 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) |
| AdmiPDayGenAcRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$380 to \$1,141 (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 $380 to $1,141. The previous year's national average is $761 (PDay < 380 or PDay > 1141) 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 < 380 or PDay > 1141) and ProgType = '1' and TargetPop = '4' and AdmiNBeds >= 5 |
| AdmiPDayGenAcRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$380 to \$1,141 (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 $380 to $1,141. The previous year's national average is $761 (PDay < 380 or PDay > 1141) 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 < 380 or PDay > 1141) and ProgType = '1' and TargetPop = '4' and AdmiNBeds < 5 |
| AdmiPDayGenRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$268 to \$805 (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 $268 to $805. The previous year's national average is $537 (PDay < 268 or PDay > 805) 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 < 268 or PDay > 805) and ProgType = '2' and TargetPop = '4' and AdmiNBeds >= 5 |
| AdmiPDayGenRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$268 to \$805 (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 $268 to $805. The previous year's national average is $537 (PDay < 268 or PDay > 805) 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 < 268 or PDay > 805) and ProgType = '2' and TargetPop = '4' and AdmiNBeds < 5 |
| AdmiPDayOldAcRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$325 to \$975 (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 $325 to $975. The previous year's national average is $650 (PDay < 325 or PDay > 975) 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 < 325 or PDay > 975) and ProgType = '1' and TargetPop = '2' and AdmiNBeds >= 5 |
| AdmiPDayOldAcRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$325 to \$975 (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 $325 to $975. The previous year's national average is $650 (PDay < 325 or PDay > 975) 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 < 325 or PDay > 975) and ProgType = '1' and TargetPop = '2' and AdmiNBeds < 5 |
| AdmiPDayOldRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$259 to \$776 (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 $259 to $776. The previous year's national average is $517 (PDay < 259 or PDay > 776) 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 < 259 or PDay > 776) and ProgType = '2' and TargetPop = '2' and AdmiNBeds >= 5 |
| AdmiPDayOldRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$259 to \$776 (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 $259 to $776. The previous year's national average is $517 (PDay < 259 or PDay > 776) 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 < 259 or PDay > 776) and ProgType = '2' and TargetPop = '2' and AdmiNBeds < 5 |
| AdmiPDayCARangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$642 to \$1,925 (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 $642 to $1,925. The previous year's national average is $1,283 (PDay < 642 or PDay > 1925) 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 < 642 or PDay > 1925) and TargetPop = '1' and AdmiNBeds >= 5 |
| AdmiPDayCARangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$642 to \$1,925 (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 $642 to $1,925. The previous year's national average is $1,283 (PDay < 642 or PDay > 1925) 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 < 642 or PDay > 1925) and TargetPop = '1' and AdmiNBeds < 5 |
| AdmiPDayForRangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$386 to \$1,159 (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 $386 to $1,159. The previous year's national average is $773 (PDay < 386 or PDay > 1159) 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 < 386 or PDay > 1159) and TargetPop = '3' and AdmiNBeds >= 5 |
| AdmiPDayForRangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$386 to \$1,159 (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 $386 to $1,159. The previous year's national average is $773 (PDay < 386 or PDay > 1159) 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 < 386 or PDay > 1159) and TargetPop = '3' and AdmiNBeds < 5 |
| ResiPDay24RangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$173 to \$691 (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 $173 to $691. The previous year's national average is $345 (PDay < 173 or PDay > 691) 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 < 173 or PDay > 691) and HrsStaffed = 24 and ResiNBeds >= 5 |
| ResiPDay24RangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$173 to \$691 (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 $173 to $691. The previous year's national average is $345 (PDay < 173 or PDay > 691) 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 < 173 or PDay > 691) and HrsStaffed = 24 and ResiNBeds < 5 |
| ResiPDayN24RangeL | Exceptional | High | No | Patient Day Cost ($PDay.dollars) is outside the range \$75 to \$298 (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 $75 to $298. The previous year's national average is $149 (PDay < 75 or PDay > 298) 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 < 75 or PDay > 298) and HrsStaffed < 24 and ResiNBeds >= 5 |
| ResiPDayN24RangeS | Exceptional | Low | No | Patient Day Cost ($PDay.dollars) is outside the range \$75 to \$298 (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 $75 to $298. The previous year's national average is $149 (PDay < 75 or PDay > 298) 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 < 75 or PDay > 298) and HrsStaffed < 24 and ResiNBeds < 5 |
| AdmiAvgSalRange | Exceptional | High | No | Average Admi Salary ($AvgSal.dollars) is outside the range \$40,620 to \$121,861 | ORG.FteorgAdmiTotal | Exceptional Average Service Setting Salaries - Average Salary for Admitted Patient Service Unit at Organisation Level is outside the range $40,620 to $121,861. The previous year's national average is $81,241 | select State, RegId, OrgId, AvgSal from OrgAdmiAvgSal where AvgSal < 40620 or AvgSal > 121861 |
| ResiAvgSalRange | Exceptional | High | No | Average Resi Salary ($AvgSal.dollars) is outside the range \$34,139 to \$102,417 | ORG.FteorgResiTotal | Exceptional Average Service Setting Salaries - Average Salary for Residential Service Unit at Organisation Level is outside the range $34,139 to $102,417. The previous year's national average is $68,278 | select State, RegId, OrgId, AvgSal from OrgResiAvgSal where AvgSal < 34139 or AvgSal > 102417 |
| AmbuAvgSalRange | Exceptional | High | No | Average Ambu Salary ($AvgSal.dollars) is outside the range \$43,009 to \$129,027 | ORG.FteorgAmbuTotal | Exceptional Average Service Setting Salaries - Average Salary for Ambulatory Service Unit at Organisation Level is outside the range $43,009 to $129,027. The previous year's national average is $86,018 | select State, RegId, OrgId, AvgSal from OrgAmbuAvgSal where AvgSal < 43009 or AvgSal > 129027 |
| AdminAvgSalRange | Exceptional | High | No | Average Administrative and Clerical Salary ($AvgSal.dollars) is outside the range \$31,834 to \$95,503 | ORG.OrgAdminAvgSal | Exceptional Average Salary - Average Administrative and Clerical Salary reported at Organisation Level is outside the range $31,834 to $95,503. The previous year's national average is $63,669 | select State, RegId, OrgId, AvgSal from OrgAdminAvgSal where AvgSal < 31834 or AvgSal > 95503 |
| CarerCnsltAvgSalRange | Exceptional | High | No | Average Carer Consultants Salary ($AvgSal.dollars) is outside the range \$28,345 to \$85,036 | ORG.OrgCarerCnsltAvgSal | Exceptional Average Salary - Average Carer Consultants Salary reported at Organisation Level is outside the range $28,345 to $85,036. The previous year's national average is $56,690 | select State, RegId, OrgId, AvgSal from OrgCarerCnsltAvgSal where AvgSal < 28345 or AvgSal > 85036 |
| ConsrCnsltAvgSalRange | Exceptional | High | No | Average Consumer Consultants Salary ($AvgSal.dollars) is outside the range \$28,440 to \$85,321 | ORG.OrgConsrCnsltAvgSal | Exceptional Average Salary - Average Consumer Consultants Salary reported at Organisation Level is outside the range $28,440 to $85,321. The previous year's national average is $56,881 | select State, RegId, OrgId, AvgSal from OrgConsrCnsltAvgSal where AvgSal < 28440 or AvgSal > 85321 |
| DHPAvgSalRange | Exceptional | High | No | Average Diagnostic and Health Professionals Salary ($AvgSal.dollars) is outside the range \$36,614 to \$109,843 | ORG.OrgDHPAvgSal | Exceptional Average Salary - Average Diagnostic and Health Professionals Salary reported at Organisation Level is outside the range $36,614 to $109,843. The previous year's national average is $73,228 | select State, RegId, OrgId, AvgSal from OrgDHPAvgSal where AvgSal < 36614 or AvgSal > 109843 |
| DomestAvgSalRange | Exceptional | High | No | Average Domestic Salary ($AvgSal.dollars) is outside the range \$26,215 to \$78,645 | ORG.OrgDomestAvgSal | Exceptional Average Salary - Average Domestic Salary reported at Organisation Level is outside the range $26,215 to $78,645. The previous year's national average is $52,430 | select State, RegId, OrgId, AvgSal from OrgDomestAvgSal where AvgSal < 26215 or AvgSal > 78645 |
| NursesAvgSalRange | Exceptional | High | No | Average Nursing Salary ($AvgSal.dollars) is outside the range \$40,447 to \$121,340 | ORG.OrgNursesAvgSal | Exceptional Average Salary - Average Nursing Salary reported at Organisation Level is outside the range $40,447 to $121,340. The previous year's national average is $80,893 | select State, RegId, OrgId, AvgSal from OrgNursesAvgSal where AvgSal < 40447 or AvgSal > 121340 |
| PCareAvgSalRange | Exceptional | High | No | Average Other Personal Care Salary ($AvgSal.dollars) is outside the range \$25,079 to \$75,238 | ORG.OrgPCareAvgSal | Exceptional Average Salary - Average Other Personal Care Salary reported at Organisation Level is outside the range $25,079 to $75,238. The previous year's national average is $50,158 | select State, RegId, OrgId, AvgSal from OrgPCareAvgSal where AvgSal < 25079 or AvgSal > 75238 |
| RealMedAvgExpRange | Exceptional | High | No | Average Medical and VMOs Expenditure ($AvgSal.dollars) is outside the range \$88,479 to \$265,436 | ORG.OrgRealMedAvgSal | Exceptional Average Expenditure - Average Medical and VMOs Expenditure reported at Organisation Level is outside the range $88,479 to $265,436. The previous year's national average is $176,957 | select State, RegId, OrgId, AvgSal from OrgRealMedAvgSal where AvgSal < 88479 or AvgSal > 265436 |
| 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 > 50 |
| 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: Deprec, ExpNonSalTot, ExpSalTot, AdmiNBeds, MHCareDays, NSeps | select State, RegId, OrgId, HospId, AdmiId, Deprec,ExpNonSalTot,ExpSalTot,AdmiNBeds,MHCareDays,NSeps, DupCount from ADMI join ( select Deprec,ExpNonSalTot,ExpSalTot,AdmiNBeds,MHCareDays,NSeps,count(*) as DupCount from ADMI group by Deprec,ExpNonSalTot,ExpSalTot,AdmiNBeds,MHCareDays,NSeps having count(*) > 1 ) as tmpinner using ( 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: Deprec, ExpNonSalTot, ExpSalTot, NClients, NCont | select State, RegId, OrgId, ClusId, AmbuId, Deprec,ExpNonSalTot,ExpSalTot,NClients,NCont, DupCount from AMBU join ( select Deprec,ExpNonSalTot,ExpSalTot,NClients,NCont,count(*) as DupCount from AMBU group by Deprec,ExpNonSalTot,ExpSalTot,NClients,NCont having count(*) > 1 ) as tmpinner using ( 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: HrsStaffed, Deprec, ExpNonSalTot, ExpSalTot, ResiNBeds, MHCareDays, NEpi | select State, RegId, OrgId, ClusId, ResiId, HrsStaffed,Deprec,ExpNonSalTot,ExpSalTot,ResiNBeds,MHCareDays,NEpi, DupCount from RESI join ( select HrsStaffed,Deprec,ExpNonSalTot,ExpSalTot,ResiNBeds,MHCareDays,NEpi,count(*) as DupCount from RESI group by HrsStaffed,Deprec,ExpNonSalTot,ExpSalTot,ResiNBeds,MHCareDays,NEpi having count(*) > 1 ) as tmpinner using ( 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, FtePCare | select State, RegId, OrgId, Setting, FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FtePCare, DupCount from FTEORG join ( select FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FtePCare,count(*) as DupCount from FTEORG group by FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FtePCare having count(*) > 1 ) as tmpinner using ( FteMed,FteNurses,FteDHP,FteAdmin,FteDomest,FtePCare ) |
| OrgFteCnsltPsychGrowthVaries | Historical | High | No | OrgFteCnsltPsychChange ($Change) size is over 20 FTE and OrgFteCnsltPsychGrowth ($Growth.perc) size is over 50% | ORG.FteCnsltPsych | Large historical change in Consultant Psychiatrists and Psychiatrists (FteCnsltPsych), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFtePsyRegGrowthVaries | Historical | High | No | OrgFtePsyRegChange ($Change) size is over 20 FTE and OrgFtePsyRegGrowth ($Growth.perc) size is over 50% | ORG.FtePsyReg | Large historical change in Psychiatry Registrars and Trainees (FtePsyReg), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFteMedOtherGrowthVaries | Historical | High | No | OrgFteMedOtherChange ($Change) size is over 20 FTE and OrgFteMedOtherGrowth ($Growth.perc) size is over 50% | ORG.FteMedOther | Large historical change in Other Medical Officers (FteMedOther), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFteNursesRegGrowthVaries | Historical | High | No | OrgFteNursesRegChange ($Change) size is over 20 FTE and OrgFteNursesRegGrowth ($Growth.perc) size is over 50% | ORG.FteNursesReg | Large historical change in Registered Nurses (FteNursesReg), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFteNursesEnrlGrowthVaries | Historical | High | No | OrgFteNursesEnrlChange ($Change) size is over 20 FTE and OrgFteNursesEnrlGrowth ($Growth.perc) size is over 50% | ORG.FteNursesEnrl | Large historical change in Enrolled Nurses (FteNursesEnrl), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFteOTGrowthVaries | Historical | High | No | OrgFteOTChange ($Change) size is over 20 FTE and OrgFteOTGrowth ($Growth.perc) size is over 50% | ORG.FteOT | Large historical change in Occupational Therapists (FteOT), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFteSocialWkGrowthVaries | Historical | High | No | OrgFteSocialWkChange ($Change) size is over 20 FTE and OrgFteSocialWkGrowth ($Growth.perc) size is over 50% | ORG.FteSocialWk | Large historical change in Social Workers (FteSocialWk), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFtePsycholGrowthVaries | Historical | High | No | OrgFtePsycholChange ($Change) size is over 20 FTE and OrgFtePsycholGrowth ($Growth.perc) size is over 50% | ORG.FtePsychol | Large historical change in Psychologists (FtePsychol), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFteDHPOtherGrowthVaries | Historical | High | No | OrgFteDHPOtherChange ($Change) size is over 20 FTE and OrgFteDHPOtherGrowth ($Growth.perc) size is over 50% | ORG.FteDHPOther | Large historical change in Other Diagnostic and Health Professionals (FteDHPOther), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| 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 20 FTE and OrgFtePCareGrowth ($Growth.perc) size is over 50% | ORG.FtePCare | Large historical change in Other Personal Care (FtePCare), over 20 FTE and over 50%. 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) > 20 and abs(Growth) > 0.50 |
| OrgFteCarerCnsltGrowthVaries | Historical | High | No | OrgFteCarerCnsltChange ($Change) size is over 20 FTE and OrgFteCarerCnsltGrowth ($Growth.perc) size is over 50% | ORG.FteCarerCnslt | Large historical change in Carer Consultants (FteCarerCnslt), over 20 FTE and over 50%. This rules uses Full-Time Equivalent Staff - Carer Consultants Change and Growth fields (OrgFteCarerCnsltChange and OrgFteCarerCnsltGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteCarerCnsltChange join OrgFteCarerCnsltGrowth using (State, RegId, OrgId) where abs(Change) > 20 and abs(Growth) > 0.50 |
| OrgFteConsrCnsltGrowthVaries | Historical | High | No | OrgFteConsrCnsltChange ($Change) size is over 20 FTE and OrgFteConsrCnsltGrowth ($Growth.perc) size is over 50% | ORG.FteConsrCnslt | Large historical change in Consumer Consultants (FteConsrCnslt), over 20 FTE and over 50%. This rules uses Full-Time Equivalent Staff - Consumer Consultants Change and Growth fields (OrgFteConsrCnsltChange and OrgFteConsrCnsltGrowth). | select State, RegId, OrgId, Change, Growth from OrgFteConsrCnsltChange join OrgFteConsrCnsltGrowth using (State, RegId, OrgId) where abs(Change) > 20 and abs(Growth) > 0.50 |
| 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 |