Skip to main content

HR Queries

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 Name Description
HRMS_EPAR_PENDING_BY_DEPT Pending ePARs by Dept/Coll/Div
HRMS_EPRF_PENDING_BY_DEPT Pending 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_HISTORY Position Incumbents History
HRMS_POSITIONS_VACANT_DEPT Vacant Positions by Department