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