ED_EVENT_HISTORY

Description: |
This table contains the audit trail and history of the event record.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
EVENT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | EVENT_ID | VARCHAR | No |
The unique ID of the event record.
2 | LINE | INTEGER | No |
The line number of the information associated with this event. Multiple pieces of information can be associated with this record.
3 | EVENT_LINE | VARCHAR | No |
The line number of the original recorded event. Together with the EVENT_ID column, this forms the foreign key to ED_IEV_EVENT_INFO.
4 | EVENT_EDITED_TIME | DATETIME (Local) | No |
The date and time when the event was edited.
5 | EVNT_DISP_NAME_AUD | VARCHAR | No |
The display name of the edited event.
6 | EVENT_AUDIT_TIME | DATETIME (Local) | No |
The date and time when this edited event occurred.
7 | EVT_REC_AUDIT_TIME | DATETIME (Local) | No |
The date and time when this edited event was recorded.
8 | EVT_AUDIT_USER_ID | VARCHAR | No |
The unique ID of the user who created this edited event.
9 | EVT_AUDIT_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
10 | EVT_EDITED_USER_ID | VARCHAR | No |
The unique ID of the user who edited this event. This user might not be the user who initially created this edited event.
11 | EVT_EDITED_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | EVENT_CMT_AUDIT | VARCHAR | No |
The comments associated with this edited event.
13 | STAFFED_BEDS_AUDIT | NUMERIC | No |
The number of staffed beds for a department at the time of the edited event. This item is only populated if you are using the Staffed Beds activity.
14 | EVENT_AUDIT_PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
15 | EVENT_STAT_AUDIT_C_NAME | VARCHAR | No |
The category number of the status of the edited event.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Deleted
Inactive and Deleted
Hidden
Inactive and Hidden
Deleted and Hidden
Inactive Deleted and Hidden
16 | EVENT_INI_REC_ID_A | VARCHAR | No |
The master file and ID of the source of a edited duplicate procedure alert event. For example, this item usually holds LDG-ID (the ID of the procedure duplicate group used) or EAP-ID (the ID of the procedure used).
17 | EVENT_CONTEXT_AUDIT | VARCHAR | No |
For some edited events, this column holds the context of the edited event. Lab Ordered events might store the order ID here. Duplicate procedure alert events might store information on specific user actions in response to the alert.
18 | EVENT_NOTECSN_AUDIT | NUMERIC | No |
The event note contact serial number (CSN) of the event that was edited. This can be used to determine the note content at each edit.
19 | EVENT_AUDIT_DEPT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
20 | ED_C_CLIENT_SRC_A_C_NAME | VARCHAR | No |
The audit trail for where the ED Course comment was filed from.
May contain organization-specific values: No
Category Entries:
Hyperspace
Limerick
Haiku
Canto