SEs 71420 and 79413D utilize a custom versioning application that does NOT replace claim lines with changes or replacements.
Action / Resolution
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.
Category 1
DSG
Category 2
Versioning
Tip / Issue
Tip
Example:
Claims
Claim Number (MC004)
Claim Line (MC005)
Paid Date (MC017)
Paid Amount (MC063)
Co-Pay (MC065)
Deductible (MC067)
Claim Status (MC138)
OEB000531711700
1
9/4/2018
$2,067.38
$0.00
$0.00
O
OEB000531711700
1
2/28/2019
$(2,067.38)
$0.00
$0.00
A
Claim Line Total
$0.00
$0.00
$0.00
OEB001380589000
13
9/12/2019
$3,711.55
$200.00
$0.00
O
OEB001380589000
13
11/26/2019
$(3,711.55)
$(200.00)
$0.00
A
Claim Line Total
$0.00
$0.00
$0.00
ATL000000359800
1
5/7/2020
$(38.90)
$0.00
$0.00
A
ATL000000359800
1
1/23/2020
$ 73.94
$40.00
$0.00
O
Claim Line Total
$35.04
$40.00
$0.00
ATL002502087200
1
2/6/2020
$0.49
$0.00
$49.28
O
ATL002502087200
1
4/13/2020
$(0.49)
$0.00
$(49.28)
A
Claim Line Total
$0.00
$0.00
$0.0
OEB000476134000
12
8/3/2018
$1,575.14
$200.00
$279.90
O
OEB000476134000
12
10/11/2018
$(1575.14)
$(200.00)
$(279.90)
A
Claim Line Total
$0.00
$0.00
$0.00
No labels
0 Comments
You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.
0 Comments