You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!