ESC_RESPONSIBLE_USERS

Description:

Status of all responsible groups and users.

Primary Key

Column Name	Ordinal Position
ESCALATION_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ESCALATION_ID	NUMERIC	No
	The unique identifier (.1 item) for the subject name 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	USER_ID	VARCHAR	No
	The IDs of the users responsible for the escalation
4	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
5	UC_GROUP_ID_RECORD_NAME	VARCHAR	No
	Record name
6	UPDATE_LOCAL_DTTM	DATETIME (Attached)	No
	Instant of responsible users change.
7	RESP_USER_STATUS_C_NAME	VARCHAR	No
	Instant there was a change event for the escalation. May contain organization-specific values: No Category Entries: Received Sender Offline Baton Holder Declined Forwarding Removed
8	PROVIDERTEAM_ID	NUMERIC	No
	The PCT IDs of the responsible provider teams
9	PROVIDERTEAM_ID_RECORD_NAME	VARCHAR	No
	The name of the record.
10	CALL_ORDER	INTEGER	No
	The most recently attempted call order for the provider team
11	ROLE_TRTMNT_TEAM_REL_C_NAME	VARCHAR	No
	The most recently attempted role for the provider team May contain organization-specific values: Yes
12	RESPONSIBLE_REASON_C_NAME	VARCHAR	No
	The reason that the user is listed as responsible for the request. May contain organization-specific values: No Category Entries: Direct Recipient Group Membership On-Call Message Forwarding Added to Conversation Sender On-Call Primary Team Contact
13	REASON_USER_ID	VARCHAR	No
	Contains the EMP ID of the user who caused this user to be listed as responsible
14	REASON_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
15	REASON_PROVIDERTEAM_ID	NUMERIC	No
	Contains the PCT ID of the On-Call team this user is a member of that caused them to become responsible
16	REASON_PROVIDERTEAM_ID_RECORD_NAME	VARCHAR	No
	The name of the record.
17	REASON_ROLE_TRTMNT_TEAM_REL_C_NAME	VARCHAR	No
	Contains the responsible user's role The category values for this column were already listed for column: ROLE_TRTMNT_TEAM_REL_C_NAME
18	REASON_UC_GROUP_ID_RECORD_NAME	VARCHAR	No
	Record name