National Outcomes and Casemix Collection — Version 01.61
Main Content
NOCC version 01.61: 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 |
| 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'; | |||||
| RegNotInSkl | Skeleton | High | No | Reg $name.qt not in SKL data | REG | Region not in skeleton reference data - A matching Region (REG) was not found in the skeleton data | select State, RegId, REG.RegName as name from REG left join skl.REG as skl_entity using (State, RegId) where skl_entity.RegId is null |
| RegInSklOnly | Skeleton | High | No | Reg $skl_name.qt expected from SKL is missing | HR | Region (REG) appears in skeleton data only - A Region (REG) with matching Ids is expected based on the SKL data but is not present in this file | select State, RegId as skl_RegId, skl_entity.RegName as skl_name from skl.REG as skl_entity left join REG as checking using (State, RegId) where checking.RegId is null |
| OrgNotInSkl | Skeleton | High | No | Org $name.qt not in SKL data | ORG | Organisation not in skeleton reference data - A matching Organisation (ORG) was not found in the skeleton data | select State, RegId, OrgId, ORG.OrgName as name from ORG left join skl.ORG as skl_entity using (State, RegId, OrgId) left join skl.REG as skl_parent using (State, RegId) where skl_entity.OrgId is null and skl_parent.RegId is not null |
| OrgInSklOnly | Skeleton | High | No | Org $skl_name.qt expected from SKL is missing | REG | Organisation (ORG) appears in skeleton data only - A Organisation (ORG) with matching Ids is expected based on the SKL data but is not present in this file | select State, RegId, OrgId as skl_OrgId, skl_entity.OrgName as skl_name from skl.ORG as skl_entity left join ORG as checking using (State, RegId, OrgId) left join REG as parent using (State, RegId) where checking.OrgId is null and parent.RegId is not null |
| HospClusNotInSkl | Skeleton | High | No | HospClus $name.qt not in SKL data | HOSPCLUS | Hospital / Cluster not in skeleton reference data - A matching Hospital (HOSP) or Service Unit Cluster (CLUS) was not found in the skeleton data | select State, RegId, OrgId, HospClusId, HOSPCLUS.HospClusName as name from HOSPCLUS left join ( select State, RegId, OrgId, HospId as HospClusId from skl.Hosp union select State, RegId, OrgId, ClusId as HospClusId from skl.Clus ) as skl_entity using (State, RegId, OrgId, HospClusId) left join skl.ORG as skl_parent using (State, RegId, OrgId) where skl_entity.HospClusId is null and skl_parent.OrgId is not null |
| HospInSklOnly | Skeleton | High | No | HospClus $skl_name.qt expected from SKL is missing | ORG | Hospital (HOSP) appears in skeleton data only - A Hospital / Cluster (HOSPCLUS) with matching Ids is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, HospClusId as skl_HospId, skl_entity.HospName as skl_name from ( select State, RegId, OrgId, HospName, HospId as HospClusId from skl.Hosp ) as skl_entity left join HOSPCLUS as checking using (State, RegId, OrgId, HospClusId) left join ORG as parent using (State, RegId, OrgId) where checking.HospClusId is null and parent.OrgId is not null |
| ClusInSklOnly | Skeleton | High | No | HospClus $skl_name.qt expected from SKL is missing | ORG | Service Unit Cluster (CLUS) appears in skeleton data only - A Hospital / Cluster (HOSPCLUS) with matching Ids is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, HospClusId as skl_ClusId, skl_entity.ClusName as skl_name from ( select State, RegId, OrgId, ClusName, ClusId as HospClusId from skl.Clus ) as skl_entity left join HOSPCLUS as checking using (State, RegId, OrgId, HospClusId) left join ORG as parent using (State, RegId, OrgId) where checking.HospClusId is null and parent.OrgId is not null |
| AdmiNotInSkl | Skeleton | High | No | Serv $name.qt not in SKL data | SERV | Service Unit not in skeleton reference data - A matching Admitted Patient Service Unit (ADMI) was not found in the skeleton data | select State, RegId, OrgId, HospClusId, SUId, SERV.SUName as name from SERV left join ( select State, RegId, OrgId, HospId as HospClusId, AdmiId as SUId from ADMI ) as skl_entity using (State, RegId, OrgId, HospClusId, SUId) left join ( select State, RegId, OrgId, HospId as HospClusId from skl.HOSP ) as skl_parent using (State, RegId, OrgId, HospClusId) where SUType = '1' and skl_entity.SUId is null and skl_parent.HospClusId is not null |
| AdmiInSklOnly | Skeleton | High | No | Serv $skl_name.qt expected from SKL is missing | HOSPCLUS | Admitted Patient Service Unit (ADMI) appears in skeleton data only - A Service Unit (SERV) with matching Ids is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, HospClusId, SUId as skl_AdmiId, skl_entity.AdmiName as skl_name from ( select State, RegId, OrgId, HospId as HospClusId, AdmiId as SUId, AdmiName from skl.Admi ) as skl_entity left join SERV as checking using (State, RegId, OrgId, HospClusId, SUId) left join HOSPCLUS as parent using (State, RegId, OrgId, HospClusId) where checking.SUId is null and parent.HospClusId is not null |
| ResiNotInSkl | Skeleton | High | No | Serv $name.qt not in SKL data | SERV | Service Unit not in skeleton reference data - A matching Residential Service Unit (RESI) was not found in the skeleton data | select State, RegId, OrgId, HospClusId, SUId, SERV.SUName as name from SERV left join ( select State, RegId, OrgId, ClusId as HospClusId, ResiId as SUId from RESI ) as skl_entity using (State, RegId, OrgId, HospClusId, SUId) left join ( select State, RegId, OrgId, ClusId as HospClusId from skl.CLUS ) as skl_parent using (State, RegId, OrgId, HospClusId) where SUType = '2' and skl_entity.SUId is null and skl_parent.HospClusId is not null |
| ResiInSklOnly | Skeleton | High | No | Serv $skl_name.qt expected from SKL is missing | HOSPCLUS | Residential Service Unit (RESI) appears in skeleton data only - A Service Unit (SERV) with matching Ids is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, HospClusId, SUId as skl_ResiId, skl_entity.ResiName as skl_name from ( select State, RegId, OrgId, ClusId as HospClusId, ResiId as SUId, ResiName from skl.Resi ) as skl_entity left join SERV as checking using (State, RegId, OrgId, HospClusId, SUId) left join HOSPCLUS as parent using (State, RegId, OrgId, HospClusId) where checking.SUId is null and parent.HospClusId is not null |
| OrgAmbuCANotInSkl | Skeleton | High | No | ORG Child and adolescent unit $name.qt not in SKL data | ORG | Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Child and adolescent age group in Ambulatory setting was not found in the skeleton data | select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuCA left join skl.OrgHasAmbuCA as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null |
| OrgAmbuCAInSklOnly | Skeleton | High | No | ORG Child and adolescent unit $skl_name.qt expected from SKL is missing | ORG | Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Child and adolescent in Ambulatory setting is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuCA left join OrgHasAmbuCA as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null |
| OrgAmbuOldNotInSkl | Skeleton | High | No | ORG Older person unit $name.qt not in SKL data | ORG | Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Older person age group in Ambulatory setting was not found in the skeleton data | select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuOld left join skl.OrgHasAmbuOld as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null |
| OrgAmbuOldInSklOnly | Skeleton | High | No | ORG Older person unit $skl_name.qt expected from SKL is missing | ORG | Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Older person in Ambulatory setting is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuOld left join OrgHasAmbuOld as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null |
| OrgAmbuForNotInSkl | Skeleton | High | No | ORG Forensic unit $name.qt not in SKL data | ORG | Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Forensic age group in Ambulatory setting was not found in the skeleton data | select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuFor left join skl.OrgHasAmbuFor as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null |
| OrgAmbuForInSklOnly | Skeleton | High | No | ORG Forensic unit $skl_name.qt expected from SKL is missing | ORG | Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Forensic in Ambulatory setting is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuFor left join OrgHasAmbuFor as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null |
| OrgAmbuGenNotInSkl | Skeleton | High | No | ORG General unit $name.qt not in SKL data | ORG | Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with General age group in Ambulatory setting was not found in the skeleton data | select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuGen left join skl.OrgHasAmbuGen as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null |
| OrgAmbuGenInSklOnly | Skeleton | High | No | ORG General unit $skl_name.qt expected from SKL is missing | ORG | Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with General in Ambulatory setting is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuGen left join OrgHasAmbuGen as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null |
| OrgAmbuYthNotInSkl | Skeleton | High | No | ORG Youth unit $name.qt not in SKL data | ORG | Organisation (ORG) not in skeleton reference data - A matching Organisation (ORG) with Youth age group in Ambulatory setting was not found in the skeleton data | select State, RegId, OrgId, ORG.OrgName as name from OrgHasAmbuYth left join skl.OrgHasAmbuYth as skl_entity using (State, RegId, OrgId) left join skl.OrgHasAmbu as skl_parent using (State, RegId, OrgId) join ORG using (State, RegId, OrgId) where skl_entity.OrgId is null and skl_parent.OrgId is not null |
| OrgAmbuYthInSklOnly | Skeleton | High | No | ORG Youth unit $skl_name.qt expected from SKL is missing | ORG | Organisation (CLUS) appears in skeleton data only - A matching Organisation (ORG) with Youth in Ambulatory setting is expected based on the SKL data but is not present in this file | select State, RegId, OrgId, skl_entity.OrgName as skl_name from skl.OrgHasAmbuYth left join OrgHasAmbuYth as checking using (State, RegId, OrgId) left join OrgHasAmbu as parent using (State, RegId, OrgId) join skl.ORG as skl_entity using (State, RegId, OrgId) where checking.OrgId is null and parent.OrgId is not null |