|
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 |
VARCHAR |
No |
|
|
|
| The unique ID of the provider who is associated with this edited event. For example, a deleted or updated Assign Attending event stores the provider who was assigned in this column. This column is frequently used to link to 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 |
NUMERIC |
No |
|
|
|
| Audit trail for the item that stores what department an event occurred in. |
|
|
| 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 |
|
|
