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.