Understanding Delivered Pivot Grids

PeopleSoft Pivot Grid supports operational dashboard reporting within the PeopleTools framework to provide a pivot table and chart representation of data using PSQuery data source. The framework also enables users to see different views of the data.

This information is stored in the Pivot Grid Wizard by navigating to Reporting Tools > Pivot Grid > Pivot Grid Wizard.

This table lists PeopleSoft-delivered Pivot Grids for HCM:

Application / Product	Pivot Grid Title	Pivot Grid Name	Link to Product Documentation for Pivot Grids
Absence Management	Absence Event Analysis	HGA_EVENT_ANALYSIS_MGR_DSH	Absence Events Analysis Pagelet
Absence Management	Absence Event Analysis	HGA_EVENT_ANALYSIS_MGR	Absence Analytics Page
Absence Management	Absence Event Analysis for ADM	HGA_EVENT_ANALYSIS_ADM	Absence Events Analysis Pagelet
Absence Management	Abs Event Cost Analysis ADM Abs Event Cost analysis MGR	HGA_EVENT_COST_ADM HGA_EVENT_COST_MGR	Absence Cost Analysis Pagelet
Absence Management	Abs Liability and Trends ADM	HGA_LIABILITY_TRENDS_ADM	Absence Liability and Trends Pagelet
Absence Management	Abs Liability and Trends MGR	HGA_LIABILITY_TRENDS_MGR	Absence Liability and Trends Pagelet
Absence Management	Leave Balances by Type	HGA_LEAVE_BAL_MGR	Absence Cost Analysis Pagelet
Absence Management	Periodic Absence Rate ADM	HGA_PRD_RATE_ADM	Periodic Absence Rate Pagelet
Absence Management	Periodic Absence Rate MGR	HGA_PRD_RATE_MGR	Periodic Absence Rate Pagelet
Compensation	Compensation by Performance	WCS_PG_COMP_PERF	Salary Increase by Performance Page Variable Compensation by Performance Page
Compensation	Compensation Distribution	WCS_PG_COUNT	Compensation Distribution Page
Compensation	Cycle Guideline Alert	WCS_PG_ALERT	Cycle Guideline Alert Page
Compensation	Cycle Tracking	WCS_PG_TRACK	Cycle Tracking Page
Compensation	Salary Analysis	WCS_PG_PEER	Salary Analysis Page
Compensation	Salary Increase by Performance	WCS_PG_SAL_PERF	Salary Increase by Performance Page
ePerformance	My Team's Performance Status	EP_PG_DOCSTS	Team Performance Status Page
ePerformance	Team Performance Status Detail	EP_PG_DOCSTS_NUI	See Team Performance Status Page
eProfile Manager Desktop	Current Salary Analysis	HR_TM_EC_SA	See My Team Pages: Supplementary Panel
eProfile Manager Desktop	Performance Status	HR_TM_EP_DOCSTS	See My Team Pages: Supplementary Panel
eProfile Manager Desktop	Performance vs. Compa-Ratio	HR_TM_PG	Performance vs. Compa-Ratio Pivot Grid
eProfile Manager Desktop	Salary Analysis	HR_GSS_PG	Salary Analysis Page
Global Payroll	Absence by Generated PI	GP_ABS_GENPI_ANLY	By Generated Positive Input Pagelet
Global Payroll and Absence Management	Absence by Take and Type	GP_TK_TY_ANLY	Absence by Take and Type Pagelet
Global Payroll and Absence Management	Absences By Negative Balance	GP_ABS_NEG_BAL	Employee with Negative Balance Pagelet
Global Payroll	Active Employees without Gross	GP_WC_ACTIVE_EMP_NOT_PAID	Active Employees without Gross Page
Global Payroll and Absence Management	Analyze by Paid-Unpaid Status	GP_ABS_PRTLPAID_UNPAID_ANLY	Absence by Paid Unpaid Status Pagelet
Global Payroll	Deduction Threshold	GP_PA_DED_THRESHOLD GP_PA_DED_PAY	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	Deduction Variance	GP_PA_DED_VAR GP_PA_DED_VARIANCE	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	Earnings Variance	GP_PA_ERN_VAR GP_PA_ERN_VARIANCE	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	Earning Threshold	GP_PA_ERN_THRESHOLD GP_PA_ERN_PAY	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	Gross Pay Threshold	GP_PA_GROSS_THRESHOLD GP_GROSS_PAY	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	Gross Pay Variance	GP_PA_VAR_GROSS GP_PA_GROSS_PAY_VAR	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	Inactive Employees with Gross	GP_WC_INACTIVE_EMP_PAID	Inactive Employees with Gross Page
Global Payroll	Missing Bank Account	GP_WC_INCOMPLETE_BANK	Missing Bank Accounts Page
Global Payroll	Net Pay Threshold	GP_PA_NET_THRESHOLD GP_PA_NETPAY	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	Net Pay Variance	GP_PA_NET_PAY_VAR GP_PA_VAR_NET	See: Global Payroll Analytics Page Global Payroll Analytics Page
Global Payroll	New Hires	GP_WC_NEWHIRE	New Hires Page
Global Payroll	Overtime > 10 Hours	O/T >10
Global Payroll	Payee in Error	GP_WC_PAYROLL_ERROR_MSG
Global Payroll	Terminations	GP_WC_TERMINATION	Terminations Page
Global Payroll	Unprocessed Iterative	GP_WC_ITERATIVE_TRGR
Global Payroll	Unprocessed Retro	GP_WC_RETRO_TRGR
Global Payroll	Unprocessed Segmentation	GP_WC_SEGMENTATION_TRGR
Global Payroll	View Department ID Details	GP_CS_DEPTID_ACUM GP_CS_DEPTID_GROSS GP_CS_DEPTID_NET	See Processing Monitor - By Calendar Group Page
Global Payroll United Kingdom	Court Order	COURT ORDER
Global Payroll United Kingdom	Pennies for Charity	GBR DD PENNS
Human Resources	Current Headcount	HR_PG_HC_CURRNT_ADMIN	Current Headcount Pivot Grid
Human Resources	Current Headcount Profile- Mgr	HR_PG_HC_CURRNT_MGR	Headcount Movement Page
Human Resources	Diversity Analysis	HR_PG_WF_DIV_TYPE_ADM	Diversity Analysis Page
Human Resources	Diversity Overview	HR_PG_WF_DIV_ADM	Diversity Overview Page
Human Resources	Headcount Movement	HR_PG_HC_MOVMNT_ADMIN	Headcount Movement Pivot Grid
Human Resources	Headcount Movement - Manager	HR_PG_HC_MOVMNT_MGR	Headcount Movement Page
Human Resources	Highest Education Level	HR_PG_ED_LVL_ADM	Highest Education Page
Human Resources	Position Status	HR_PG_POS_STATUS_ADM	Position Status Page
Human Resources	Workforce Turnover	HR_PG_WF_TRNOVR_ADM	Workforce Turnover Page
Payroll for North America	Comparative Checks Comparative Cheques	PY_WC_CHK_HIST_USA PY_WC_CHK_HIST_CAN	Comparative Checks Pivot Grid Comparative Checks Page
Payroll for North America	Comparative Deductions	PY_WC_DED_HIST_CAN PY_WC_DED_HIST_USA	Comparative Deductions Pivot Grid Comparative Deductions Page
Payroll for North America	Comparative Earnings	PY_WC_ERN_HIST_CAN PY_WC_ERN_HIST_USA	Comparative Earnings Pivot Grid Comparative Earnings Page
Payroll for North America	Deductions By Company	PY_WC_DED_COM_CAN PY_WC_DED_COM_USA	Deductions By Company Pivot Grid Deductions By Company Page
Payroll for North America	Deductions by Deduction Code	PY_WC_DED_DEDCD_CAN PY_WC_DED_DEDCD_USA	Deductions By Deduction Code Pivot Grid Deductions By Deduction Code Page
Payroll for North America	Earnings by Company	PY_WC_ERN_COM_CAN PY_WC_ERN_COM_USA	Earnings By Company Pivot Grid Earnings By Company Page
Payroll for North America	Earnings by Earnings Code	PY_WC_ERN_ERNCD_CAN PY_WC_ERN_ERNCD_USA	Earnings By Earnings Code Pivot Grid Earnings By Earnings Code Page
Payroll for North America	Employee Check Data Employee Cheque Data	PY_WC_CHK_USA PY_WC_CHK_CAN	Employee Paycheck Information Pivot Grid Paycheck Information Page
Payroll for North America	Payment Option	PY_WC_PAYMENT_OPT_CAN PY_WC_PAYMENT_OPT_USA	Payment Options Page Payment Options Page
Talent Acquisition Manager	Application Diversity	HRS_PG_DA_APPLN HRS_PG_DA_APPLN2	Applicant Diversity Overview Pivot Grid Diversity By Applications Pivot Grid Applications Diversity Pivot Grid
Talent Acquisition Manager	Average Time to FIll	HRS_PG_TTF_DB HRS_PG_TTF_DB_A	Time to Fill Pagelet Time to Fill Pivot Grid Time to Fill Jobs Pivot Grid
Talent Acquisition Manager	Diversity Overview	HRS_PG_DIV_OV1 HRS_PG_DIV_OV2 DIVERSITY OVERVIEW	Applicant Diversity Overview Pivot Grid Diversity Overview Page
Talent Acquisition Manager	In Process Applicants	HRS_PG_INPRC_APPL_SA HRS_PG_INPRC_APPL	In Process Applicants Pivot Grid In Process Applicants Pivot Grid
Talent Acquisition Manager	Job Opening Aging Analysis	HRS_PG_JO_AGE_M HRS_PG_JO_AGE_MY_ANALYTICS HRS_PG_JO_AGE_SA HRS_PG_JO_AGE	Job Opening Aging Analysis Pivot Grid Job Opening Aging Pivot Grid
Talent Acquisition Manager	Job Openings Opened/Closed JO Opened and Closed Job Opening Open/Close	HRS_PG_JO_OC HRS_PG_JO_OC_M HRS_PG_JO_OC_SA	Job Opening Open and Close Trend Pivot Grid Jobs Opened/Closed Pivot Grid
Talent Acquisition Manager	JO Time to Fill JO Time to Fill JO Time to Fill - Manager JO Time to Fill - Manager Time to Fill Jobs	HRS_PG_TTF HRS_PG_TTF_A HRS_PG_TTF_M HRS_PG_TTF_M_A HRS_PG_TTF_MY_ANALYTICS	Time to Fill Pivot Grid Time to Fill Jobs Pivot Grid
Time and Labor	Absence Type	TL_ABST_IRPT	Absence Type - Absence Mgmt Pivot Grid Page
Time and Labor	Absence Types - Benefits	TL_ABST_IRPT_BC	Absence Types - Benefits Pivot Grid Page
Time and Labor	ACA Full/ Part Time Status	ACA_FULL_PART_TIME	ACA Full/Part Time Status Page
Time and Labor	ACA Monthly Threshold	ACA_MONTHLY_RPT	ACA Threshold Limits Page
Time and Labor	ACA New Hire/ Rehire	ACA_HIRE_REHIRE	ACA New Hire/Rehire Report Page
Time and Labor	ACA Weekly Threshold	ACA_WEEKLY_RPT	ACA Threshold Limits Page
Time and Labor	Attendance Violations	TL_ATTP_IRPT	Attendance Violations Pivot Grid Page
Time and Labor	Payable Time by Labor Costs	TL_LBR_IRPT	Labor Costs Page
Time and Labor	Payable Time by Status	TL_PT_STATUS_IRPT	Payable Time by Status Page
Time and Labor	Payable Time Trend	TL_PT_TREND_IRPT	Payable Time Trend Page
Time and Labor	Schedule Assign Enrollments	SCH_AENRL_PREVIEW	Preview Schedule Assignment Report
Time and Labor	Scheduled Enrollment Errors	SCH_AENRL_ERRORS	Errors Schedule Assignment Report
Time and Labor	Time and Labor Enrollments	TL_AENRL_PREVIEW	Preview Time and Labor Report
Time and Labor	Time Categories Comparison	TL_TIM_CAT_COMP_IRPT	Time Categories Comparison Page
Time and Labor	Timesheet by Status	TL_RPTD_IRPT	Timesheet by Status Pivot Grid Page
Time and Labor	TL Enrollment Errors	TL_AENRL_ERRORS	Errors Time and Labor Report
Time and Labor	TL Time Status Pivot Grid	TL_TIME_STATUS_IRPT	Payable Time by Status Page Timesheet by Status Pivot Grid Page
Time and Labor	Workforce Analytics	TL_WFA_DEPT_HRS