ADT_SPLIT_ACCT_INTERP_HX

Description:

The ADT_SPLIT_ACCT_INTERP_HX table extracts the history of the reporting interpretations of the Encounter Series billing items for ADT events. This table contains a foreign key to the CLARITY_ADT table for linking to other ADT tables.

Primary Key

Column Name	Ordinal Position
EVENT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EVENT_ID	NUMERIC	No
	This column stores the unique identifier for the event 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	START_INSTANT_DTTM	DATETIME (UTC)	No
	The starting instant for this interpretation.
4	END_INSTANT_DTTM	DATETIME (UTC)	No
	The ending instant for this interpretation.
5	OUTGOING_FIN_CLASS_EVENT_TYP_C_NAME	VARCHAR	No
	The event type interpretation category for outgoing events for financial class. May contain organization-specific values: Yes Category Entries: Admission Discharge In Out Patient Update Census Leave of Absence Out Leave of Absence Return Leave of Absence Census
6	INCOMING_FIN_CLASS_EVENT_TYP_C_NAME	VARCHAR	No
	The event type interpretation category for incoming events for financial class. The category values for this column were already listed for column: OUTGOING_FIN_CLASS_EVENT_TYP_C_NAME
7	FROM_FINANCIAL_CLASS_C_NAME	VARCHAR	No
	The category number of the financial class that the patient had prior to the event. May contain organization-specific values: Yes Category Entries: Commercial Medicare Medicaid Self-Pay Worker's Comp Tricare Champva Group Health Plan FECA Black Lung Blue Shield Medigap Other DK Regional Client Received Self-Pay Sent to Consolidated Self-Pay Patient Assistance Program
8	TO_FINANCIAL_CLASS_C_NAME	VARCHAR	No
	The category number of the financial class that the patient had after the event. The category values for this column were already listed for column: FROM_FINANCIAL_CLASS_C_NAME
9	OUTGOING_PAYER_EVENT_TYP_C_NAME	VARCHAR	No
	The event type interpretation category for outgoing events for the payer. The category values for this column were already listed for column: OUTGOING_FIN_CLASS_EVENT_TYP_C_NAME
10	INCOMING_PAYER_EVENT_TYP_C_NAME	VARCHAR	No
	The event type interpretation category for incoming events for the payer. The category values for this column were already listed for column: OUTGOING_FIN_CLASS_EVENT_TYP_C_NAME
11	FROM_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
12	TO_PAYER_ID_PAYOR_NAME	VARCHAR	No
	The name of the payor.
13	OUTGOING_PLAN_EVENT_TYP_C_NAME	VARCHAR	No
	The event type interpretation category for outgoing events for the plan. The category values for this column were already listed for column: OUTGOING_FIN_CLASS_EVENT_TYP_C_NAME
14	INCOMING_PLAN_EVENT_TYP_C_NAME	VARCHAR	No
	The event type interpretation category for incoming events for the plan. The category values for this column were already listed for column: OUTGOING_FIN_CLASS_EVENT_TYP_C_NAME
15	FROM_PLAN_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
16	TO_PLAN_ID_BENEFIT_PLAN_NAME	VARCHAR	No
	The name of the benefit plan record.
17	PREVIOUS_ENC_EVENT_ID	NUMERIC	No
	This column stores the unique identifier for the event prior to this line's event ID.
18	SPLIT_ACCT_HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account that was active during this line in the interpretation history. This column is frequently used to link to the HSP_ACCOUNT table.