View Reports - WebVal

NOCC version 02.11: Rules

Table detailing the rules for specification: NOCC
Name	Class	Priority	Bulk	Message	Mark	Description	SQL
CodSexSpaces	Invalid	High	Yes	All spaces in field Sex (Char)	COD.Sex	All spaces in field Sex (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, Sex from COD where Sex is null
HonosHnos01Spaces	Invalid	High	Yes	All spaces in field Hnos01 (Number)	HONOS.Hnos01	All spaces in field Hnos01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos01 from HONOS where Hnos01 is null
HonosHnos02Spaces	Invalid	High	Yes	All spaces in field Hnos02 (Number)	HONOS.Hnos02	All spaces in field Hnos02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos02 from HONOS where Hnos02 is null
HonosHnos03Spaces	Invalid	High	Yes	All spaces in field Hnos03 (Number)	HONOS.Hnos03	All spaces in field Hnos03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos03 from HONOS where Hnos03 is null
HonosHnos04Spaces	Invalid	High	Yes	All spaces in field Hnos04 (Number)	HONOS.Hnos04	All spaces in field Hnos04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos04 from HONOS where Hnos04 is null
HonosHnos05Spaces	Invalid	High	Yes	All spaces in field Hnos05 (Number)	HONOS.Hnos05	All spaces in field Hnos05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos05 from HONOS where Hnos05 is null
HonosHnos06Spaces	Invalid	High	Yes	All spaces in field Hnos06 (Number)	HONOS.Hnos06	All spaces in field Hnos06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos06 from HONOS where Hnos06 is null
HonosHnos07Spaces	Invalid	High	Yes	All spaces in field Hnos07 (Number)	HONOS.Hnos07	All spaces in field Hnos07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos07 from HONOS where Hnos07 is null
HonosHnos08Spaces	Invalid	High	Yes	All spaces in field Hnos08 (Number)	HONOS.Hnos08	All spaces in field Hnos08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos08 from HONOS where Hnos08 is null
HonosHnos08aSpaces	Invalid	High	Yes	All spaces in field Hnos08a (Char)	HONOS.Hnos08a	All spaces in field Hnos08a (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos08a from HONOS where Hnos08a is null
HonosHnos09Spaces	Invalid	High	Yes	All spaces in field Hnos09 (Number)	HONOS.Hnos09	All spaces in field Hnos09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos09 from HONOS where Hnos09 is null
HonosHnos10Spaces	Invalid	High	Yes	All spaces in field Hnos10 (Number)	HONOS.Hnos10	All spaces in field Hnos10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos10 from HONOS where Hnos10 is null
HonosHnos11Spaces	Invalid	High	Yes	All spaces in field Hnos11 (Number)	HONOS.Hnos11	All spaces in field Hnos11 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos11 from HONOS where Hnos11 is null
HonosHnos12Spaces	Invalid	High	Yes	All spaces in field Hnos12 (Number)	HONOS.Hnos12	All spaces in field Hnos12 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Hnos12 from HONOS where Hnos12 is null
Lsp16Lsp01Spaces	Invalid	High	Yes	All spaces in field Lsp01 (Number)	LSP16.Lsp01	All spaces in field Lsp01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp01 from LSP16 where Lsp01 is null
Lsp16Lsp02Spaces	Invalid	High	Yes	All spaces in field Lsp02 (Number)	LSP16.Lsp02	All spaces in field Lsp02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp02 from LSP16 where Lsp02 is null
Lsp16Lsp03Spaces	Invalid	High	Yes	All spaces in field Lsp03 (Number)	LSP16.Lsp03	All spaces in field Lsp03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp03 from LSP16 where Lsp03 is null
Lsp16Lsp04Spaces	Invalid	High	Yes	All spaces in field Lsp04 (Number)	LSP16.Lsp04	All spaces in field Lsp04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp04 from LSP16 where Lsp04 is null
Lsp16Lsp05Spaces	Invalid	High	Yes	All spaces in field Lsp05 (Number)	LSP16.Lsp05	All spaces in field Lsp05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp05 from LSP16 where Lsp05 is null
Lsp16Lsp06Spaces	Invalid	High	Yes	All spaces in field Lsp06 (Number)	LSP16.Lsp06	All spaces in field Lsp06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp06 from LSP16 where Lsp06 is null
Lsp16Lsp07Spaces	Invalid	High	Yes	All spaces in field Lsp07 (Number)	LSP16.Lsp07	All spaces in field Lsp07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp07 from LSP16 where Lsp07 is null
Lsp16Lsp08Spaces	Invalid	High	Yes	All spaces in field Lsp08 (Number)	LSP16.Lsp08	All spaces in field Lsp08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp08 from LSP16 where Lsp08 is null
Lsp16Lsp09Spaces	Invalid	High	Yes	All spaces in field Lsp09 (Number)	LSP16.Lsp09	All spaces in field Lsp09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp09 from LSP16 where Lsp09 is null
Lsp16Lsp10Spaces	Invalid	High	Yes	All spaces in field Lsp10 (Number)	LSP16.Lsp10	All spaces in field Lsp10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp10 from LSP16 where Lsp10 is null
Lsp16Lsp11Spaces	Invalid	High	Yes	All spaces in field Lsp11 (Number)	LSP16.Lsp11	All spaces in field Lsp11 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp11 from LSP16 where Lsp11 is null
Lsp16Lsp12Spaces	Invalid	High	Yes	All spaces in field Lsp12 (Number)	LSP16.Lsp12	All spaces in field Lsp12 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp12 from LSP16 where Lsp12 is null
Lsp16Lsp13Spaces	Invalid	High	Yes	All spaces in field Lsp13 (Number)	LSP16.Lsp13	All spaces in field Lsp13 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp13 from LSP16 where Lsp13 is null
Lsp16Lsp14Spaces	Invalid	High	Yes	All spaces in field Lsp14 (Number)	LSP16.Lsp14	All spaces in field Lsp14 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp14 from LSP16 where Lsp14 is null
Lsp16Lsp15Spaces	Invalid	High	Yes	All spaces in field Lsp15 (Number)	LSP16.Lsp15	All spaces in field Lsp15 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp15 from LSP16 where Lsp15 is null
Lsp16Lsp16Spaces	Invalid	High	Yes	All spaces in field Lsp16 (Number)	LSP16.Lsp16	All spaces in field Lsp16 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Lsp16 from LSP16 where Lsp16 is null
RugadlRugAdl1Spaces	Invalid	High	Yes	All spaces in field RugAdl1 (Number)	RUGADL.RugAdl1	All spaces in field RugAdl1 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, RugAdl1 from RUGADL where RugAdl1 is null
RugadlRugAdl2Spaces	Invalid	High	Yes	All spaces in field RugAdl2 (Number)	RUGADL.RugAdl2	All spaces in field RugAdl2 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, RugAdl2 from RUGADL where RugAdl2 is null
RugadlRugAdl3Spaces	Invalid	High	Yes	All spaces in field RugAdl3 (Number)	RUGADL.RugAdl3	All spaces in field RugAdl3 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, RugAdl3 from RUGADL where RugAdl3 is null
RugadlRugAdl4Spaces	Invalid	High	Yes	All spaces in field RugAdl4 (Number)	RUGADL.RugAdl4	All spaces in field RugAdl4 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, RugAdl4 from RUGADL where RugAdl4 is null
HonoscaHnosC01Spaces	Invalid	High	Yes	All spaces in field HnosC01 (Number)	HONOSCA.HnosC01	All spaces in field HnosC01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC01 from HONOSCA where HnosC01 is null
HonoscaHnosC02Spaces	Invalid	High	Yes	All spaces in field HnosC02 (Number)	HONOSCA.HnosC02	All spaces in field HnosC02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC02 from HONOSCA where HnosC02 is null
HonoscaHnosC03Spaces	Invalid	High	Yes	All spaces in field HnosC03 (Number)	HONOSCA.HnosC03	All spaces in field HnosC03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC03 from HONOSCA where HnosC03 is null
HonoscaHnosC04Spaces	Invalid	High	Yes	All spaces in field HnosC04 (Number)	HONOSCA.HnosC04	All spaces in field HnosC04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC04 from HONOSCA where HnosC04 is null
HonoscaHnosC05Spaces	Invalid	High	Yes	All spaces in field HnosC05 (Number)	HONOSCA.HnosC05	All spaces in field HnosC05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC05 from HONOSCA where HnosC05 is null
HonoscaHnosC06Spaces	Invalid	High	Yes	All spaces in field HnosC06 (Number)	HONOSCA.HnosC06	All spaces in field HnosC06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC06 from HONOSCA where HnosC06 is null
HonoscaHnosC07Spaces	Invalid	High	Yes	All spaces in field HnosC07 (Number)	HONOSCA.HnosC07	All spaces in field HnosC07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC07 from HONOSCA where HnosC07 is null
HonoscaHnosC08Spaces	Invalid	High	Yes	All spaces in field HnosC08 (Number)	HONOSCA.HnosC08	All spaces in field HnosC08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC08 from HONOSCA where HnosC08 is null
HonoscaHnosC09Spaces	Invalid	High	Yes	All spaces in field HnosC09 (Number)	HONOSCA.HnosC09	All spaces in field HnosC09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC09 from HONOSCA where HnosC09 is null
HonoscaHnosC10Spaces	Invalid	High	Yes	All spaces in field HnosC10 (Number)	HONOSCA.HnosC10	All spaces in field HnosC10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC10 from HONOSCA where HnosC10 is null
HonoscaHnosC11Spaces	Invalid	High	Yes	All spaces in field HnosC11 (Number)	HONOSCA.HnosC11	All spaces in field HnosC11 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC11 from HONOSCA where HnosC11 is null
HonoscaHnosC12Spaces	Invalid	High	Yes	All spaces in field HnosC12 (Number)	HONOSCA.HnosC12	All spaces in field HnosC12 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC12 from HONOSCA where HnosC12 is null
HonoscaHnosC13Spaces	Invalid	High	Yes	All spaces in field HnosC13 (Number)	HONOSCA.HnosC13	All spaces in field HnosC13 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC13 from HONOSCA where HnosC13 is null
HonoscaHnosC14Spaces	Invalid	High	Yes	All spaces in field HnosC14 (Number)	HONOSCA.HnosC14	All spaces in field HnosC14 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC14 from HONOSCA where HnosC14 is null
HonoscaHnosC15Spaces	Invalid	High	Yes	All spaces in field HnosC15 (Number)	HONOSCA.HnosC15	All spaces in field HnosC15 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, HnosC15 from HONOSCA where HnosC15 is null
CgasCgasSpaces	Invalid	High	Yes	All spaces in field Cgas (Number)	CGAS.Cgas	All spaces in field Cgas (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Cgas from CGAS where Cgas is null
FihsFihs1Spaces	Invalid	High	Yes	All spaces in field Fihs1 (Number)	FIHS.Fihs1	All spaces in field Fihs1 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Fihs1 from FIHS where Fihs1 is null
FihsFihs2Spaces	Invalid	High	Yes	All spaces in field Fihs2 (Number)	FIHS.Fihs2	All spaces in field Fihs2 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Fihs2 from FIHS where Fihs2 is null
FihsFihs3Spaces	Invalid	High	Yes	All spaces in field Fihs3 (Number)	FIHS.Fihs3	All spaces in field Fihs3 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Fihs3 from FIHS where Fihs3 is null
FihsFihs4Spaces	Invalid	High	Yes	All spaces in field Fihs4 (Number)	FIHS.Fihs4	All spaces in field Fihs4 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Fihs4 from FIHS where Fihs4 is null
FihsFihs5Spaces	Invalid	High	Yes	All spaces in field Fihs5 (Number)	FIHS.Fihs5	All spaces in field Fihs5 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Fihs5 from FIHS where Fihs5 is null
FihsFihs6Spaces	Invalid	High	Yes	All spaces in field Fihs6 (Number)	FIHS.Fihs6	All spaces in field Fihs6 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Fihs6 from FIHS where Fihs6 is null
FihsFihs7Spaces	Invalid	High	Yes	All spaces in field Fihs7 (Number)	FIHS.Fihs7	All spaces in field Fihs7 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, Fihs7 from FIHS where Fihs7 is null
Mhi38ColStSpaces	Invalid	High	Yes	All spaces in field ColSt (Char)	MHI38.ColSt	All spaces in field ColSt (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, ColSt from MHI38 where ColSt is null
Mhi38MHI01Spaces	Invalid	High	Yes	All spaces in field MHI01 (Number)	MHI38.MHI01	All spaces in field MHI01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI01 from MHI38 where MHI01 is null
Mhi38MHI02Spaces	Invalid	High	Yes	All spaces in field MHI02 (Number)	MHI38.MHI02	All spaces in field MHI02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI02 from MHI38 where MHI02 is null
Mhi38MHI03Spaces	Invalid	High	Yes	All spaces in field MHI03 (Number)	MHI38.MHI03	All spaces in field MHI03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI03 from MHI38 where MHI03 is null
Mhi38MHI04Spaces	Invalid	High	Yes	All spaces in field MHI04 (Number)	MHI38.MHI04	All spaces in field MHI04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI04 from MHI38 where MHI04 is null
Mhi38MHI05Spaces	Invalid	High	Yes	All spaces in field MHI05 (Number)	MHI38.MHI05	All spaces in field MHI05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI05 from MHI38 where MHI05 is null
Mhi38MHI06Spaces	Invalid	High	Yes	All spaces in field MHI06 (Number)	MHI38.MHI06	All spaces in field MHI06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI06 from MHI38 where MHI06 is null
Mhi38MHI07Spaces	Invalid	High	Yes	All spaces in field MHI07 (Number)	MHI38.MHI07	All spaces in field MHI07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI07 from MHI38 where MHI07 is null
Mhi38MHI08Spaces	Invalid	High	Yes	All spaces in field MHI08 (Number)	MHI38.MHI08	All spaces in field MHI08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI08 from MHI38 where MHI08 is null
Mhi38MHI09Spaces	Invalid	High	Yes	All spaces in field MHI09 (Number)	MHI38.MHI09	All spaces in field MHI09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI09 from MHI38 where MHI09 is null
Mhi38MHI10Spaces	Invalid	High	Yes	All spaces in field MHI10 (Number)	MHI38.MHI10	All spaces in field MHI10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI10 from MHI38 where MHI10 is null
Mhi38MHI11Spaces	Invalid	High	Yes	All spaces in field MHI11 (Number)	MHI38.MHI11	All spaces in field MHI11 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI11 from MHI38 where MHI11 is null
Mhi38MHI12Spaces	Invalid	High	Yes	All spaces in field MHI12 (Number)	MHI38.MHI12	All spaces in field MHI12 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI12 from MHI38 where MHI12 is null
Mhi38MHI13Spaces	Invalid	High	Yes	All spaces in field MHI13 (Number)	MHI38.MHI13	All spaces in field MHI13 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI13 from MHI38 where MHI13 is null
Mhi38MHI14Spaces	Invalid	High	Yes	All spaces in field MHI14 (Number)	MHI38.MHI14	All spaces in field MHI14 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI14 from MHI38 where MHI14 is null
Mhi38MHI15Spaces	Invalid	High	Yes	All spaces in field MHI15 (Number)	MHI38.MHI15	All spaces in field MHI15 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI15 from MHI38 where MHI15 is null
Mhi38MHI16Spaces	Invalid	High	Yes	All spaces in field MHI16 (Number)	MHI38.MHI16	All spaces in field MHI16 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI16 from MHI38 where MHI16 is null
Mhi38MHI17Spaces	Invalid	High	Yes	All spaces in field MHI17 (Number)	MHI38.MHI17	All spaces in field MHI17 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI17 from MHI38 where MHI17 is null
Mhi38MHI18Spaces	Invalid	High	Yes	All spaces in field MHI18 (Number)	MHI38.MHI18	All spaces in field MHI18 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI18 from MHI38 where MHI18 is null
Mhi38MHI19Spaces	Invalid	High	Yes	All spaces in field MHI19 (Number)	MHI38.MHI19	All spaces in field MHI19 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI19 from MHI38 where MHI19 is null
Mhi38MHI20Spaces	Invalid	High	Yes	All spaces in field MHI20 (Number)	MHI38.MHI20	All spaces in field MHI20 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI20 from MHI38 where MHI20 is null
Mhi38MHI21Spaces	Invalid	High	Yes	All spaces in field MHI21 (Number)	MHI38.MHI21	All spaces in field MHI21 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI21 from MHI38 where MHI21 is null
Mhi38MHI22Spaces	Invalid	High	Yes	All spaces in field MHI22 (Number)	MHI38.MHI22	All spaces in field MHI22 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI22 from MHI38 where MHI22 is null
Mhi38MHI23Spaces	Invalid	High	Yes	All spaces in field MHI23 (Number)	MHI38.MHI23	All spaces in field MHI23 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI23 from MHI38 where MHI23 is null
Mhi38MHI24Spaces	Invalid	High	Yes	All spaces in field MHI24 (Number)	MHI38.MHI24	All spaces in field MHI24 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI24 from MHI38 where MHI24 is null
Mhi38MHI25Spaces	Invalid	High	Yes	All spaces in field MHI25 (Number)	MHI38.MHI25	All spaces in field MHI25 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI25 from MHI38 where MHI25 is null
Mhi38MHI26Spaces	Invalid	High	Yes	All spaces in field MHI26 (Number)	MHI38.MHI26	All spaces in field MHI26 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI26 from MHI38 where MHI26 is null
Mhi38MHI27Spaces	Invalid	High	Yes	All spaces in field MHI27 (Number)	MHI38.MHI27	All spaces in field MHI27 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI27 from MHI38 where MHI27 is null
Mhi38MHI28Spaces	Invalid	High	Yes	All spaces in field MHI28 (Number)	MHI38.MHI28	All spaces in field MHI28 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI28 from MHI38 where MHI28 is null
Mhi38MHI29Spaces	Invalid	High	Yes	All spaces in field MHI29 (Number)	MHI38.MHI29	All spaces in field MHI29 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI29 from MHI38 where MHI29 is null
Mhi38MHI30Spaces	Invalid	High	Yes	All spaces in field MHI30 (Number)	MHI38.MHI30	All spaces in field MHI30 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI30 from MHI38 where MHI30 is null
Mhi38MHI31Spaces	Invalid	High	Yes	All spaces in field MHI31 (Number)	MHI38.MHI31	All spaces in field MHI31 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI31 from MHI38 where MHI31 is null
Mhi38MHI32Spaces	Invalid	High	Yes	All spaces in field MHI32 (Number)	MHI38.MHI32	All spaces in field MHI32 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI32 from MHI38 where MHI32 is null
Mhi38MHI33Spaces	Invalid	High	Yes	All spaces in field MHI33 (Number)	MHI38.MHI33	All spaces in field MHI33 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI33 from MHI38 where MHI33 is null
Mhi38MHI34Spaces	Invalid	High	Yes	All spaces in field MHI34 (Number)	MHI38.MHI34	All spaces in field MHI34 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI34 from MHI38 where MHI34 is null
Mhi38MHI35Spaces	Invalid	High	Yes	All spaces in field MHI35 (Number)	MHI38.MHI35	All spaces in field MHI35 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI35 from MHI38 where MHI35 is null
Mhi38MHI36Spaces	Invalid	High	Yes	All spaces in field MHI36 (Number)	MHI38.MHI36	All spaces in field MHI36 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI36 from MHI38 where MHI36 is null
Mhi38MHI37Spaces	Invalid	High	Yes	All spaces in field MHI37 (Number)	MHI38.MHI37	All spaces in field MHI37 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI37 from MHI38 where MHI37 is null
Mhi38MHI38Spaces	Invalid	High	Yes	All spaces in field MHI38 (Number)	MHI38.MHI38	All spaces in field MHI38 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, MHI38 from MHI38 where MHI38 is null
Basis32ColStSpaces	Invalid	High	Yes	All spaces in field ColSt (Char)	BASIS32.ColSt	All spaces in field ColSt (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, ColSt from BASIS32 where ColSt is null
Basis32BASIS01Spaces	Invalid	High	Yes	All spaces in field BASIS01 (Number)	BASIS32.BASIS01	All spaces in field BASIS01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS01 from BASIS32 where BASIS01 is null
Basis32BASIS02Spaces	Invalid	High	Yes	All spaces in field BASIS02 (Number)	BASIS32.BASIS02	All spaces in field BASIS02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS02 from BASIS32 where BASIS02 is null
Basis32BASIS03Spaces	Invalid	High	Yes	All spaces in field BASIS03 (Number)	BASIS32.BASIS03	All spaces in field BASIS03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS03 from BASIS32 where BASIS03 is null
Basis32BASIS04Spaces	Invalid	High	Yes	All spaces in field BASIS04 (Number)	BASIS32.BASIS04	All spaces in field BASIS04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS04 from BASIS32 where BASIS04 is null
Basis32BASIS05Spaces	Invalid	High	Yes	All spaces in field BASIS05 (Number)	BASIS32.BASIS05	All spaces in field BASIS05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS05 from BASIS32 where BASIS05 is null
Basis32BASIS06Spaces	Invalid	High	Yes	All spaces in field BASIS06 (Number)	BASIS32.BASIS06	All spaces in field BASIS06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS06 from BASIS32 where BASIS06 is null
Basis32BASIS07Spaces	Invalid	High	Yes	All spaces in field BASIS07 (Number)	BASIS32.BASIS07	All spaces in field BASIS07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS07 from BASIS32 where BASIS07 is null
Basis32BASIS08Spaces	Invalid	High	Yes	All spaces in field BASIS08 (Number)	BASIS32.BASIS08	All spaces in field BASIS08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS08 from BASIS32 where BASIS08 is null
Basis32BASIS09Spaces	Invalid	High	Yes	All spaces in field BASIS09 (Number)	BASIS32.BASIS09	All spaces in field BASIS09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS09 from BASIS32 where BASIS09 is null
Basis32BASIS10Spaces	Invalid	High	Yes	All spaces in field BASIS10 (Number)	BASIS32.BASIS10	All spaces in field BASIS10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS10 from BASIS32 where BASIS10 is null
Basis32BASIS11Spaces	Invalid	High	Yes	All spaces in field BASIS11 (Number)	BASIS32.BASIS11	All spaces in field BASIS11 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS11 from BASIS32 where BASIS11 is null
Basis32BASIS12Spaces	Invalid	High	Yes	All spaces in field BASIS12 (Number)	BASIS32.BASIS12	All spaces in field BASIS12 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS12 from BASIS32 where BASIS12 is null
Basis32BASIS13Spaces	Invalid	High	Yes	All spaces in field BASIS13 (Number)	BASIS32.BASIS13	All spaces in field BASIS13 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS13 from BASIS32 where BASIS13 is null
Basis32BASIS14Spaces	Invalid	High	Yes	All spaces in field BASIS14 (Number)	BASIS32.BASIS14	All spaces in field BASIS14 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS14 from BASIS32 where BASIS14 is null
Basis32BASIS15Spaces	Invalid	High	Yes	All spaces in field BASIS15 (Number)	BASIS32.BASIS15	All spaces in field BASIS15 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS15 from BASIS32 where BASIS15 is null
Basis32BASIS16Spaces	Invalid	High	Yes	All spaces in field BASIS16 (Number)	BASIS32.BASIS16	All spaces in field BASIS16 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS16 from BASIS32 where BASIS16 is null
Basis32BASIS17Spaces	Invalid	High	Yes	All spaces in field BASIS17 (Number)	BASIS32.BASIS17	All spaces in field BASIS17 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS17 from BASIS32 where BASIS17 is null
Basis32BASIS18Spaces	Invalid	High	Yes	All spaces in field BASIS18 (Number)	BASIS32.BASIS18	All spaces in field BASIS18 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS18 from BASIS32 where BASIS18 is null
Basis32BASIS19Spaces	Invalid	High	Yes	All spaces in field BASIS19 (Number)	BASIS32.BASIS19	All spaces in field BASIS19 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS19 from BASIS32 where BASIS19 is null
Basis32BASIS20Spaces	Invalid	High	Yes	All spaces in field BASIS20 (Number)	BASIS32.BASIS20	All spaces in field BASIS20 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS20 from BASIS32 where BASIS20 is null
Basis32BASIS21Spaces	Invalid	High	Yes	All spaces in field BASIS21 (Number)	BASIS32.BASIS21	All spaces in field BASIS21 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS21 from BASIS32 where BASIS21 is null
Basis32BASIS22Spaces	Invalid	High	Yes	All spaces in field BASIS22 (Number)	BASIS32.BASIS22	All spaces in field BASIS22 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS22 from BASIS32 where BASIS22 is null
Basis32BASIS23Spaces	Invalid	High	Yes	All spaces in field BASIS23 (Number)	BASIS32.BASIS23	All spaces in field BASIS23 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS23 from BASIS32 where BASIS23 is null
Basis32BASIS24Spaces	Invalid	High	Yes	All spaces in field BASIS24 (Number)	BASIS32.BASIS24	All spaces in field BASIS24 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS24 from BASIS32 where BASIS24 is null
Basis32BASIS25Spaces	Invalid	High	Yes	All spaces in field BASIS25 (Number)	BASIS32.BASIS25	All spaces in field BASIS25 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS25 from BASIS32 where BASIS25 is null
Basis32BASIS26Spaces	Invalid	High	Yes	All spaces in field BASIS26 (Number)	BASIS32.BASIS26	All spaces in field BASIS26 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS26 from BASIS32 where BASIS26 is null
Basis32BASIS27Spaces	Invalid	High	Yes	All spaces in field BASIS27 (Number)	BASIS32.BASIS27	All spaces in field BASIS27 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS27 from BASIS32 where BASIS27 is null
Basis32BASIS28Spaces	Invalid	High	Yes	All spaces in field BASIS28 (Number)	BASIS32.BASIS28	All spaces in field BASIS28 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS28 from BASIS32 where BASIS28 is null
Basis32BASIS29Spaces	Invalid	High	Yes	All spaces in field BASIS29 (Number)	BASIS32.BASIS29	All spaces in field BASIS29 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS29 from BASIS32 where BASIS29 is null
Basis32BASIS30Spaces	Invalid	High	Yes	All spaces in field BASIS30 (Number)	BASIS32.BASIS30	All spaces in field BASIS30 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS30 from BASIS32 where BASIS30 is null
Basis32BASIS31Spaces	Invalid	High	Yes	All spaces in field BASIS31 (Number)	BASIS32.BASIS31	All spaces in field BASIS31 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS31 from BASIS32 where BASIS31 is null
Basis32BASIS32Spaces	Invalid	High	Yes	All spaces in field BASIS32 (Number)	BASIS32.BASIS32	All spaces in field BASIS32 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, BASIS32 from BASIS32 where BASIS32 is null
K10lmColStSpaces	Invalid	High	Yes	All spaces in field ColSt (Char)	K10LM.ColSt	All spaces in field ColSt (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, ColSt from K10LM where ColSt is null
K10lmK10LM01Spaces	Invalid	High	Yes	All spaces in field K10LM01 (Number)	K10LM.K10LM01	All spaces in field K10LM01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM01 from K10LM where K10LM01 is null
K10lmK10LM02Spaces	Invalid	High	Yes	All spaces in field K10LM02 (Number)	K10LM.K10LM02	All spaces in field K10LM02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM02 from K10LM where K10LM02 is null
K10lmK10LM03Spaces	Invalid	High	Yes	All spaces in field K10LM03 (Number)	K10LM.K10LM03	All spaces in field K10LM03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM03 from K10LM where K10LM03 is null
K10lmK10LM04Spaces	Invalid	High	Yes	All spaces in field K10LM04 (Number)	K10LM.K10LM04	All spaces in field K10LM04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM04 from K10LM where K10LM04 is null
K10lmK10LM05Spaces	Invalid	High	Yes	All spaces in field K10LM05 (Number)	K10LM.K10LM05	All spaces in field K10LM05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM05 from K10LM where K10LM05 is null
K10lmK10LM06Spaces	Invalid	High	Yes	All spaces in field K10LM06 (Number)	K10LM.K10LM06	All spaces in field K10LM06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM06 from K10LM where K10LM06 is null
K10lmK10LM07Spaces	Invalid	High	Yes	All spaces in field K10LM07 (Number)	K10LM.K10LM07	All spaces in field K10LM07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM07 from K10LM where K10LM07 is null
K10lmK10LM08Spaces	Invalid	High	Yes	All spaces in field K10LM08 (Number)	K10LM.K10LM08	All spaces in field K10LM08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM08 from K10LM where K10LM08 is null
K10lmK10LM09Spaces	Invalid	High	Yes	All spaces in field K10LM09 (Number)	K10LM.K10LM09	All spaces in field K10LM09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM09 from K10LM where K10LM09 is null
K10lmK10LM10Spaces	Invalid	High	Yes	All spaces in field K10LM10 (Number)	K10LM.K10LM10	All spaces in field K10LM10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM10 from K10LM where K10LM10 is null
K10lmK10LM11Spaces	Invalid	High	Yes	All spaces in field K10LM11 (Number)	K10LM.K10LM11	All spaces in field K10LM11 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM11 from K10LM where K10LM11 is null
K10lmK10LM12Spaces	Invalid	High	Yes	All spaces in field K10LM12 (Number)	K10LM.K10LM12	All spaces in field K10LM12 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM12 from K10LM where K10LM12 is null
K10lmK10LM13Spaces	Invalid	High	Yes	All spaces in field K10LM13 (Number)	K10LM.K10LM13	All spaces in field K10LM13 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM13 from K10LM where K10LM13 is null
K10lmK10LM14Spaces	Invalid	High	Yes	All spaces in field K10LM14 (Number)	K10LM.K10LM14	All spaces in field K10LM14 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10LM14 from K10LM where K10LM14 is null
K10l3dColStSpaces	Invalid	High	Yes	All spaces in field ColSt (Char)	K10L3D.ColSt	All spaces in field ColSt (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, ColSt from K10L3D where ColSt is null
K10l3dK10L3D01Spaces	Invalid	High	Yes	All spaces in field K10L3D01 (Number)	K10L3D.K10L3D01	All spaces in field K10L3D01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D01 from K10L3D where K10L3D01 is null
K10l3dK10L3D02Spaces	Invalid	High	Yes	All spaces in field K10L3D02 (Number)	K10L3D.K10L3D02	All spaces in field K10L3D02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D02 from K10L3D where K10L3D02 is null
K10l3dK10L3D03Spaces	Invalid	High	Yes	All spaces in field K10L3D03 (Number)	K10L3D.K10L3D03	All spaces in field K10L3D03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D03 from K10L3D where K10L3D03 is null
K10l3dK10L3D04Spaces	Invalid	High	Yes	All spaces in field K10L3D04 (Number)	K10L3D.K10L3D04	All spaces in field K10L3D04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D04 from K10L3D where K10L3D04 is null
K10l3dK10L3D05Spaces	Invalid	High	Yes	All spaces in field K10L3D05 (Number)	K10L3D.K10L3D05	All spaces in field K10L3D05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D05 from K10L3D where K10L3D05 is null
K10l3dK10L3D06Spaces	Invalid	High	Yes	All spaces in field K10L3D06 (Number)	K10L3D.K10L3D06	All spaces in field K10L3D06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D06 from K10L3D where K10L3D06 is null
K10l3dK10L3D07Spaces	Invalid	High	Yes	All spaces in field K10L3D07 (Number)	K10L3D.K10L3D07	All spaces in field K10L3D07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D07 from K10L3D where K10L3D07 is null
K10l3dK10L3D08Spaces	Invalid	High	Yes	All spaces in field K10L3D08 (Number)	K10L3D.K10L3D08	All spaces in field K10L3D08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D08 from K10L3D where K10L3D08 is null
K10l3dK10L3D09Spaces	Invalid	High	Yes	All spaces in field K10L3D09 (Number)	K10L3D.K10L3D09	All spaces in field K10L3D09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D09 from K10L3D where K10L3D09 is null
K10l3dK10L3D10Spaces	Invalid	High	Yes	All spaces in field K10L3D10 (Number)	K10L3D.K10L3D10	All spaces in field K10L3D10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, K10L3D10 from K10L3D where K10L3D10 is null
SdqColStSpaces	Invalid	High	Yes	All spaces in field ColSt (Char)	SDQ.ColSt	All spaces in field ColSt (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, ColSt from SDQ where ColSt is null
SdqSDQ01Spaces	Invalid	High	Yes	All spaces in field SDQ01 (Number)	SDQ.SDQ01	All spaces in field SDQ01 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ01 from SDQ where SDQ01 is null
SdqSDQ02Spaces	Invalid	High	Yes	All spaces in field SDQ02 (Number)	SDQ.SDQ02	All spaces in field SDQ02 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ02 from SDQ where SDQ02 is null
SdqSDQ03Spaces	Invalid	High	Yes	All spaces in field SDQ03 (Number)	SDQ.SDQ03	All spaces in field SDQ03 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ03 from SDQ where SDQ03 is null
SdqSDQ04Spaces	Invalid	High	Yes	All spaces in field SDQ04 (Number)	SDQ.SDQ04	All spaces in field SDQ04 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ04 from SDQ where SDQ04 is null
SdqSDQ05Spaces	Invalid	High	Yes	All spaces in field SDQ05 (Number)	SDQ.SDQ05	All spaces in field SDQ05 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ05 from SDQ where SDQ05 is null
SdqSDQ06Spaces	Invalid	High	Yes	All spaces in field SDQ06 (Number)	SDQ.SDQ06	All spaces in field SDQ06 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ06 from SDQ where SDQ06 is null
SdqSDQ07Spaces	Invalid	High	Yes	All spaces in field SDQ07 (Number)	SDQ.SDQ07	All spaces in field SDQ07 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ07 from SDQ where SDQ07 is null
SdqSDQ08Spaces	Invalid	High	Yes	All spaces in field SDQ08 (Number)	SDQ.SDQ08	All spaces in field SDQ08 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ08 from SDQ where SDQ08 is null
SdqSDQ09Spaces	Invalid	High	Yes	All spaces in field SDQ09 (Number)	SDQ.SDQ09	All spaces in field SDQ09 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ09 from SDQ where SDQ09 is null
SdqSDQ10Spaces	Invalid	High	Yes	All spaces in field SDQ10 (Number)	SDQ.SDQ10	All spaces in field SDQ10 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ10 from SDQ where SDQ10 is null
SdqSDQ11Spaces	Invalid	High	Yes	All spaces in field SDQ11 (Number)	SDQ.SDQ11	All spaces in field SDQ11 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ11 from SDQ where SDQ11 is null
SdqSDQ12Spaces	Invalid	High	Yes	All spaces in field SDQ12 (Number)	SDQ.SDQ12	All spaces in field SDQ12 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ12 from SDQ where SDQ12 is null
SdqSDQ13Spaces	Invalid	High	Yes	All spaces in field SDQ13 (Number)	SDQ.SDQ13	All spaces in field SDQ13 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ13 from SDQ where SDQ13 is null
SdqSDQ14Spaces	Invalid	High	Yes	All spaces in field SDQ14 (Number)	SDQ.SDQ14	All spaces in field SDQ14 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ14 from SDQ where SDQ14 is null
SdqSDQ15Spaces	Invalid	High	Yes	All spaces in field SDQ15 (Number)	SDQ.SDQ15	All spaces in field SDQ15 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ15 from SDQ where SDQ15 is null
SdqSDQ16Spaces	Invalid	High	Yes	All spaces in field SDQ16 (Number)	SDQ.SDQ16	All spaces in field SDQ16 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ16 from SDQ where SDQ16 is null
SdqSDQ17Spaces	Invalid	High	Yes	All spaces in field SDQ17 (Number)	SDQ.SDQ17	All spaces in field SDQ17 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ17 from SDQ where SDQ17 is null
SdqSDQ18Spaces	Invalid	High	Yes	All spaces in field SDQ18 (Number)	SDQ.SDQ18	All spaces in field SDQ18 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ18 from SDQ where SDQ18 is null
SdqSDQ19Spaces	Invalid	High	Yes	All spaces in field SDQ19 (Number)	SDQ.SDQ19	All spaces in field SDQ19 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ19 from SDQ where SDQ19 is null
SdqSDQ20Spaces	Invalid	High	Yes	All spaces in field SDQ20 (Number)	SDQ.SDQ20	All spaces in field SDQ20 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ20 from SDQ where SDQ20 is null
SdqSDQ21Spaces	Invalid	High	Yes	All spaces in field SDQ21 (Number)	SDQ.SDQ21	All spaces in field SDQ21 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ21 from SDQ where SDQ21 is null
SdqSDQ22Spaces	Invalid	High	Yes	All spaces in field SDQ22 (Number)	SDQ.SDQ22	All spaces in field SDQ22 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ22 from SDQ where SDQ22 is null
SdqSDQ23Spaces	Invalid	High	Yes	All spaces in field SDQ23 (Number)	SDQ.SDQ23	All spaces in field SDQ23 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ23 from SDQ where SDQ23 is null
SdqSDQ24Spaces	Invalid	High	Yes	All spaces in field SDQ24 (Number)	SDQ.SDQ24	All spaces in field SDQ24 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ24 from SDQ where SDQ24 is null
SdqSDQ25Spaces	Invalid	High	Yes	All spaces in field SDQ25 (Number)	SDQ.SDQ25	All spaces in field SDQ25 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ25 from SDQ where SDQ25 is null
SdqSDQ26Spaces	Invalid	High	Yes	All spaces in field SDQ26 (Number)	SDQ.SDQ26	All spaces in field SDQ26 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ26 from SDQ where SDQ26 is null
SdqSDQ27Spaces	Invalid	High	Yes	All spaces in field SDQ27 (Number)	SDQ.SDQ27	All spaces in field SDQ27 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ27 from SDQ where SDQ27 is null
SdqSDQ28Spaces	Invalid	High	Yes	All spaces in field SDQ28 (Number)	SDQ.SDQ28	All spaces in field SDQ28 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ28 from SDQ where SDQ28 is null
SdqSDQ29Spaces	Invalid	High	Yes	All spaces in field SDQ29 (Number)	SDQ.SDQ29	All spaces in field SDQ29 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ29 from SDQ where SDQ29 is null
SdqSDQ30Spaces	Invalid	High	Yes	All spaces in field SDQ30 (Number)	SDQ.SDQ30	All spaces in field SDQ30 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ30 from SDQ where SDQ30 is null
SdqSDQ31Spaces	Invalid	High	Yes	All spaces in field SDQ31 (Number)	SDQ.SDQ31	All spaces in field SDQ31 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ31 from SDQ where SDQ31 is null
SdqSDQ32Spaces	Invalid	High	Yes	All spaces in field SDQ32 (Number)	SDQ.SDQ32	All spaces in field SDQ32 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ32 from SDQ where SDQ32 is null
SdqSDQ33Spaces	Invalid	High	Yes	All spaces in field SDQ33 (Number)	SDQ.SDQ33	All spaces in field SDQ33 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ33 from SDQ where SDQ33 is null
SdqSDQ34Spaces	Invalid	High	Yes	All spaces in field SDQ34 (Number)	SDQ.SDQ34	All spaces in field SDQ34 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ34 from SDQ where SDQ34 is null
SdqSDQ35Spaces	Invalid	High	Yes	All spaces in field SDQ35 (Number)	SDQ.SDQ35	All spaces in field SDQ35 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ35 from SDQ where SDQ35 is null
SdqSDQ36Spaces	Invalid	High	Yes	All spaces in field SDQ36 (Number)	SDQ.SDQ36	All spaces in field SDQ36 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ36 from SDQ where SDQ36 is null
SdqSDQ37Spaces	Invalid	High	Yes	All spaces in field SDQ37 (Number)	SDQ.SDQ37	All spaces in field SDQ37 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ37 from SDQ where SDQ37 is null
SdqSDQ38Spaces	Invalid	High	Yes	All spaces in field SDQ38 (Number)	SDQ.SDQ38	All spaces in field SDQ38 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ38 from SDQ where SDQ38 is null
SdqSDQ39Spaces	Invalid	High	Yes	All spaces in field SDQ39 (Number)	SDQ.SDQ39	All spaces in field SDQ39 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ39 from SDQ where SDQ39 is null
SdqSDQ40Spaces	Invalid	High	Yes	All spaces in field SDQ40 (Number)	SDQ.SDQ40	All spaces in field SDQ40 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ40 from SDQ where SDQ40 is null
SdqSDQ41Spaces	Invalid	High	Yes	All spaces in field SDQ41 (Number)	SDQ.SDQ41	All spaces in field SDQ41 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ41 from SDQ where SDQ41 is null
SdqSDQ42Spaces	Invalid	High	Yes	All spaces in field SDQ42 (Number)	SDQ.SDQ42	All spaces in field SDQ42 (Number). This field should not be empty (only spaces), one of the codes is required.	select ColId, SDQVer, SDQ42 from SDQ where SDQ42 is null
PocPoCSpaces	Invalid	High	Yes	All spaces in field PoC (Char)	POC.PoC	All spaces in field PoC (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, PoC from POC where PoC is null
MhlsLegalStSpaces	Invalid	High	Yes	All spaces in field LegalSt (Char)	MHLS.LegalSt	All spaces in field LegalSt (Char). This field should not be empty (only spaces), one of the codes is required.	select ColId, LegalSt from MHLS where LegalSt is null
HrGenDtMissing	Missing	High	Yes	Missing data - GenDt $GenDt.q	HR.GenDt	Missing data - Data File Generation Date (GenDt)	select State, GenDt from HR where GenDt is null
RegRegNameMissing	Missing	High	Yes	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	Yes	Missing data - OrgName $OrgName.q	ORG.OrgName	Missing data - Organisation Name (OrgName)	select State, RegId, OrgId, OrgName from ORG where OrgName is null
HospClusHospClusNameMissing	Missing	High	Yes	Missing data - HospClusName $HospClusName.q	HOSPCLUS.HospClusName	Missing data - Hospital - Cluster Name (HospClusName)	select State, RegId, OrgId, HospClusId, HospClusName from HOSPCLUS where HospClusName is null
HospClusCoLocStatusMissing	Missing	High	Yes	Missing data - CoLocStatus $CoLocStatus.q	HOSPCLUS.CoLocStatus	Missing data - Co-Location Status (CoLocStatus)	select State, RegId, OrgId, HospClusId, CoLocStatus from HOSPCLUS where CoLocStatus is null
ServSUNameMissing	Missing	High	Yes	Missing data - SUName $SUName.q	SERV.SUName	Missing data - Service Unit Name (SUName)	select State, RegId, OrgId, HospClusId, SUId, SUName from SERV where SUName is null
ServSectorMissing	Missing	High	Yes	Missing data - Sector $Sector.q	SERV.Sector	Missing data - Service Unit Sector (Sector)	select State, RegId, OrgId, HospClusId, SUId, Sector from SERV where Sector is null
ServTargetPopMissing	Missing	High	Yes	Missing data - TargetPop $TargetPop.q	SERV.TargetPop	Missing data - Target Population (TargetPop)	select State, RegId, OrgId, HospClusId, SUId, TargetPop from SERV where TargetPop is null
ServProgTypeMissing	Missing	High	Yes	Missing data - ProgType $ProgType.q	SERV.ProgType	Missing data - Program Type (ProgType)	select State, RegId, OrgId, HospClusId, SUId, ProgType from SERV where ProgType is null
ServEstAreaMissing	Missing	High	Yes	Missing data - EstArea $EstArea.q	SERV.EstArea	Missing data - Geographical Location of Establishment (EstArea)	select State, RegId, OrgId, HospClusId, SUId, EstArea from SERV where EstArea is null
ServSUTypeMissing	Missing	High	Yes	Missing data - SUType $SUType.q	SERV.SUType	Missing data - Service Unit Type (SUType)	select State, RegId, OrgId, HospClusId, SUId, SUType from SERV where SUType is null
CodAgeGrpMissing	Missing	High	Yes	Missing data - AgeGrp $AgeGrp.q	COD.AgeGrp	Missing data - Age Group (AgeGrp)	select ColId, AgeGrp from COD where AgeGrp is null
HonosHnosVerMissing	Missing	High	Yes	Missing data - HnosVer $HnosVer.q	HONOS.HnosVer	Missing data - HoNOS Version (HnosVer)	select ColId, HnosVer from HONOS where HnosVer is null
Lsp16LspVerMissing	Missing	High	Yes	Missing data - LspVer $LspVer.q	LSP16.LspVer	Missing data - LSP-16 Version (LspVer)	select ColId, LspVer from LSP16 where LspVer is null
RugadlRugAdlVerMissing	Missing	High	Yes	Missing data - RugAdlVer $RugAdlVer.q	RUGADL.RugAdlVer	Missing data - RUGADL Version (RugAdlVer)	select ColId, RugAdlVer from RUGADL where RugAdlVer is null
HonoscaHnosCVerMissing	Missing	High	Yes	Missing data - HnosCVer $HnosCVer.q	HONOSCA.HnosCVer	Missing data - HoNOSCA Version (HnosCVer)	select ColId, HnosCVer from HONOSCA where HnosCVer is null
CgasCgasVerMissing	Missing	High	Yes	Missing data - CgasVer $CgasVer.q	CGAS.CgasVer	Missing data - CGAS Version (CgasVer)	select ColId, CgasVer from CGAS where CgasVer is null
FihsFihsVerMissing	Missing	High	Yes	Missing data - FihsVer $FihsVer.q	FIHS.FihsVer	Missing data - FIHS Version (FihsVer)	select ColId, FihsVer from FIHS where FihsVer is null
Mhi38MHIVerMissing	Missing	High	Yes	Missing data - MHIVer $MHIVer.q	MHI38.MHIVer	Missing data - MHI38 Version (MHIVer)	select ColId, MHIVer from MHI38 where MHIVer is null
Basis32BASISVerMissing	Missing	High	Yes	Missing data - BASISVer $BASISVer.q	BASIS32.BASISVer	Missing data - BASIS32 Version (BASISVer)	select ColId, BASISVer from BASIS32 where BASISVer is null
K10lmK10LMVerMissing	Missing	High	Yes	Missing data - K10LMVer $K10LMVer.q	K10LM.K10LMVer	Missing data - K10+LM Version (K10LMVer)	select ColId, K10LMVer from K10LM where K10LMVer is null
K10l3dK10L3DVerMissing	Missing	High	Yes	Missing data - K10L3DVer $K10L3DVer.q	K10L3D.K10L3DVer	Missing data - K10L3D Version (K10L3DVer)	select ColId, K10L3DVer from K10L3D where K10L3DVer is null
DoBBefore1900	Invalid	High	Yes	Date of Birth ($DoB.dmy) before 1900	COD.DoB	Date of Birth before 1900	select ColId, DoB from COD where extract(year FROM DoB) < 1900
HonosIncomplete	Missing	Low	Yes	HONOS is Incomplete (at least 10 valid required)	HONOS	HONOS is Incomplete - 10 valid items (valid: 0, 1, 2, 3, 4) are required from: Hnos01, Hnos02, Hnos03, Hnos04, Hnos05, Hnos06, Hnos07, Hnos08, Hnos09, Hnos10, Hnos11, Hnos12	select State, RegId, OrgId, ColId, IsCompleted from COD join Honos using (ColId) join HonosCompletion using (ColId) where not IsCompleted
Lsp16Incomplete	Missing	Low	Yes	LSP16 is Incomplete (at least 14 valid required)	LSP16	LSP16 is Incomplete - 14 valid items (valid: 0, 1, 2, 3) are required from: Lsp01, Lsp02, Lsp03, Lsp04, Lsp05, Lsp06, Lsp07, Lsp08, Lsp09, Lsp10, Lsp11, Lsp12, Lsp13, Lsp14, Lsp15, Lsp16	select State, RegId, OrgId, ColId, IsCompleted from COD join Lsp16 using (ColId) join Lsp16Completion using (ColId) where not IsCompleted
RugadlIncomplete	Missing	Low	Yes	RUGADL is Incomplete (at least 4 valid required)	RUGADL	RUGADL is Incomplete - 4 valid items (valid: 1, 2, 3, 4, 5) are required from: RugAdl1, RugAdl2, RugAdl3, RugAdl4	select State, RegId, OrgId, ColId, IsCompleted from COD join Rugadl using (ColId) join RugadlCompletion using (ColId) where not IsCompleted
HonoscaIncomplete	Missing	Low	Yes	HONOSCA is Incomplete (at least 11 valid required)	HONOSCA	HONOSCA is Incomplete - 11 valid items (valid: 0, 1, 2, 3, 4) are required from: HnosC01, HnosC02, HnosC03, HnosC04, HnosC05, HnosC06, HnosC07, HnosC08, HnosC09, HnosC10, HnosC11, HnosC12, HnosC13	select State, RegId, OrgId, ColId, IsCompleted from COD join Honosca using (ColId) join HonoscaCompletion using (ColId) where not IsCompleted
CgasIncomplete	Missing	Low	Yes	CGAS is Incomplete (at least 1 valid required)	CGAS	CGAS is Incomplete - 1 valid items (valid: 1-100) are required from: Cgas	select State, RegId, OrgId, ColId, IsCompleted from COD join Cgas using (ColId) join CgasCompletion using (ColId) where not IsCompleted
FihsIncomplete	Missing	Low	Yes	FIHS is Incomplete (at least 6 valid required)	FIHS	FIHS is Incomplete - 6 valid items (valid: 1, 2) are required from: Fihs1, Fihs2, Fihs3, Fihs4, Fihs5, Fihs6, Fihs7	select State, RegId, OrgId, ColId, IsCompleted from COD join Fihs using (ColId) join FihsCompletion using (ColId) where not IsCompleted
Mhi38Incomplete	Missing	Low	Yes	MHI38 is Incomplete (at least 30 valid required)	MHI38	MHI38 is Incomplete - 30 valid items (valid: 1, 2, 3, 4, 5, 6) are required from: MHI01, MHI02, MHI03, MHI04, MHI05, MHI06, MHI07, MHI08, MHI09, MHI10, MHI11, MHI12, MHI13, MHI14, MHI15, MHI16, MHI17, MHI18, MHI19, MHI20, MHI21, MHI22, MHI23, MHI24, MHI25, MHI26, MHI27, MHI28, MHI29, MHI30, MHI31, MHI32, MHI33, MHI34, MHI35, MHI36, MHI37, MHI38	select State, RegId, OrgId, ColId, IsCompleted from COD join Mhi38 using (ColId) join Mhi38Completion using (ColId) where not IsCompleted
Basis32Incomplete	Missing	Low	Yes	BASIS32 is Incomplete (at least 27 valid required)	BASIS32	BASIS32 is Incomplete - 27 valid items (valid: 0, 1, 2, 3, 4) are required from: BASIS01, BASIS02, BASIS03, BASIS04, BASIS05, BASIS06, BASIS07, BASIS08, BASIS09, BASIS10, BASIS11, BASIS12, BASIS13, BASIS14, BASIS15, BASIS16, BASIS17, BASIS18, BASIS19, BASIS20, BASIS21, BASIS22, BASIS23, BASIS24, BASIS25, BASIS26, BASIS27, BASIS28, BASIS29, BASIS30, BASIS31, BASIS32	select State, RegId, OrgId, ColId, IsCompleted from COD join Basis32 using (ColId) join Basis32Completion using (ColId) where not IsCompleted
K10lmIncomplete	Missing	Low	Yes	K10LM is Incomplete (at least 9 valid required)	K10LM	K10LM is Incomplete - 9 valid items (valid: 1, 2, 3, 4, 5) are required from: K10LM01, K10LM02, K10LM03, K10LM04, K10LM05, K10LM06, K10LM07, K10LM08, K10LM09, K10LM10	select State, RegId, OrgId, ColId, IsCompleted from COD join K10lm using (ColId) join K10lmCompletion using (ColId) where not IsCompleted
K10l3dIncomplete	Missing	Low	Yes	K10L3D is Incomplete (at least 9 valid required)	K10L3D	K10L3D is Incomplete - 9 valid items (valid: 1, 2, 3, 4, 5) are required from: K10L3D01, K10L3D02, K10L3D03, K10L3D04, K10L3D05, K10L3D06, K10L3D07, K10L3D08, K10L3D09, K10L3D10	select State, RegId, OrgId, ColId, IsCompleted from COD join K10l3d using (ColId) join K10l3dCompletion using (ColId) where not IsCompleted
SdqIncomplete	Missing	Low	Yes	SDQ is Incomplete (at least 3/5 for each of 5 subscales valid required)	SDQ	SDQ is Incomplete - 3/5 for each of 5 subscales valid items (valid: 0, 1, 2) are required from: Subscale 1 (SDQ03, SDQ08, SDQ13, SDQ16, SDQ24) Subscale 2 (SDQ05, SDQ07, SDQ12, SDQ18, SDQ22) Subscale 3 (SDQ02, SDQ10, SDQ15, SDQ21, SDQ25) Subscale 4 (SDQ06, SDQ11, SDQ14, SDQ19, SDQ23)	select State, RegId, OrgId, ColId, SDQVer, IsCompleted from COD join Sdq using (ColId) join SdqCompletion using (ColId, SDQVer) where not IsCompleted
DiagIncomplete	Missing	Low	Yes	DIAG is Incomplete	DIAG	DIAG is Incomplete	select State, RegId, OrgId, ColId, IsCompleted from COD join Diag using (ColId) join DiagCompletion using (ColId) where not IsCompleted
PocIncomplete	Missing	Low	Yes	POC is Incomplete	POC	POC is Incomplete	select State, RegId, OrgId, ColId, IsCompleted from COD join Poc using (ColId) join PocCompletion using (ColId) where not IsCompleted
MhlsIncomplete	Missing	Low	Yes	MHLS is Incomplete	MHLS	MHLS is Incomplete	select State, RegId, OrgId, ColId, IsCompleted from COD join Mhls using (ColId) join MhlsCompletion using (ColId) where not IsCompleted
RegOpened	Historical	High	Yes	Reg opened, $RegName.qt (RegId: $RegId) not in historical data	REG	Region Opened - A matching Region was not found in the historical data	select State, RegId, REG.RegName from main.REG left join hist.REG as hist_entity using (State, RegId) where hist_entity.RegId is null
RegClosed	Historical	High	Yes	Reg closed, historical $hist_name.qt (RegId: $hist_RegId) no longer exists	HR	Region Closed - A historical Region was not found in current data	select State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.RegName as hist_name from hist.REG as hist_entity left join main.REG using (State, RegId) where REG.RegId is null
RegRenamed	Historical	High	Yes	Reg renamed from $hist_name.qt to $RegName.qt	REG.RegName	Region Renamed - Region Name differs between historical and current data	select State, RegId, REG.RegName, hist_entity.RegName as hist_name from REG join hist.REG as hist_entity using(State, RegId) where not sloppy_match(REG.RegName, hist_entity.RegName)
OrgOpened	Historical	High	Yes	Org opened, $OrgName.qt (OrgId: $OrgId) not in historical data	ORG	Organisation Opened - A matching Organisation was not found in the historical data	select State, RegId, OrgId, ORG.OrgName from main.ORG left join hist.ORG as hist_entity using (State, RegId, OrgId) where hist_entity.OrgId is null
OrgClosed	Historical	High	Yes	Org closed, historical $hist_name.qt (OrgId: $hist_OrgId) no longer exists	HR	Organisation Closed - A historical Organisation was not found in current data	select State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.OrgName as hist_name from hist.ORG as hist_entity left join main.ORG using (State, RegId, OrgId) where ORG.OrgId is null
OrgRenamed	Historical	High	Yes	Org renamed from $hist_name.qt to $OrgName.qt	ORG.OrgName	Organisation Renamed - Organisation Name differs between historical and current data	select State, RegId, OrgId, ORG.OrgName, hist_entity.OrgName as hist_name from ORG join hist.ORG as hist_entity using(State, RegId, OrgId) where not sloppy_match(ORG.OrgName, hist_entity.OrgName)
HospClusOpened	Historical	High	Yes	HospClus opened, $HospClusName.qt (HospClusId: $HospClusId) not in historical data	HOSPCLUS	Hospital / Cluster Opened - A matching Hospital / Cluster was not found in the historical data	select State, RegId, OrgId, HospClusId, HOSPCLUS.HospClusName from main.HOSPCLUS left join hist.HOSPCLUS as hist_entity using (State, RegId, OrgId, HospClusId) where hist_entity.HospClusId is null
HospClusClosed	Historical	High	Yes	HospClus closed, historical $hist_name.qt (HospClusId: $hist_HospClusId) no longer exists	HR	Hospital / Cluster Closed - A historical Hospital / Cluster was not found in current data	select State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.HospClusId as hist_HospClusId, hist_entity.HospClusName as hist_name from hist.HOSPCLUS as hist_entity left join main.HOSPCLUS using (State, RegId, OrgId, HospClusId) where HOSPCLUS.HospClusId is null
HospClusRenamed	Historical	High	Yes	HospClus renamed from $hist_name.qt to $HospClusName.qt	HOSPCLUS.HospClusName	Hospital / Cluster Renamed - Hospital / Cluster Name differs between historical and current data	select State, RegId, OrgId, HospClusId, HOSPCLUS.HospClusName, hist_entity.HospClusName as hist_name from HOSPCLUS join hist.HOSPCLUS as hist_entity using(State, RegId, OrgId, HospClusId) where not sloppy_match(HOSPCLUS.HospClusName, hist_entity.HospClusName)
ServOpened	Historical	High	Yes	Serv opened, $SUName.qt (SUId: $SUId) not in historical data	SERV	Service Unit Opened - A matching Service Unit was not found in the historical data	select State, RegId, OrgId, HospClusId, SUId, SERV.SUName from main.SERV left join hist.SERV as hist_entity using (State, RegId, OrgId, HospClusId, SUId) where hist_entity.SUId is null
ServClosed	Historical	High	Yes	Serv closed, historical $hist_name.qt (SUId: $hist_SUId) no longer exists	HR	Service Unit Closed - A historical Service Unit was not found in current data	select State, hist_entity.State as hist_State, hist_entity.RegId as hist_RegId, hist_entity.OrgId as hist_OrgId, hist_entity.HospClusId as hist_HospClusId, hist_entity.SUId as hist_SUId, hist_entity.SUName as hist_name from hist.SERV as hist_entity left join main.SERV using (State, RegId, OrgId, HospClusId, SUId) where SERV.SUId is null
ServRenamed	Historical	High	Yes	Serv renamed from $hist_name.qt to $SUName.qt	SERV.SUName	Service Unit Renamed - Service Unit Name differs between historical and current data	select State, RegId, OrgId, HospClusId, SUId, SERV.SUName, hist_entity.SUName as hist_name from SERV join hist.SERV as hist_entity using(State, RegId, OrgId, HospClusId, SUId) where not sloppy_match(SERV.SUName, hist_entity.SUName)
HospClusCoLocStatusChanged	Historical	High	No	Hospital / Cluster CoLocStatus changed from $hist_CoLocStatus to $CoLocStatus	HOSPCLUS.CoLocStatus	Co-Location Status Changed - Co-Location Status value for Hospital / Cluster differs between historical and current data	select State, RegId, OrgId, HospClusId, HOSPCLUS.CoLocStatus, hist_HOSPCLUS.CoLocStatus as hist_CoLocStatus from HOSPCLUS join hist.HOSPCLUS as hist_HOSPCLUS using(State, RegId, OrgId, HospClusId) where HOSPCLUS.CoLocStatus != hist_HOSPCLUS.CoLocStatus
ServSectorChanged	Historical	High	No	Service Unit Sector changed from $hist_Sector to $Sector	SERV.Sector	Service Unit Sector Changed - Service Unit Sector value for Service Unit differs between historical and current data	select State, RegId, OrgId, HospClusId, SUId, SERV.Sector, hist_SERV.Sector as hist_Sector from SERV join hist.SERV as hist_SERV using(State, RegId, OrgId, HospClusId, SUId) where SERV.Sector != hist_SERV.Sector
ServTargetPopChanged	Historical	High	No	Service Unit TargetPop changed from $hist_TargetPop to $TargetPop	SERV.TargetPop	Target Population Changed - Target Population value for Service Unit differs between historical and current data	select State, RegId, OrgId, HospClusId, SUId, SERV.TargetPop, hist_SERV.TargetPop as hist_TargetPop from SERV join hist.SERV as hist_SERV using(State, RegId, OrgId, HospClusId, SUId) where SERV.TargetPop != hist_SERV.TargetPop
ServProgTypeChanged	Historical	High	No	Service Unit ProgType changed from $hist_ProgType to $ProgType	SERV.ProgType	Program Type Changed - Program Type value for Service Unit differs between historical and current data	select State, RegId, OrgId, HospClusId, SUId, SERV.ProgType, hist_SERV.ProgType as hist_ProgType from SERV join hist.SERV as hist_SERV using(State, RegId, OrgId, HospClusId, SUId) where SERV.ProgType != hist_SERV.ProgType
ServSUTypeChanged	Historical	High	No	Service Unit SUType changed from $hist_SUType to $SUType	SERV.SUType	Service Unit Type Changed - Service Unit Type value for Service Unit differs between historical and current data	select State, RegId, OrgId, HospClusId, SUId, SERV.SUType, hist_SERV.SUType as hist_SUType from SERV join hist.SERV as hist_SERV using(State, RegId, OrgId, HospClusId, SUId) where SERV.SUType != hist_SERV.SUType
HrChildAiHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildAiHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Inpatient setting after Admission	select State from HrChildAiHonoscaCompleted join HrChildAiCodCount using (State) where HrChildAiHonoscaCompleted.Total = 0 and HrChildAiCodCount.Total > 0
HrChildAiHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildAiHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildAiHonoscaCountGrowth where Growth < -0.1
HrChildAiHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildAiHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrChildAiHonoscaCompletionRateChange where Change < -0.05
HrChildAiCgasZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildAiCgasCompletionRate	HR	Zero completion rate for HR-level count of CGAS for Child age group in Inpatient setting after Admission	select State from HrChildAiCgasCompleted join HrChildAiCodCount using (State) where HrChildAiCgasCompleted.Total = 0 and HrChildAiCodCount.Total > 0
HrChildAiCgasVolumeDecrease	Historical	High	No	Decrease in HrChildAiCgasCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of CGAS for Child age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildAiCgasCountGrowth where Growth < -0.1
HrChildAiCgasCompletionRateDecrease	Historical	High	No	Decrease in HrChildAiCgasCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of CGAS for Child age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrChildAiCgasCompletionRateChange where Change < -0.05
HrChildAiSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildAiSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Inpatient setting after Admission	select State from HrChildAiSdqCompleted join HrChildAiCodCount using (State) where HrChildAiSdqCompleted.Total = 0 and HrChildAiCodCount.Total > 0
HrChildAiSdqVolumeDecrease	Historical	High	No	Decrease in HrChildAiSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildAiSdqCountGrowth where Growth < -0.1
HrChildAiSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildAiSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrChildAiSdqCompletionRateChange where Change < -0.05
HrChildRiHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRiHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Inpatient setting after Review	select State from HrChildRiHonoscaCompleted join HrChildRiCodCount using (State) where HrChildRiHonoscaCompleted.Total = 0 and HrChildRiCodCount.Total > 0
HrChildRiHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildRiHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRiHonoscaCountGrowth where Growth < -0.1
HrChildRiHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildRiHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrChildRiHonoscaCompletionRateChange where Change < -0.05
HrChildRiCgasZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRiCgasCompletionRate	HR	Zero completion rate for HR-level count of CGAS for Child age group in Inpatient setting after Review	select State from HrChildRiCgasCompleted join HrChildRiCodCount using (State) where HrChildRiCgasCompleted.Total = 0 and HrChildRiCodCount.Total > 0
HrChildRiCgasVolumeDecrease	Historical	High	No	Decrease in HrChildRiCgasCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of CGAS for Child age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRiCgasCountGrowth where Growth < -0.1
HrChildRiCgasCompletionRateDecrease	Historical	High	No	Decrease in HrChildRiCgasCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of CGAS for Child age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrChildRiCgasCompletionRateChange where Change < -0.05
HrChildRiFihsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRiFihsCompletionRate	HR	Zero completion rate for HR-level count of FIHS for Child age group in Inpatient setting after Review	select State from HrChildRiFihsCompleted join HrChildRiCodCount using (State) where HrChildRiFihsCompleted.Total = 0 and HrChildRiCodCount.Total > 0
HrChildRiFihsVolumeDecrease	Historical	High	No	Decrease in HrChildRiFihsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of FIHS for Child age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRiFihsCountGrowth where Growth < -0.1
HrChildRiFihsCompletionRateDecrease	Historical	High	No	Decrease in HrChildRiFihsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of FIHS for Child age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrChildRiFihsCompletionRateChange where Change < -0.05
HrChildRiSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRiSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Inpatient setting after Review	select State from HrChildRiSdqCompleted join HrChildRiCodCount using (State) where HrChildRiSdqCompleted.Total = 0 and HrChildRiCodCount.Total > 0
HrChildRiSdqVolumeDecrease	Historical	High	No	Decrease in HrChildRiSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRiSdqCountGrowth where Growth < -0.1
HrChildRiSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildRiSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrChildRiSdqCompletionRateChange where Change < -0.05
HrChildRiDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRiDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Child age group in Inpatient setting after Review	select State from HrChildRiDiagCompleted join HrChildRiCodCount using (State) where HrChildRiDiagCompleted.Total = 0 and HrChildRiCodCount.Total > 0
HrChildRiDiagVolumeDecrease	Historical	High	No	Decrease in HrChildRiDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Child age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRiDiagCountGrowth where Growth < -0.1
HrChildRiDiagCompletionRateDecrease	Historical	High	No	Decrease in HrChildRiDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Child age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrChildRiDiagCompletionRateChange where Change < -0.05
HrChildRiMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRiMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Child age group in Inpatient setting after Review	select State from HrChildRiMhlsCompleted join HrChildRiCodCount using (State) where HrChildRiMhlsCompleted.Total = 0 and HrChildRiCodCount.Total > 0
HrChildRiMhlsVolumeDecrease	Historical	High	No	Decrease in HrChildRiMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Child age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRiMhlsCountGrowth where Growth < -0.1
HrChildRiMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrChildRiMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Child age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrChildRiMhlsCompletionRateChange where Change < -0.05
HrChildDiHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDiHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Inpatient setting after Discharge	select State from HrChildDiHonoscaCompleted join HrChildDiCodCount using (State) where HrChildDiHonoscaCompleted.Total = 0 and HrChildDiCodCount.Total > 0
HrChildDiHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildDiHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDiHonoscaCountGrowth where Growth < -0.1
HrChildDiHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildDiHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDiHonoscaCompletionRateChange where Change < -0.05
HrChildDiFihsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDiFihsCompletionRate	HR	Zero completion rate for HR-level count of FIHS for Child age group in Inpatient setting after Discharge	select State from HrChildDiFihsCompleted join HrChildDiCodCount using (State) where HrChildDiFihsCompleted.Total = 0 and HrChildDiCodCount.Total > 0
HrChildDiFihsVolumeDecrease	Historical	High	No	Decrease in HrChildDiFihsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of FIHS for Child age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDiFihsCountGrowth where Growth < -0.1
HrChildDiFihsCompletionRateDecrease	Historical	High	No	Decrease in HrChildDiFihsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of FIHS for Child age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDiFihsCompletionRateChange where Change < -0.05
HrChildDiSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDiSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Inpatient setting after Discharge	select State from HrChildDiSdqCompleted join HrChildDiCodCount using (State) where HrChildDiSdqCompleted.Total = 0 and HrChildDiCodCount.Total > 0
HrChildDiSdqVolumeDecrease	Historical	High	No	Decrease in HrChildDiSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDiSdqCountGrowth where Growth < -0.1
HrChildDiSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildDiSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDiSdqCompletionRateChange where Change < -0.05
HrChildDiDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDiDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Child age group in Inpatient setting after Discharge	select State from HrChildDiDiagCompleted join HrChildDiCodCount using (State) where HrChildDiDiagCompleted.Total = 0 and HrChildDiCodCount.Total > 0
HrChildDiDiagVolumeDecrease	Historical	High	No	Decrease in HrChildDiDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Child age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDiDiagCountGrowth where Growth < -0.1
HrChildDiDiagCompletionRateDecrease	Historical	High	No	Decrease in HrChildDiDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Child age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDiDiagCompletionRateChange where Change < -0.05
HrChildDiMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDiMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Child age group in Inpatient setting after Discharge	select State from HrChildDiMhlsCompleted join HrChildDiCodCount using (State) where HrChildDiMhlsCompleted.Total = 0 and HrChildDiCodCount.Total > 0
HrChildDiMhlsVolumeDecrease	Historical	High	No	Decrease in HrChildDiMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Child age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDiMhlsCountGrowth where Growth < -0.1
HrChildDiMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrChildDiMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Child age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDiMhlsCompletionRateChange where Change < -0.05
HrChildArHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildArHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Residential setting after Admission	select State from HrChildArHonoscaCompleted join HrChildArCodCount using (State) where HrChildArHonoscaCompleted.Total = 0 and HrChildArCodCount.Total > 0
HrChildArHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildArHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildArHonoscaCountGrowth where Growth < -0.1
HrChildArHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildArHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrChildArHonoscaCompletionRateChange where Change < -0.05
HrChildArCgasZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildArCgasCompletionRate	HR	Zero completion rate for HR-level count of CGAS for Child age group in Residential setting after Admission	select State from HrChildArCgasCompleted join HrChildArCodCount using (State) where HrChildArCgasCompleted.Total = 0 and HrChildArCodCount.Total > 0
HrChildArCgasVolumeDecrease	Historical	High	No	Decrease in HrChildArCgasCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of CGAS for Child age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildArCgasCountGrowth where Growth < -0.1
HrChildArCgasCompletionRateDecrease	Historical	High	No	Decrease in HrChildArCgasCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of CGAS for Child age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrChildArCgasCompletionRateChange where Change < -0.05
HrChildArSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildArSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Residential setting after Admission	select State from HrChildArSdqCompleted join HrChildArCodCount using (State) where HrChildArSdqCompleted.Total = 0 and HrChildArCodCount.Total > 0
HrChildArSdqVolumeDecrease	Historical	High	No	Decrease in HrChildArSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildArSdqCountGrowth where Growth < -0.1
HrChildArSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildArSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrChildArSdqCompletionRateChange where Change < -0.05
HrChildRrHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRrHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Residential setting after Review	select State from HrChildRrHonoscaCompleted join HrChildRrCodCount using (State) where HrChildRrHonoscaCompleted.Total = 0 and HrChildRrCodCount.Total > 0
HrChildRrHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildRrHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRrHonoscaCountGrowth where Growth < -0.1
HrChildRrHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildRrHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrChildRrHonoscaCompletionRateChange where Change < -0.05
HrChildRrCgasZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRrCgasCompletionRate	HR	Zero completion rate for HR-level count of CGAS for Child age group in Residential setting after Review	select State from HrChildRrCgasCompleted join HrChildRrCodCount using (State) where HrChildRrCgasCompleted.Total = 0 and HrChildRrCodCount.Total > 0
HrChildRrCgasVolumeDecrease	Historical	High	No	Decrease in HrChildRrCgasCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of CGAS for Child age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRrCgasCountGrowth where Growth < -0.1
HrChildRrCgasCompletionRateDecrease	Historical	High	No	Decrease in HrChildRrCgasCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of CGAS for Child age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrChildRrCgasCompletionRateChange where Change < -0.05
HrChildRrFihsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRrFihsCompletionRate	HR	Zero completion rate for HR-level count of FIHS for Child age group in Residential setting after Review	select State from HrChildRrFihsCompleted join HrChildRrCodCount using (State) where HrChildRrFihsCompleted.Total = 0 and HrChildRrCodCount.Total > 0
HrChildRrFihsVolumeDecrease	Historical	High	No	Decrease in HrChildRrFihsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of FIHS for Child age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRrFihsCountGrowth where Growth < -0.1
HrChildRrFihsCompletionRateDecrease	Historical	High	No	Decrease in HrChildRrFihsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of FIHS for Child age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrChildRrFihsCompletionRateChange where Change < -0.05
HrChildRrSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRrSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Residential setting after Review	select State from HrChildRrSdqCompleted join HrChildRrCodCount using (State) where HrChildRrSdqCompleted.Total = 0 and HrChildRrCodCount.Total > 0
HrChildRrSdqVolumeDecrease	Historical	High	No	Decrease in HrChildRrSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRrSdqCountGrowth where Growth < -0.1
HrChildRrSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildRrSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrChildRrSdqCompletionRateChange where Change < -0.05
HrChildRrDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRrDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Child age group in Residential setting after Review	select State from HrChildRrDiagCompleted join HrChildRrCodCount using (State) where HrChildRrDiagCompleted.Total = 0 and HrChildRrCodCount.Total > 0
HrChildRrDiagVolumeDecrease	Historical	High	No	Decrease in HrChildRrDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Child age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRrDiagCountGrowth where Growth < -0.1
HrChildRrDiagCompletionRateDecrease	Historical	High	No	Decrease in HrChildRrDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Child age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrChildRrDiagCompletionRateChange where Change < -0.05
HrChildRrMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRrMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Child age group in Residential setting after Review	select State from HrChildRrMhlsCompleted join HrChildRrCodCount using (State) where HrChildRrMhlsCompleted.Total = 0 and HrChildRrCodCount.Total > 0
HrChildRrMhlsVolumeDecrease	Historical	High	No	Decrease in HrChildRrMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Child age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRrMhlsCountGrowth where Growth < -0.1
HrChildRrMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrChildRrMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Child age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrChildRrMhlsCompletionRateChange where Change < -0.05
HrChildDrHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDrHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Residential setting after Discharge	select State from HrChildDrHonoscaCompleted join HrChildDrCodCount using (State) where HrChildDrHonoscaCompleted.Total = 0 and HrChildDrCodCount.Total > 0
HrChildDrHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildDrHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDrHonoscaCountGrowth where Growth < -0.1
HrChildDrHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildDrHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDrHonoscaCompletionRateChange where Change < -0.05
HrChildDrFihsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDrFihsCompletionRate	HR	Zero completion rate for HR-level count of FIHS for Child age group in Residential setting after Discharge	select State from HrChildDrFihsCompleted join HrChildDrCodCount using (State) where HrChildDrFihsCompleted.Total = 0 and HrChildDrCodCount.Total > 0
HrChildDrFihsVolumeDecrease	Historical	High	No	Decrease in HrChildDrFihsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of FIHS for Child age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDrFihsCountGrowth where Growth < -0.1
HrChildDrFihsCompletionRateDecrease	Historical	High	No	Decrease in HrChildDrFihsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of FIHS for Child age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDrFihsCompletionRateChange where Change < -0.05
HrChildDrSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDrSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Residential setting after Discharge	select State from HrChildDrSdqCompleted join HrChildDrCodCount using (State) where HrChildDrSdqCompleted.Total = 0 and HrChildDrCodCount.Total > 0
HrChildDrSdqVolumeDecrease	Historical	High	No	Decrease in HrChildDrSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDrSdqCountGrowth where Growth < -0.1
HrChildDrSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildDrSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDrSdqCompletionRateChange where Change < -0.05
HrChildDrDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDrDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Child age group in Residential setting after Discharge	select State from HrChildDrDiagCompleted join HrChildDrCodCount using (State) where HrChildDrDiagCompleted.Total = 0 and HrChildDrCodCount.Total > 0
HrChildDrDiagVolumeDecrease	Historical	High	No	Decrease in HrChildDrDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Child age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDrDiagCountGrowth where Growth < -0.1
HrChildDrDiagCompletionRateDecrease	Historical	High	No	Decrease in HrChildDrDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Child age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDrDiagCompletionRateChange where Change < -0.05
HrChildDrMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDrMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Child age group in Residential setting after Discharge	select State from HrChildDrMhlsCompleted join HrChildDrCodCount using (State) where HrChildDrMhlsCompleted.Total = 0 and HrChildDrCodCount.Total > 0
HrChildDrMhlsVolumeDecrease	Historical	High	No	Decrease in HrChildDrMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Child age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDrMhlsCountGrowth where Growth < -0.1
HrChildDrMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrChildDrMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Child age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDrMhlsCompletionRateChange where Change < -0.05
HrChildAaHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildAaHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Ambulatory setting after Admission	select State from HrChildAaHonoscaCompleted join HrChildAaCodCount using (State) where HrChildAaHonoscaCompleted.Total = 0 and HrChildAaCodCount.Total > 0
HrChildAaHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildAaHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildAaHonoscaCountGrowth where Growth < -0.1
HrChildAaHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildAaHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrChildAaHonoscaCompletionRateChange where Change < -0.05
HrChildAaCgasZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildAaCgasCompletionRate	HR	Zero completion rate for HR-level count of CGAS for Child age group in Ambulatory setting after Admission	select State from HrChildAaCgasCompleted join HrChildAaCodCount using (State) where HrChildAaCgasCompleted.Total = 0 and HrChildAaCodCount.Total > 0
HrChildAaCgasVolumeDecrease	Historical	High	No	Decrease in HrChildAaCgasCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of CGAS for Child age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildAaCgasCountGrowth where Growth < -0.1
HrChildAaCgasCompletionRateDecrease	Historical	High	No	Decrease in HrChildAaCgasCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of CGAS for Child age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrChildAaCgasCompletionRateChange where Change < -0.05
HrChildAaSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildAaSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Ambulatory setting after Admission	select State from HrChildAaSdqCompleted join HrChildAaCodCount using (State) where HrChildAaSdqCompleted.Total = 0 and HrChildAaCodCount.Total > 0
HrChildAaSdqVolumeDecrease	Historical	High	No	Decrease in HrChildAaSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrChildAaSdqCountGrowth where Growth < -0.1
HrChildAaSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildAaSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrChildAaSdqCompletionRateChange where Change < -0.05
HrChildRaHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRaHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Ambulatory setting after Review	select State from HrChildRaHonoscaCompleted join HrChildRaCodCount using (State) where HrChildRaHonoscaCompleted.Total = 0 and HrChildRaCodCount.Total > 0
HrChildRaHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildRaHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRaHonoscaCountGrowth where Growth < -0.1
HrChildRaHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildRaHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrChildRaHonoscaCompletionRateChange where Change < -0.05
HrChildRaCgasZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRaCgasCompletionRate	HR	Zero completion rate for HR-level count of CGAS for Child age group in Ambulatory setting after Review	select State from HrChildRaCgasCompleted join HrChildRaCodCount using (State) where HrChildRaCgasCompleted.Total = 0 and HrChildRaCodCount.Total > 0
HrChildRaCgasVolumeDecrease	Historical	High	No	Decrease in HrChildRaCgasCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of CGAS for Child age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRaCgasCountGrowth where Growth < -0.1
HrChildRaCgasCompletionRateDecrease	Historical	High	No	Decrease in HrChildRaCgasCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of CGAS for Child age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrChildRaCgasCompletionRateChange where Change < -0.05
HrChildRaFihsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRaFihsCompletionRate	HR	Zero completion rate for HR-level count of FIHS for Child age group in Ambulatory setting after Review	select State from HrChildRaFihsCompleted join HrChildRaCodCount using (State) where HrChildRaFihsCompleted.Total = 0 and HrChildRaCodCount.Total > 0
HrChildRaFihsVolumeDecrease	Historical	High	No	Decrease in HrChildRaFihsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of FIHS for Child age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRaFihsCountGrowth where Growth < -0.1
HrChildRaFihsCompletionRateDecrease	Historical	High	No	Decrease in HrChildRaFihsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of FIHS for Child age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrChildRaFihsCompletionRateChange where Change < -0.05
HrChildRaSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRaSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Ambulatory setting after Review	select State from HrChildRaSdqCompleted join HrChildRaCodCount using (State) where HrChildRaSdqCompleted.Total = 0 and HrChildRaCodCount.Total > 0
HrChildRaSdqVolumeDecrease	Historical	High	No	Decrease in HrChildRaSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRaSdqCountGrowth where Growth < -0.1
HrChildRaSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildRaSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrChildRaSdqCompletionRateChange where Change < -0.05
HrChildRaDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRaDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Child age group in Ambulatory setting after Review	select State from HrChildRaDiagCompleted join HrChildRaCodCount using (State) where HrChildRaDiagCompleted.Total = 0 and HrChildRaCodCount.Total > 0
HrChildRaDiagVolumeDecrease	Historical	High	No	Decrease in HrChildRaDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Child age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRaDiagCountGrowth where Growth < -0.1
HrChildRaDiagCompletionRateDecrease	Historical	High	No	Decrease in HrChildRaDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Child age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrChildRaDiagCompletionRateChange where Change < -0.05
HrChildRaMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildRaMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Child age group in Ambulatory setting after Review	select State from HrChildRaMhlsCompleted join HrChildRaCodCount using (State) where HrChildRaMhlsCompleted.Total = 0 and HrChildRaCodCount.Total > 0
HrChildRaMhlsVolumeDecrease	Historical	High	No	Decrease in HrChildRaMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Child age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrChildRaMhlsCountGrowth where Growth < -0.1
HrChildRaMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrChildRaMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Child age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrChildRaMhlsCompletionRateChange where Change < -0.05
HrChildDaHonoscaZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDaHonoscaCompletionRate	HR	Zero completion rate for HR-level count of HONOSCA for Child age group in Ambulatory setting after Discharge	select State from HrChildDaHonoscaCompleted join HrChildDaCodCount using (State) where HrChildDaHonoscaCompleted.Total = 0 and HrChildDaCodCount.Total > 0
HrChildDaHonoscaVolumeDecrease	Historical	High	No	Decrease in HrChildDaHonoscaCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOSCA for Child age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDaHonoscaCountGrowth where Growth < -0.1
HrChildDaHonoscaCompletionRateDecrease	Historical	High	No	Decrease in HrChildDaHonoscaCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOSCA for Child age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDaHonoscaCompletionRateChange where Change < -0.05
HrChildDaFihsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDaFihsCompletionRate	HR	Zero completion rate for HR-level count of FIHS for Child age group in Ambulatory setting after Discharge	select State from HrChildDaFihsCompleted join HrChildDaCodCount using (State) where HrChildDaFihsCompleted.Total = 0 and HrChildDaCodCount.Total > 0
HrChildDaFihsVolumeDecrease	Historical	High	No	Decrease in HrChildDaFihsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of FIHS for Child age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDaFihsCountGrowth where Growth < -0.1
HrChildDaFihsCompletionRateDecrease	Historical	High	No	Decrease in HrChildDaFihsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of FIHS for Child age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDaFihsCompletionRateChange where Change < -0.05
HrChildDaSdqZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDaSdqCompletionRate	HR	Zero completion rate for HR-level count of SDQ for Child age group in Ambulatory setting after Discharge	select State from HrChildDaSdqCompleted join HrChildDaCodCount using (State) where HrChildDaSdqCompleted.Total = 0 and HrChildDaCodCount.Total > 0
HrChildDaSdqVolumeDecrease	Historical	High	No	Decrease in HrChildDaSdqCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of SDQ for Child age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDaSdqCountGrowth where Growth < -0.1
HrChildDaSdqCompletionRateDecrease	Historical	High	No	Decrease in HrChildDaSdqCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of SDQ for Child age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDaSdqCompletionRateChange where Change < -0.05
HrChildDaDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDaDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Child age group in Ambulatory setting after Discharge	select State from HrChildDaDiagCompleted join HrChildDaCodCount using (State) where HrChildDaDiagCompleted.Total = 0 and HrChildDaCodCount.Total > 0
HrChildDaDiagVolumeDecrease	Historical	High	No	Decrease in HrChildDaDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Child age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDaDiagCountGrowth where Growth < -0.1
HrChildDaDiagCompletionRateDecrease	Historical	High	No	Decrease in HrChildDaDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Child age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDaDiagCompletionRateChange where Change < -0.05
HrChildDaMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrChildDaMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Child age group in Ambulatory setting after Discharge	select State from HrChildDaMhlsCompleted join HrChildDaCodCount using (State) where HrChildDaMhlsCompleted.Total = 0 and HrChildDaCodCount.Total > 0
HrChildDaMhlsVolumeDecrease	Historical	High	No	Decrease in HrChildDaMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Child age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrChildDaMhlsCountGrowth where Growth < -0.1
HrChildDaMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrChildDaMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Child age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrChildDaMhlsCompletionRateChange where Change < -0.05
HrAdultAiHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultAiHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Inpatient setting after Admission	select State from HrAdultAiHonosCompleted join HrAdultAiCodCount using (State) where HrAdultAiHonosCompleted.Total = 0 and HrAdultAiCodCount.Total > 0
HrAdultAiHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultAiHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAiHonosCountGrowth where Growth < -0.1
HrAdultAiHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultAiHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAiHonosCompletionRateChange where Change < -0.05
HrAdultAiPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultAiPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Adult age group in Inpatient setting after Admission	select State from HrAdultAiPocCompleted join HrAdultAiCodCount using (State) where HrAdultAiPocCompleted.Total = 0 and HrAdultAiCodCount.Total > 0
HrAdultAiPocVolumeDecrease	Historical	High	No	Decrease in HrAdultAiPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Adult age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAiPocCountGrowth where Growth < -0.1
HrAdultAiPocCompletionRateDecrease	Historical	High	No	Decrease in HrAdultAiPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Adult age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAiPocCompletionRateChange where Change < -0.05
HrAdultRiHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRiHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Inpatient setting after Review	select State from HrAdultRiHonosCompleted join HrAdultRiCodCount using (State) where HrAdultRiHonosCompleted.Total = 0 and HrAdultRiCodCount.Total > 0
HrAdultRiHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultRiHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRiHonosCountGrowth where Growth < -0.1
HrAdultRiHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRiHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRiHonosCompletionRateChange where Change < -0.05
HrAdultRiDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRiDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Adult age group in Inpatient setting after Review	select State from HrAdultRiDiagCompleted join HrAdultRiCodCount using (State) where HrAdultRiDiagCompleted.Total = 0 and HrAdultRiCodCount.Total > 0
HrAdultRiDiagVolumeDecrease	Historical	High	No	Decrease in HrAdultRiDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Adult age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRiDiagCountGrowth where Growth < -0.1
HrAdultRiDiagCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRiDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Adult age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRiDiagCompletionRateChange where Change < -0.05
HrAdultRiPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRiPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Adult age group in Inpatient setting after Review	select State from HrAdultRiPocCompleted join HrAdultRiCodCount using (State) where HrAdultRiPocCompleted.Total = 0 and HrAdultRiCodCount.Total > 0
HrAdultRiPocVolumeDecrease	Historical	High	No	Decrease in HrAdultRiPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Adult age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRiPocCountGrowth where Growth < -0.1
HrAdultRiPocCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRiPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Adult age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRiPocCompletionRateChange where Change < -0.05
HrAdultRiMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRiMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Adult age group in Inpatient setting after Review	select State from HrAdultRiMhlsCompleted join HrAdultRiCodCount using (State) where HrAdultRiMhlsCompleted.Total = 0 and HrAdultRiCodCount.Total > 0
HrAdultRiMhlsVolumeDecrease	Historical	High	No	Decrease in HrAdultRiMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Adult age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRiMhlsCountGrowth where Growth < -0.1
HrAdultRiMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRiMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Adult age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRiMhlsCompletionRateChange where Change < -0.05
HrAdultDiHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDiHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Inpatient setting after Discharge	select State from HrAdultDiHonosCompleted join HrAdultDiCodCount using (State) where HrAdultDiHonosCompleted.Total = 0 and HrAdultDiCodCount.Total > 0
HrAdultDiHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultDiHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDiHonosCountGrowth where Growth < -0.1
HrAdultDiHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDiHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDiHonosCompletionRateChange where Change < -0.05
HrAdultDiDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDiDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Adult age group in Inpatient setting after Discharge	select State from HrAdultDiDiagCompleted join HrAdultDiCodCount using (State) where HrAdultDiDiagCompleted.Total = 0 and HrAdultDiCodCount.Total > 0
HrAdultDiDiagVolumeDecrease	Historical	High	No	Decrease in HrAdultDiDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Adult age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDiDiagCountGrowth where Growth < -0.1
HrAdultDiDiagCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDiDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Adult age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDiDiagCompletionRateChange where Change < -0.05
HrAdultDiMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDiMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Adult age group in Inpatient setting after Discharge	select State from HrAdultDiMhlsCompleted join HrAdultDiCodCount using (State) where HrAdultDiMhlsCompleted.Total = 0 and HrAdultDiCodCount.Total > 0
HrAdultDiMhlsVolumeDecrease	Historical	High	No	Decrease in HrAdultDiMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Adult age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDiMhlsCountGrowth where Growth < -0.1
HrAdultDiMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDiMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Adult age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDiMhlsCompletionRateChange where Change < -0.05
HrAdultArHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultArHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Residential setting after Admission	select State from HrAdultArHonosCompleted join HrAdultArCodCount using (State) where HrAdultArHonosCompleted.Total = 0 and HrAdultArCodCount.Total > 0
HrAdultArHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultArHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultArHonosCountGrowth where Growth < -0.1
HrAdultArHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultArHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultArHonosCompletionRateChange where Change < -0.05
HrAdultArLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultArLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Adult age group in Residential setting after Admission	select State from HrAdultArLsp16Completed join HrAdultArCodCount using (State) where HrAdultArLsp16Completed.Total = 0 and HrAdultArCodCount.Total > 0
HrAdultArLsp16VolumeDecrease	Historical	High	No	Decrease in HrAdultArLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Adult age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultArLsp16CountGrowth where Growth < -0.1
HrAdultArLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrAdultArLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Adult age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultArLsp16CompletionRateChange where Change < -0.05
HrAdultArBasis32VolumeDecrease	Historical	High	No	Decrease in HrAdultArBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Adult age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultArBasis32CountGrowth where Growth < -0.1
HrAdultArBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrAdultArBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Adult age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultArBasis32CompletionRateChange where Change < -0.05
HrAdultArK10l3dVolumeDecrease	Historical	High	No	Decrease in HrAdultArK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Adult age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultArK10l3dCountGrowth where Growth < -0.1
HrAdultArK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrAdultArK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Adult age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultArK10l3dCompletionRateChange where Change < -0.05
HrAdultArK10lmVolumeDecrease	Historical	High	No	Decrease in HrAdultArK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Adult age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultArK10lmCountGrowth where Growth < -0.1
HrAdultArK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrAdultArK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Adult age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultArK10lmCompletionRateChange where Change < -0.05
HrAdultArMhi38VolumeDecrease	Historical	High	No	Decrease in HrAdultArMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Adult age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultArMhi38CountGrowth where Growth < -0.1
HrAdultArMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrAdultArMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Adult age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultArMhi38CompletionRateChange where Change < -0.05
HrAdultArPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultArPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Adult age group in Residential setting after Admission	select State from HrAdultArPocCompleted join HrAdultArCodCount using (State) where HrAdultArPocCompleted.Total = 0 and HrAdultArCodCount.Total > 0
HrAdultArPocVolumeDecrease	Historical	High	No	Decrease in HrAdultArPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Adult age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultArPocCountGrowth where Growth < -0.1
HrAdultArPocCompletionRateDecrease	Historical	High	No	Decrease in HrAdultArPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Adult age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultArPocCompletionRateChange where Change < -0.05
HrAdultArSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultArSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Adult age group in Residential setting after Admission	select HrAdultArCodCount.State as State from HrAdultArCodCount join HrAdultArMhi38Completed using (State) join HrAdultArBasis32Completed using (State) join HrAdultArK10lmCompleted using (State) join HrAdultArK10l3dCompleted using (State) where HrAdultArMhi38Completed.Total = 0 and HrAdultArBasis32Completed.Total = 0 and HrAdultArK10lmCompleted.Total = 0 and HrAdultArK10l3dCompleted.Total = 0 and HrAdultArCodCount.Total > 0
HrAdultRrHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRrHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Residential setting after Review	select State from HrAdultRrHonosCompleted join HrAdultRrCodCount using (State) where HrAdultRrHonosCompleted.Total = 0 and HrAdultRrCodCount.Total > 0
HrAdultRrHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultRrHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrHonosCountGrowth where Growth < -0.1
HrAdultRrHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrHonosCompletionRateChange where Change < -0.05
HrAdultRrLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRrLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Adult age group in Residential setting after Review	select State from HrAdultRrLsp16Completed join HrAdultRrCodCount using (State) where HrAdultRrLsp16Completed.Total = 0 and HrAdultRrCodCount.Total > 0
HrAdultRrLsp16VolumeDecrease	Historical	High	No	Decrease in HrAdultRrLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrLsp16CountGrowth where Growth < -0.1
HrAdultRrLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrLsp16CompletionRateChange where Change < -0.05
HrAdultRrBasis32VolumeDecrease	Historical	High	No	Decrease in HrAdultRrBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrBasis32CountGrowth where Growth < -0.1
HrAdultRrBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrBasis32CompletionRateChange where Change < -0.05
HrAdultRrK10l3dVolumeDecrease	Historical	High	No	Decrease in HrAdultRrK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrK10l3dCountGrowth where Growth < -0.1
HrAdultRrK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrK10l3dCompletionRateChange where Change < -0.05
HrAdultRrK10lmVolumeDecrease	Historical	High	No	Decrease in HrAdultRrK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrK10lmCountGrowth where Growth < -0.1
HrAdultRrK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrK10lmCompletionRateChange where Change < -0.05
HrAdultRrMhi38VolumeDecrease	Historical	High	No	Decrease in HrAdultRrMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrMhi38CountGrowth where Growth < -0.1
HrAdultRrMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrMhi38CompletionRateChange where Change < -0.05
HrAdultRrDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRrDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Adult age group in Residential setting after Review	select State from HrAdultRrDiagCompleted join HrAdultRrCodCount using (State) where HrAdultRrDiagCompleted.Total = 0 and HrAdultRrCodCount.Total > 0
HrAdultRrDiagVolumeDecrease	Historical	High	No	Decrease in HrAdultRrDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrDiagCountGrowth where Growth < -0.1
HrAdultRrDiagCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrDiagCompletionRateChange where Change < -0.05
HrAdultRrPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRrPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Adult age group in Residential setting after Review	select State from HrAdultRrPocCompleted join HrAdultRrCodCount using (State) where HrAdultRrPocCompleted.Total = 0 and HrAdultRrCodCount.Total > 0
HrAdultRrPocVolumeDecrease	Historical	High	No	Decrease in HrAdultRrPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrPocCountGrowth where Growth < -0.1
HrAdultRrPocCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrPocCompletionRateChange where Change < -0.05
HrAdultRrMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRrMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Adult age group in Residential setting after Review	select State from HrAdultRrMhlsCompleted join HrAdultRrCodCount using (State) where HrAdultRrMhlsCompleted.Total = 0 and HrAdultRrCodCount.Total > 0
HrAdultRrMhlsVolumeDecrease	Historical	High	No	Decrease in HrAdultRrMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Adult age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRrMhlsCountGrowth where Growth < -0.1
HrAdultRrMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRrMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Adult age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRrMhlsCompletionRateChange where Change < -0.05
HrAdultRrSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRrSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Adult age group in Residential setting after Review	select HrAdultRrCodCount.State as State from HrAdultRrCodCount join HrAdultRrMhi38Completed using (State) join HrAdultRrBasis32Completed using (State) join HrAdultRrK10lmCompleted using (State) join HrAdultRrK10l3dCompleted using (State) where HrAdultRrMhi38Completed.Total = 0 and HrAdultRrBasis32Completed.Total = 0 and HrAdultRrK10lmCompleted.Total = 0 and HrAdultRrK10l3dCompleted.Total = 0 and HrAdultRrCodCount.Total > 0
HrAdultDrHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDrHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Residential setting after Discharge	select State from HrAdultDrHonosCompleted join HrAdultDrCodCount using (State) where HrAdultDrHonosCompleted.Total = 0 and HrAdultDrCodCount.Total > 0
HrAdultDrHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultDrHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrHonosCountGrowth where Growth < -0.1
HrAdultDrHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrHonosCompletionRateChange where Change < -0.05
HrAdultDrLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDrLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Adult age group in Residential setting after Discharge	select State from HrAdultDrLsp16Completed join HrAdultDrCodCount using (State) where HrAdultDrLsp16Completed.Total = 0 and HrAdultDrCodCount.Total > 0
HrAdultDrLsp16VolumeDecrease	Historical	High	No	Decrease in HrAdultDrLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrLsp16CountGrowth where Growth < -0.1
HrAdultDrLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrLsp16CompletionRateChange where Change < -0.05
HrAdultDrBasis32VolumeDecrease	Historical	High	No	Decrease in HrAdultDrBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrBasis32CountGrowth where Growth < -0.1
HrAdultDrBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrBasis32CompletionRateChange where Change < -0.05
HrAdultDrK10l3dVolumeDecrease	Historical	High	No	Decrease in HrAdultDrK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrK10l3dCountGrowth where Growth < -0.1
HrAdultDrK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrK10l3dCompletionRateChange where Change < -0.05
HrAdultDrK10lmVolumeDecrease	Historical	High	No	Decrease in HrAdultDrK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrK10lmCountGrowth where Growth < -0.1
HrAdultDrK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrK10lmCompletionRateChange where Change < -0.05
HrAdultDrMhi38VolumeDecrease	Historical	High	No	Decrease in HrAdultDrMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrMhi38CountGrowth where Growth < -0.1
HrAdultDrMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrMhi38CompletionRateChange where Change < -0.05
HrAdultDrDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDrDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Adult age group in Residential setting after Discharge	select State from HrAdultDrDiagCompleted join HrAdultDrCodCount using (State) where HrAdultDrDiagCompleted.Total = 0 and HrAdultDrCodCount.Total > 0
HrAdultDrDiagVolumeDecrease	Historical	High	No	Decrease in HrAdultDrDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrDiagCountGrowth where Growth < -0.1
HrAdultDrDiagCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrDiagCompletionRateChange where Change < -0.05
HrAdultDrMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDrMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Adult age group in Residential setting after Discharge	select State from HrAdultDrMhlsCompleted join HrAdultDrCodCount using (State) where HrAdultDrMhlsCompleted.Total = 0 and HrAdultDrCodCount.Total > 0
HrAdultDrMhlsVolumeDecrease	Historical	High	No	Decrease in HrAdultDrMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Adult age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDrMhlsCountGrowth where Growth < -0.1
HrAdultDrMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDrMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Adult age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDrMhlsCompletionRateChange where Change < -0.05
HrAdultDrSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDrSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Adult age group in Residential setting after Discharge	select HrAdultDrCodCount.State as State from HrAdultDrCodCount join HrAdultDrMhi38Completed using (State) join HrAdultDrBasis32Completed using (State) join HrAdultDrK10lmCompleted using (State) join HrAdultDrK10l3dCompleted using (State) where HrAdultDrMhi38Completed.Total = 0 and HrAdultDrBasis32Completed.Total = 0 and HrAdultDrK10lmCompleted.Total = 0 and HrAdultDrK10l3dCompleted.Total = 0 and HrAdultDrCodCount.Total > 0
HrAdultAaHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultAaHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Ambulatory setting after Admission	select State from HrAdultAaHonosCompleted join HrAdultAaCodCount using (State) where HrAdultAaHonosCompleted.Total = 0 and HrAdultAaCodCount.Total > 0
HrAdultAaHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultAaHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAaHonosCountGrowth where Growth < -0.1
HrAdultAaHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultAaHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAaHonosCompletionRateChange where Change < -0.05
HrAdultAaBasis32VolumeDecrease	Historical	High	No	Decrease in HrAdultAaBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Adult age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAaBasis32CountGrowth where Growth < -0.1
HrAdultAaBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrAdultAaBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Adult age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAaBasis32CompletionRateChange where Change < -0.05
HrAdultAaK10l3dVolumeDecrease	Historical	High	No	Decrease in HrAdultAaK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Adult age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAaK10l3dCountGrowth where Growth < -0.1
HrAdultAaK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrAdultAaK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Adult age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAaK10l3dCompletionRateChange where Change < -0.05
HrAdultAaK10lmVolumeDecrease	Historical	High	No	Decrease in HrAdultAaK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Adult age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAaK10lmCountGrowth where Growth < -0.1
HrAdultAaK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrAdultAaK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Adult age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAaK10lmCompletionRateChange where Change < -0.05
HrAdultAaMhi38VolumeDecrease	Historical	High	No	Decrease in HrAdultAaMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Adult age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAaMhi38CountGrowth where Growth < -0.1
HrAdultAaMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrAdultAaMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Adult age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAaMhi38CompletionRateChange where Change < -0.05
HrAdultAaPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultAaPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Adult age group in Ambulatory setting after Admission	select State from HrAdultAaPocCompleted join HrAdultAaCodCount using (State) where HrAdultAaPocCompleted.Total = 0 and HrAdultAaCodCount.Total > 0
HrAdultAaPocVolumeDecrease	Historical	High	No	Decrease in HrAdultAaPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Adult age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrAdultAaPocCountGrowth where Growth < -0.1
HrAdultAaPocCompletionRateDecrease	Historical	High	No	Decrease in HrAdultAaPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Adult age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrAdultAaPocCompletionRateChange where Change < -0.05
HrAdultAaSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultAaSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Adult age group in Ambulatory setting after Admission	select HrAdultAaCodCount.State as State from HrAdultAaCodCount join HrAdultAaMhi38Completed using (State) join HrAdultAaBasis32Completed using (State) join HrAdultAaK10lmCompleted using (State) join HrAdultAaK10l3dCompleted using (State) where HrAdultAaMhi38Completed.Total = 0 and HrAdultAaBasis32Completed.Total = 0 and HrAdultAaK10lmCompleted.Total = 0 and HrAdultAaK10l3dCompleted.Total = 0 and HrAdultAaCodCount.Total > 0
HrAdultRaHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRaHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Ambulatory setting after Review	select State from HrAdultRaHonosCompleted join HrAdultRaCodCount using (State) where HrAdultRaHonosCompleted.Total = 0 and HrAdultRaCodCount.Total > 0
HrAdultRaHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultRaHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaHonosCountGrowth where Growth < -0.1
HrAdultRaHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaHonosCompletionRateChange where Change < -0.05
HrAdultRaLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRaLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Adult age group in Ambulatory setting after Review	select State from HrAdultRaLsp16Completed join HrAdultRaCodCount using (State) where HrAdultRaLsp16Completed.Total = 0 and HrAdultRaCodCount.Total > 0
HrAdultRaLsp16VolumeDecrease	Historical	High	No	Decrease in HrAdultRaLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaLsp16CountGrowth where Growth < -0.1
HrAdultRaLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaLsp16CompletionRateChange where Change < -0.05
HrAdultRaBasis32VolumeDecrease	Historical	High	No	Decrease in HrAdultRaBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaBasis32CountGrowth where Growth < -0.1
HrAdultRaBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaBasis32CompletionRateChange where Change < -0.05
HrAdultRaK10l3dVolumeDecrease	Historical	High	No	Decrease in HrAdultRaK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaK10l3dCountGrowth where Growth < -0.1
HrAdultRaK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaK10l3dCompletionRateChange where Change < -0.05
HrAdultRaK10lmVolumeDecrease	Historical	High	No	Decrease in HrAdultRaK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaK10lmCountGrowth where Growth < -0.1
HrAdultRaK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaK10lmCompletionRateChange where Change < -0.05
HrAdultRaMhi38VolumeDecrease	Historical	High	No	Decrease in HrAdultRaMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaMhi38CountGrowth where Growth < -0.1
HrAdultRaMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaMhi38CompletionRateChange where Change < -0.05
HrAdultRaDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRaDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Adult age group in Ambulatory setting after Review	select State from HrAdultRaDiagCompleted join HrAdultRaCodCount using (State) where HrAdultRaDiagCompleted.Total = 0 and HrAdultRaCodCount.Total > 0
HrAdultRaDiagVolumeDecrease	Historical	High	No	Decrease in HrAdultRaDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaDiagCountGrowth where Growth < -0.1
HrAdultRaDiagCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaDiagCompletionRateChange where Change < -0.05
HrAdultRaPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRaPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Adult age group in Ambulatory setting after Review	select State from HrAdultRaPocCompleted join HrAdultRaCodCount using (State) where HrAdultRaPocCompleted.Total = 0 and HrAdultRaCodCount.Total > 0
HrAdultRaPocVolumeDecrease	Historical	High	No	Decrease in HrAdultRaPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaPocCountGrowth where Growth < -0.1
HrAdultRaPocCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaPocCompletionRateChange where Change < -0.05
HrAdultRaMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRaMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Adult age group in Ambulatory setting after Review	select State from HrAdultRaMhlsCompleted join HrAdultRaCodCount using (State) where HrAdultRaMhlsCompleted.Total = 0 and HrAdultRaCodCount.Total > 0
HrAdultRaMhlsVolumeDecrease	Historical	High	No	Decrease in HrAdultRaMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Adult age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrAdultRaMhlsCountGrowth where Growth < -0.1
HrAdultRaMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrAdultRaMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Adult age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrAdultRaMhlsCompletionRateChange where Change < -0.05
HrAdultRaSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultRaSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Adult age group in Ambulatory setting after Review	select HrAdultRaCodCount.State as State from HrAdultRaCodCount join HrAdultRaMhi38Completed using (State) join HrAdultRaBasis32Completed using (State) join HrAdultRaK10lmCompleted using (State) join HrAdultRaK10l3dCompleted using (State) where HrAdultRaMhi38Completed.Total = 0 and HrAdultRaBasis32Completed.Total = 0 and HrAdultRaK10lmCompleted.Total = 0 and HrAdultRaK10l3dCompleted.Total = 0 and HrAdultRaCodCount.Total > 0
HrAdultDaHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDaHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Adult age group in Ambulatory setting after Discharge	select State from HrAdultDaHonosCompleted join HrAdultDaCodCount using (State) where HrAdultDaHonosCompleted.Total = 0 and HrAdultDaCodCount.Total > 0
HrAdultDaHonosVolumeDecrease	Historical	High	No	Decrease in HrAdultDaHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaHonosCountGrowth where Growth < -0.1
HrAdultDaHonosCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaHonosCompletionRateChange where Change < -0.05
HrAdultDaLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDaLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Adult age group in Ambulatory setting after Discharge	select State from HrAdultDaLsp16Completed join HrAdultDaCodCount using (State) where HrAdultDaLsp16Completed.Total = 0 and HrAdultDaCodCount.Total > 0
HrAdultDaLsp16VolumeDecrease	Historical	High	No	Decrease in HrAdultDaLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaLsp16CountGrowth where Growth < -0.1
HrAdultDaLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaLsp16CompletionRateChange where Change < -0.05
HrAdultDaBasis32VolumeDecrease	Historical	High	No	Decrease in HrAdultDaBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaBasis32CountGrowth where Growth < -0.1
HrAdultDaBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaBasis32CompletionRateChange where Change < -0.05
HrAdultDaK10l3dVolumeDecrease	Historical	High	No	Decrease in HrAdultDaK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaK10l3dCountGrowth where Growth < -0.1
HrAdultDaK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaK10l3dCompletionRateChange where Change < -0.05
HrAdultDaK10lmVolumeDecrease	Historical	High	No	Decrease in HrAdultDaK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaK10lmCountGrowth where Growth < -0.1
HrAdultDaK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaK10lmCompletionRateChange where Change < -0.05
HrAdultDaMhi38VolumeDecrease	Historical	High	No	Decrease in HrAdultDaMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaMhi38CountGrowth where Growth < -0.1
HrAdultDaMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaMhi38CompletionRateChange where Change < -0.05
HrAdultDaDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDaDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Adult age group in Ambulatory setting after Discharge	select State from HrAdultDaDiagCompleted join HrAdultDaCodCount using (State) where HrAdultDaDiagCompleted.Total = 0 and HrAdultDaCodCount.Total > 0
HrAdultDaDiagVolumeDecrease	Historical	High	No	Decrease in HrAdultDaDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaDiagCountGrowth where Growth < -0.1
HrAdultDaDiagCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaDiagCompletionRateChange where Change < -0.05
HrAdultDaMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDaMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Adult age group in Ambulatory setting after Discharge	select State from HrAdultDaMhlsCompleted join HrAdultDaCodCount using (State) where HrAdultDaMhlsCompleted.Total = 0 and HrAdultDaCodCount.Total > 0
HrAdultDaMhlsVolumeDecrease	Historical	High	No	Decrease in HrAdultDaMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Adult age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrAdultDaMhlsCountGrowth where Growth < -0.1
HrAdultDaMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrAdultDaMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Adult age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrAdultDaMhlsCompletionRateChange where Change < -0.05
HrAdultDaSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrAdultDaSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Adult age group in Ambulatory setting after Discharge	select HrAdultDaCodCount.State as State from HrAdultDaCodCount join HrAdultDaMhi38Completed using (State) join HrAdultDaBasis32Completed using (State) join HrAdultDaK10lmCompleted using (State) join HrAdultDaK10l3dCompleted using (State) where HrAdultDaMhi38Completed.Total = 0 and HrAdultDaBasis32Completed.Total = 0 and HrAdultDaK10lmCompleted.Total = 0 and HrAdultDaK10l3dCompleted.Total = 0 and HrAdultDaCodCount.Total > 0
HrOlderAiHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderAiHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Inpatient setting after Admission	select State from HrOlderAiHonosCompleted join HrOlderAiCodCount using (State) where HrOlderAiHonosCompleted.Total = 0 and HrOlderAiCodCount.Total > 0
HrOlderAiHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderAiHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAiHonosCountGrowth where Growth < -0.1
HrOlderAiHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderAiHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAiHonosCompletionRateChange where Change < -0.05
HrOlderAiRugadlZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderAiRugadlCompletionRate	HR	Zero completion rate for HR-level count of RUGADL for Older age group in Inpatient setting after Admission	select State from HrOlderAiRugadlCompleted join HrOlderAiCodCount using (State) where HrOlderAiRugadlCompleted.Total = 0 and HrOlderAiCodCount.Total > 0
HrOlderAiRugadlVolumeDecrease	Historical	High	No	Decrease in HrOlderAiRugadlCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of RUGADL for Older age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAiRugadlCountGrowth where Growth < -0.1
HrOlderAiRugadlCompletionRateDecrease	Historical	High	No	Decrease in HrOlderAiRugadlCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of RUGADL for Older age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAiRugadlCompletionRateChange where Change < -0.05
HrOlderAiPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderAiPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Older age group in Inpatient setting after Admission	select State from HrOlderAiPocCompleted join HrOlderAiCodCount using (State) where HrOlderAiPocCompleted.Total = 0 and HrOlderAiCodCount.Total > 0
HrOlderAiPocVolumeDecrease	Historical	High	No	Decrease in HrOlderAiPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Older age group in Inpatient setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAiPocCountGrowth where Growth < -0.1
HrOlderAiPocCompletionRateDecrease	Historical	High	No	Decrease in HrOlderAiPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Older age group in Inpatient setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAiPocCompletionRateChange where Change < -0.05
HrOlderRiHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRiHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Inpatient setting after Review	select State from HrOlderRiHonosCompleted join HrOlderRiCodCount using (State) where HrOlderRiHonosCompleted.Total = 0 and HrOlderRiCodCount.Total > 0
HrOlderRiHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderRiHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRiHonosCountGrowth where Growth < -0.1
HrOlderRiHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRiHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRiHonosCompletionRateChange where Change < -0.05
HrOlderRiRugadlZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRiRugadlCompletionRate	HR	Zero completion rate for HR-level count of RUGADL for Older age group in Inpatient setting after Review	select State from HrOlderRiRugadlCompleted join HrOlderRiCodCount using (State) where HrOlderRiRugadlCompleted.Total = 0 and HrOlderRiCodCount.Total > 0
HrOlderRiRugadlVolumeDecrease	Historical	High	No	Decrease in HrOlderRiRugadlCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of RUGADL for Older age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRiRugadlCountGrowth where Growth < -0.1
HrOlderRiRugadlCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRiRugadlCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of RUGADL for Older age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRiRugadlCompletionRateChange where Change < -0.05
HrOlderRiDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRiDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Older age group in Inpatient setting after Review	select State from HrOlderRiDiagCompleted join HrOlderRiCodCount using (State) where HrOlderRiDiagCompleted.Total = 0 and HrOlderRiCodCount.Total > 0
HrOlderRiDiagVolumeDecrease	Historical	High	No	Decrease in HrOlderRiDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Older age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRiDiagCountGrowth where Growth < -0.1
HrOlderRiDiagCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRiDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Older age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRiDiagCompletionRateChange where Change < -0.05
HrOlderRiPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRiPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Older age group in Inpatient setting after Review	select State from HrOlderRiPocCompleted join HrOlderRiCodCount using (State) where HrOlderRiPocCompleted.Total = 0 and HrOlderRiCodCount.Total > 0
HrOlderRiPocVolumeDecrease	Historical	High	No	Decrease in HrOlderRiPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Older age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRiPocCountGrowth where Growth < -0.1
HrOlderRiPocCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRiPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Older age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRiPocCompletionRateChange where Change < -0.05
HrOlderRiMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRiMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Older age group in Inpatient setting after Review	select State from HrOlderRiMhlsCompleted join HrOlderRiCodCount using (State) where HrOlderRiMhlsCompleted.Total = 0 and HrOlderRiCodCount.Total > 0
HrOlderRiMhlsVolumeDecrease	Historical	High	No	Decrease in HrOlderRiMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Older age group in Inpatient setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRiMhlsCountGrowth where Growth < -0.1
HrOlderRiMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRiMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Older age group in Inpatient setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRiMhlsCompletionRateChange where Change < -0.05
HrOlderDiHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDiHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Inpatient setting after Discharge	select State from HrOlderDiHonosCompleted join HrOlderDiCodCount using (State) where HrOlderDiHonosCompleted.Total = 0 and HrOlderDiCodCount.Total > 0
HrOlderDiHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderDiHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDiHonosCountGrowth where Growth < -0.1
HrOlderDiHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDiHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDiHonosCompletionRateChange where Change < -0.05
HrOlderDiDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDiDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Older age group in Inpatient setting after Discharge	select State from HrOlderDiDiagCompleted join HrOlderDiCodCount using (State) where HrOlderDiDiagCompleted.Total = 0 and HrOlderDiCodCount.Total > 0
HrOlderDiDiagVolumeDecrease	Historical	High	No	Decrease in HrOlderDiDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Older age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDiDiagCountGrowth where Growth < -0.1
HrOlderDiDiagCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDiDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Older age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDiDiagCompletionRateChange where Change < -0.05
HrOlderDiMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDiMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Older age group in Inpatient setting after Discharge	select State from HrOlderDiMhlsCompleted join HrOlderDiCodCount using (State) where HrOlderDiMhlsCompleted.Total = 0 and HrOlderDiCodCount.Total > 0
HrOlderDiMhlsVolumeDecrease	Historical	High	No	Decrease in HrOlderDiMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Older age group in Inpatient setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDiMhlsCountGrowth where Growth < -0.1
HrOlderDiMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDiMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Older age group in Inpatient setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDiMhlsCompletionRateChange where Change < -0.05
HrOlderArHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderArHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Residential setting after Admission	select State from HrOlderArHonosCompleted join HrOlderArCodCount using (State) where HrOlderArHonosCompleted.Total = 0 and HrOlderArCodCount.Total > 0
HrOlderArHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderArHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderArHonosCountGrowth where Growth < -0.1
HrOlderArHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderArHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderArHonosCompletionRateChange where Change < -0.05
HrOlderArLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderArLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Older age group in Residential setting after Admission	select State from HrOlderArLsp16Completed join HrOlderArCodCount using (State) where HrOlderArLsp16Completed.Total = 0 and HrOlderArCodCount.Total > 0
HrOlderArLsp16VolumeDecrease	Historical	High	No	Decrease in HrOlderArLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Older age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderArLsp16CountGrowth where Growth < -0.1
HrOlderArLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrOlderArLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Older age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderArLsp16CompletionRateChange where Change < -0.05
HrOlderArBasis32VolumeDecrease	Historical	High	No	Decrease in HrOlderArBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Older age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderArBasis32CountGrowth where Growth < -0.1
HrOlderArBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrOlderArBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Older age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderArBasis32CompletionRateChange where Change < -0.05
HrOlderArK10l3dVolumeDecrease	Historical	High	No	Decrease in HrOlderArK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Older age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderArK10l3dCountGrowth where Growth < -0.1
HrOlderArK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrOlderArK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Older age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderArK10l3dCompletionRateChange where Change < -0.05
HrOlderArK10lmVolumeDecrease	Historical	High	No	Decrease in HrOlderArK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Older age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderArK10lmCountGrowth where Growth < -0.1
HrOlderArK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrOlderArK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Older age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderArK10lmCompletionRateChange where Change < -0.05
HrOlderArMhi38VolumeDecrease	Historical	High	No	Decrease in HrOlderArMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Older age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderArMhi38CountGrowth where Growth < -0.1
HrOlderArMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrOlderArMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Older age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderArMhi38CompletionRateChange where Change < -0.05
HrOlderArPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderArPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Older age group in Residential setting after Admission	select State from HrOlderArPocCompleted join HrOlderArCodCount using (State) where HrOlderArPocCompleted.Total = 0 and HrOlderArCodCount.Total > 0
HrOlderArPocVolumeDecrease	Historical	High	No	Decrease in HrOlderArPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Older age group in Residential setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderArPocCountGrowth where Growth < -0.1
HrOlderArPocCompletionRateDecrease	Historical	High	No	Decrease in HrOlderArPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Older age group in Residential setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderArPocCompletionRateChange where Change < -0.05
HrOlderArSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderArSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Older age group in Residential setting after Admission	select HrOlderArCodCount.State as State from HrOlderArCodCount join HrOlderArMhi38Completed using (State) join HrOlderArBasis32Completed using (State) join HrOlderArK10lmCompleted using (State) join HrOlderArK10l3dCompleted using (State) where HrOlderArMhi38Completed.Total = 0 and HrOlderArBasis32Completed.Total = 0 and HrOlderArK10lmCompleted.Total = 0 and HrOlderArK10l3dCompleted.Total = 0 and HrOlderArCodCount.Total > 0
HrOlderRrHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRrHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Residential setting after Review	select State from HrOlderRrHonosCompleted join HrOlderRrCodCount using (State) where HrOlderRrHonosCompleted.Total = 0 and HrOlderRrCodCount.Total > 0
HrOlderRrHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderRrHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrHonosCountGrowth where Growth < -0.1
HrOlderRrHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrHonosCompletionRateChange where Change < -0.05
HrOlderRrLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRrLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Older age group in Residential setting after Review	select State from HrOlderRrLsp16Completed join HrOlderRrCodCount using (State) where HrOlderRrLsp16Completed.Total = 0 and HrOlderRrCodCount.Total > 0
HrOlderRrLsp16VolumeDecrease	Historical	High	No	Decrease in HrOlderRrLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrLsp16CountGrowth where Growth < -0.1
HrOlderRrLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrLsp16CompletionRateChange where Change < -0.05
HrOlderRrBasis32VolumeDecrease	Historical	High	No	Decrease in HrOlderRrBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrBasis32CountGrowth where Growth < -0.1
HrOlderRrBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrBasis32CompletionRateChange where Change < -0.05
HrOlderRrK10l3dVolumeDecrease	Historical	High	No	Decrease in HrOlderRrK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrK10l3dCountGrowth where Growth < -0.1
HrOlderRrK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrK10l3dCompletionRateChange where Change < -0.05
HrOlderRrK10lmVolumeDecrease	Historical	High	No	Decrease in HrOlderRrK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrK10lmCountGrowth where Growth < -0.1
HrOlderRrK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrK10lmCompletionRateChange where Change < -0.05
HrOlderRrMhi38VolumeDecrease	Historical	High	No	Decrease in HrOlderRrMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrMhi38CountGrowth where Growth < -0.1
HrOlderRrMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrMhi38CompletionRateChange where Change < -0.05
HrOlderRrDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRrDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Older age group in Residential setting after Review	select State from HrOlderRrDiagCompleted join HrOlderRrCodCount using (State) where HrOlderRrDiagCompleted.Total = 0 and HrOlderRrCodCount.Total > 0
HrOlderRrDiagVolumeDecrease	Historical	High	No	Decrease in HrOlderRrDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrDiagCountGrowth where Growth < -0.1
HrOlderRrDiagCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrDiagCompletionRateChange where Change < -0.05
HrOlderRrPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRrPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Older age group in Residential setting after Review	select State from HrOlderRrPocCompleted join HrOlderRrCodCount using (State) where HrOlderRrPocCompleted.Total = 0 and HrOlderRrCodCount.Total > 0
HrOlderRrPocVolumeDecrease	Historical	High	No	Decrease in HrOlderRrPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrPocCountGrowth where Growth < -0.1
HrOlderRrPocCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrPocCompletionRateChange where Change < -0.05
HrOlderRrMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRrMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Older age group in Residential setting after Review	select State from HrOlderRrMhlsCompleted join HrOlderRrCodCount using (State) where HrOlderRrMhlsCompleted.Total = 0 and HrOlderRrCodCount.Total > 0
HrOlderRrMhlsVolumeDecrease	Historical	High	No	Decrease in HrOlderRrMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Older age group in Residential setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRrMhlsCountGrowth where Growth < -0.1
HrOlderRrMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRrMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Older age group in Residential setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRrMhlsCompletionRateChange where Change < -0.05
HrOlderRrSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRrSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Older age group in Residential setting after Review	select HrOlderRrCodCount.State as State from HrOlderRrCodCount join HrOlderRrMhi38Completed using (State) join HrOlderRrBasis32Completed using (State) join HrOlderRrK10lmCompleted using (State) join HrOlderRrK10l3dCompleted using (State) where HrOlderRrMhi38Completed.Total = 0 and HrOlderRrBasis32Completed.Total = 0 and HrOlderRrK10lmCompleted.Total = 0 and HrOlderRrK10l3dCompleted.Total = 0 and HrOlderRrCodCount.Total > 0
HrOlderDrHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDrHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Residential setting after Discharge	select State from HrOlderDrHonosCompleted join HrOlderDrCodCount using (State) where HrOlderDrHonosCompleted.Total = 0 and HrOlderDrCodCount.Total > 0
HrOlderDrHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderDrHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrHonosCountGrowth where Growth < -0.1
HrOlderDrHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrHonosCompletionRateChange where Change < -0.05
HrOlderDrLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDrLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Older age group in Residential setting after Discharge	select State from HrOlderDrLsp16Completed join HrOlderDrCodCount using (State) where HrOlderDrLsp16Completed.Total = 0 and HrOlderDrCodCount.Total > 0
HrOlderDrLsp16VolumeDecrease	Historical	High	No	Decrease in HrOlderDrLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrLsp16CountGrowth where Growth < -0.1
HrOlderDrLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrLsp16CompletionRateChange where Change < -0.05
HrOlderDrBasis32VolumeDecrease	Historical	High	No	Decrease in HrOlderDrBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrBasis32CountGrowth where Growth < -0.1
HrOlderDrBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrBasis32CompletionRateChange where Change < -0.05
HrOlderDrK10l3dVolumeDecrease	Historical	High	No	Decrease in HrOlderDrK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrK10l3dCountGrowth where Growth < -0.1
HrOlderDrK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrK10l3dCompletionRateChange where Change < -0.05
HrOlderDrK10lmVolumeDecrease	Historical	High	No	Decrease in HrOlderDrK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrK10lmCountGrowth where Growth < -0.1
HrOlderDrK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrK10lmCompletionRateChange where Change < -0.05
HrOlderDrMhi38VolumeDecrease	Historical	High	No	Decrease in HrOlderDrMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrMhi38CountGrowth where Growth < -0.1
HrOlderDrMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrMhi38CompletionRateChange where Change < -0.05
HrOlderDrDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDrDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Older age group in Residential setting after Discharge	select State from HrOlderDrDiagCompleted join HrOlderDrCodCount using (State) where HrOlderDrDiagCompleted.Total = 0 and HrOlderDrCodCount.Total > 0
HrOlderDrDiagVolumeDecrease	Historical	High	No	Decrease in HrOlderDrDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrDiagCountGrowth where Growth < -0.1
HrOlderDrDiagCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrDiagCompletionRateChange where Change < -0.05
HrOlderDrMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDrMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Older age group in Residential setting after Discharge	select State from HrOlderDrMhlsCompleted join HrOlderDrCodCount using (State) where HrOlderDrMhlsCompleted.Total = 0 and HrOlderDrCodCount.Total > 0
HrOlderDrMhlsVolumeDecrease	Historical	High	No	Decrease in HrOlderDrMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Older age group in Residential setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDrMhlsCountGrowth where Growth < -0.1
HrOlderDrMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDrMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Older age group in Residential setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDrMhlsCompletionRateChange where Change < -0.05
HrOlderDrSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDrSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Older age group in Residential setting after Discharge	select HrOlderDrCodCount.State as State from HrOlderDrCodCount join HrOlderDrMhi38Completed using (State) join HrOlderDrBasis32Completed using (State) join HrOlderDrK10lmCompleted using (State) join HrOlderDrK10l3dCompleted using (State) where HrOlderDrMhi38Completed.Total = 0 and HrOlderDrBasis32Completed.Total = 0 and HrOlderDrK10lmCompleted.Total = 0 and HrOlderDrK10l3dCompleted.Total = 0 and HrOlderDrCodCount.Total > 0
HrOlderAaHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderAaHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Ambulatory setting after Admission	select State from HrOlderAaHonosCompleted join HrOlderAaCodCount using (State) where HrOlderAaHonosCompleted.Total = 0 and HrOlderAaCodCount.Total > 0
HrOlderAaHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderAaHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAaHonosCountGrowth where Growth < -0.1
HrOlderAaHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderAaHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAaHonosCompletionRateChange where Change < -0.05
HrOlderAaBasis32VolumeDecrease	Historical	High	No	Decrease in HrOlderAaBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Older age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAaBasis32CountGrowth where Growth < -0.1
HrOlderAaBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrOlderAaBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Older age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAaBasis32CompletionRateChange where Change < -0.05
HrOlderAaK10l3dVolumeDecrease	Historical	High	No	Decrease in HrOlderAaK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Older age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAaK10l3dCountGrowth where Growth < -0.1
HrOlderAaK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrOlderAaK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Older age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAaK10l3dCompletionRateChange where Change < -0.05
HrOlderAaK10lmVolumeDecrease	Historical	High	No	Decrease in HrOlderAaK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Older age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAaK10lmCountGrowth where Growth < -0.1
HrOlderAaK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrOlderAaK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Older age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAaK10lmCompletionRateChange where Change < -0.05
HrOlderAaMhi38VolumeDecrease	Historical	High	No	Decrease in HrOlderAaMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Older age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAaMhi38CountGrowth where Growth < -0.1
HrOlderAaMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrOlderAaMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Older age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAaMhi38CompletionRateChange where Change < -0.05
HrOlderAaPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderAaPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Older age group in Ambulatory setting after Admission	select State from HrOlderAaPocCompleted join HrOlderAaCodCount using (State) where HrOlderAaPocCompleted.Total = 0 and HrOlderAaCodCount.Total > 0
HrOlderAaPocVolumeDecrease	Historical	High	No	Decrease in HrOlderAaPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Older age group in Ambulatory setting after Admission	select State, round(-Growth, 3) as Decrease from HrOlderAaPocCountGrowth where Growth < -0.1
HrOlderAaPocCompletionRateDecrease	Historical	High	No	Decrease in HrOlderAaPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Older age group in Ambulatory setting after Admission	select State, round(-Change, 3) as Decrease from HrOlderAaPocCompletionRateChange where Change < -0.05
HrOlderAaSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderAaSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Older age group in Ambulatory setting after Admission	select HrOlderAaCodCount.State as State from HrOlderAaCodCount join HrOlderAaMhi38Completed using (State) join HrOlderAaBasis32Completed using (State) join HrOlderAaK10lmCompleted using (State) join HrOlderAaK10l3dCompleted using (State) where HrOlderAaMhi38Completed.Total = 0 and HrOlderAaBasis32Completed.Total = 0 and HrOlderAaK10lmCompleted.Total = 0 and HrOlderAaK10l3dCompleted.Total = 0 and HrOlderAaCodCount.Total > 0
HrOlderRaHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRaHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Ambulatory setting after Review	select State from HrOlderRaHonosCompleted join HrOlderRaCodCount using (State) where HrOlderRaHonosCompleted.Total = 0 and HrOlderRaCodCount.Total > 0
HrOlderRaHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderRaHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaHonosCountGrowth where Growth < -0.1
HrOlderRaHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaHonosCompletionRateChange where Change < -0.05
HrOlderRaLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRaLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Older age group in Ambulatory setting after Review	select State from HrOlderRaLsp16Completed join HrOlderRaCodCount using (State) where HrOlderRaLsp16Completed.Total = 0 and HrOlderRaCodCount.Total > 0
HrOlderRaLsp16VolumeDecrease	Historical	High	No	Decrease in HrOlderRaLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaLsp16CountGrowth where Growth < -0.1
HrOlderRaLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaLsp16CompletionRateChange where Change < -0.05
HrOlderRaBasis32VolumeDecrease	Historical	High	No	Decrease in HrOlderRaBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaBasis32CountGrowth where Growth < -0.1
HrOlderRaBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaBasis32CompletionRateChange where Change < -0.05
HrOlderRaK10l3dVolumeDecrease	Historical	High	No	Decrease in HrOlderRaK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaK10l3dCountGrowth where Growth < -0.1
HrOlderRaK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaK10l3dCompletionRateChange where Change < -0.05
HrOlderRaK10lmVolumeDecrease	Historical	High	No	Decrease in HrOlderRaK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaK10lmCountGrowth where Growth < -0.1
HrOlderRaK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaK10lmCompletionRateChange where Change < -0.05
HrOlderRaMhi38VolumeDecrease	Historical	High	No	Decrease in HrOlderRaMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaMhi38CountGrowth where Growth < -0.1
HrOlderRaMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaMhi38CompletionRateChange where Change < -0.05
HrOlderRaDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRaDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Older age group in Ambulatory setting after Review	select State from HrOlderRaDiagCompleted join HrOlderRaCodCount using (State) where HrOlderRaDiagCompleted.Total = 0 and HrOlderRaCodCount.Total > 0
HrOlderRaDiagVolumeDecrease	Historical	High	No	Decrease in HrOlderRaDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaDiagCountGrowth where Growth < -0.1
HrOlderRaDiagCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaDiagCompletionRateChange where Change < -0.05
HrOlderRaPocZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRaPocCompletionRate	HR	Zero completion rate for HR-level count of POC for Older age group in Ambulatory setting after Review	select State from HrOlderRaPocCompleted join HrOlderRaCodCount using (State) where HrOlderRaPocCompleted.Total = 0 and HrOlderRaCodCount.Total > 0
HrOlderRaPocVolumeDecrease	Historical	High	No	Decrease in HrOlderRaPocCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of POC for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaPocCountGrowth where Growth < -0.1
HrOlderRaPocCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaPocCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of POC for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaPocCompletionRateChange where Change < -0.05
HrOlderRaMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRaMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Older age group in Ambulatory setting after Review	select State from HrOlderRaMhlsCompleted join HrOlderRaCodCount using (State) where HrOlderRaMhlsCompleted.Total = 0 and HrOlderRaCodCount.Total > 0
HrOlderRaMhlsVolumeDecrease	Historical	High	No	Decrease in HrOlderRaMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Older age group in Ambulatory setting after Review	select State, round(-Growth, 3) as Decrease from HrOlderRaMhlsCountGrowth where Growth < -0.1
HrOlderRaMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrOlderRaMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Older age group in Ambulatory setting after Review	select State, round(-Change, 3) as Decrease from HrOlderRaMhlsCompletionRateChange where Change < -0.05
HrOlderRaSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderRaSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Older age group in Ambulatory setting after Review	select HrOlderRaCodCount.State as State from HrOlderRaCodCount join HrOlderRaMhi38Completed using (State) join HrOlderRaBasis32Completed using (State) join HrOlderRaK10lmCompleted using (State) join HrOlderRaK10l3dCompleted using (State) where HrOlderRaMhi38Completed.Total = 0 and HrOlderRaBasis32Completed.Total = 0 and HrOlderRaK10lmCompleted.Total = 0 and HrOlderRaK10l3dCompleted.Total = 0 and HrOlderRaCodCount.Total > 0
HrOlderDaHonosZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDaHonosCompletionRate	HR	Zero completion rate for HR-level count of HONOS for Older age group in Ambulatory setting after Discharge	select State from HrOlderDaHonosCompleted join HrOlderDaCodCount using (State) where HrOlderDaHonosCompleted.Total = 0 and HrOlderDaCodCount.Total > 0
HrOlderDaHonosVolumeDecrease	Historical	High	No	Decrease in HrOlderDaHonosCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of HONOS for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaHonosCountGrowth where Growth < -0.1
HrOlderDaHonosCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaHonosCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of HONOS for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaHonosCompletionRateChange where Change < -0.05
HrOlderDaLsp16ZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDaLsp16CompletionRate	HR	Zero completion rate for HR-level count of LSP16 for Older age group in Ambulatory setting after Discharge	select State from HrOlderDaLsp16Completed join HrOlderDaCodCount using (State) where HrOlderDaLsp16Completed.Total = 0 and HrOlderDaCodCount.Total > 0
HrOlderDaLsp16VolumeDecrease	Historical	High	No	Decrease in HrOlderDaLsp16Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of LSP16 for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaLsp16CountGrowth where Growth < -0.1
HrOlderDaLsp16CompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaLsp16CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of LSP16 for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaLsp16CompletionRateChange where Change < -0.05
HrOlderDaBasis32VolumeDecrease	Historical	High	No	Decrease in HrOlderDaBasis32Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of BASIS32 for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaBasis32CountGrowth where Growth < -0.1
HrOlderDaBasis32CompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaBasis32CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of BASIS32 for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaBasis32CompletionRateChange where Change < -0.05
HrOlderDaK10l3dVolumeDecrease	Historical	High	No	Decrease in HrOlderDaK10l3dCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10L3D for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaK10l3dCountGrowth where Growth < -0.1
HrOlderDaK10l3dCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaK10l3dCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10L3D for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaK10l3dCompletionRateChange where Change < -0.05
HrOlderDaK10lmVolumeDecrease	Historical	High	No	Decrease in HrOlderDaK10lmCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of K10LM for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaK10lmCountGrowth where Growth < -0.1
HrOlderDaK10lmCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaK10lmCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of K10LM for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaK10lmCompletionRateChange where Change < -0.05
HrOlderDaMhi38VolumeDecrease	Historical	High	No	Decrease in HrOlderDaMhi38Count exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHI38 for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaMhi38CountGrowth where Growth < -0.1
HrOlderDaMhi38CompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaMhi38CompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHI38 for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaMhi38CompletionRateChange where Change < -0.05
HrOlderDaDiagZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDaDiagCompletionRate	HR	Zero completion rate for HR-level count of DIAG for Older age group in Ambulatory setting after Discharge	select State from HrOlderDaDiagCompleted join HrOlderDaCodCount using (State) where HrOlderDaDiagCompleted.Total = 0 and HrOlderDaCodCount.Total > 0
HrOlderDaDiagVolumeDecrease	Historical	High	No	Decrease in HrOlderDaDiagCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of DIAG for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaDiagCountGrowth where Growth < -0.1
HrOlderDaDiagCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaDiagCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of DIAG for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaDiagCompletionRateChange where Change < -0.05
HrOlderDaMhlsZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDaMhlsCompletionRate	HR	Zero completion rate for HR-level count of MHLS for Older age group in Ambulatory setting after Discharge	select State from HrOlderDaMhlsCompleted join HrOlderDaCodCount using (State) where HrOlderDaMhlsCompleted.Total = 0 and HrOlderDaCodCount.Total > 0
HrOlderDaMhlsVolumeDecrease	Historical	High	No	Decrease in HrOlderDaMhlsCount exceeding 10% ($Decrease.perc)	HR	Decrease in overall volume exceeding 10% HR-level count of MHLS for Older age group in Ambulatory setting after Discharge	select State, round(-Growth, 3) as Decrease from HrOlderDaMhlsCountGrowth where Growth < -0.1
HrOlderDaMhlsCompletionRateDecrease	Historical	High	No	Decrease in HrOlderDaMhlsCompletionRate exceeding 5% ($Decrease.perc)	HR	Decrease in completion rate exceeding 5% for HR-level count of MHLS for Older age group in Ambulatory setting after Discharge	select State, round(-Change, 3) as Decrease from HrOlderDaMhlsCompletionRateChange where Change < -0.05
HrOlderDaSelfRepZeroCompletion	Anomaly	High	No	Zero completion rate for HrOlderDaSelfRepCompletionRate	HR	Zero completion rate for HR-level count of self-reported meastures for Older age group in Ambulatory setting after Discharge	select HrOlderDaCodCount.State as State from HrOlderDaCodCount join HrOlderDaMhi38Completed using (State) join HrOlderDaBasis32Completed using (State) join HrOlderDaK10lmCompleted using (State) join HrOlderDaK10l3dCompleted using (State) where HrOlderDaMhi38Completed.Total = 0 and HrOlderDaBasis32Completed.Total = 0 and HrOlderDaK10lmCompleted.Total = 0 and HrOlderDaK10l3dCompleted.Total = 0 and HrOlderDaCodCount.Total > 0
SDQ_SelfIncomplete			No				SELECT * FROM SDQIncomplete WHERE SDQVer = 'YR101' OR SDQVer = 'YR201';
SDQ_ParentIncomplete			No				SELECT * FROM SDQIncomplete WHERE SDQVer = 'PC101' OR SDQVer = 'PC201' OR SDQVer = 'PY101' OR SDQVer = 'PY201';
OrgCodSexDiffers	Anomaly	Low	Yes	Organisation has $percount people with inconsistently recorded Sex field values	ORG	Person has multiple values for Sex across one organisation	with codattrdiffers as ( select State, RegId, OrgId, pid from cod group by State, RegId, OrgId, pid having count(distinct Sex) > 1 ) select State, RegId, OrgId, count(pid) as percount from codattrdiffers group by State, RegId, OrgId
OrgCodDoBDiffers	Anomaly	Low	Yes	Organisation has $percount people with inconsistently recorded DoB field values	ORG	Person has multiple values for DoB across one organisation	with codattrdiffers as ( select State, RegId, OrgId, pid from cod group by State, RegId, OrgId, pid having count(distinct DoB) > 1 ) select State, RegId, OrgId, count(pid) as percount from codattrdiffers group by State, RegId, OrgId
CodDoBMissingPropHigh	Anomaly	High	Yes	Greater than 1% of DoB values are coded as Missing ($total_missing out of $total_all)	ORG	Greater than 1% of COD DoB values in an organisation are coded as Missing	with CodDoBMissingProp as ( select State, RegId, OrgId, count(*) as total_all, sum( case when dob = '9999-09-09' then 1 else 0 end ) as total_missing from COD group by State, RegId, OrgId ) select State, RegId, OrgId, total_all, total_missing from CodDoBMissingProp where total_all > 0 and (total_missing::float / total_all::float > 0.01)
CodSexMissingPropHigh	Anomaly	High	Yes	Greater than 0.1% of Sex values are coded as Missing ($total_missing out of $total_all)	HR	Greater than 0.1% of COD Sex values are coded as Missing	with CodSexMissingProp as ( select state, count(*) as total_all, sum( case when sex = '9' then 1 else 0 end ) as total_missing from COD group by state ) select state, total_all, total_missing from CodSexMissingProp where total_all > 0 and (total_missing::float / total_all::float > 0.001)
BadDx1F	Inconsistent	High	No	Principal Diagnosis ($Dx1) and Sex ($Sex) is not female	DIAG.Dx1	The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 '	select ColId, Dx1, Sex from DIAG join COD using (ColId) where Dx1 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2' and Sex != '3'
BadDx1M	Inconsistent	High	No	Principal Diagnosis ($Dx1) and Sex ($Sex) is not male	DIAG.Dx1	The following diagnosis codes should only apply to males: 'F52.4 '	select ColId, Dx1, Sex from DIAG join COD using (ColId) where Dx1 in ('F52.4 ') and Sex != '1' and Sex != '3'
BadDx1Ppm	Inconsistent	Low	No	Principal Diagnosis ($Dx1) and Age ($Age) not between 10 and 60	DIAG.Dx1	The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 '	select ColId, Dx1, Age from DIAG join CodAge using (ColId) where Dx1 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDx1Ad	Inconsistent	Low	No	Principal Diagnosis ($Dx1) and Age ($Age) less than 15	DIAG.Dx1	The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 '	select ColId, Dx1, Age from DIAG join CodAge using (ColId) where Dx1 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDx1LowAge	Inconsistent	Low	No	Principal Diagnosis ($Dx1) and Age ($Age) less than 1	DIAG.Dx1	The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 '	select ColId, Dx1, Age from DIAG join CodAge using (ColId) where Dx1 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDx2F	Inconsistent	High	No	Principal Diagnosis ($Dx2) and Sex ($Sex) is not female	DIAG.Dx2	The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 '	select ColId, Dx2, Sex from DIAG join COD using (ColId) where Dx2 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2' and Sex != '3'
BadDx2M	Inconsistent	High	No	Principal Diagnosis ($Dx2) and Sex ($Sex) is not male	DIAG.Dx2	The following diagnosis codes should only apply to males: 'F52.4 '	select ColId, Dx2, Sex from DIAG join COD using (ColId) where Dx2 in ('F52.4 ') and Sex != '1' and Sex != '3'
BadDx2Ppm	Inconsistent	Low	No	Principal Diagnosis ($Dx2) and Age ($Age) not between 10 and 60	DIAG.Dx2	The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 '	select ColId, Dx2, Age from DIAG join CodAge using (ColId) where Dx2 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDx2Ad	Inconsistent	Low	No	Principal Diagnosis ($Dx2) and Age ($Age) less than 15	DIAG.Dx2	The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 '	select ColId, Dx2, Age from DIAG join CodAge using (ColId) where Dx2 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDx2LowAge	Inconsistent	Low	No	Principal Diagnosis ($Dx2) and Age ($Age) less than 1	DIAG.Dx2	The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 '	select ColId, Dx2, Age from DIAG join CodAge using (ColId) where Dx2 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
BadDx3F	Inconsistent	High	No	Principal Diagnosis ($Dx3) and Sex ($Sex) is not female	DIAG.Dx3	The following diagnosis codes should only apply to females: 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 '	select ColId, Dx3, Sex from DIAG join COD using (ColId) where Dx3 in ('F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ', 'F52.5 ') and Sex != '2' and Sex != '3'
BadDx3M	Inconsistent	High	No	Principal Diagnosis ($Dx3) and Sex ($Sex) is not male	DIAG.Dx3	The following diagnosis codes should only apply to males: 'F52.4 '	select ColId, Dx3, Sex from DIAG join COD using (ColId) where Dx3 in ('F52.4 ') and Sex != '1' and Sex != '3'
BadDx3Ppm	Inconsistent	Low	No	Principal Diagnosis ($Dx3) and Age ($Age) not between 10 and 60	DIAG.Dx3	The following diagnosis codes should only apply to ages 10-60: 'F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 '	select ColId, Dx3, Age from DIAG join CodAge using (ColId) where Dx3 in ('F53 ', 'F53.0 ', 'F53.1 ', 'F53.8 ', 'F53.9 ', 'F32.01', 'F32.11', 'F32.21', 'F32.31', 'F32.81', 'F32.91', 'O99.3 ') and Age not between 10 and 60
BadDx3Ad	Inconsistent	Low	No	Principal Diagnosis ($Dx3) and Age ($Age) less than 15	DIAG.Dx3	The following diagnosis codes should not apply to ages less than 15: 'F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 '	select ColId, Dx3, Age from DIAG join CodAge using (ColId) where Dx3 in ('F03 ', 'F01.0 ', 'F01.1 ', 'F01.2 ', 'F01.3 ', 'F01.8 ', 'F01.9 ') and Age < 15
BadDx3LowAge	Inconsistent	Low	No	Principal Diagnosis ($Dx3) and Age ($Age) less than 1	DIAG.Dx3	The following diagnosis codes should not apply to ages less than 1: 'F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 '	select ColId, Dx3, Age from DIAG join CodAge using (ColId) where Dx3 in ('F80.0 ', 'F80.1 ', 'F80.2 ', 'F80.3 ', 'F80.8 ', 'F80.9 ', 'F81.0 ', 'F81.1 ', 'F81.2 ', 'F81.3 ', 'F81.8 ', 'F81.9 ', 'F82 ', 'F83 ', 'F88 ', 'F89 ') and Age < 1
RegNotInSkl	Skeleton	High	No	Reg $name.qt not in SKL data	REG	Region not in skeleton reference data - A matching Region (REG) was not found in the skeleton data	select State, RegId, REG.RegName as name from REG left join skl.REG as skl_entity using (State, RegId) where skl_entity.RegId is null
RegInSklOnly	Skeleton	High	No	Reg $skl_name.qt expected from SKL is missing	HR	Region (REG) appears in skeleton data only - A Region (REG) with matching Ids is expected based on the SKL data but is not present in this file	select State, RegId as skl_RegId, skl_entity.RegName as skl_name from skl.REG as skl_entity left join REG as checking using (State, RegId) where checking.RegId is null
OrgNotInSkl	Skeleton	High	No	Org $name.qt not in SKL data	ORG	Organisation not in skeleton reference data - A matching Organisation (ORG) was not found in the skeleton data	select State, RegId, OrgId, ORG.OrgName as name from ORG left join skl.ORG as skl_entity using (State, RegId, OrgId) left join skl.REG as skl_parent using (State, RegId) where skl_entity.OrgId is null and skl_parent.RegId is not null
OrgInSklOnly	Skeleton	High	No	Org $skl_name.qt expected from SKL is missing	REG	Organisation (ORG) appears in skeleton data only - A Organisation (ORG) with matching Ids is expected based on the SKL data but is not present in this file	select State, RegId, OrgId as skl_OrgId, skl_entity.OrgName as skl_name from skl.ORG as skl_entity left join ORG as checking using (State, RegId, OrgId) left join REG as parent using (State, RegId) where checking.OrgId is null and parent.RegId is not null
HospClusNotInSkl	Skeleton	High	No	HospClus $name.qt not in SKL data	HOSPCLUS	Hospital / Cluster not in skeleton reference data - A matching Hospital (HOSP) or Service Unit Cluster (CLUS) was not found in the skeleton data	select State, RegId, OrgId, HospClusId, HOSPCLUS.HospClusName as name from HOSPCLUS left join ( select State, RegId, OrgId, HospId as HospClusId from skl.Hosp union select State, RegId, OrgId, ClusId as HospClusId from skl.Clus ) as skl_entity using (State, RegId, OrgId, HospClusId) left join skl.ORG as skl_parent using (State, RegId, OrgId) where skl_entity.HospClusId is null and skl_parent.OrgId is not null
HospInSklOnly	Skeleton	High	No	HospClus $skl_name.qt expected from SKL is missing	ORG	Hospital (HOSP) appears in skeleton data only - A Hospital / Cluster (HOSPCLUS) with matching Ids is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, HospClusId as skl_HospId, skl_entity.HospName as skl_name from ( select State, RegId, OrgId, HospName, HospId as HospClusId from skl.Hosp ) as skl_entity left join HOSPCLUS as checking using (State, RegId, OrgId, HospClusId) left join ORG as parent using (State, RegId, OrgId) where checking.HospClusId is null and parent.OrgId is not null
ClusInSklOnly	Skeleton	High	No	HospClus $skl_name.qt expected from SKL is missing	ORG	Service Unit Cluster (CLUS) appears in skeleton data only - A Hospital / Cluster (HOSPCLUS) with matching Ids is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, HospClusId as skl_ClusId, skl_entity.ClusName as skl_name from ( select State, RegId, OrgId, ClusName, ClusId as HospClusId from skl.Clus ) as skl_entity left join HOSPCLUS as checking using (State, RegId, OrgId, HospClusId) left join ORG as parent using (State, RegId, OrgId) where checking.HospClusId is null and parent.OrgId is not null
AdmiNotInSkl	Skeleton	High	No	Serv $name.qt not in SKL data	SERV	Service Unit not in skeleton reference data - A matching Admitted Patient Service Unit (ADMI) was not found in the skeleton data	select State, RegId, OrgId, HospClusId, SUId, SERV.SUName as name from SERV left join ( select State, RegId, OrgId, HospId as HospClusId, AdmiId as SUId from ADMI ) as skl_entity using (State, RegId, OrgId, HospClusId, SUId) left join ( select State, RegId, OrgId, HospId as HospClusId from skl.HOSP ) as skl_parent using (State, RegId, OrgId, HospClusId) where SUType = '1' and skl_entity.SUId is null and skl_parent.HospClusId is not null
AdmiInSklOnly	Skeleton	High	No	Serv $skl_name.qt expected from SKL is missing	HOSPCLUS	Admitted Patient Service Unit (ADMI) appears in skeleton data only - A Service Unit (SERV) with matching Ids is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, HospClusId, SUId as skl_AdmiId, skl_entity.AdmiName as skl_name from ( select State, RegId, OrgId, HospId as HospClusId, AdmiId as SUId, AdmiName from skl.Admi ) as skl_entity left join SERV as checking using (State, RegId, OrgId, HospClusId, SUId) left join HOSPCLUS as parent using (State, RegId, OrgId, HospClusId) where checking.SUId is null and parent.HospClusId is not null
ResiNotInSkl	Skeleton	High	No	Serv $name.qt not in SKL data	SERV	Service Unit not in skeleton reference data - A matching Residential Service Unit (RESI) was not found in the skeleton data	select State, RegId, OrgId, HospClusId, SUId, SERV.SUName as name from SERV left join ( select State, RegId, OrgId, ClusId as HospClusId, ResiId as SUId from RESI ) as skl_entity using (State, RegId, OrgId, HospClusId, SUId) left join ( select State, RegId, OrgId, ClusId as HospClusId from skl.CLUS ) as skl_parent using (State, RegId, OrgId, HospClusId) where SUType = '2' and skl_entity.SUId is null and skl_parent.HospClusId is not null
ResiInSklOnly	Skeleton	High	No	Serv $skl_name.qt expected from SKL is missing	HOSPCLUS	Residential Service Unit (RESI) appears in skeleton data only - A Service Unit (SERV) with matching Ids is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, HospClusId, SUId as skl_ResiId, skl_entity.ResiName as skl_name from ( select State, RegId, OrgId, ClusId as HospClusId, ResiId as SUId, ResiName from skl.Resi ) as skl_entity left join SERV as checking using (State, RegId, OrgId, HospClusId, SUId) left join HOSPCLUS as parent using (State, RegId, OrgId, HospClusId) where checking.SUId is null and parent.HospClusId is not null
OrgAmbuCANotInSkl	Skeleton	High	No	ORG Child and adolescent unit $name.qt not in SKL data	ORG	Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Child and adolescent age group in Ambulatory setting was not found in the skeleton data	select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuCA left join skl.OrgHasAmbuCA as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null
OrgAmbuCAInSklOnly	Skeleton	High	No	ORG Child and adolescent unit $skl_name.qt expected from SKL is missing	ORG	Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Child and adolescent in Ambulatory setting is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuCA left join OrgHasAmbuCA as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null
OrgAmbuOldNotInSkl	Skeleton	High	No	ORG Older person unit $name.qt not in SKL data	ORG	Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Older person age group in Ambulatory setting was not found in the skeleton data	select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuOld left join skl.OrgHasAmbuOld as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null
OrgAmbuOldInSklOnly	Skeleton	High	No	ORG Older person unit $skl_name.qt expected from SKL is missing	ORG	Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Older person in Ambulatory setting is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuOld left join OrgHasAmbuOld as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null
OrgAmbuForNotInSkl	Skeleton	High	No	ORG Forensic unit $name.qt not in SKL data	ORG	Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Forensic age group in Ambulatory setting was not found in the skeleton data	select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuFor left join skl.OrgHasAmbuFor as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null
OrgAmbuForInSklOnly	Skeleton	High	No	ORG Forensic unit $skl_name.qt expected from SKL is missing	ORG	Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Forensic in Ambulatory setting is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuFor left join OrgHasAmbuFor as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null
OrgAmbuGenNotInSkl	Skeleton	High	No	ORG General unit $name.qt not in SKL data	ORG	Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with General age group in Ambulatory setting was not found in the skeleton data	select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuGen left join skl.OrgHasAmbuGen as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null
OrgAmbuGenInSklOnly	Skeleton	High	No	ORG General unit $skl_name.qt expected from SKL is missing	ORG	Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with General in Ambulatory setting is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuGen left join OrgHasAmbuGen as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null
OrgAmbuYthNotInSkl	Skeleton	High	No	ORG Youth unit $name.qt not in SKL data	ORG	Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Youth age group in Ambulatory setting was not found in the skeleton data	select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuYth left join skl.OrgHasAmbuYth as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null
OrgAmbuYthInSklOnly	Skeleton	High	No	ORG Youth unit $skl_name.qt expected from SKL is missing	ORG	Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Youth in Ambulatory setting is expected based on the SKL data but is not present in this file	select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuYth left join OrgHasAmbuYth as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null

National Outcomes and Casemix Collection — Version 02.11

NOCC version 02.11: Rules