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	NUMERIC	No
	This column stores the unique identifier for the payer responsible for the bundled episode's expected payment.
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