| 11/20/2025 |
4.0.22 |
ALL-17-001-1 |
UPDATE |
Specification |
STEP 1: Active paid IP claims during DQ report monthDefine the IP claims universe at the header level by importing both headers and lines that satisfy the following criteria:1a. Limit to Report MonthReporting Period from the filename = DQ report month1b. Join Headers and LinesMerge headers and lines using: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJUSTMENT-IND, and keep all claims, even if there is no match1c. Keep headers and associated lines if header is not denied1. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing2. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing3. TYPE-OF-CLAIM is not equal to "Z" or is missing4. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing1d. Drop Header DuplicatesDuplicates are dropped at the header level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND.1e. Keep line if line is not denied1. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missingSTEP 2: Childless headersOf the claim headers that meet the criteria from STEP 1, keep claim headers that did not merge to any claim lineSTEP 3: Calculate percentageDivide the count of claim headers from STEP 2 by the count of claim headers from STEP 1 |
N/A |
| 08/13/2025 |
4.0.16 |
ALL-17-001-1 |
UPDATE |
Specification |
STEP 1: Active paid IP claims during DQ report monthDefine the IP claims universe at the header level by importing both headers and lines that satisfy the following criteria:1a. Limit to Report MonthReporting Period from the filename = DQ report month1b. Join Headers and LinesMerge headers and lines using: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJSTMT-IND, and keep all claims, even if there is no match1c. Keep headers and associated lines if header is not denied1. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing2. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing3. TYPE-OF-CLAIM is not equal to "Z" or is missing4. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing1d. Drop Header DuplicatesDuplicates are dropped at the header level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND.1e. Keep line if line is not denied1. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missingSTEP 2: Childless headersOf the claim headers that meet the criteria from STEP 1, keep claim headers that did not merge to any claim lineSTEP 3: Calculate percentageDivide the count of claim headers from STEP 2 by the count of claim headers from STEP 1 |
STEP 1: Active paid IP claims during DQ report monthDefine the IP claims universe at the header level by importing both headers and lines that satisfy the following criteria:1a. Limit to Report MonthReporting Period from the filename = DQ report month1b. Join Headers and LinesMerge headers and lines using: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND=LINE-ADJUSTMENT-IND, and keep all claims, even if there is no match1c. Keep headers and associated lines if header is not denied1. CLAIM-STATUS-CATEGORY is not equal to "F2" or is missing2. CLAIM-DENIED-INDICATOR is not equal to "0" or is missing3. TYPE-OF-CLAIM is not equal to "Z" or is missing4. CLAIM-STATUS is not equal to ("26","026","87","087","542","585", "654") or is missing1d. Drop Header DuplicatesDuplicates are dropped at the header level, if the following four data elements are the same: ICN-ORIG, ICN-ADJ, ADJUDICATION-DATE, and ADJUSTMENT-IND.1e. Keep line if line is not denied1. CLAIM-LINE-STATUS is not equal to ("26","026","87","087","542","585","654") or is missingSTEP 2: Childless headersOf the claim headers that meet the criteria from STEP 1, keep claim headers that did not merge to any claim lineSTEP 3: Calculate percentageDivide the count of claim headers from STEP 2 by the count of claim headers from STEP 1 |