Subsequently All Withhold Claim
This use case shows the financial transactions and the financial messages that would be created for an invoiced claim that only has covered coverages and after adjustments only withhold coverages.
Summary
-
Version 1 ` Financial message includes; `* an invoice to fully pay the covered amount of the claim `* accounting details for all coverages of the claim
-
Version 2 ` Financial message includes; `* an invoice to fully reverse the covered amount of version 1 of the claim `* accounting details to fully reverse all coverages of version 1 of the claim `* accounting details to account for the full withhold of the 2nd version
Version 1
Adjudicate Claim
The claim is adjudicated resulting in the following details in Claims:
-
$110.00 Coverage
- Working Copy Claim
Code |
Person Code |
Provider Code |
Total Claimed Amount |
Total Covered Amount |
CL444 |
456 |
789AB |
110.00 |
110.00 |
- Working Copy Claim Lines
| Sequence | Payment Receiver | Allowed Amount | Action | Amount | Label |
|---|---|---|---|---|---|
1 |
789AB |
50.00 |
Covered |
50.00 |
Covered |
2 |
789AB |
60.00 |
Covered |
60.00 |
Covered |
Finalize (First Time)
The claim is finalized for the first time on 12 March 2014. The following are created at the same time:
-
First version claim transaction
-
A financial transaction with a Base Financial Object
Claim Transaction
The claim transaction has the following details.
- CTR Claim
| Claim Transaction Code | Version | Transaction Date | Person Code | Provider Code | Total Allowed Amount | Total Covered Amount | Reversal Ind |
|---|---|---|---|---|---|---|---|
CL444 |
1 |
12-Mar-2014 |
456 |
789AB |
110.00 |
110.00 |
N |
- CTR Claim Line ⇒ Coverages
| Claim Transaction Code | Reversal Ind | Version | Claim Line Transaction Code | Allowed Amount | ⇒ | Action | Label | Amount |
|---|---|---|---|---|---|---|---|---|
CL444 |
N |
1 |
1 |
50.00 |
Covered |
Covered |
50.00 |
|
2 |
60.00 |
Covered |
Covered |
60.00 |
Financial Transaction
The financial transaction has the following details:
- Base Financial Object
| Type | Claim code | Status |
|---|---|---|
CLA |
CL444 |
IN |
- Financial Transaction and Financial Transaction Process Data
| Version | Processing Type | Reversal? | Creation Date | Total Amount | ⇒ | Due Date | Financial Message Mandatory | Financial Message Bulking Group | Financial Message ID | Financial Message Result |
|---|---|---|---|---|---|---|---|---|---|---|
1 |
Regular |
N |
12-Mar-2014 |
$110.00 |
25-Mar-2014 |
N |
CL444 |
null |
null |
- Financial Transaction Detail and Financial Transaction Detail Process Data
| Version | Reversal | Claim Line Code | Component Code | Amount | ⇒ | Invoice Indicator | Invoice Line Grouping | Accounting Detail Grouping | Payment Receiver | |
|---|---|---|---|---|---|---|---|---|---|---|
1 |
N |
1 |
Covered |
50.00 |
Y |
N |
N |
789AB |
Create Financial Messages
The financial messages are created on 14 March 2014. The claim is still in status Finalized. A financial message will be created:
-
The message is just for the claim (because Financial Message Bulking Group is set to the claim code)
-
It will have a single invoice
-
It will have a separate invoice line for each financial transaction detail that has its invoice indicator set
-
It will have a separate accounting detail for each of the financial transaction detail
Financial Message
The contents of the various parts of the financial message are as follows:
- Financial Message Table
| Job ID | Message Date | Message Bulking Group |
|---|---|---|
132432 |
14-Mar-2014 |
CL444 |
- Financial Message - Invoice
| ID | Invoice Type | Vendor Num | Invoice Amount | Attribute 1 (CTR Claim Code) | Attribute 2 (CTR Version) |
|---|---|---|---|---|---|
89070 |
Standard |
789AB |
110.00 |
CL444 |
1 |
- Financial Message - Invoice Line
| ID | Line Number | Line Type | Amount | Attribute 1 (CTR Claim Code) | Attribute 2 (CTR Version) | Attribute 3 (Reversal Indicator) | Attribute 4 (CTR Claim Line Code) |
|---|---|---|---|---|---|---|---|
123572 |
1 |
ITEM |
50 |
CL444 |
1 |
N |
1 |
123573 |
2 |
ITEM |
60 |
CL444 |
1 |
N |
2 |
- Financial Message - Accounting Detail
| ID | Ledger ID | Accounting Date | Amount | Attribute 1 (CTR Claim Code) | Attribute 2 (CTR Version) | Attribute 3 (Reversal Indicator) | Attribute 4 (CTR Claim Line Code) | Attribute 5 (Component Code) |
|---|---|---|---|---|---|---|---|---|
8719048 |
32423432 |
14-Mar-2014 |
50 |
CL444 |
1 |
N |
1 |
COVERED |
8719050 |
32423432 |
14-Mar-2014 |
60 |
CL444 |
1 |
N |
2 |
COVERED |
Financial Transaction Process Data
In addition, the following financial transaction process data columns are set. These fields provide information back on the financial transaction to make visible which message the transaction is included in.
| Claim Transaction Code | Version Code | Reversal | ⇒ | Financial Message Handled Datetime | Financial Message ID | Financial Message Result |
|---|---|---|---|---|---|---|
CL444 |
1 |
N |
14-Mar-2014 |
132432 |
M |
Financial Transaction Detail Process Data
The following financial message transaction detail process data columns are set. These fields provide information back on the financial transaction detail to make visible which invoice line and accounting detail the transaction detail has been included in.
| Claim Transaction Code | Version Code | Claim Line Transaction | ⇒ | Invoice ID | Invoice Line ID | Accounting Detail ID |
|---|---|---|---|---|---|---|
CL444 |
1 |
1 |
89070 |
123572 |
8719048 |
|
CL444 |
1 |
2 |
89070 |
123573 |
8719050 |
Version 2
Unfinalize Claim
The claim is unfinalized on 16 March 2014 making the working copy of it available for changing and readjudication. When unfinalizing the following occurs:
-
Version 1 of the CTR Claim (transaction) is labeled as unfinalized
-
A reversal CTR Claim (transaction) for version 1 is created with the allowed and covered amounts reversed
-
A reversal Financial Transaction for version 1 is created with allowed and covered amounts reversed. It will be associated with the base financial object created when the claim was first finalized.
These reversals are shown below.
Adjust Claim
The claim is adjusted resulting in both claim lines being withhold due to deductible limits being applied. It now has the following details in Claims:
-
Claim line 1; $0 covered, $50.00 withhold
-
Claim line 2: $0 covered, $60.00 withhold
- Claim
Code |
Person Code |
Provider Code |
Total Claimed Amount |
Total Covered Amount |
123 |
456 |
789AB |
110.00 |
0.00 |
- Claim Line ⇒ Coverages
| Sequence | Payment Receiver | Claimed Amount | ⇒ | Action | Amount | Label |
|---|---|---|---|---|---|---|
1 |
789AB |
50.00 |
Covered |
50.00 |
Covered |
|
|
|
|
||||
2 |
789AB |
60.00 |
Covered |
60.00 |
Covered |
|
|
|
|
Finalize (Second Time)
The claim is finalized for the second time on 20 March 2014. The following are created:
-
A second version claim transaction
-
A second version financial transaction
CTR Claim Transaction
- CTR Claim (Transaction)
| Claim Transaction Code | Version | Transaction Date | Person Code | Provider Code | Total Allowed Amount | Total Covered Amount | Reversal Indicator |
|---|---|---|---|---|---|---|---|
CL444 |
1 |
12-Mar-2014 |
456 |
789AB |
110.00 |
110.00 |
N |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- CTR Claim Line ⇒ Coverages
| Claim Transaction Code | Reversal Indicator | Version | Claim Line Transaction Code | Allowed Amount | ⇒ | Action | Label | Amount |
|---|---|---|---|---|---|---|---|---|
CL444 |
N |
1 |
1 |
50.00 |
Covered |
Covered |
50.00 |
|
2 |
60.00 |
Covered |
Covered |
60.00 |
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
||||
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financial Transaction
The reversal financial transaction which is created when unfinalizing the claim is depicted below.
- Financial Transaction and Financial Transaction Process Data
| Version | Processing Type | Reversal? | Creation Date | Total Amount | ⇒ | Due Date | Financial Message Mandatory | Financial Message Bulking Group | Financial Message ID | Financial Message Result |
|---|---|---|---|---|---|---|---|---|---|---|
1 |
Regular |
N |
12-Mar-2014 |
$110.00 |
25-Mar-2014 |
N |
CL444 |
132432 |
M |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
- Financial Transaction Detail and Financial Transaction Detail Process Data
| Version | Reversal? | ⇒ | Claim Line Code | Component Code | Amount | ⇒ | Invoice Indicator | Invoice Line Grouping | Accounting Detail Grouping | Payment Receiver |
|---|---|---|---|---|---|---|---|---|---|---|
1 |
N |
1 |
Covered |
50.00 |
Y |
N |
N |
789AB |
||
2 |
Covered |
60.00 |
Y |
N |
N |
789AB |
||||
|
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
||||
|
|
|
|
|
|
|
|
|
||
|
|
|
|
|
|
|
Create Financial Messages
The financial messages are created on 22 March 2014. The working copy claim has not been unfinalized. A financial message is created with the following details:
-
An invoice with a negative invoice amount offsetting the previous invoice
-
Negative invoice lines for each of the claim lines
-
Both the financial transaction details of the current version and the financial details of the reversal details are included in the financial message
Financial Message
The contents of the various parts of the financial message are as follows:
- Financial Message Table
| Job ID | Message Date | Message Bulking Criteria |
|---|---|---|
132732 |
22-Mar-2014 |
CL444 |
- Financial Message - Invoice
| ID | Invoice Type | Vendor Num | Invoice Amount | Attribute 1 (CTR Claim Code) | Attribute 2 (CTR Version) |
|---|---|---|---|---|---|
89171 |
Standard |
789AB |
-110.00 |
CL444 |
2 |
- Financial Message - Invoice Line
| ID | Line Number | Line Type | Amount | Attribute 1 (CTR Claim Code) | Attribute 2 (CTR Version) | Attribute 3 (Reversal) | Attribute 4 (CTR Claim Line Code) |
|---|---|---|---|---|---|---|---|
123574 |
1 |
ITEM |
-50 |
CL444 |
1 |
Y |
1 |
123575 |
2 |
ITEM |
-60 |
CL444 |
1 |
Y |
2 |
- Financial Message - Accounting Detail
| ID | Ledger ID | Accounting Date | Amount | Attribute 1 (CTR Claim Code) | Attribute 2 (CTR Version) | Attribute 3 (Reversal) | Attribute 4 (CTR Claim Line Code) | Attribute 5 (Component Code) |
|---|---|---|---|---|---|---|---|---|
8719051 |
32423432 |
22-Mar-2014 |
-50 |
CL444 |
1 |
Y |
1 |
COVERED |
8719053 |
32423432 |
22-Mar-2014 |
-60 |
CL444 |
1 |
Y |
2 |
COVERED |
8719154 |
32423432 |
22-Mar-2014 |
50 |
CL444 |
2 |
N |
1 |
DEDUCTIBLE |
8719156 |
32423432 |
22-Mar-2014 |
60 |
CL444 |
2 |
N |
2 |
DEDUCTIBLE |
Financial Transaction Process Data
In addition, the following financial transaction process data columns is set.
| Claim Transaction Code | Version Code | Reversal | ⇒ | Financial Message Datetime | Financial Message ID | Financial Message Result |
|---|---|---|---|---|---|---|
CL444 |
1 |
N |
14-Mar-2014 |
132432 |
M |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Financial Transaction Detail Process Data
The following financial message transaction detail process data columns are set.
| Claim Transaction Code | Reversal | Version Code | Claim Line Transaction | ⇒ | Invoice ID | Invoice Line ID | Accounting Detail ID |
|---|---|---|---|---|---|---|---|
CL444 |
N |
1 |
1 |
89070 |
123572 |
8719048 |
|
CL444 |
N |
1 |
2 |
89070 |
123573 |
8719050 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|||
|
|
|
|
|