Main Content

MHE version 02.40: Rules

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