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 Service Area
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 NUMERIC No
This column stores the unique identifier for the primary payer that the patient had prior to the event. This column is frequently used to link to the CLARITY_EPM table.
12 TO_PAYER_ID NUMERIC No
This column stores the unique identifier for the primary payer that the patient had after the event. This column is frequently used to link to the CLARITY_EPM table.
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 NUMERIC No
This column stores the unique identifier for the primary plan that the patient had prior to the event. This column is frequently used to link to the CLARITY_EPP table.
16 TO_PLAN_ID NUMERIC No
This column stores the unique identifier for the primary plan that the patient had after the event. This column is frequently used to link to the CLARITY_EPP table.
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.