The Payroll Query Access for HR Professionals reporting role is now available in SF People & Pay. This security role provides Human Resources (HR) staff reporting capabilities in SF People & Pay without accessing the actual Department Timekeeper - related pages.
HR staff with this security role can access the queries below containing data from Payroll, Time & Labor, and Absence Management.
| Query Name | Description |
| MRG_AM_BAL_BY_ELIG_GRP | Absence Balances by Elig Grp |
| MRG_AM_BAL_BY_EMPL | Absence Balances by Empl |
| MRG_AM_BAL_BY_EMPL_BY_DEPT | Absence Balances by Empl&DEP |
| MRG_AM_BAL_BY_EMPL_DEPT_JOB | Absence Balances by Empl |
| MRG_AM_EE_SCKHRS_OVR39 | Sick leave hours >39 PPE |
| MRG_AM_EE_UNION_CRT | Empl Sick & Vac Bal |
| MRG_AM_EE_VAC_AND_SICK | Empl Sick & Vac Bal |
| MRG_AM_EE_VAC_AND_SICK_EMP | Sick & Vac Bal by Empl |
| MRG_AM_EE_VAC_AND_SICK_JOB | Empl Sick & Vac Bal |
| MRG_AM_ELIGGRP_EMPL | AM Empl in Elig Grp |
| MRG_AM_EMPL_NOT_ACTIVE_LEA_BAL | Empl not active leave balance |
| MRG_AM_FLOAT_BAL_CRT | Absence Balances for CRT |
| MRG_AM_KIN_CARE | Kin Care Taken by Date Range |
| MRG_AM_VAC_15YR_ANNIV | Empl close to 15 Year Service |
| MRG_AM_VAC_1YR_ANNIV | Empl close to 1 Year Service |
| MRG_AM_VAC_20YR_ANNIV | Empl close to 20 Year Service |
| MRG_AM_VAC_5YR_ANNIV | Empl close to 5 Year Service |
| MRG_PY_2320_EE_INFO | List of Stand alone 2320s |
| MRG_PY_9163_WAGE_RATES | Comp. rates 9163 Transit Oper. |
| MRG_PY_COMBO_CD_INDEXCD_PROMPT | ValidComboCd fr IndexCd Prompt |
| MRG_PY_DISPLAY_MAX_WAGE | Displays EEs maximum rate |
| MRG_PY_EE_TERM_AND_ACTIVE_POS | Inactive Empl with Active Job |
| MRG_PY_EMPL_HIR_REH_TER_BY_PP | EE HIR REH AND TERM DATA |
| MRG_PY_EMPL_MAIL_DROP_BY_DEPT | |
| MRG_PY_EMP_WITH_PAY_NO_MAILDRP | Empl with Pay No Mail Drop ID |
| MRG_PY_INDEX_CD_XLAT_COMBO_CD | Obtain ValidComboCd fr IndexCd |
| MRG_PY_MAA_LONGEVITY | |
| MRG_PY_MAA_QUERY | |
| MRG_PY_NEGATIVE_OTF | Audit Negative OTF Payments |
| MRG_PY_PY0109_INCORRECT_ADDRES | PY0109 Incorrect Address Searc |
| MRG_PY_ROSTERS_DEPT | Rosters by Dept |
| MRG_PY_UAPD_PROF_REIMBURSE_QTR | UAPD Prof. Reimbursement |
| MRG_TL_12MONRTHS_OT_BY_JOBCD | OT Hours within last 12 months |
| MRG_TL_ABS_WITHOUT_PAY | Identify EEs taking abs no pay |
| MRG_TL_ACTIVE_NOT_IN_TL | Active On Job not in TL |
| MRG_TL_ADHOC_OVERTIME | OT Report by Roster or Emplid |
| MRG_TL_AUDIT_PAYABLE_TIME | Payable Time Audit |
| MRG_TL_COMP_PLANS_PAID_HRS | Comp Plans Paid Hours in Range |
| MRG_TL_DIS_RECOV_DRP_TRC_ONLY | Payable Tm/PPE w/DRP TRC ONLY |
| MRG_TL_DIS_RECOV_INCIDENT_CDE | Payable Tm/PPE w/DR Inc Codes |
| MRG_TL_DIS_RECOV_PROJECT_ID | Payable Tm/PPE by DR Proj ID |
| MRG_TL_DLP_HRS | Disability Leave Hrs |
| MRG_TL_DSA_MSA_LONGEVITY | Longevity Query for DSA, MSA |
| MRG_TL_EARNINGS_BY_DEPARTMENT | Total hours and pay by TRC |
| MRG_TL_EARNINGS_BY_ROSTER_CODE | Total hours and pay by TRC |
| MRG_TL_EARNINGS_BY_TASK_PROFIL | Hours & pay by Task Profile |
| MRG_TL_EARNINGS_DETAIL_BY_EMPL | Total hours and pay by TRC |
| MRG_TL_EES_WITH_PAID_TIME | EEs with paid time by dept. |
| MRG_TL_EE_DFLTTSKPRF_BY_DEPT | Default Task Profile EMPL_DATA |
| MRG_TL_EE_TASK_PROFILE_BY_DEPT | Task Profile on EMPL_DATA |
| MRG_TL_EMPL_TL_A_TIME_TO_PAY_N | EE ActiveT&L send to Payroll N |
| MRG_TL_EMP_NOT_UPDATE_TO_PR | Payable Time not send to PR |
| MRG_TL_ESTIMATED_EARNINGS_DAT | Total hours and pay by TRC |
| MRG_TL_ESTIMATED_EARNINGS_DTLS | Total hours and pay by TRC |
| MRG_TL_FT_REGWUNPD_HRS_NOT_80 | FT EE Reg & Unpd Hrs Not 80 |
| MRG_TL_FT_REGWUNPD_HRS_NTPROMP | FT EE Reg & Unpd Hrs NotPrompt |
| MRG_TL_JOBCODE_OVERRIDE | Job code override on timesheet |
| MRG_TL_LWOP_BY_EMPL | Leave without Pay hours |
| MRG_TL_MULT_JOB_HRS_BY_DEPT | |
| MRG_TL_MULT_JOB_HRS_BY_RECDPT | |
| MRG_TL_NO_PAYABLE_TIME | Active & Pd Lv No Payable Time |
| MRG_TL_NO_PAYABLE_TIME_GLOBAL | Active & Pd Lv No Payable Time |
| MRG_TL_OVERTIME_BY_JOBCODE |
Overtime by Job Code |
| MRG_TL_PAYABLE_STAT_BEFORE_PPE | Payable Time NA or AP<Paybegin |
| MRG_TL_PAYABLE_TIME_NA | Payable Time Needs Approval |
| MRG_TL_PAYABLE_TIME_NA_GRP | Payable Time NA by Group |
| MRG_TL_PAYABLE_TIME_WTP | SEIU-WorkTrainProg PayableTime |
| MRG_TL_PT_GRTHAN_STDHRS | PT & As-Needed > Std Hours |
| MRG_TL_ROSTER_CODES_BY_DEPT | Roster codes by Department |
| MRG_TL_RPTDTIME_ASIGNCD_EMPLID | Rptd Time with Assign Code |
| MRG_TL_RPTDTIME_ASSIGNCD_DEPT | Rptd Time with Assign Code |
| MRG_TL_RPTD_HOLIDAY_ENTRIES | LHP/HBE/HOE Entries by PPE |
| MRG_TL_RPTD_HOLIDAY_HRS_NOT_8 | LHP/HBE/HOE Unequal to 8 Hours |
| MRG_TL_RPTD_OVERRIDE_RATE | Override Rate on Timesheet |
| MRG_TL_RPTD_TIME_DPT_EE_COUNT | Rptd Time Empl Count by Dept |
| MRG_TL_RPTD_TIME_WITH_ASIGN_CD | Rptd Time with Assign Code |
| MRG_TL_RPTHRS_NOTEQL_STDHRS | Reported Hrs <> Std Hours |
| MRG_TL_SFT_ASGN_ON_OUT_PUNCHES | Shft or Assign Cd on OUT Punch |
| MRG_TL_SINGLE_JOB_HRS_BY_DEPT | |
| MRG_TL_SINGLE_JOB_HRS_BY_RECDP | |
| MRG_TL_SUCCESSION_PLAN | Years of Service & Work Hours |
| MRG_TL_TESS_TRC_BY_DEPT_PPE_SM | TESS Transection count by Dept |
| MRG_TL_TESS_TRC_UNPD_RPT | TESS Transaction Unpaid Earns |
| MRG_TL_TIME_ROSTER_CODES | Time Reporters with Roster Cd |
| MRG_TL_TOO_MANY_RPT_TIME_ENTRY | Capture EE with many rpt time |
| MRG_TL_WORK_HRS_BY_MONTH | Worked Hours by Dept. & Month |
| MRG_TL_WRKCOMP_HRS | Workers Comp Hrs by Dept |
How to request the Payroll Query Access for HR Professionals security role
Department Payroll System Access Approvers can submit an SF People & Pay Dept. Power User System Access Request (SAR) to request this security role on behalf of an HR professional. As a Payroll SAA, you can find the SAR under the System Access folder of our Service Catalog. See our Submitting an SF People & Pay Department Power User SAR solution article for more information about submitting requests on behalf of your Department employees.
If you are an HR Professional and would like to request the Payroll Query Access for HR Professionals security role, please reach out to your Department Payroll SAA to discuss your payroll reporting needs.
Questions?
If you have additional questions about systems access, please reach out to our SF Employee Portal Support Team.