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
|
