Working with Delivered OBIEE Dashboards for the Human Capital Management (HCM) Warehouse

This chapter provides prerequisites, an overview of delivered OBIEE dashboards for the HCM Warehouse, and discusses:

Click to jump to parent topicPrerequisites

Before you use dashboards for the HCM Warehouse, you must implement:

Click to jump to parent topicUnderstanding Dashboards for 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:

Click to jump to top of pageClick to jump to parent topicGuided Navigation

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."

Click to jump to top of pageClick to jump to parent topicDelivered Security Groups

This list contains the financials-oriented Oracle BI Server and Oracle Presentation Catalog security groups provided for the HCM Warehouse:

Click to jump to parent topicUsing the Recruitment Analysis Dashboard - Recruitment Demand Page

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:

  • Current Open Positions report

  • Hiring Demand Analysis report

  • Hiring Demand Surge Details report

Use the Recruitment Demand page prompt to filter page results by:

  • Fiscal Year

  • Fiscal Quarter

  • Department

Click to jump to top of pageClick to jump to parent topicCurrent Open Positions Report

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

Click to jump to top of pageClick to jump to parent topicHiring Demand Analysis Report

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

Click to jump to top of pageClick to jump to parent topicHiring Demand Surge Details Report

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

Click to jump to parent topicUsing the Recruitment Analysis Dashboard - Recruiting Effectiveness Page

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:

  • Vacancy Fill Rate report

  • Time to Fill report

  • Recruiting Source Effectiveness report

  • Vacancy Fill Rate Details report

  • Recruiting Source Effectiveness Detail report

Use the Recruiting Effectiveness page prompt to filter page results by:

  • Fiscal Year

  • Fiscal Quarter

  • Department

Click to jump to top of pageClick to jump to parent topicVacancy Fill Rate Report

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

Click to jump to top of pageClick to jump to parent topicTime to Fill Report

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

Click to jump to top of pageClick to jump to parent topicRecruiting Source Effectiveness Report

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:

  • Advertisement

  • Client Referral

  • Walk-In

  • Employee

  • Executive Referral

  • Former Employee

  • Job Fair

  • Open House

  • College Recruiting

  • Agency

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

Click to jump to top of pageClick to jump to parent topicVacancy Fill Rate Details Report

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:

  • Location

  • Job Family Description

  • Job Description (default)

  • Grade

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

Click to jump to top of pageClick to jump to parent topicRecruiting Source Effectiveness Detail Report

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:

  • Location

  • Department

  • Job Series (default)

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

Click to jump to parent topicUsing the Recruitment Analysis Dashboard - Applicant Trending Page

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:

  • Applicant Tracking report

  • Applicant Characteristics report

Use the Applicant Trending page prompt to filter page results by:

  • Fiscal Year

  • Fiscal Quarter

Click to jump to top of pageClick to jump to parent topicApplicant Tracking Report

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

Click to jump to top of pageClick to jump to parent topicApplicant Characteristics Report

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:

  • Applicant Marital Status

  • Applicant Disabled Indicator

  • Applicant Highest Education Level

  • Applicant Veterans Preference

  • Applicant Full/Part Time

  • Applicant Salary Grade

  • Ethnic Group (default)

Use this filter to view report results by:

  • Applicant Marital Status

  • Applicant Disabled Indicator

  • Applicant Highest Education Level

  • Applicant Veterans Preference

  • Applicant Full/Part Time

  • Applicant Salary Grade

  • Ethnic Group (default)

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Overview Page

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:

  • Headcount by Region and Organization report

  • Headcount Trend report

  • Turnover Trend report

  • Promotion Trend report

Use the Workforce Profile - Overview page prompt to filter page results by:

  • Year

  • Quarter

  • Month

  • Business Unit

  • Department Name

  • Geography

Click to jump to top of pageClick to jump to parent topicHeadcount by Region and Organization Report

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

Click to jump to top of pageClick to jump to parent topicHeadcount Trend Report

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:

  • Department Name (default)

  • Location

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

Click to jump to top of pageClick to jump to parent topicTurnover Trend Report

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:

  • Department Name (default)

  • Location

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)

Click to jump to top of pageClick to jump to parent topicPromotion Trend Report

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:

  • Department Name (default)

  • Location

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Workforce Demographics Page

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:

  • Headcount Demographics report

  • Headcount Distribution by Job Category report

  • Termination Demographics report

  • Termination Distribution by Job Category report

  • Promotion Demographics report

  • Promotion Distribution by Job Category report

Use the Workforce Demographics page prompt to filter page results by:

  • Year

  • Quarter

  • Month

  • Business Unit

  • Department Name

  • Geography

Click to jump to top of pageClick to jump to parent topicHeadcount Demographics Report

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:

  • Fairlabor Standards Act Status

  • Service Group

  • Location

  • Department Name

  • Age Group (default)

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:

  • Fairlabor Standards Act Status

  • Service Group

  • Location

  • Department Name

  • Age Group (default)

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

Click to jump to top of pageClick to jump to parent topicHeadcount Distribution by Job Category Report

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:

  • Equal Employment Opportunity 1 Code

  • Department Name

  • Job Code

  • Job Family Description (default)

  • Location

  • Position

  • Salary Grade Group

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:

  • Equal Employment Opportunity 1 Code

  • Department Name

  • Job Code

  • Job Family Description (default)

  • Location

  • Position

  • Salary Grade Group

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

Click to jump to top of pageClick to jump to parent topicTermination Demographics Report

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:

  • Age Group

  • Department Name

  • Location

  • Service Group

  • Fairlabor Standards Act Status (default)

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:

  • Age Group

  • Department Name

  • Location

  • Service Group

  • Fairlabor Standards Act Status (default)

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

Click to jump to top of pageClick to jump to parent topicTermination Distribution by Job Category Report

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:

  • Equal Employment Opportunity 1 Code

  • Department Name (default)

  • Job Code

  • Job Family Description

  • Location

  • Position

  • Salary Grade Group

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:

  • Equal Employment Opportunity 1 Code

  • Department Name (default)

  • Job Code

  • Job Family Description (default)

  • Location

  • Position

  • Salary Grade Group

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

Click to jump to top of pageClick to jump to parent topicPromotion Demographics Report

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:

  • Fairlabor Standards Act Status

  • Service Group

  • Location

  • Department Name (default)

  • Age Group

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:

  • Fairlabor Standards Act Status

  • Service Group

  • Location

  • Department Name (default)

  • Age Group

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

Click to jump to top of pageClick to jump to parent topicPromotion Distribution by Job Category Report

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:

  • Equal Employment Opportunity 1 Code (default)

  • Department Name

  • Job Code

  • Job Family Description

  • Location

  • Position

  • Salary Grade Group

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:

  • Equal Employment Opportunity 1 Code (default)

  • Department Name

  • Job Code

  • Job Family Description

  • Location

  • Position

  • Salary Grade Group

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Contingent Workforce Analysis Page

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:

  • Contingent Headcount Distribution report

  • Contingent Labor Utilization % Trend report

Use the Contingent Workforce Analysis page prompt to filter page results by:

  • Year

  • Quarter

  • Month

  • Business Unit

  • Department Name

  • Geography

Click to jump to top of pageClick to jump to parent topicContingent Headcount Distribution Report

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:

  • Department (default)

  • Geography

  • Job Family

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:

  • Department (default)

  • Geography

  • Job Family

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

Click to jump to top of pageClick to jump to parent topicContingent Headcount Distribution Details Report

Access the Contingent Headcount Distribution Details report, which provides a detailed analysis of contingent headcount distribution.

Click to jump to top of pageClick to jump to parent topicContingent Labor Utilization % Trend Report

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Turnover Trend Page

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:

  • Turnover Trend report

  • Position Change Trends report

  • Termination Detail report

  • Termination Root Cause report

  • Top Performer Turnover Trend report

  • Turnover Distribution Analysis report

  • Turnover Demographics report

Use the Turnover Trend page prompt to filter page results by:

  • Year

  • Quarter

  • Month

  • Business Unit

  • Department Name

  • Geography

Click to jump to top of pageClick to jump to parent topicTurnover Trend Report

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.

Click to jump to top of pageClick to jump to parent topicPosition Change Trends Report

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

Click to jump to top of pageClick to jump to parent topicTermination Detail Report

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:

  • Job Function

  • Appraisal Review Rating

  • Service Group

  • Age Group (default)

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:

  • Job Function

  • Appraisal Review Rating

  • Service Group

  • Age Group (default)

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

Click to jump to top of pageClick to jump to parent topicTermination Root Cause Report

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

Click to jump to top of pageClick to jump to parent topicTop Performer Turnover Trend Report

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

Click to jump to top of pageClick to jump to parent topicTurnover Distribution Analysis Report

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

Click to jump to top of pageClick to jump to parent topicTurnover Demographics Report

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:

  • Employee Type

  • Position Security Clearance Code

  • Age

  • Employee High Potential Flag

  • Ethnic Group

  • Gender (default)

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:

  • Employee Type

  • Position Security Clearance Code

  • Age

  • Employee High Potential Flag

  • Ethnic Group

  • Gender (default)

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:

  • J (Doctorate Academic)

  • K (Doctorate Professional)

  • L (Post Doctorate)

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Workforce Activity Page

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:

  • Business Unit

  • Department

  • Geography

  • Period Type

  • Period Value

Click to jump to top of pageClick to jump to parent topicWorkforce Movement Activity Report

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Top Performer Turnover Page

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:

  • Recent Regrettable Losses report

  • Top Performer Turnover Trends report

  • Top Performer At Risk report

Use the Top Performer Turnover page prompt to filter page results by:

  • Year

  • Quarter

  • Month

  • Business Unit

  • Department Name

  • Geography

  • Job Code

  • Employee Location

Click to jump to top of pageClick to jump to parent topicRecent Regrettable Losses Report

Access the Recent Regrettable Losses report, which displays information about employees that have recently left the organization.

Click to jump to top of pageClick to jump to parent topicTop Performer Turnover Trends Report

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.

Click to jump to top of pageClick to jump to parent topicTop Performer At Risk Report

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Equal Employment Opportunity (EEO) Compliance Page

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:

  • Professional Category By Ethnicity report

  • Minority Representation by Job Category report

  • Female Representation By Job Category report

Use the EEO Compliance page prompt to filter page results by Fiscal Year.

Click to jump to top of pageClick to jump to parent topicProfessional Category By Ethnicity Report

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

Click to jump to top of pageClick to jump to parent topicMinority Representation by Job Category Report

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

Click to jump to top of pageClick to jump to parent topicFemale Representation By Job Category Report

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Headcount Distribution Page

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:

  • Headcount Distribution report

  • Headcount by Job Categories report

  • Organization Headcount Trend report

Use the Headcount Distribution page prompt to filter page results by:

  • Fiscal Year

  • Department

Click to jump to top of pageClick to jump to parent topicHeadcount Distribution Report

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:

  • Department (default)

  • Location

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

Click to jump to top of pageClick to jump to parent topicHeadcount by Job Categories Report

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:

  • Grade

  • Job Code

  • Job Series (default)

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:

  • Grade

  • Job Code

  • Job Series (default)

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

Click to jump to top of pageClick to jump to parent topicOrganization Headcount Trend Report

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Demographic Trend Page

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:

  • Positional Demographic Trend report

  • Headcount Demographic Trend report

Use the Demographic Trend page prompt to filter page results by:

  • Fiscal Year

  • Department

Click to jump to top of pageClick to jump to parent topicPositional Demographic Trend Report

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:

  • Headcount (default)

  • Voluntary Headcount

  • Involuntary Headcount

  • Number of Promotion

The x/y-axis can also plot any of the following dimensions, depending on your Analyze By filter selection:

  • Pay Grade

  • Job Category

  • EEO Job Category (default)

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:

  • Headcount (default)

  • Voluntary Headcount

  • Involuntary Headcount

  • Number of Promotion

Use this filter to view report results by the following dimensions:

  • Pay Grade

  • Job Series

  • EEO Job Category (default)

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

Click to jump to top of pageClick to jump to parent topicHeadcount Demographic Trend Report

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:

  • Headcount (default)

  • Voluntary Headcount

  • Involuntary Headcount

  • Number of Promotion

  • Dissatisfied Termination Ratio

The x/y-axis can also plot any of the following dimensions, depending on your Analyze By filter selection:

  • Age

  • Employee High Potential Flag

  • Employee Marital Status

  • Gender

  • Employee Citizenship

  • Employee Disability

  • Security Clearance Level

  • Ethnic Group

  • Veterans Preference Code

  • Employee Veteran Status (default)

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:

  • Headcount (default)

  • Voluntary Headcount

  • Involuntary Headcount

  • Number of Promotion

  • Dissatisfied Termination Ratio

Use this filter to view report results by the following dimensions:

  • Age

  • Employee High Potential Flag

  • Employee Marital Status

  • Gender

  • Employee Citizenship

  • Employee Disability

  • Security Clearance Level

  • Ethnic Group

  • Veterans Preference Code

  • Employee Veteran Status (default)

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:

  • J (Doctorate Academic)

  • K (Doctorate Professional)

  • L (Post Doctorate)

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)

Click to jump to parent topicUsing the Workforce Profile Dashboard - Employee Demographics Page

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:

  • Individual Characteristics report

  • Employment Characteristics report

Use the Employee Demographics page prompt to filter page results by:

  • Fiscal Year

  • Fiscal Quarter

  • Department

Click to jump to top of pageClick to jump to parent topicIndividual Characteristics Report

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:

  • Gender

  • Age

  • Employee Citizenship

  • Employee Disability

  • Security Clearance Level

  • Employee Highest Education Degree

  • Employee Marital Status

  • Ethnic Group (default)

Note. You can click on graph data to review drill down data for a particular year.

Use this filter to view report results by:

  • Gender

  • Age

  • Employee Citizenship

  • Employee Disability

  • Security Clearance Level

  • Employee Highest Education Degree

  • Employee Marital Status

  • Ethnic Group (default)

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

Click to jump to top of pageClick to jump to parent topicEmployment Characteristics Report

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:

  • Employee Type (default)

  • Full Time Part Time

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

Click to jump to parent topicUsing the Workforce Profile Dashboard - Pay for Performance Page

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:

  • Pay for Performance Relationship report

  • Department Pay for Performance Analysis report

Use the Pay for Performance page prompt to filter page results by:

  • Fiscal Year

  • Fiscal Quarter

  • Department

Click to jump to top of pageClick to jump to parent topicPay for Performance Relationship Report

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

Click to jump to top of pageClick to jump to parent topicDepartment Pay for Performance Analysis Report

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