National Outcomes and Casemix Collection — Version 01.60
Main Content
NOCC version 01.60: Rules
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 |
FocFoCSpaces | Invalid | High | Yes | All spaces in field FoC (Char) | FOC.FoC | All spaces in field FoC (Char). This field should not be empty (only spaces), one of the codes is required. | select ColId, FoC from FOC where FoC 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 or TargetPop = '9' |
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 |
ServEstSLAMissing | Missing | High | Yes | Missing data - EstSLA $EstSLA.q | SERV.EstSLA | Missing data - Geographical Location of Establishment (EstSLA) | select State, RegId, OrgId, HospClusId, SUId, EstSLA from SERV where EstSLA 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 |
FocIncomplete | Missing | Low | Yes | FOC is Incomplete | FOC | FOC is Incomplete | select State, RegId, OrgId, ColId, IsCompleted from COD join Foc using (ColId) join FocCompletion 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 |
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 |
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 |
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 |
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 |
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 |
HrAdultRaFocZeroCompletion | Anomaly | High | No | Zero completion rate for HrAdultRaFocCompletionRate | HR | Zero completion rate for HR-level count of FOC for Adult age group in Ambulatory setting after Review | select State from HrAdultRaFocCompleted join HrAdultRaCodCount using (State) where HrAdultRaFocCompleted.Total = 0 and HrAdultRaCodCount.Total > 0 |
HrAdultRaFocVolumeDecrease | Historical | High | No | Decrease in HrAdultRaFocCount exceeding 10% ($Decrease.perc) | HR | Decrease in overall volume exceeding 10% HR-level count of FOC for Adult age group in Ambulatory setting after Review | select State, round(-Growth, 3) as Decrease from HrAdultRaFocCountGrowth where Growth < -0.1 |
HrAdultRaFocCompletionRateDecrease | Historical | High | No | Decrease in HrAdultRaFocCompletionRate exceeding 5% ($Decrease.perc) | HR | Decrease in completion rate exceeding 5% for HR-level count of FOC for Adult age group in Ambulatory setting after Review | select State, round(-Change, 3) as Decrease from HrAdultRaFocCompletionRateChange 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 |
HrAdultDaFocZeroCompletion | Anomaly | High | No | Zero completion rate for HrAdultDaFocCompletionRate | HR | Zero completion rate for HR-level count of FOC for Adult age group in Ambulatory setting after Discharge | select State from HrAdultDaFocCompleted join HrAdultDaCodCount using (State) where HrAdultDaFocCompleted.Total = 0 and HrAdultDaCodCount.Total > 0 |
HrAdultDaFocVolumeDecrease | Historical | High | No | Decrease in HrAdultDaFocCount exceeding 10% ($Decrease.perc) | HR | Decrease in overall volume exceeding 10% HR-level count of FOC for Adult age group in Ambulatory setting after Discharge | select State, round(-Growth, 3) as Decrease from HrAdultDaFocCountGrowth where Growth < -0.1 |
HrAdultDaFocCompletionRateDecrease | Historical | High | No | Decrease in HrAdultDaFocCompletionRate exceeding 5% ($Decrease.perc) | HR | Decrease in completion rate exceeding 5% for HR-level count of FOC for Adult age group in Ambulatory setting after Discharge | select State, round(-Change, 3) as Decrease from HrAdultDaFocCompletionRateChange 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 |
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 |
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 |
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 |
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 |
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 |
HrOlderRaFocZeroCompletion | Anomaly | High | No | Zero completion rate for HrOlderRaFocCompletionRate | HR | Zero completion rate for HR-level count of FOC for Older age group in Ambulatory setting after Review | select State from HrOlderRaFocCompleted join HrOlderRaCodCount using (State) where HrOlderRaFocCompleted.Total = 0 and HrOlderRaCodCount.Total > 0 |
HrOlderRaFocVolumeDecrease | Historical | High | No | Decrease in HrOlderRaFocCount exceeding 10% ($Decrease.perc) | HR | Decrease in overall volume exceeding 10% HR-level count of FOC for Older age group in Ambulatory setting after Review | select State, round(-Growth, 3) as Decrease from HrOlderRaFocCountGrowth where Growth < -0.1 |
HrOlderRaFocCompletionRateDecrease | Historical | High | No | Decrease in HrOlderRaFocCompletionRate exceeding 5% ($Decrease.perc) | HR | Decrease in completion rate exceeding 5% for HR-level count of FOC for Older age group in Ambulatory setting after Review | select State, round(-Change, 3) as Decrease from HrOlderRaFocCompletionRateChange 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 |
HrOlderDaFocZeroCompletion | Anomaly | High | No | Zero completion rate for HrOlderDaFocCompletionRate | HR | Zero completion rate for HR-level count of FOC for Older age group in Ambulatory setting after Discharge | select State from HrOlderDaFocCompleted join HrOlderDaCodCount using (State) where HrOlderDaFocCompleted.Total = 0 and HrOlderDaCodCount.Total > 0 |
HrOlderDaFocVolumeDecrease | Historical | High | No | Decrease in HrOlderDaFocCount exceeding 10% ($Decrease.perc) | HR | Decrease in overall volume exceeding 10% HR-level count of FOC for Older age group in Ambulatory setting after Discharge | select State, round(-Growth, 3) as Decrease from HrOlderDaFocCountGrowth where Growth < -0.1 |
HrOlderDaFocCompletionRateDecrease | Historical | High | No | Decrease in HrOlderDaFocCompletionRate exceeding 5% ($Decrease.perc) | HR | Decrease in completion rate exceeding 5% for HR-level count of FOC for Older age group in Ambulatory setting after Discharge | select State, round(-Change, 3) as Decrease from HrOlderDaFocCompletionRateChange 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'; |