V_EHI_AUDIT_PAYOR_AND_DP_COMM

Description:

This view contains audit data for the Continued Care and Services Coordination (CCSC) and Payer Communication workflows. Each row corresponds to a single audited event from those workflows.

Primary Key

Column Name	Ordinal Position
PAT_ENC_CSN_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	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).
2	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4	AUDIT_EVENT_TYPE_C_NAME	VARCHAR	No
	This is the event type (adding recipient, changing status, changing override fax, or changing override phone) of the item being changed. May contain organization-specific values: No Category Entries: Adding Recipient Removing Recipient Changing Status Changing Override Fax Changing Override Phone Changing Selected Caregiver Flag Changing Override Contact Name Changing Address Changing Selected Service Flag Selecting Specialty Deselecting Specialty Changing Completion Selecting Service Deselecting Service Archiving Service Provider Marking Service Provider Patient Preferred Removing Patient Preference for Service Provider Adding No Patient Preference Flag Removing No Patient Preference Flag Adding Follow-ups Removing Follow-ups Change Encounter-Specific Fax Adding Service To Coordinate Removing Service To Coordinate Marking Service Provider Complete Change Encounter-Specific Phone
5	AUDIT_USER_ID	VARCHAR	No
	This is the ID of the user who is making the item change.
6	AUDIT_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	AUDIT_INSTANT_UTC_DTTM	DATETIME (UTC)	No
	This is the time instant of the item change.
8	RECIPIENT_EXTERNAL	VARCHAR	No
	This column stores the name of the recipient for this audit event in external format. For CCSC audit events this is the name of the service provider. For Payer Communication audit events this is the name of the payer recipient.
9	DP_COORD_TYPE_C_NAME	VARCHAR	No
	The coordination type of an item being changed as part of the Continued Care and Services Coordination (post-discharge services or placement for the patient) workflow. May contain organization-specific values: Yes Category Entries: Destination Durable Medical Equipment Dialysis/Infusion Home Medical Care Community Resources
10	OLD_VALUE_INTERNAL	VARCHAR	No
	This is the old value of the item being changed.
11	NEW_VALUE_INTERNAL	VARCHAR	No
	This is the new value of the item being changed.
12	OLD_VALUE_EXTERNAL	VARCHAR	No
	This is the externally formatted old value of the item being changed. The internally formatted value is stored in the AUDIT_OLD_VALUE column. For example, if the AUDIT_OLD_VALUE includes a category value, then this column will store the category title that describes the category value. This column shows the translated external value as of when the column was last extracted.
13	NEW_VALUE_EXTERNAL	VARCHAR	No
	This is the externally formatted new value of the item being changed. The internally formatted value is stored in the AUDIT_NEW_VALUE column. For example, if the AUDIT_NEW_VALUE includes a category value, then this column will store the category title that describes the category value. This column shows the translated external value as of when the column was last extracted.
14	CHANGED_DATA_ELEMENT	VARCHAR	No
	The column descriptor that contains the metadata to be associated with data stored in columns OLD_VALUE_INTERNAL and NEW_VALUE_INTERNAL.
15	DP_RECIPIENT_SVC_LN_ID	NUMERIC	No
	This is the recipient's Service Line ID (HCS ID) of the item being changed, only used by DP workflows.
16	DP_RECIPIENT_SVC_LN_ID_SVC_LN_NAME	VARCHAR	No
	The name (.2 item) of the service line record.