Tables installed with On-Call Scheduling
- UpdatedJan 30, 2025
- 2 minutes to read
- Yokohama
- On-Call Scheduling
On-Call Scheduling adds the following tables.
Tables installed with On-Call Scheduling
Note: Tables with prefix "v_" such as [v_alternate_rotation] are view-only
tables used for generating on-call reports. Do not use these tables
to create reports.
Display name [Table name] | Description |
---|---|
On-call Member [cmn_rota_member] | Table of group members that are participating in the on-call schedule and escalations. |
Roster [cmn_rota_roster] | Table that holds the members of the shift, the shift interval, and escalation settings. |
Shift [cmn_rota] | The table that holds the on-call schedule for a shift. |
Roster Schedule Span [roster_schedule_span] | Table that contains the schedule span definitions. On-Call Scheduling adds a group reference and the On-call type to the Type field. |
Trigger Rule [trigger_rule] | Table that extends the Assignment Rule [sysrule_assignment] table and stores when the escalation process is triggered and what actions to take. |
On-call Notifications [v_on_call] | Table that lists the reminder notifications that were sent. |
Rotation Schedule [v_rotation] | Table that lists shift schedules by start date and time and includes user contact information, if available. |
User Rotation Schedule [v_user_rotation] | Table that lists the shift schedule by user. |
Alternate Rotation Schedule [v_alternate_rotation] | Table that lists the alternate user schedules by shift and roster and the start and end date and time stamps. |
Rotation Escalation [cmn_rota_escalation] | Table that lists the escalations including the event and last updated time stamp. |
Shift Contact Preference [cmn_rota_contact_preference] | Table that holds the contact preferences for default and custom escalations. |
On-Call Communication Type [on_call_communication_type] | Table that lists the type of communication channel used. |
On-Call Group Template [sys_on_call_group_template] | Table with information about the template used to create/edit a schedule of a group. |
On-Call Shift Template [sys_on_call_shift_template] | Table with information about the template used to create/edit a schedule of a shift. |
On-Call User Preference [on_call_user_preference] | Table with information on a member's preferences. |
On-Call User Contact Preference [on_call_user_contact_preference] | Table with information on a member's contact preferences. |
[sys_on_call_contact_source] | Table that lists the contact sources and devices |
On-Call Escalation [on_call_escalation] | Table that records the source, group, and related details for escalation tracking. |
On-Call Escalation Level [on_call_escalation_level] | Table that logs the escalation levels reached for an escalation and related details for escalation tracking. |
On-Call Escalation Contact Attempt [on_call_escalation_con_attempt] | Table that logs contact attempts at an escalation level and related details for escalation tracking. |
On-Call Escalation Notification [on_call_escalation_comm] | Table that logs both the notifications and the responses for a contact attempt and related details for escalation tracking. |
On-Call Escalation Response [on_call_escalation_response] | Table that tracks On-Call escalation responses by On-Call workflows. Once consumed, entries are deleted by the system. |
Trigger Rule Table Configuration [trigger_rule_table_cfg] | Table that lists the tables that are enabled for creating escalation trigger rules. The table is used to enable the escalation trigger rules for the tables that do not extend tasks. |
On-Call Add Member [on_call_add_member] | Table that records the member details for adding a member to the roster. |
On-Call Remove Member [on_call_remove_member] | Table that records the member details for removing a member from the roster. |
On-Call Move Member [on_call_swap_member] | Table that records the member details for swapping the order of a member with the target member or moving the order of a member after the target member in the roster. |