Tables installed with on-call scheduling

On-call scheduling adds the following tables.

Tables

Table 1. Tables for on-call scheduling
Display name [Table name] Description
Alternate Rotation Schedule

[v_alternate_rotation]

Lists the alternate user schedules by rota and roster and the start and end date and time stamps.
On-call Member

[cmn_rota_member]

Lists the selected group members participating in the on-call schedule and escalations.
On-call Notifications

[v_on_call]

Lists the reminder notifications that were sent.
Roster

[cmn_rota_roster]

Determines the members on-call, the rotation interval and escalation settings.
Roster Schedule Span

[roster_schedule_span]

Contains the schedule span definitions. on-call scheduling adds a group reference and the on-call type to the Type field.
Rota

[cmn_rota]

Holds the on-call schedule for a particular shift.
Rotation

[v_rotation]

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

[cmn_rota_escalation]

Lists the escalations including the event and last updated time stamp.
Trigger Rule

[trigger_rule]

Extends the Assignment Rule [sysrule_assignment] table and stores when the escalation process is triggered and what actions to take.
User Rotation Schedule

[v_user_rotation]

Lists the rotation schedule by user.
Note: The tables whose name starts with prefix v such as [v_alternate_rotation] are view-only tables and are used for generating reports.