Three new Absence Management queries

posted May 19, 2015, 11:03 AM by Peyri Herrera
There are three new Absence Management queries related to finding unapproved absences:
  • M_AM_UNAPPROVED_ABSENCES: To identify absences that need to be approved.
  • M_AM_UNAPPRVD_ABSENCES_W_SUPVR: To identify absences that need to be approved, including the employee's Reports To position number, Supervisor ID and Supervisor Name.
  • M_AM_UNAPPRVD_ABSENCE_NO_SUPVR: To identify absences that need to be approved, including the employee's Reports To position number but no Supervisor information because one has not been assigned to the employee yet.