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_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).
14 | EVENT_TIME | DATETIME (Local) | No |
The instant when the event record was actually created.
15 | USER_ID | VARCHAR | No |
The ID number of the user who created the event record.
16 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
17 | 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
18 | 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
19 | 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
20 | DELETE_TIME | DATETIME (Local) | No |
The instant when the event record was actually deleted.
21 | CANC_EVENT_ID | NUMERIC | No |
The ID number of the canceled event record that this event record replaces.
22 | 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.
23 | 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.
24 | 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
25 | ACCOMMODATION_C_NAME | VARCHAR | No |
The accommodation code of the event. This is extracted as the category title.
May contain organization-specific values: Yes
26 | 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
27 | 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
28 | ORIG_EVENT_TIME | DATETIME (Local) | No |
The instant when the original subtype record for this event was actually created.
29 | PREV_UPD_EVNT_TIME | DATETIME (Local) | No |
The instant when the last previous update subtype record for this event was actually created.
30 | ORIG_EFF_TIME | DATETIME (Local) | No |
The instant when the original subtype record for this event was supposed to have happened.
31 | PREV_UPD_EFF_TIME | DATETIME (Local) | No |
The instant when the last previous update subtype record for this event was supposed to have happened.
32 | 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.
33 | 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.
34 | 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.
35 | 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
36 | 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
37 | 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
38 | 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
39 | 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
40 | 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
41 | 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
42 | ORDER_ID | NUMERIC | No |
This item is a link to the ORD record directly responsible for generating an ADT event.
43 | 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.
44 | 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
45 | REVIEW_DTTM | DATETIME (UTC) | No |
The date and time when this event was reviewed by the user.
46 | REVIEW_USER_ID | VARCHAR | No |
The unique ID of the user who reviewed this event.
47 | REVIEW_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
48 | LOA_REASON_C_NAME | VARCHAR | No |
The leave of absence reason category ID for the event.
May contain organization-specific values: Yes
49 | 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.
50 | 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
51 | 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.
52 | 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
53 | SPLIT_ACCT_PRIMARY_PAYER_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
54 | SPLIT_ACCT_PRIMARY_PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
55 | 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
56 | 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
57 | 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
58 | 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
59 | 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
60 | 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
61 | SPLIT_ACCT_FROM_PAYER_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
62 | SPLIT_ACCT_TO_PAYER_ID_PAYOR_NAME | VARCHAR | No |
The name of the payor.
63 | 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
64 | 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
65 | SPLIT_ACCT_FROM_PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
66 | SPLIT_ACCT_TO_PLAN_ID_BENEFIT_PLAN_NAME | VARCHAR | No |
The name of the benefit plan record.
67 | 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
68 | 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
69 | EFFECTIVE_UTC_DTTM | DATETIME (UTC) | No |
The instant when the event was supposed to have happened in UTC.