Is the Absence Display Status (Scheduled / In progress / Completed) stored in any table?
Hi,
I'm building a report for the absence Status shown in Manage Absences and Entitlements → Existing Absences (screenshot attached). The values are Scheduled, Completed, In progress, Withdrawn, Awaiting approval, Awaiting withdrawal approval and so on.
In ANC_PER_ABS_ENTRIES, I'm using ABSENCE_STATUS_CD and APPROVAL_STATUS_CD. Neither column returns the status exactly as it appears on screen. For example, I can't get Scheduled, In progress or Completed from them.
Which table or view stores this status directly? If it isn't stored anywhere, how can I get it in a BI Publisher or SQL report?
Thanks,
Gaurav
Tagged:
0