SC_EPISODE_EXT_ENC_AUD
Description:
Data about the audit history for external encounters linked to a Compass Rose episode.

Primary Key
Column Name Ordinal Position
SUMMARY_BLOCK_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 SUMMARY_BLOCK_ID NUMERIC No
The unique identifier (.1 item) for the episode 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 AUDIT_REFERENCE VARCHAR No
The audit history composite DXR reference ID for an external encounter linked to this episode.
4 AUDIT_USER_ID VARCHAR No
The unique ID associated with the user record for this row. This column is frequently used to link to the CLARITY_EMP table.
5 AUDIT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
6 AUDIT_UTC_DTTM DATETIME (UTC) No
The audit history update date and time in UTC when the external encounter link to this episode was updated.
7 AUDIT_BND_EPSD_SRC_C_NAME VARCHAR No
The source category ID for the audit history for an external encounter linked to this episode.
May contain organization-specific values: No
Category Entries:
User
Visit Association
Auto Link
Auto Creation
Auto Link Via Transform
Auto Link Via Association
Auto Removal
8 AUDIT_EPISODE_LINK_ST_C_NAME VARCHAR No
The status category ID for the audit history for an external encounter linked to this episode.
May contain organization-specific values: No
Category Entries:
Added
Removed
Other