02/05/2021
|
3.0.0 |
RULE-689
|
UPDATE |
Data Dictionary - Validation Rules |
if CLAIM-HEADER-RECORD-IP.CLAIM-STATUS-CATEGORY does not equal 'F2' and CLAIM-HEADER-RECORD-IP.CLAIM-DENIED-INDICATOR does not equal '0' and CLAIM-HEADER-RECORD-IP.TYPE-OF-CLAIM is not equal to one of the following: 'Z', '3', 'C', 'W', '2', 'B', 'V', '4', 'D', 'X' and CLAIM-HEADER-RECORD-IP.CLAIM-STATUS is not equal to one of the following: '26', '026', '87', '087', '542', '585', '654' and CLAIM-HEADER-RECORD-IP has a valid, non-null value for BILLING-PROV-NUM, then for every record of type CLAIM-HEADER-RECORD-IP, ((there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys where PROV-IDENTIFIERS.PROV-IDENTIFIER-TYPE equals '1' and CLAIM-HEADER-RECORD-IP has a null value for DISCHARGE-DATE or CLAIM-HEADER-RECORD-IP.DISCHARGE-DATE must be in (PROV-IDENTIFIERS.PROV-IDENTIFIER-EFF-DATE, PROV-IDENTIFIERS.PROV-IDENTIFIER-END-DATE)) OR (there must be a valid record of type PROV-ATTRIBUTES-MAIN that matches on the join keys and CLAIM-HEADER-RECORD-IP has a null value for DISCHARGE-DATE or CLAIM-HEADER-RECORD-IP.DISCHARGE-DATE must be in (PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-EFF-DATE, PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-END-DATE))) |
if CLAIM-HEADER-RECORD-IP.CLAIM-STATUS-CATEGORY does not equal 'F2' and CLAIM-HEADER-RECORD-IP.CLAIM-DENIED-INDICATOR does not equal '0' and CLAIM-HEADER-RECORD-IP.CLAIM-STATUS is not equal to one of the following: '26', '026', '87', '087', '542', '585', '654' and CLAIM-HEADER-RECORD-IP has a valid, non-null value for BILLING-PROV-NUM, then for every record of type CLAIM-HEADER-RECORD-IP, ((there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys where PROV-IDENTIFIERS.PROV-IDENTIFIER-TYPE equals '1' and CLAIM-HEADER-RECORD-IP has a null value for DISCHARGE-DATE or CLAIM-HEADER-RECORD-IP.DISCHARGE-DATE must be in (PROV-IDENTIFIERS.PROV-IDENTIFIER-EFF-DATE, PROV-IDENTIFIERS.PROV-IDENTIFIER-END-DATE)) OR (there must be a valid record of type PROV-ATTRIBUTES-MAIN that matches on the join keys and CLAIM-HEADER-RECORD-IP has a null value for DISCHARGE-DATE or CLAIM-HEADER-RECORD-IP.DISCHARGE-DATE must be in (PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-EFF-DATE, PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-END-DATE))) |
08/30/2018
|
2.3.0 |
RULE-689
|
UPDATE |
Data Dictionary - Validation Rules |
if (CLAIM-HEADER-RECORD-IP.CLAIM-STATUS-CATEGORY does not equal 'F2' AND CLAIM-HEADER-RECORD-IP.CLAIM-DENIED-INDICATOR does not equal to '0' AND CLAIM-HEADER-RECORD-IP.TYPE-OF-CLAIM NOT IN ('Z','3','C','W',"2","B","V"," 4","D","X") AND CLAIM-HEADER-RECORD-IP.CLAIM-STATUS NOT IN ("26","026","87","087","542","585", "654")) AND CLAIM-HEADER-RECORD-IP has a valid, non-null value for BILLING-PROV-NUM
then for every record of type CLAIM-HEADER-RECORD-IP,
((there must be a valid record of type PROV-ATTRIBUTES-MAIN that matches on the join keys (CLAIM-HEADER-RECORD-RX.SUBMITTING-STATE,CLAIM-HEADER-RECORD-IP.BILLING-PROV-NUM with PROV-ATTRIBUTES-MAIN.SUBMITTING-STATE,PROV-ATTRIBUTES-MAIN. SUBMITTING-STATE-PROV-ID ) AND CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE must in (PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-EFF-DATE, PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-END-DATE))
OR
(there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys ((CLAIM-HEADER-RECORD-IP.SUBMITTING-STATE,CLAIM-HEADER-RECORD-IP.BILLING-PROV-NUM with PROV-ATTRIBUTES-MAIN.SUBMITTING-STATE,PROV-ATTRIBUTES-MAIN.PROV-IDENTIFIER )), where PROV-IDENTIFIERS.PROV-IDENTIFIER-TYPE equals '1') AND CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE must in (PROV_IDENTIFIER_EFF_DATE, PROV_IDENTIFIER_END_DATE)))
Note: If CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE is NULL Then rule should not trigger. |
N/A |
08/03/2018
|
2.3.0 |
RULE-689
|
ADD |
Data Dictionary - Validation Rules |
N/A |
if (CLAIM-HEADER-RECORD-IP.CLAIM-STATUS-CATEGORY does not equal 'F2' AND CLAIM-HEADER-RECORD-IP.CLAIM-DENIED-INDICATOR does not equal to '0' AND CLAIM-HEADER-RECORD-IP.TYPE-OF-CLAIM NOT IN ('Z','3','C','W',"2","B","V"," 4","D","X") AND CLAIM-HEADER-RECORD-IP.CLAIM-STATUS NOT IN ("26","026","87","087","542","585", "654")) AND CLAIM-HEADER-RECORD-IP has a valid, non-null value for BILLING-PROV-NUM
then for every record of type CLAIM-HEADER-RECORD-IP,
((there must be a valid record of type PROV-ATTRIBUTES-MAIN that matches on the join keys (CLAIM-HEADER-RECORD-RX.SUBMITTING-STATE,CLAIM-HEADER-RECORD-IP.BILLING-PROV-NUM with PROV-ATTRIBUTES-MAIN.SUBMITTING-STATE,PROV-ATTRIBUTES-MAIN. SUBMITTING-STATE-PROV-ID ) AND CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE must in (PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-EFF-DATE, PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-END-DATE))
OR
(there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys ((CLAIM-HEADER-RECORD-IP.SUBMITTING-STATE,CLAIM-HEADER-RECORD-IP.BILLING-PROV-NUM with PROV-ATTRIBUTES-MAIN.SUBMITTING-STATE,PROV-ATTRIBUTES-MAIN.PROV-IDENTIFIER )), where PROV-IDENTIFIERS.PROV-IDENTIFIER-TYPE equals '1') AND CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE must in (PROV_IDENTIFIER_EFF_DATE, PROV_IDENTIFIER_END_DATE)))
Note: If CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE is NULL Then rule should not trigger. |
12/21/2018
|
2.3.0 |
RULE-689
|
UPDATE |
Data Dictionary - Validation Rules |
N/A |
if (CLAIM-HEADER-RECORD-IP.CLAIM-STATUS-CATEGORY does not equal 'F2' AND CLAIM-HEADER-RECORD-IP.CLAIM-DENIED-INDICATOR does not equal to '0' AND CLAIM-HEADER-RECORD-IP.TYPE-OF-CLAIM NOT IN ('Z','3','C','W',"2","B","V"," 4","D","X") AND CLAIM-HEADER-RECORD-IP.CLAIM-STATUS NOT IN ("26","026","87","087","542","585", "654")) AND CLAIM-HEADER-RECORD-IP has a valid, non-null value for BILLING-PROV-NUM then for every record of type CLAIM-HEADER-RECORD-IP, ((there must be a valid record of type PROV-ATTRIBUTES-MAIN that matches on the join keys (CLAIM-HEADER-RECORD-RX.SUBMITTING-STATE,CLAIM-HEADER-RECORD-IP.BILLING-PROV-NUM with PROV-ATTRIBUTES-MAIN.SUBMITTING-STATE,PROV-ATTRIBUTES-MAIN. SUBMITTING-STATE-PROV-ID ) AND CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE must in (PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-EFF-DATE, PROV-ATTRIBUTES-MAIN.PROV-ATTRIBUTES-END-DATE)) OR (there must be a valid record of type PROV-IDENTIFIERS that matches on the join keys ((CLAIM-HEADER-RECORD-IP.SUBMITTING-STATE,CLAIM-HEADER-RECORD-IP.BILLING-PROV-NUM with PROV-ATTRIBUTES-MAIN.SUBMITTING-STATE,PROV-ATTRIBUTES-MAIN.PROV-IDENTIFIER )), where PROV-IDENTIFIERS.PROV-IDENTIFIER-TYPE equals '1') AND CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE must in (PROV_IDENTIFIER_EFF_DATE, PROV_IDENTIFIER_END_DATE))) Note: If CLAIM-HEADER-RECORD-IP.DISCHARGE_DATE is NULL Then rule should not trigger. |