ClaimPaymentDetai
This table holds information about payments for AP Claims. Payment information is stored once the claim is sent to AP and subsequently updated with check information once the claim is batched. Therefore, and other columns populated after batching such as AP_BATCH_RUN_CSN_ID, may be . If reporting on amounts paid by checks only, you should filter on whether and amount columns are . When a claim is sent to AP, this table contains one row per responsibility class for the claim without CHECK_IDs. If the claim is batched for a responsibility class, the table is updated to contain one row per claim per responsibility class per check plus the rows for any responsibility classes that remained unbatched. Once a claim is paid in full, all rows will have populated. The other scenario that is important to consider arises because amounts may be if the claim was associated with a check, but no amount was paid. For example, if a reversal claim and its adjustment are batched separately, the reversal claim will have a row with amounts for the adjustment claim's check and vice versa.
| Column Name | Type | Description |
|---|---|---|
| ClaimServiceAllowedAmount | NUMERIC | The total allowed amount of the services paid by this check. |
| ClaimInterestCalculationIndicator | VARCHAR | Stores an indicator to identify that an interest computation was done for the claim as part of the check on the current line of data. |
| ClaimPaymentCheckIdentifier | NUMERIC | The unique check ID that was used to pay this claim. |
| TotalBilledAmountForService | NUMERIC | The total billed amount of the services paid by this check. |
| ClaimCheckInterestAmount | NUMERIC | The amount on the check that corresponds to the interest amount on this claim. |
| CommunityLogicalOwnerIdentifier | VARCHAR | The Community ID (CID) of the instance from which this record or line was extracted. This is only populated if you use IntraConnect. |
| AccountsPayableBatchRunContactSerialNumber | NUMERIC | The link to the AP batch run that created the check. |
| ServiceQuantityPaidByCheck | INTEGER | The count of services paid by this check. |
| ClaimPenaltyCheckAmount | NUMERIC | The amount on the check that corresponds to the portion of the penalty amount on this claim. |
| ClaimInformationLineNumber | INTEGER | The line number for the information associated with this record (claim). Multiple pieces of information can be associated with this record. |
| ClaimIdentifier | NUMERIC | The unique identifier (.1 item) for the claim info record. |
| ResponsibilityClassIdentifier | NUMERIC | The ID for the responsibility class that was used to pay this claim. |
| CheckNetPayableAmount | NUMERIC | The amount on the check that corresponds to the portion of the net payable amount for this claim. |
| IntraConnectOwningInstanceIdentifier | VARCHAR | The Community ID (CID) of the instance that owns this record or line. This is only populated if you use IntraConnect. |
| CheckTotalAmount | NUMERIC | The amount on the check that corresponds to this claim (net payable + interest + penalty). |
| AccountsPayableStatusCategory | INTEGER | The AP status for the current line's payment info. |