AP_CLAIMS_BUNDLE_LEDGER
Description:
This table is used to represent bundled episode ledgers which contain information about the services linked to episodes.

Primary Key
Column Name Ordinal Position
EPISODE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 EPISODE_ID NUMERIC No
The unique identifier for the episode record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 BND_AMOUNT NUMERIC No
The amount by which a transaction updated the bundle ledger. This could be either a contribution or an adjustment.
4 BND_SOURCE_TYPE_C_NAME VARCHAR No
The source type of the bundle ledger transaction.
May contain organization-specific values: No
Category Entries:
Phase Expected Payment - Case Rate
Phase Expected Payment - Per Diem Rate
Service Line Contractual Amount
Service Line Adjustment Amount
Ad-Hoc Adjustment
5 BND_TX_ENTRY_INST_UTC_DTTM DATETIME (UTC) No
The instant that the bundle ledger transaction was logged in the UTC timezone.
6 BND_SERVICE_DATE DATETIME No
The service date of the transaction.
7 BND_SOURCE_TX_ID NUMERIC No
The unique identifier of the AP Claim service line that caused the transaction.
8 BND_REVERSAL_OF_LN INTEGER No
The bundle ledger line that was reversed by this transaction.
9 BND_TX_ENTRY_INST_LOCAL_DTTM DATETIME (Local) No
The instant that the bundle ledger transaction was logged in the local time zone.