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