FIRST_CALL_AUDIT

Description:

Audit trail for the patient's first contact provider.

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	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	CM_CT_OWNER_ID	VARCHAR	No
	The Community ID (CID) of the instance that owns this contact. This is only populated if you use IntraConnect.
6	FIRST_CALL_PROV_ID	VARCHAR	No
	This item identifies the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. The item is only populated for assignments from the patient's encounter care team.
7	FIRST_CALL_USER_ID	VARCHAR	No
	This item identifies the user who was designated as the patient's first call following a change in coverage for the encounter treatment team. The item is only populated for assignments from the On-Call schedule.
8	FIRST_CALL_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	FIRST_CALL_TRTMNT_TEAM_REL_C_NAME	VARCHAR	No
	This item identifies the role of the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. May contain organization-specific values: Yes
10	FIRST_CALL_UPDATE_DTTM	DATETIME (UTC)	No
	This item identifies the update time of the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. This corresponds to the time the first call was referenced for use (by the system or display to an end user) and not necessarily the time at which the patient's first call provider's assignment was updated.
11	FIRST_CALL_REASON_C_NAME	VARCHAR	No
	This item identifies the update reason for the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team. May contain organization-specific values: No Category Entries: Manual Automatic - On-Call Covering Automatic - Team Role Automatic - Primary Team Contact Automatic - Scheduled Manual Override Shift Start
12	FIRST_CALL_CHNG_USER_ID	VARCHAR	No
	This item identifies the update user for the provider who was designated as the patient's first call following a change in coverage for the encounter treatment team.
13	FIRST_CALL_CHNG_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.