Skip to main content

The following are some of the useful queries which can be used by departments

Peoplesoft HR Navigation: Maine Menu-> Reporting Tools->Query-> Query Viewer

Query NameDescription
HRMS_EPAR_PENDING_BY_DEPT Pending ePARs by Dept/Coll/Div
HRMS_EPRF_PENDING_BY_DEPTPending ePRFs by Dept/Coll/Div
HRMS_TR_BW_PT_EXCEPTS           Time Reporting Exceptions
HRMS_EMP_ROSTER_BY_DEPT               Employee Roster by Dept ID
HRMS_AM_LV_RQS_PND_APR_DEPT       Leave requests pending approval 
HRMS_TR_BW_RT_NA_BY_DEPT                Biweekly Reported Time pending approval
HRMS_TR_BW_PT_NA_BY_DEPT                Biweekly Payable time pending approval
HR_POS_INCUMBENT_HISTORYPosition Incumbents History
HRMS_POSITIONS_VACANT_DEPT Vacant Positions by Department

 


Last updated 7/23/2018 5:54 AM