CLARITY_ADT
Description:
The CLARITY_ADT table is the master table for ADT event history information. This table contains several foreign keys for other ADT tables.

Primary Key
Column Name Ordinal Position
EVENT_ID 1

Column Information
Name Type Discontinued?
1 EVENT_ID NUMERIC No
The unique ID number of the ADT event record.
2 EVENT_TYPE_C_NAME VARCHAR No
The category value corresponding to the type of the event record.
May contain organization-specific values: Yes
Category Entries:
Admission
Discharge
Transfer In
Transfer Out
Patient Update
Census
Hospital Outpatient
Leave of Absence Out
Leave of Absence Return
Leave of Absence Census
3 EVENT_SUBTYPE_C_NAME VARCHAR No
The category value indicating whether the event record has been changed or deleted.
May contain organization-specific values: No
Category Entries:
Original
Canceled
Update
4 DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
5 ROOM_ID_ROOM_NAME VARCHAR No
The name of the Room record.
6 ROOM_CSN_ID NUMERIC No
The serial number for the room contact of the event record. This number is unique across all room contacts in the system.
7 BED_ID VARCHAR No
The ID number of the bed of the event record at the effective time.
8 BED_ID_BED_LABEL VARCHAR No
The name of the bed.
9 BED_CSN_ID NUMERIC No
The serial number for the bed contact of the event record. This number is unique across all bed contacts in the system.
10 BED_STATUS_C_NAME VARCHAR No
The category value corresponding to the record state of the bed of the event record at the effective time.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Deleted
Hidden
Inactive and Hidden
Deleted and Hidden
11 EFFECTIVE_TIME DATETIME (Local) No
The instant when the event was supposed to have happened.
12 PAT_ID VARCHAR No
The ID of the patient of the event record at the effective time.
13 PAT_ENC_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
14 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
15 EVENT_TIME DATETIME (Local) No
The instant when the event record was actually created.
16 USER_ID VARCHAR No
The ID number of the user who created the event record.
17 USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
18 PAT_CLASS_C_NAME VARCHAR No
The category value corresponding to the classification for the patient of the event record at the effective time.
May contain organization-specific values: Yes
19 PAT_SERVICE_C_NAME VARCHAR No
The category value corresponding to the hospital service for the patient of the event record at the effective time.
May contain organization-specific values: Yes
20 PAT_LVL_OF_CARE_C_NAME VARCHAR No
The category value corresponding to the level of care for the patient of the event record at the effective time.
May contain organization-specific values: Yes
21 DELETE_TIME DATETIME (Local) No
The instant when the event record was actually deleted.
22 CANC_EVENT_ID NUMERIC No
The ID number of the canceled event record that this event record replaces.
23 XFER_EVENT_ID NUMERIC No
The ID number of the 'transfer out' event type event record which with this 'transfer in' event type event record corresponds to a transfer action for the patient of the event records.
24 COMMENTS VARCHAR No
The free text comment associated with the event record. This is used to hold overridden confirmation warnings by the user for the event type event record action.
25 REASON_C_NAME VARCHAR No
The category value corresponding to the reason the event record was undone or corrected.
May contain organization-specific values: Yes
26 ACCOMMODATION_C_NAME VARCHAR No
The accommodation code of the event. This is extracted as the category title.
May contain organization-specific values: Yes
27 ACCOM_REASON_C_NAME VARCHAR No
The category value corresponding to the reason for the room accommodation for the patient of the event record at the effective time.
May contain organization-specific values: Yes
28 ALT_EVENT_TYPE_C_NAME VARCHAR No
The category value corresponding to an alternate type for the event record.
The category values for this column were already listed for column: EVENT_TYPE_C_NAME
29 ORIG_EVENT_TIME DATETIME (Local) No
The instant when the original subtype record for this event was actually created.
30 PREV_UPD_EVNT_TIME DATETIME (Local) No
The instant when the last previous update subtype record for this event was actually created.
31 ORIG_EFF_TIME DATETIME (Local) No
The instant when the original subtype record for this event was supposed to have happened.
32 PREV_UPD_EFF_TIME DATETIME (Local) No
The instant when the last previous update subtype record for this event was supposed to have happened.
33 XFER_IN_EVENT_ID NUMERIC No
The ID number of the 'transfer in' type record which with this 'transfer out' type record corresponds to a transfer action for the patient CSN of these records.
34 NEXT_OUT_EVENT_ID NUMERIC No
The ID number of the next 'transfer out' or 'discharge' type record for this bed for the patient CSN of these records.
35 LAST_IN_EVENT_ID NUMERIC No
The ID number of the last 'transfer in' or 'admission' type record for this bed for the patient CSN of these records.
36 STATUS_OF_BED_C_NAME VARCHAR No
The category value corresponding to the status of the bed of the event record at the event timestamp.
May contain organization-specific values: Yes
Category Entries:
Ready
Not Available
Maintenance
Dirty
Cleaning
37 BASE_PAT_CLASS_C_NAME VARCHAR No
The category value corresponding to the base classification for the patient of the event record at the effective time.
May contain organization-specific values: No
Category Entries:
Inpatient
Outpatient
Emergency
38 OUT_EVENT_TYPE_C_NAME VARCHAR No
This column contains the outgoing event type as it would currently be interpreted
The category values for this column were already listed for column: EVENT_TYPE_C_NAME
39 FROM_BASE_CLASS_C_NAME VARCHAR No
This column contains the base patient class that the patient had prior to this event.
May contain organization-specific values: No
Category Entries:
Direct
Inpatient
Outpatient
Emergency
Observation
40 TO_BASE_CLASS_C_NAME VARCHAR No
This column contains the base patient class that the patient had after this event.
The category values for this column were already listed for column: FROM_BASE_CLASS_C_NAME
41 LABOR_STATUS_C_NAME VARCHAR No
This item holds the L&D status of the encounter at the time of the ADT event.
May contain organization-specific values: No
Category Entries:
Expected
Assessment
Admitted
Delivered
Newborn
Discharged
Reserved
Undo
42 FIRST_IP_IN_IP_YN VARCHAR No
This column indicates whether this event represents the first time a patient was admitted with an inpatient base class in an inpatient-type unit.
May contain organization-specific values: No
Category Entries:
No
Yes
43 ORDER_ID NUMERIC No
This item is a link to the ORD record directly responsible for generating an ADT event.
44 SOURCE_LOC_EVNT_ID NUMERIC No
The unique ID of the Patient Location event that generated this Admission, Discharge, Transfer, or Leave of Absence (ADT) event. This signifies that this ADT event was created from a Patient Location update.
45 EVNT_REVIEW_C_NAME VARCHAR No
The review status category number for the event. If empty, then this event never needed review.
May contain organization-specific values: No
Category Entries:
Reviewed Through Event Management
Reviewed Manually
Needs Review
46 REVIEW_DTTM DATETIME (UTC) No
The date and time when this event was reviewed by the user.
47 REVIEW_USER_ID VARCHAR No
The unique ID of the user who reviewed this event.
48 REVIEW_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
49 LOA_REASON_C_NAME VARCHAR No
The leave of absence reason category ID for the event.
May contain organization-specific values: Yes
50 ORIGINAL_EVENT_ID NUMERIC No
The unique ID of the original event that this event record replaces. If this event record has not been canceled or updated, this column will be equal to the EVENT_ID column. This column is not necessarily equal to the CANC_EVENT_ID column. If the original event has been updated multiple times, then this column will show the ID of the original event, not the ID of the event that was most recently replaced by this record.
51 ACTION_SOURCE_C_NAME VARCHAR No
This item holds the reason behind an auto-generated event (e.g. when the service is automatically updated due to an attending provider change).
May contain organization-specific values: No
Category Entries:
Attending Provider Added
Automatic Leave of Absence
Transport Completed
RTLS
OpTime Case Tracking Event
52 SPLIT_ACCT_HSP_ACCOUNT_ID NUMERIC No
The unique ID of the hospital account for the associated event. This column will only be set for admissions enabled for split accounts.
53 SPLIT_ACCT_FINANCIAL_CLASS_C_NAME VARCHAR No
The category ID of the financial classification that corresponds to the primary payer for the associated event. This column will only be set for admissions enabled for split accounts.
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
54 SPLIT_ACCT_PRIMARY_PAYER_ID_PAYOR_NAME VARCHAR No
The name of the payor.
55 SPLIT_ACCT_PRIMARY_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
56 SPLIT_ACCT_OUT_FIN_CL_EV_TYP_C_NAME VARCHAR No
The event type category ID of the outgoing financial class for this event.
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
57 SPLIT_ACCT_IN_FIN_CL_EV_TYP_C_NAME VARCHAR No
The event type category ID of the incoming financial class for this event.
The category values for this column were already listed for column: SPLIT_ACCT_OUT_FIN_CL_EV_TYP_C_NAME
58 SPLIT_ACCT_FROM_FIN_CLASS_C_NAME VARCHAR No
The category ID of the financial class prior to this event.
The category values for this column were already listed for column: SPLIT_ACCT_FINANCIAL_CLASS_C_NAME
59 SPLIT_ACCT_TO_FIN_CLASS_C_NAME VARCHAR No
The category ID of the financial class after this event.
The category values for this column were already listed for column: SPLIT_ACCT_FINANCIAL_CLASS_C_NAME
60 SPLIT_ACCT_OUT_PAYER_EV_TYP_C_NAME VARCHAR No
The unique ID of the outgoing payer for this event.
The category values for this column were already listed for column: SPLIT_ACCT_OUT_FIN_CL_EV_TYP_C_NAME
61 SPLIT_ACCT_IN_PAYER_EV_TYP_C_NAME VARCHAR No
The unique ID of the incoming payer for this event.
The category values for this column were already listed for column: SPLIT_ACCT_OUT_FIN_CL_EV_TYP_C_NAME
62 SPLIT_ACCT_FROM_PAYER_ID_PAYOR_NAME VARCHAR No
The name of the payor.
63 SPLIT_ACCT_TO_PAYER_ID_PAYOR_NAME VARCHAR No
The name of the payor.
64 SPLIT_ACCT_OUT_PLAN_EV_TYP_C_NAME VARCHAR No
The unique ID of the outgoing payer for this event.
The category values for this column were already listed for column: SPLIT_ACCT_OUT_FIN_CL_EV_TYP_C_NAME
65 SPLIT_ACCT_IN_PLAN_EV_TYP_C_NAME VARCHAR No
The unique ID of the incoming payer for this event.
The category values for this column were already listed for column: SPLIT_ACCT_OUT_FIN_CL_EV_TYP_C_NAME
66 SPLIT_ACCT_FROM_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
67 SPLIT_ACCT_TO_PLAN_ID_BENEFIT_PLAN_NAME VARCHAR No
The name of the benefit plan record.
68 IS_LOA_UPDATE_YN VARCHAR No
Indicates whether this event is part of a leave of absence update. 'Y' indicates that the event is part of a leave of absence update, 'N' or NULL indicates it is not.
The category values for this column were already listed for column: FIRST_IP_IN_IP_YN
69 EVENT_CONVERTED_FLAG_C_NAME VARCHAR No
Indicates that this event has been converted to another event type.
May contain organization-specific values: No
Category Entries:
Manually Converted to Discharge
Auto Converted to Discharge
Converted to LOA
70 EFFECTIVE_UTC_DTTM DATETIME (UTC) No
The instant when the event was supposed to have happened in UTC.