01/27/2021
|
3.0.0 |
RULE-7200
|
UPDATE |
Data Dictionary - Validation Rules |
if CLAIM-HEADER-RECORD-OT.CLAIM-STATUS-CATEGORY does not equal 'F2' and CLAIM-HEADER-RECORD-OT.CLAIM-DENIED-INDICATOR does not equal '0' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM is not equal to one of the following: 'Z' and CLAIM-HEADER-RECORD-OT.CLAIM-STATUS is not equal to one of the following: '26', '026', '87', '087', '542', '585', '654' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM is equal to one of the following: '3', 'C', 'W', '2', 'B', 'V' and CLAIM-HEADER-RECORD-OT has a valid, non-null value for PLAN-ID-NUMBER, then for every record of type CLAIM-HEADER-RECORD-OT, there must be a valid record of type MANAGED-CARE-MAIN that matches on the join keys and CLAIM-HEADER-RECORD-OT.BEGINNING-DATE-OF-SERVICE must be in (MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-EFF-DATE, MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-END-DATE) |
if CLAIM-HEADER-RECORD-OT.CLAIM-STATUS-CATEGORY does not equal 'F2' and CLAIM-HEADER-RECORD-OT.CLAIM-DENIED-INDICATOR does not equal '0' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM is not equal to one of the following: 'Z' and CLAIM-HEADER-RECORD-OT.CLAIM-STATUS is not equal to one of the following: '26', '026', '87', '087', '542', '585', '654', '686' and CLAIM-HEADER-RECORD-OT.ADJUSTMENT-IND is not equal to '1' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM is equal to one of the following: '3', 'C', 'W', '2', 'B', 'V' and CLAIM-HEADER-RECORD-OT has a valid, non-null value for PLAN-ID-NUMBER, then for every record of type CLAIM-HEADER-RECORD-OT, there must be a valid record of type MANAGED-CARE-MAIN that matches on the join keys and CLAIM-HEADER-RECORD-OT.BEGINNING-DATE-OF-SERVICE must be in (MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-EFF-DATE, MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-END-DATE) |
08/05/2022
|
3.0.1 |
RULE-7200
|
UPDATE |
Data Dictionary - Validation Rules |
if CLAIM-HEADER-RECORD-OT.CLAIM-STATUS-CATEGORY does not equal 'F2' and CLAIM-HEADER-RECORD-OT.CLAIM-DENIED-INDICATOR does not equal '0' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM is not equal to one of the following: 'Z' and CLAIM-HEADER-RECORD-OT.CLAIM-STATUS is not equal to one of the following: '26', '026', '87', '087', '542', '585', '654', '686' and CLAIM-HEADER-RECORD-OT.ADJUSTMENT-IND does not equal '1' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM is equal to one of the following: '3', 'C', 'W', '2', 'B', 'V' and CLAIM-HEADER-RECORD-OT has a valid, non-null value for PLAN-ID-NUMBER, then for every record of type CLAIM-HEADER-RECORD-OT, there must be a valid record of type MANAGED-CARE-MAIN that matches on the join keys and CLAIM-HEADER-RECORD-OT.BEGINNING-DATE-OF-SERVICE must be in (MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-EFF-DATE, MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-END-DATE) |
if CLAIM-HEADER-RECORD-OT.CLAIM-STATUS-CATEGORY does not equal 'F2' and CLAIM-HEADER-RECORD-OT.CLAIM-DENIED-INDICATOR does not equal '0' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM does not equal 'Z' and CLAIM-HEADER-RECORD-OT.CLAIM-STATUS is not equal to one of the following: '26', '026', '87', '087', '542', '585', '654', '686' and CLAIM-HEADER-RECORD-OT.ADJUSTMENT-IND does not equal '1' and CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM is equal to one of the following: '3', 'C', 'W' and CLAIM-HEADER-RECORD-OT has a valid, non-null value for PLAN-ID-NUMBER, then for every record of type CLAIM-HEADER-RECORD-OT, there must be a valid record of type MANAGED-CARE-MAIN that matches on the join keys and CLAIM-HEADER-RECORD-OT.BEGINNING-DATE-OF-SERVICE must be in (MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-EFF-DATE, MANAGED-CARE-MAIN.MANAGED-CARE-CONTRACT-END-DATE) |
08/30/2018
|
2.3.0 |
RULE-7200
|
UPDATE |
Data Dictionary - Validation Rules |
if (CLAIM-HEADER-RECORD-OT.CLAIM-STATUS-CATEGORY does not equal 'F2' AND CLAIM-HEADER-RECORD-OT.CLAIM-DENIED-INDICATOR does not equal to '0' AND CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM NOT IN (Z) AND CLAIM-HEADER-RECORD-OT.CLAIM-STATUS NOT IN (("26","026","87","087", "542","585", "654")) AND CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM IN (3, C, W, 2, B, V) AND CLAIM-HEADER-RECORD-OT.PLAN-ID-NUMBER has non null value then for every record of type CLAIM-HEADER-RECORD-OT, there must be a valid record of type MANAGED-CARE-PARTICIPATION-ELG00014 that matches on the join keys (CLAIM-HEADER-RECORD-OT.SUBMITTING-STATE, CLAIM-HEADER-RECORD-OT.PLAN-ID-NUMBER with MANAGED-CARE-MAIN-MCR00002.SUBMITTING-STATE, MANAGED-CARE-MAIN-MCR00002.STATE-PLAN-ID-NUM) AND CLAIM-HEADER-RECORD-OT.BEGINING-DATE-OF-SERVICE BETWEEN MANAGED-CARE-MAIN-MCR00002.MANAGED-CARE-CONTRACT-EFF-DATE and MANAGED-CARE-MAIN-MCR00002.MANAGED-CARE-CONTRACT-END-DATE Note: See Tab 'DateRangeValidationCriteria' for date range criteria in detail |
N/A |
08/17/2018
|
2.3.0 |
RULE-7200
|
ADD |
Data Dictionary - Validation Rules |
N/A |
if (CLAIM-HEADER-RECORD-OT.CLAIM-STATUS-CATEGORY does not equal 'F2' AND CLAIM-HEADER-RECORD-OT.CLAIM-DENIED-INDICATOR does not equal to '0' AND CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM NOT IN (Z) AND CLAIM-HEADER-RECORD-OT.CLAIM-STATUS NOT IN (("26","026","87","087", "542","585", "654")) AND CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM IN (3, C, W, 2, B, V) AND CLAIM-HEADER-RECORD-OT.PLAN-ID-NUMBER has non null value then for every record of type CLAIM-HEADER-RECORD-OT, there must be a valid record of type MANAGED-CARE-PARTICIPATION-ELG00014 that matches on the join keys (CLAIM-HEADER-RECORD-OT.SUBMITTING-STATE, CLAIM-HEADER-RECORD-OT.PLAN-ID-NUMBER with MANAGED-CARE-MAIN-MCR00002.SUBMITTING-STATE, MANAGED-CARE-MAIN-MCR00002.STATE-PLAN-ID-NUM) AND CLAIM-HEADER-RECORD-OT.BEGINING-DATE-OF-SERVICE BETWEEN MANAGED-CARE-MAIN-MCR00002.MANAGED-CARE-CONTRACT-EFF-DATE and MANAGED-CARE-MAIN-MCR00002.MANAGED-CARE-CONTRACT-END-DATE Note: See Tab 'DateRangeValidationCriteria' for date range criteria in detail |
11/23/2018
|
2.3.0 |
RULE-7200
|
UPDATE |
Data Dictionary - Validation Rules |
N/A |
if (CLAIM-HEADER-RECORD-OT.CLAIM-STATUS-CATEGORY does not equal 'F2' AND CLAIM-HEADER-RECORD-OT.CLAIM-DENIED-INDICATOR does not equal to '0' AND CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM NOT IN (Z) AND CLAIM-HEADER-RECORD-OT.CLAIM-STATUS NOT IN (("26","026","87","087", "542","585", "654")) AND CLAIM-HEADER-RECORD-OT.TYPE-OF-CLAIM IN (3, C, W, 2, B, V) AND CLAIM-HEADER-RECORD-OT.PLAN-ID-NUMBER has non null value; then for every record of type CLAIM-HEADER-RECORD-OT, there must be a valid record of type MANAGED-CARE-PARTICIPATION-ELG00014 that matches on the join keys (CLAIM-HEADER-RECORD-OT.SUBMITTING-STATE, CLAIM-HEADER-RECORD-OT.PLAN-ID-NUMBER with MANAGED-CARE-MAIN-MCR00002.SUBMITTING-STATE, MANAGED-CARE-MAIN-MCR00002.STATE-PLAN-ID-NUM) AND CLAIM-HEADER-RECORD-OT.BEGINING-DATE-OF-SERVICE BETWEEN MANAGED-CARE-MAIN-MCR00002.MANAGED-CARE-CONTRACT-EFF-DATE and MANAGED-CARE-MAIN-MCR00002.MANAGED-CARE-CONTRACT-END-DATE |