Tables installed with on-call scheduling

On-call scheduling adds the following tables.

Display name [Table name] Description
On-call Member


Table with the selected group members participating in the on-call schedule and escalations.


The table that determines the members on-call, the rotation interval and, escalation settings.


The table that holds the on-call schedule for a particular shift.
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


This table extends the Assignment Rule [sysrule_assignment] table and stores when the escalation process is triggered and what actions to take.
On-call Notifications


Lists the reminder notifications that were sent.
Rotation Schedule


Lists rotation schedules by start date and time and includes user contact information, if available.
User Rotation Schedule


Lists the rotation schedule by user.
Alternate Rotation Schedule


Lists the alternate user schedules by rota and roster and the start and end date and time stamps.
Rotation Escalation


Lists the escalations including the event and last updated time stamp.
Note: The tables whose name starts with prefix v such as [v_alternate_rotation] are view-only tables and are used for generating reports.