New Absence Management Query – M_AM_LEAVE_TRANSACTIONS_X_MNTH

posted Mar 6, 2019, 7:21 AM by Barbara Thiss
New icon

A new query for transactions that cross months (M_AM_LEAVE_TRANSACTIONS_X_MNTH) is available to only list employees having vacation leave that has been entered as cross months either through ESS or Timesheet. For example the M_AM_LEAVE_TRANSACTIONS_X_MNTH query will list a vacation taken from 9/27/2018 to 10/2/2018. The query will not list a vacation taken from 9/27/2018 to 9/28/2018 because those dates do not cross months. This new query is based on the All Leave Transactions (M_AM_LEAVE_TRANSACTIONS) query and has the same prompts, however the query’s fields match the ones found on the Excess Leave Report (M_EXCESS_LEAVE_RPT) query.

M_AM_LEAVE_TRANSACTIONS_X_MNTH query parameters

M_AM_LEAVE_TRANSACTIONS_X_MNTH query results