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 |