On-call report - file to read?

[CKnight]

I need to create a report that lists the primary on-call person for each group.  What file should I use?  Thank you!

[Vikram Reddy]

Hello @CKnight,

on-call reporting isn't one file, it's a small chain of tables. The roster lives in cmn_rota_roster (out-of-the-box rosters are named Primary, Secondary, Tertiary per rotation), and the actual people sit in cmn_rota_member ordered against that roster. The catch: those two only tell you who could be on-call, not who is on-call right now, since that depends on evaluating the schedule at the current moment, not just roster order.

For a report that shows the actual current primary person per group, run the built-in On-Call Rotation Schedule Report. It resolves the live on-call user per group into the v_rotation view table, which is what you want to build the report against, not the raw roster tables. One gotcha: v_rotation only holds data from the last time that report ran, so schedule the report itself rather than pointing a scheduled report cold at the view.

References

• REST API - Find the current primary on-call person for a given group?
• Export the data from On-call Schedules (v_rotation) to import in e-mail report
• On-Call Scheduling - Rotation of Members - How to Change sequence of members

Thank you,
Vikram Karety
Octigo Solutions INC