Tables installed with on-call scheduling

On-call scheduling adds the following tables.
Display name [Table name] Description
On-call Member

[cmn_rota_member]

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

[cmn_rota_roster]

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

[cmn_rota]

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

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

[v_on_call]

Lists the reminder notifications that were sent.
Rotation Schedule

[v_rotation]

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

[v_user_rotation]

Lists the rotation schedule by user.
Alternate Rotation Schedule

[v_alternate_rotation]

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

[cmn_rota_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.