To find total costs for the claim, all claim lines must be aggregated. The user would sum all values in the cost fields across all rows with the same claim number (MC004) and claim line (MC005) to get total claim line cost. The example below illustrates this approach. Claim line 1 for claim OEB00053171 has two rows, one with paid date 9/4/2018 and the second with paid date 2/28/2019. The paid amount for the claim line where paid date = 9/4/2019 is $2067.38. The paid amount for the claim line where paid date = 2/28/2019 is ($2067.38). Sum these two paid amounts to get the overall claim line paid amount of $0.00. Claim status (MC138) appears to indicate adjustments however it cannot be relied upon consistently to indicate adjustments. The same approach should be used for all $ fields. The example below includes co-pay and deductible, too. |