BND_EPSD_HX

Description: |
This table contains the history of various changes made to bundled episodes.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EPISODE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EPISODE_ID | NUMERIC | No |
This column stores the unique identifier for the bundled 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 | HX_UPDATE_DTTM | DATETIME (UTC) | No |
The date and time at which the bundled episode was changed.
4 | HX_USER_ID | VARCHAR | No |
This column stores the unique identifier for the user who performed the changes to the bundled episode.
5 | HX_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
6 | HX_COVERAGE_ID | NUMERIC | No |
The unique ID of the coverage that will be billed for the bundled episode.
7 | HX_PAYOR_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
8 | HX_SELFPAY_YN | VARCHAR | No |
Indicates whether the guarantor is responsible for the bundled episode's expected payment.
May contain organization-specific values: No
Category Entries:
No
Yes
9 | HX_BPC_ID | NUMERIC | No |
This column stores the unique identifier for the bundled episode terms associated with the bundled episode. The terms are used to define various reimbursement related attributes for a bundled episode.
10 | HX_BPC_ID_BPC_NAME | VARCHAR | No |
The name of the bundled episode terms record.
11 | HX_BPC_CSN | NUMERIC | No |
The contact serial number of the bundled episode terms associated with the bundled episode. The terms are used to define various reimbursement related attributes for a bundled episode.
12 | HX_BILLING_START_DT | DATETIME | No |
The start date from which the services are covered in the bundled episode.
13 | HX_BILLING_END_DT | DATETIME | No |
The end date until which the services are covered in the bundled episode.
14 | HX_EXP_TOT_PMT | NUMERIC | No |
The amount of the total expected payment from the responsible party of a bundled episode.
15 | HX_EXP_HOSP_PMT | NUMERIC | No |
The amount of the total hospital expected payment from the responsible party of a bundled episode.
16 | HX_EXP_PROF_PMT | NUMERIC | No |
The amount of the total professional expected payment from the responsible party of a bundled episode. This will only be used when a separate professional payment is expected.
17 | HX_AUTO_CHG_YN | VARCHAR | No |
Set to yes if this bundled episode update was done via a background system update.
The category values for this column were already listed for column: HX_SELFPAY_YN