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.