V_EHI_AUDIT_DCS

Description:

This view contains audit information for document records for the purpose of Electronic Health Information (EHI) export.

Primary Key

Column Name	Ordinal Position
DOC_INFO_ID	1
CHANGE_TIME	2
CHANGED_DATA_ELEMENT	3
LINE	4

Column Information

	Name	Type	Discontinued?
1	DOC_INFO_ID	VARCHAR	No
	The unique ID of the document information record.
2	PAT_ID	VARCHAR	No
	The unique ID of the patient associated with the document record.
3	CHANGE_TIME	DATETIME (Local)	No
	The instant when the value was changed.
4	LINE	INTEGER	No
	Audit of the line number that changed
5	NEW_VALUE_EXTERNAL	VARCHAR	No
	The value after the audited change in external format. This column shows the translated external value as of when the column was last extracted.
6	OLD_VALUE_EXTERNAL	VARCHAR	No
	The value before the audited change in external format. This column shows the translated external value as of when the column was last extracted.
7	NEW_VALUE_INTERNAL	VARCHAR	No
	The value of the item after it was changed in internal format.
8	OLD_VALUE_INTERNAL	VARCHAR	No
	The value of the item before it was changed in internal format.
9	CHANGED_DATA_ELEMENT	VARCHAR	No
	The name of the Clarity table and column corresponding to the changed data.
10	USER_ID	VARCHAR	No
	The ID of the employee who changed the item.
11	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.