This chapter provides prerequisites, an overview of delivered OBIEE dashboards for the HCM Warehouse, and discusses:
Recruitment Analysis Dashboard - Recruitment Demand Page
Recruitment Analysis Dashboard - Recruiting Effectiveness Page
Recruitment Analysis Dashboard - Applicant Trending Page
Workforce Profile Dashboard - Overview Page
Workforce Profile Dashboard - Workforce Demographics Page
Workforce Profile Dashboard - Contingent Workforce Analysis Page
Workforce Profile Dashboard - Turnover Trend Page
Workforce Profile Dashboard - Workforce Activity Page
Workforce Profile Dashboard - Top Performer Turnover Page
Workforce Profile Dashboard - EEO Compliance Page
Workforce Profile Dashboard - Headcount Distribution Page
Workforce Profile Dashboard - Demographic Trend Page
Workforce Profile Dashboard - Employee Demographics Page
Workforce Profile Dashboard - Pay for Performance Page
Before you use dashboards for the HCM Warehouse, you must implement:
PeopleSoft HCM Warehouse.
PeopleSoft Human Resources Management System (HRMS), which supplies transaction data to the HCM Warehouse.
The prebuilt dashboard and reports packaged for the HCM Warehouse help you proactively monitor workforce trends and retention. You can optimize your workforce by capturing and analyzing data regarding workforce demographics, movement, and turnover.
PeopleSoft provides dashboards that map to the following HCM Warehouse data marts:
Compensation
Learning and Development
Recruiting
Workforce Profile
The Turnover Trend page in the Workforce Profile dashboard contains the Turnover Correlation Guided Navigation that appears conditionally based on the voluntary turnover results. When the system detects that voluntary turnover exceeds its predefined threshold of 20%, a link appears in the Turnover Trend section so that you can easily access the Employee Termination Detail report for further investigation.
You can change the delivered threshold value by accessing the Create/Edit Filter page for the Voluntary Term Rate column and editing the filter, as shown in this example:
See Using the Workforce Profile Dashboard - Turnover Trend Page.
See Also
Oracle Business Intelligence Answers, Delivers, and Interactive Dashboards User Guide, "Filtering Requests in Oracle BI Answers."
This list contains the financials-oriented Oracle BI Server and Oracle Presentation Catalog security groups provided for the HCM Warehouse:
HCM Executive
HCM Manager
Line Manager
Access the Recruitment Demand page (Dashboards, HCM: Human Capital Management, HCM: Recruitment Analysis, Recruitment Demand).
Usage |
Reports |
Dashboard Prompt |
Provides you with an overview of recruiting metrics for your organization, including open positions and hiring demand counts analysis. |
This page is comprised of the following reports:
|
Use the Recruitment Demand page prompt to filter page results by:
|
Access the Current Open Positions report, which enables you to analyze current open positions within your organization by individual department.
The pie chart displays open position count percentage grouped by department.
The following table lists the columns and measures used in the Current Open Positions report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Open Position Count |
Recruitment (F_RCMNT) Fact |
Access the Hiring Demand Analysis report, which enables you to analyze hiring demands for your organization and view details of open position headcount by fiscal year, fiscal quarter, and department.
The Hiring Demand Analysis graph displays Fiscal Year, Fiscal Quarter data on the x-axis and Open Position Count data on the y-axis.
The following table lists the columns and measures used in the Hiring Demand Analysis report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Open Position Count |
Recruitment (F_RCMNT) Fact |
Access the Hiring Demand Surge Details report, which enables you to analyze hiring demands for an organization and view details of open position headcount by fiscal year, fiscal quarter, department, region, and job description.
The following table lists the columns and measures used in the Hiring Demand Surge Details report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Location |
Location (D_LOCATION) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Department |
Department (D_DEPT) Dimension |
Open Position Count |
Recruitment (F_RCMNT) Fact |
Access the Recruiting Effectiveness page (Dashboards, HCM: Human Capital Management, HCM: Recruitment Analysis, Recruiting Effectiveness).
Usage |
Reports |
Dashboard Prompt |
Provides you with an overview of recruiting effectiveness metrics for your organization, including vacancy fill rates, time to fill analysis, and recruiting source effectiveness. |
This page is comprised of the following reports:
|
Use the Recruiting Effectiveness page prompt to filter page results by:
|
Access the Vacancy Fill Rate report, which enables you to analyze vacancy fill rates for your organization and view details about job openings count, hire count, and job fill rate percentage.
The Vacancy Fill Rate graph displays Fiscal Year, Fiscal Quarter data on the x-axis and Filled Position Count and Position Fill Rate data on the y-axis.
The following table lists the columns and measures used in the Vacancy Fill Rate report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Open Position Count |
Recruitment (F_RCMNT) Fact |
Filled Position Count |
Recruitment (F_RCMNT) Fact |
Position Fill Rate (%) |
("Fact Recruitment"."Hire Count") /("Fact Job Opening"."Job Openings Count") * 100 |
Access the Time to Fill report, which enables you to analyze the time it takes for various departments in your organization to fill a job opening.
The Time to Fill graph displays Fiscal Year, Fiscal Quarter data on the x-axis and Average Open Position Duration (Days) data on the y-axis.
The following table lists the columns and measures used in the Time to Fill report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Average Open Position Duration (Days) |
Recruitment (F_RCMNT) Fact: CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('090','100','110','120') THEN ( "Dimension Day Entry Date"."Entry Day Date"-"Dimension Day Status Date"."Status Day Date" ) ELSE NULL END |
Access the Recruiting Source Effectiveness report, which enables you to analyze the effectiveness of your organization's recruiting sources and view details about the number of candidates hired by department, job, referral source and referral source percentage.
X,Y Axis Data |
Referral Source Filter |
The Recruiting Source Effectiveness graph displays Department and Job Description data on the x-axis and Number of Candidates, Number of Candidates Hired and % Hired from Source data on the y-axis. |
Use this filter to view report results by the following referral sources:
|
The following table lists the columns and measures used in the Recruiting Source Effectiveness report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Referral Source Category Description |
Referral Source Category (D_REF_SRC_CAT) Dimension |
Number of Candidates |
Recruitment (F_RCMNT) Fact |
Number of Candidates Hired |
Recruitment (F_RCMNT) Fact |
% Hired from Source |
("Fact Recruitment"."Hire Count"/"Fact Recruitment"."Applicant Headcount")*100 |
Access the Vacancy Fill Rate Details report, which enables you to analyze job vacancy fill rates for various departments in your organization and view details about job openings count, hire count, and job fill rate percentage.
X,Y Axis Data |
View By Filter |
The Vacancy Fill Rate Details graph displays Fiscal Year data on the x-axis and Open Position Count, Filled Position Count and Position Fill Rate data on the y-axis. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Vacancy Fill Rate Details report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Job Description |
Employee Job Code (D_EMPL_JOB) Dimension |
Job Family Description |
Employee Job Code (D_EMPL_JOB) Dimension |
Grade |
Employee Job Code (D_EMPL_JOB) Dimension |
Filled Position Count |
Recruitment (F_RCMNT) Fact |
Open Position Count |
Recruitment (F_RCMNT) Fact |
Position Fill Rate (%) |
("Fact Recruitment"."Hire Count") /("Fact Job Opening"."Job Openings Count") * 100 |
Access the Recruiting Source Effectiveness Detail report, which enables you to analyze recruiting source effectiveness for your organization.
X,Y Axis Data |
View By Filter |
The Recruiting Source Effectiveness Detail graph displays Fiscal Year and Referral Source data on the x-axis and Percent Hired from Source data on the y-axis. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Recruiting Source Effectiveness Detail report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Referral Source Category Description |
Referral Source Category (D_REF_SRC_CAT) Dimension |
Hire Count |
Recruitment (F_RCMNT) Fact |
Applicant Head Count |
Recruitment (F_RCMNT) Fact: |
% Hired from Source |
Fact Recruitment.Hire Count / Fact Recruitment.Applicant Head Count * 100 |
Access the Applicant Trending page (Dashboards, HCM: Human Capital Management, HCM: Recruitment Analysis, Applicant Trending).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of applicant trends and characteristics for your organization. |
This page is comprised of the following reports:
|
Use the Applicant Trending page prompt to filter page results by:
|
Access the Applicant Tracking report, which enables you to analyze applicant offer, acceptance, hire, and head counts.
The Applicant Tracking graph displays Fiscal Year and Fiscal Quarter data on the x-axis and Applicant Headcount, Offer Count, Acceptance Count and Hire Count data on the y-axis.
The following table lists the columns and measures used in the Applicant Tracking report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Fiscal Quarter |
Day (D_DAY) Dimension |
Applicant Head Count |
Recruitment (F_RCMNT) Fact |
Offer Count |
Recruitment (F_RCMNT) Fact: COUNT_DISTINCT(CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('070','071','075','076','077','078','080','090','100','110','120') THEN Fact Recruitment.Applicant Sid ELSE NULL END) |
Acceptance Count |
Recruitment (F_RCMNT) Fact: COUNT_DISTINCT(CASE WHEN Dimension Recruitment Status Reason.Recruitment Area Code = '3' AND Dimension Recruitment Status Reason.Recruitment Status Code IN ('071','075','076','077','078','080','090','100','110','120') THEN Fact Recruitment.Applicant Sid ELSE NULL END) |
Hire Count |
Recruitment (F_RCMNT) Fact |
Access the Applicant Characteristics report, which enables you to analyze applicant characteristics, such as ethnic group, marital status, disability, and highest education level.
X,Y Axis Data |
View By Filter |
The Applicant Characteristics graph displays Fiscal Year data on the x-axis and Total Applicant Headcount and data on the y-axis. The y-axis will also display one of the following values, depending on your View By filter selection:
|
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Applicant Characteristics report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year (Status Year Number) |
Day Status Date (D_DAY) Dimension |
Applicant Ethnic Group |
Applicant (D_APPLICANT) Dimension |
Applicant Marital Status |
Applicant (D_APPLICANT) Dimension |
Applicant Disabled Indicator |
Applicant (D_APPLICANT) Dimension |
Applicant Highest Education Level |
Applicant (D_APPLICANT) Dimension |
Applicant Veterans Preference |
Applicant (D_APPLICANT) Dimension |
Applicant Full/Part Time |
Applicant (D_APPLICANT) Dimension |
Applicant Salary Grade |
Applicant (D_APPLICANT) Dimension |
Applicant Head Count |
Recruitment (F_RCMNT) Fact |
Access the Workforce Profile - Overview page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Overview).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of headcount, turnover, and promotion trends for your organization. |
This page is comprised of the following reports:
|
Use the Workforce Profile - Overview page prompt to filter page results by:
|
Access the Headcount by Region report, which enables you to analyze headcount and termination distribution by department or location.
View By Filter - Department Name (Default) |
View By Filter - Location |
The Headcount Distribution pie chart displays Headcount / Percent Headcount data grouped by Department. The Termination Distribution pie chart displays Terminations / Percent Terminations data grouped by Department. Note. You can click on a pie slice to drill down to individual department-level data. |
The Headcount Distribution pie chart displays Headcount / Percent Headcount data grouped by Location. The Termination Distribution pie chart displays Terminations / Percent Terminations data grouped by Location. Note. You can click on a pie slice to drill down to individual location data. |
The following table lists the columns and measures used in the Headcount by Region and Organization report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Termination (count) |
Workforce (F_WORKFORCE) Fact |
% Headcount |
Workforce (F_WORKFORCE) Fact |
% of Termination |
Workforce (F_WORKFORCE) Fact |
Access the Headcount Trend report, which provides a trending of headcount by quarter, year, department, and location.
X,Y Axis Data |
View By Filter |
The Headcount Trend graph displays Snapshot Year, Quarter data on the x-axis and Headcount and Department data on the y-axis. The y-axis can also display Location data if you select the value from the View By filter. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Headcount Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Snapshot Year |
Day (D_DAY) Dimension |
Snapshot Quarter |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Turnover Trend report, which provides a trending of employee turnover by quarter, year, department, and location.
X,Y Axis Data |
View By Filter |
The Turnover Trend graph displays Year, Quarter data on the x-axis and Turnover Rate and Department data on the y-axis. The y-axis can also display Location data if you select the value from the View By filter. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Turnover Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Year |
Day (D_DAY) Dimension |
Quarter |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Turnover Rate |
Workforce (F_WORKFORCE) Fact: Total Termination Count * (100 / Total Headcount) |
Access the Promotion Trend report, which provides a trending of employee promotions by quarter, year, department, and location.
X,Y Axis Data |
View By Filter |
The Promotion Trend graph displays Year, Quarter data on the x-axis and Promotion Count and Department data on the y-axis. The y-axis can also display Location data if you select the value from the View By filter. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Promotion Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Year |
Day (D_DAY) Dimension |
Quarter |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Promotion Count |
Workforce (F_WORKFORCE) Fact |
Access the Workforce Demographics page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Workforce Demographics).
Usage |
Reports |
Dashboard Prompt |
Provides a detailed overview of organization headcount demographics |
This page is comprised of the following reports:
|
Use the Workforce Demographics page prompt to filter page results by:
|
Access the Headcount Demographics report, which details headcount by various demographic dimensions such as age, service group, location, and department.
Pie Chart Data |
View By Filter |
The Headcount Demographics pie chart displays Headcount data grouped by Age Group. Headcount data can also be grouped by any of the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to headcount data for a particular dimension (such as location). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Headcount Demographics report.
Report Column / Measure Name |
Report Column / Measure Origin |
Age Group |
Age Group (D_AGRGRP_VW) Dimension (D_DURATION) |
Fairlabor Standards Act Status |
Employee Job (D_EMPL_JOB) Dimension |
Service Group |
Service Group (D_SERVICEGRP_VW) Dimension (D_DURATION) |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Headcount Distribution by Job Category report, which details employee headcount distribution by various job category dimensions such as job code, position, and salary grade.
Pie Chart Data |
View By Filter |
The Headcount Distribution by Job Category pie chart displays Headcount data grouped by Job Family Description. Headcount data can also be grouped by any of the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to head count data for a particular dimension (such as location). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Headcount Distribution by Job Category report.
Report Column / Measure Name |
Report Column / Measure Origin |
Equal Employment Opportunity 1 Code |
Jobcode (D_JOBCODE) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Job Family Description |
Jobcode (D_JOBCODE) Dimension |
Position |
Position (D_POS) Dimension |
Salary Grade Group |
Salary Grade Group (D_SALGRDGRP_VW) Dimension (D_DURATION) |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Termination Demographics report, which details employee terminations by various dimensions such as age, department, or service group.
Pie Chart Data |
View By Filter |
The Termination Demographics pie chart displays Termination Count data grouped by Fairlabor Standards Act Status. Termination count data can also be grouped by any of the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to termination count data for a particular dimension (such as location). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Termination Demographics report.
Report Column / Measure Name |
Report Column / Measure Origin |
Age Group |
Age Group (D_AGRGRP_VW) Dimension (D_DURATION) |
Fairlabor Standards Act Status |
Employee Job (D_EMPL_JOB) Dimension |
Service Group |
Service Group (D_SERVICEGRP_VW) Dimension (D_DURATION) |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Termination Count |
Workforce (F_WORKFORCE) Fact |
Access the Termination Distribution by Job Category report, which details employee termination distribution by various job category dimensions such as job code, position, and salary grade.
Pie Chart Data |
View By Filter |
The Termination Distribution by Job Category pie chart displays Termination Count data grouped by Department. Termination count data can also be grouped by any of the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to termination count data for a particular dimension (such as position). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Termination Distribution by Job Category report.
Report Column / Measure Name |
Report Column / Measure Origin |
Equal Employment Opportunity 1 Code |
Jobcode (D_JOBCODE) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Job Family Description |
Jobcode (D_JOBCODE) Dimension |
Position |
Position (D_POS) Dimension |
Salary Grade Group |
Salary Grade Group (D_SALGRDGRP_VW) Dimension (D_DURATION) |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Termination Count |
Workforce (F_WORKFORCE) Fact |
Access the Promotion Demographics report, which details employee promotions by various dimensions such as age group, location, or department.
Pie Chart Data |
View By Filter |
The Promotion Demographics pie chart displays Promotion Count data grouped by Department. Promotion count data can also be grouped by any of the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to promotion count data for a particular dimension (such as age group). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Promotion Demographics report.
Report Column / Measure Name |
Report Column / Measure Origin |
Age Group |
Age Group (D_AGRGRP_VW) Dimension (D_DURATION) |
Fairlabor Standards Act Status |
Employee Job (D_EMPL_JOB) Dimension |
Service Group |
Service Group (D_SERVICEGRP_VW) Dimension (D_DURATION) |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Promotion Count |
Workforce (F_WORKFORCE) Fact |
Access the Promotion Distribution by Job Category report, which details employee promotion distribution by various job category dimensions such as job code, position, and salary grade.
Pie Chart Data |
View By Filter |
The Promotion Distribution by Job Category pie chart displays Promotion Count data grouped by Equal Employment Opportunity 1 Code. Promotion count data can also be grouped by any of the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to promotion count data for a particular dimension (such as department). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Promotion Distribution by Job Category report.
Report Column / Measure Name |
Report Column / Measure Origin |
Equal Employment Opportunity 1 Code |
Jobcode (D_JOBCODE) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Job Family Description |
Jobcode (D_JOBCODE) Dimension |
Position |
Position (D_POS) Dimension |
Salary Grade Group |
Salary Grade Group (D_SALGRDGRP_VW) Dimension (D_DURATION) |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Promotion Count |
Workforce (F_WORKFORCE) Fact |
Access the Contingent Workforce Analysis page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Contingent Workforce Analysis).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of contingent headcount distribution and labor utilization for your organization. |
This page is comprised of the following reports:
|
Use the Contingent Workforce Analysis page prompt to filter page results by:
|
Access the Contingent Headcount Distribution report, which provides an overview of contingent headcount distribution by department, geography and job family.
Pie Chart Data |
View By Filter |
The Contingent Headcount Distribution pie chart displays Contingent Headcount data grouped by Department. Contingent headcount data can also be grouped by any of the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to contingent headcount data for a particular dimension (such as geography). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Contingent Headcount Distribution report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Geography |
Geography (D_GEOGRAPHY) Dimension |
Job Family Description |
Jobcode (D_JOBCODE) Dimension |
Contingent Headcount |
Workforce (F_WORKFORCE) Fact |
Headcount |
Workforce (F_WORKFORCE) Fact |
Total Headcount |
Workforce (F_WORKFORCE) Fact |
Contingent Labor Utilization (percent) |
Workforce (F_WORKFORCE) Fact: |
Total Contingent Labor Utilization (percent) |
Workforce (F_WORKFORCE) Fact: Contingent Headcount / Total Headcount |
Access the Contingent Headcount Distribution Details report, which provides a detailed analysis of contingent headcount distribution.
Access the Contingent Labor Utilization % Trend report, which details labor utilization percentages, headcount, and contingent headcount trends by quarter.
The Contingent Labor Utilization % Trend graph displays Year and Quarter data on the x-axis and Headcount, Contingent Headcount and Contingent Labor Utilization % data on the y-axis.
Note. You can click on graph data to review drill down data for a particular year and quarter.
The following table lists the columns and measures used in the Contingent Labor Utilization % Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Year |
Day (D_DAY) Dimension |
Quarter |
Day (D_DAY) Dimension |
Contingent Headcount |
Workforce (F_WORKFORCE) Fact |
Headcount |
Workforce (F_WORKFORCE) Fact |
Contingent Labor Utilization % |
Workforce (F_WORKFORCE) Fact |
Access the Turnover Trend page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Turnover Trend).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of turnover and position-change trends for your organization. |
This page is comprised of the following reports:
|
Use the Turnover Trend page prompt to filter page results by:
|
Access the Turnover Trend report, which details employee turnover trend by voluntary term rate and involuntary term rate by quarter.
The Turnover Trend graph displays Snapshot Year and Snapshot Quarter data on the x-axis and Headcount, Voluntary Term Rate, and Headcount Involuntary Term Rate data on the y-axis.
Note. You can click on graph data to review drill down data for a particular year and quarter.
The following table lists the columns and measures used in the Turnover Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Snapshot Year |
Day (D_DAY) Dimension |
Snapshot Quarter |
Day (D_DAY) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Voluntary Term Rate |
Workforce (F_WORKFORCE) Fact This measure is calculated by dividing the sum of Voluntary count by sum of Terminate count when terminate count not equal to 0: Case when [(IF Fact Workforce.TERMINATE_COUNT <> 0 AND Dimension Action.WA_VOLUNTARY_FLAG = 'V' then Fact Workforce.TERMINATE_COUNT else 0) * 100 / nullif (Fact Workforce.TERMINATE_COUNT,0)] else 0. |
Involuntary Term Rate |
Workforce (F_WORKFORCE) Fact This measure is calculated by dividing sum of Involuntary count by sum of Termination count when terminate count not equal to 0: Case when [(IF Fact Workforce.TERMINATE_COUNT <> 0 AND Dimension Action.WA_VOLUNTARY_FLAG = 'I' then Fact Workforce.TERMINATE_COUNT else 0) * 100 / nullif (Fact Workforce.TERMINATE_COUNT,0)] else 0. |
Access the Position Change Trends report, which details turnover rates, promotion ratio, and hire count by quarter.
The Position Change Trends graph displays Snapshot Year and Snapshot Quarter data on the x-axis and Hire Count, Turnover Rate, and Promotion Ratio data on the y-axis.
Note. You can click on graph data to review drill down data for a particular year and quarter.
The following table lists the columns and measures used in the Position Change Trends report.
Report Column / Measure Name |
Report Column / Measure Origin |
Snapshot Year |
Day (D_DAY) Dimension |
Snapshot Quarter |
Day (D_DAY) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Turnover Rate |
Workforce (F_WORKFORCE) Fact: Total Termination Count * (100 / Total Headcount) |
Promotion Ratio |
Workforce (F_WORKFORCE) Fact Promotion Count / Total Headcount |
Access the Termination Detail report, which details both voluntary term rate and involuntary term rate by age group, job function, service group, and appraisal review rating.
X,Y Axis Data |
View By Filter |
The Termination Detail graph displays Age Group data on the x-axis and Voluntary Count and Involuntary Count data on the y-axis. The x-axis can also display any of the following dimensions, depending on your View By filter selection:
Note. You can on graph data to review drill down data for a particular dimension (such as job function). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Termination Detail report.
Report Column / Measure Name |
Report Column / Measure Origin |
Job Function |
Jobcode (D_JOBCODE) Dimension |
Appraisal Review Rating |
Employee Appraisal (D_EMPL_APRSL) Dimension |
Service Group |
Service Group (D_SERVICEGRP_VW) Dimension (D_DURATION) |
Age Group |
Age Group (D_AGRGRP_VW) Dimension (D_DURATION) |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Access the Termination Root Cause report, which enables you to analyze root causes of termination across your organization and the action taken.
X,Y Axis Data |
Choose View Filter |
In chart view, the Termination Root Cause graph displays Reason data on the x-axis and Voluntary Count and Involuntary Count data on the y-axis. In pivot table view, the same data is displayed in table format, but includes the addition of Department data. |
Use this filter to view report results in chart format or pivot table format. |
The following table lists the columns and measures used in the Termination Root Cause report.
Report Column / Measure Name |
Report Column / Measure Origin |
Person |
Person (D_PERSON) Dimension |
Position |
Position (D_POS) Dimension |
Action |
Action (D_WA_ACTION) Dimension |
Department |
Department (D_DEPT) Dimension |
Reason |
Response Reason (D_RESP_RSN) Dimension |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Access the Top Performer Turnover Trend report, which enables you to analyze voluntary and involuntary turnover trends for your top performers across your organization.
The Top Performer Turnover Trend graph displays Fiscal Quarter data on the x-axis and Voluntary Count, Involuntary Count and Total Number of Top Performer Termination Count data on the y-axis.
Note. You define the report threshold value in the chart view of the report. In chart view, click Axis Scaling. In the new window click Edit Scale Markers. In the new window, edit the threshold value per your business requirements.
The following table lists the columns and measures used in the Top Performer Turnover Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Quarter |
Day (D_DAY) Dimension |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Total Number of Top Performer Termination |
Workforce (F_WORKFORCE) Fact |
Access the Turnover Distribution Analysis report, which details both voluntary term counts and involuntary term counts by fiscal year and department.
The Turnover Distribution Analysis graph displays Fiscal Year data on the x-axis and Voluntary Count and Involuntary Count data on the y-axis.
Note. You can click on graph data to review drill down data for a particular year.
The following table lists the columns and measures used in the Turnover Distribution Analysis report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Access the Turnover Demographics report, which enables you to analyze employee turnover by demographic, such as gender or age.
X,Y Axis Data |
View By Filter |
The Turnover Demographics graph displays Gender data on the x-axis and Voluntary Count and Involuntary Count data on the y-axis. The x-axis can also display any of the following dimensions, depending on your View By filter selection:
Note. You can click on graph data to review drill down data for a particular dimension (such as gender or age). |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Turnover Demographics report.
Report Column / Measure Name |
Report Column / Measure Origin |
Employee Type |
Employee Job Code (D_EMPL_JOB) Dimension |
Age |
Person (D_PERSON) Dimension |
Ethnic Group |
Person (D_PERSON) Dimension |
Gender |
Person (D_PERSON) Dimension |
Position Security Clearance Code |
Position (D_POS) Dimension |
Employee High Potential Flag |
This flag uses a Y or N value, based on Higher Education Level Code (HI_EDU_LVL_CD) values, which include:
If HI_EDU_LVL_CD value = J, K or L, then Employee High Potential Flag is set to Y. Otherwise, the flag is set to N. |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Access the Workforce Activity page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Workforce Activity).
Usage |
Dashboard Prompt |
Provides you with an overview of workforce movement for your organization, such as new hires, transfers, and terminations. |
Use the Workforce Activity page prompt to filter page results by:
|
Access the Workforce Movement Activity report, which enables you to track workforce movement within your organization, such as new hires, transfers, and terminations.
The following table lists the columns and measures used in the Workforce Movement Activity report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Start Headcount |
Workforce (F_WORKFORCE) Fact |
End Headcount |
Workforce (F_WORKFORCE) Fact |
Hire Count |
Recruitment (F_RCMNT) Fact |
Transfer in Count |
Workforce Activity (F_WORKFORCE_ACT) Fact |
Transfer out Count |
Workforce Activity (F_WORKFORCE_ACT) Fact |
Termination Count |
Workforce (F_WORKFORCE) Fact |
Headcount Net Change |
Workforce Activity (F_WORKFORCE_ACT) Fact |
Headcount Change Percent |
Workforce Activity (F_WORKFORCE_ACT) Fact: (Headcount Net Change / Grand Total Headcount Net Change) * 100 |
Access the Top Performer Turnover page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Top Performer Turnover).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of key turnover metrics for top performers in your organization, such as recent losses and trends. |
This page is comprised of the following reports:
|
Use the Top Performer Turnover page prompt to filter page results by:
|
Access the Recent Regrettable Losses report, which displays information about employees that have recently left the organization.
Access the Top Performer Turnover Trends report, which details trending of both voluntary term rate and involuntary term rate of your top performers.
The Top Performer Turnover Trends graph displays Snapshot Year and Snapshot Quarter data on the x-axis and Voluntary Term Rate and Involuntary Term Rate data on the y-axis.
Note. You can click on graph data to review drill down data for a particular year or quarter.
The following table lists the columns and measures used in the Top Performer Turnover Trends report.
Report Column / Measure Name |
Report Column / Measure Origin |
Snapshot Year |
Day (D_DAY) Dimension |
Snapshot Quarter |
Day (D_DAY) Dimension |
Voluntary Term Rate |
Workforce (F_WORKFORCE) Fact This measure is calculated by dividing the sum of Voluntary count by sum of Terminate count when terminate count not equal to 0: Case when [(IF Fact Workforce.TERMINATE_COUNT <> 0 AND Dimension Action.WA_VOLUNTARY_FLAG = 'V' then Fact Workforce.TERMINATE_COUNT else 0) * 100 / nullif (Fact Workforce.TERMINATE_COUNT,0)] else 0. |
Involuntary Term Rate |
Workforce (F_WORKFORCE) Fact This measure is calculated by dividing sum of Involuntary count by sum of Termination count when terminate count not equal to 0: Case when [(IF Fact Workforce.TERMINATE_COUNT <> 0 AND Dimension Action.WA_VOLUNTARY_FLAG = 'I' then Fact Workforce.TERMINATE_COUNT else 0) * 100 / nullif (Fact Workforce.TERMINATE_COUNT,0)] else 0. |
Access the Top Performer At Risk report, which details top performers at risk of turnover by department, location and job.
You can click any person name, department name, or location on the graph to review drill down data.
The following table lists the columns and measures used in the Top Performer At Risk report.
Report Column / Measure Name |
Report Column / Measure Origin |
Snapshot Year |
Day (D_DAY) Dimension |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Performance Rating |
Employee Appraisal (D_EMPL_APRSL) Dimension |
Person Name |
Person (D_PERSON) Dimension |
Promotion Count |
Workforce (F_WORKFORCE) Fact |
Access the EEO Compliance page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, EEO Compliance).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of equal employment opportunity metrics for your organization by ethnicity, gender, and minority group. |
This page is comprised of the following reports:
|
Use the EEO Compliance page prompt to filter page results by Fiscal Year. |
Access the Professional Category By Ethnicity report, which enables you to analyze the ethnic composition of your workforce.
The Professional Category By Ethnicity pie chart displays Headcount data grouped by Ethnic Group.
Note. You can click on a pie slice to drill down to active headcount data for a particular ethnic group.
The following table lists the columns and measures used in the Professional Category By Ethnicity report.
Report Column / Measure Name |
Report Column / Measure Origin |
Snapshot Year |
Day (D_DAY) Dimension |
Ethnic Group |
Person (D_PERSON) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Minority Representation by Job Category report, which enables you to analyze the ethnic composition of employees across equal employment opportunity job categories.
The Minority Representation by Job Category graph displays Headcount data on the x-axis and EEO Job Category and Fiscal Year data on the y-axis.
Note. You can click on graph data to review drill down data for a particular year.
The following table lists the columns and measures used in the Minority Representation by Job Category report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
EEO Job Category |
Job Code (D_JOBCODE) Dimension |
Ethnic Group |
Person (D_PERSON) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Female Representation By Job Category report, which enables you to analyze female representation across job categories.
The Female Representation By Job Category graph displays Gender and Job Code data on the x-axis and Headcount and Fiscal Year data on the y-axis.
Note. You can click on graph data to review drill down data for a particular job code and year.
The following table lists the columns and measures used in the Female Representation By Job Category report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Gender |
Person (D_PERSON) Dimension |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Headcount Distribution page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Headcount Distribution).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of headcount distribution for your organization by department and job category, as well as headcount trends. |
This page is comprised of the following reports:
|
Use the Headcount Distribution page prompt to filter page results by:
|
Access the Headcount Distribution report, which enables you to analyze the distribution of employees across departments or location.
Pie Chart Data |
View By Filter |
The Headcount Distribution pie chart displays Headcount data grouped by Department. Note. You can click on a pie slice to drill down to headcount data for a particular department or location. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Headcount Distribution report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Location |
Location (D_LOCATION) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
% of Total Headcount |
(Applicant Count / Total Applicants) * 100 |
Access the Headcount by Job Categories report, which enables you to analyze the distribution of employees across job categories.
Pie Chart Data |
View By Filter |
The Headcount by Job Categories pie chart displays Headcount data grouped by Job Series. Headcount data can also be grouped by the following dimensions, depending on your View By filter selection:
Note. You can click on a pie slice to drill down to headcount data for a particular job code, job series, or grade. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Headcount by Job Categories report.
Report Column / Measure Name |
Report Column / Measure Origin |
Job Code |
Employee Job Code (D_EMPL_JOB) Dimension |
Job Series |
Employee Job Code (D_EMPL_JOB) Dimension |
Grade |
Employee Job Code (D_EMPL_JOB) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
% of Total Headcount |
(Applicant Count / Total Applicants) * 100 |
Access the Organization Headcount Trend report, which details headcount, voluntary count, and involuntary count trends.
The Organization Headcount Trend graph displays Fiscal Quarter data on the x-axis and Headcount data on the y-axis, with Voluntary Count and Involuntary Count data plotted across the x/y-axis.
Note. You can on graph data to review drill down data for a particular quarter.
The following table lists the columns and measures used in the Organization Headcount Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Quarter |
Day (D_DAY) Dimension |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Demographic Trend page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Demographic Trend).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of demographic trends for your organization, by position and headcount. |
This page is comprised of the following reports:
|
Use the Demographic Trend page prompt to filter page results by:
|
Access the Positional Demographic Trend report, which enables you to analyze active headcount, voluntary headcount, involuntary headcount, and promotions by various dimensions, such as pay grade and job category.
X,Y Axis Data |
Choose Measure |
Analyze By Filter |
The Positional Demographic Trend graph displays Fiscal Quarter data on the x-axis and Headcount data on the y-axis, with EEO Job Category data plotted across the x/y-axis. The y-axis can also display any of the following measures, depending on your Choose Measure filter selection:
The x/y-axis can also plot any of the following dimensions, depending on your Analyze By filter selection:
Note. You can click on graph data to review drill down data for a particular quarter. |
Use this filter to view report results by the following measures:
|
Use this filter to view report results by the following dimensions:
|
The following table lists the columns and measures used in the Positional Demographic Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Quarter |
Day (D_DAY) Dimension |
Job Series |
Employee Job Code (D_EMPL_JOB) Dimension |
EEO Job Category |
Job Code (D_JOBCODE) Dimension |
Pay Grade |
Employee Job Code (D_EMPL_JOB) Dimension |
Number of Promotions (Promotion Count) |
Workforce (F_WORKFORCE) Fact |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Headcount Demographic Trend report, which enables you to analyze active headcount, voluntary headcount, involuntary headcount, and promotions by various dimensions, such as pay grade and job category.
X,Y Axis Data |
Choose Measure |
Analyze By Filter |
The Headcount Demographic Trend graph displays Fiscal Quarter data on the x-axis and Headcount data on the y-axis, with Employee Veteran Status data plotted across the x/y-axis. The y-axis can also display any of the following measures, depending on your Choose Measure filter selection:
The x/y-axis can also plot any of the following dimensions, depending on your Analyze By filter selection:
Note. You can click on the data in the graph to review drill down data for a particular quarter. |
Use this filter to view report results by the following measures:
|
Use this filter to view report results by the following dimensions:
|
The following table lists the columns and measures used in the Headcount Demographic Trend report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Quarter |
Day (D_DAY) Dimension |
Age |
Person (D_PERSON) Dimension |
Employee High Potential Flag |
This flag uses a Y or N value, based on Higher Education Level (HI_EDU_LVL_CD) values, which include:
If HI_EDU_LVL_CD value = J, K or L, then Employee High Potential Flag is set to Y. Otherwise, the flag is set to N. |
Employee Marital Status |
Person (D_PERSON) Dimension |
Gender |
Person (D_PERSON) Dimension |
Employee Citizenship |
Person (D_PERSON) Dimension |
Employee Disability |
Person (D_PERSON) Dimension |
Security Clearance Level |
Position (D_POS) Dimension |
Ethnic Group |
Person (D_PERSON) Dimension |
Veterans Preference Code |
Person (D_PERSON) Dimension |
Employee Veteran Status |
Person (D_PERSON) Dimension |
Voluntary Count |
Workforce (F_WORKFORCE) Fact |
Involuntary Count |
Workforce (F_WORKFORCE) Fact |
Headcount |
Workforce (F_WORKFORCE) Fact |
Number of Promotions (Promotion Count) |
Workforce (F_WORKFORCE) Fact |
Dissatisfied Termination Ratio |
Workforce (F_WORKFORCE) Fact: (If F_WORKFORCE.TERMINATE_COUNT <> 0 AND D_WA_ACTION.ACTION = 'TER' AND D_WA_ACTION.WA_VOLUNTARY_FLAG = 'V' AND D_WA_ACTION.ACTION_REASON in ([ 'EES', 'HRS', 'LOC', 'LOF', 'PAY', 'POL', 'PRM', 'SUP', 'TYP', 'UNS', 'USP', 'WOR'] ) then F_WORKFORCE.TERMINATE_COUNT else 0} / nullif(F_WORKFORCE.TERMINATE_COUNT) , 0) |
Access the Employee Demographics page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Employee Demographics).
Usage |
Reports |
Dashboard Prompt |
Provides a detailed overview of employee demographics and characteristics for your organization. |
This page is comprised of the following reports:
|
Use the Employee Demographics page prompt to filter page results by:
|
Access the Individual Characteristics report, which details trending of employee characteristics by ethnic group, age, gender, and so forth.
X,Y Axis Data |
View By Filter |
The Individual Characteristics graph displays Fiscal Year data on the x-axis and Headcount data on the y-axis, with Ethnic Group data plotted across the x/y-axis. The x/y-axis can also plot any of the following dimensions, depending on your View By filter selection:
Note. You can click on graph data to review drill down data for a particular year. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Individual Characteristics report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Gender |
Person (D_PERSON) Dimension |
Age |
Person (D_PERSON) Dimension |
Employee Citizenship |
Person (D_PERSON) Dimension |
Employee Disability |
Person (D_PERSON) Dimension |
Security Clearance Level |
Position (D_POS) Dimension |
Employee Highest Education Degree |
Person (D_PERSON) Dimension |
Employee Marital Status |
Person (D_PERSON) Dimension |
Ethnic Group |
Person (D_PERSON) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
% of Department Total |
Workforce (F_WORKFORCE) Fact: (Active Headcount / Total Active Headcount) * 100 |
Access the Employment Characteristics report, which details active headcount by employee type and full time or part time.
X,Y Axis Data |
View By Filter |
The Employment Characteristics graph displays Fiscal Year data on the x-axis and Headcount data on the y-axis, with Employee Type data plotted across the x/y-axis. The x/y-axis can also plot the Full Time/Part Time dimension, depending on your View By filter selection. Note. You can click on graph data to review drill down data for a particular year. |
Use this filter to view report results by:
|
The following table lists the columns and measures used in the Employment Characteristics report.
Report Column / Measure Name |
Report Column / Measure Origin |
Fiscal Year |
Day (D_DAY) Dimension |
Employee Type |
Employee Job Code (D_EMPL_JOB) Dimension |
Full Time / Part Time |
Employee Job Code (D_EMPL_JOB) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Pay for Performance page (Dashboards, HCM: Human Capital Management, HCM: Workforce Profile, Pay for Performance).
Usage |
Reports |
Dashboard Prompt |
Provides an overview of performance pay metrics for your organization, by relationship and department. |
This page is comprised of the following reports:
|
Use the Pay for Performance page prompt to filter page results by:
|
Access the Pay for Performance Relationship report, which details performance rating and active headcount metrics.
The Pay for Performance Relationship graph displays Performance Rating data on the x-axis and Headcount data on the y-axis.
The following table lists the columns and measures used in the Pay for Performance Relationship report.
Report Column / Measure Name |
Report Column / Measure Origin |
Performance Rating |
Employee Appraisal (D_EMPL_APRSL) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |
Access the Department Pay for Performance Analysis report, which details performance rating and active headcount metrics by department.
The Department Pay for Performance Analysis graph displays Performance Rating data on the x-axis and Headcount data on the y-axis, with Department data plotted across the x/y-axis.
Note. You can click on graph data to review drill down data for a particular department.
The following table lists the columns and measures used in the Department Pay for Performance Analysis report.
Report Column / Measure Name |
Report Column / Measure Origin |
Department |
Department (D_DEPT) Dimension |
Performance Rating |
Employee Appraisal (D_EMPL_APRSL) Dimension |
Headcount |
Workforce (F_WORKFORCE) Fact |