Using Diversity Analytics

This topic discusses diversity analytics for recruiting.

Page Name

Definition Name


Refresh Diversity Analytics Page


Run the Refresh Diversity Analytics (HRS_PG_DA) application engine process to load applicant diversity data into the diversity analytics table.

Applicant Diversity Overview Pivot Grid


View applicant diversity data.

Diversity analytics provide a mechanism to review your recruitment practices and your compliance with affirmative action and equal employment opportunity programs.

The Diversity Overview pivot grid shows information about four important types of diversity: disability, ethnicity, gender, and veteran status.  You can see applicant data for all diversity types at once, or you can drill down for a closer look at a specific diversity type. Prompts enable you to choose the date range to report on.  You can also filter data by applicant status and by a variety of job data, including posting title, job code, location, department, business unit, recruiter, and hiring manager.

You access this pivot grid from the Diversity Analytics Pagelet on the Recruiting Home page.

The pivot grid does not read data directly from the main recruiting tables. Instead, the Refresh Diversity Analytics (HRS_PG_DA) application engine process loads applicant diversity data into a dedicated analytics table.

When you run this process, you can specify the date range for the applicants to be loaded. Applicants are loaded if they submitted applications with or without a job opening in the specified date range. However, the process does not load applicant data for:

  • Applications in Draft status.

  • Applications in Withdrawn status with a reason of Candidate Withdrawn.

  • Applications in Inactive status.

  • Applicants in Inactive or Queued. status.

Use the Refresh Diversity Analytics page (HRS_RUN_DIVERSITY) to run the Refresh Diversity Analytics application engine process to load applicant diversity data into the diversity analytics table.

Image: Refresh Diversity Analytics page

This example illustrates the Refresh Diversity Analytics page.

Refresh Diversity Analytics page

Field or Control



Click this button to access the PeopleSoft Process Scheduler Request page, where you schedule the Refresh Diversity Analytics process.

Date Range for Applicant Selection

Field or Control


From and To

Specify a date range for the process. The Refresh Diversity Analytics process loads diversity data for applicants who submitted applications (with or without a job opening) within the specified date range.

The default date range extends back five years from the current date.

Use the Applicant Diversity Overview pivot grid (HRS_PG_DIV_OV1) to view applicant diversity data.

Image: Applicant Diversity Overview pivot grid

This example illustrates the Applicant Diversity Overview pivot grid.

Applicant Diversity Overview chart

The Diversity Overview pivot grid includes a left frame with prompts and filters and a right frame with a chart.

General Pivot Grid Functionality

Pivot grids are a feature of PeopleTools. For general information on setting up and using pivot grids, see PeopleTools: Pivot Grid. This topic does not discuss the generic pivot grid functionality such as the Rows and Columns controls or the Options icon in the top right corner.


When the page first opens, it displays a bar chart with four types of diversity data: Disability, Ethnicity, Gender, and Veterans (veteran status). The bars for each diversity type are clustered together, creating the effect of four bar charts side-by-side.

You can hover over a bar to see mouseover text with a description of the data that is represented. The chart also has a legend that matches bar colors to labels, and you can hover over a label to highlight the associated bar.

Use standard pivot grid controls to change the chart to a line chart or a horizontal bar chart.

Notes on Specific Diversity Values

  • Multiple Ethnicities: An applicant with more than one ethnic group is classified as Multiple in the chart.

  • Disability Data: An applicant who does not have data in the USA-specific Section 503 Disability Status section of the Create Applicant page: Eligibility & Identity Tab is still considered disabled if the non-country specific Disability check box is selected on that same page.

  • Not Indicated or Unknown Diversity Data: The labels Not Indicated (for disability, ethnicity, and veteran status) and Unknown (for gender) are valid values delivered by PeopleSoft.


Field or Control


From Date and To Date

Enter the date range that you want to analyze. The pivot grid displays data for applications that were submitted within the specified date range.

The default date range extends back one month from the current date.


Click to refresh the chart based on the date range that you specify.


For the first two filters, Diversity Value and Diversity Type, you apply the filter by clicking the link for a single value. For all other filters, there are check boxes next to the values, and you can select multiple values to include in your data set.

An explanation of the counts that appear next to each filter value appears after this list of filters.

Field or Control


Diversity Value

This filter includes specific values for all of the different types of diversity shown in the chart. Because this filter initially includes a mix of values that apply to gender, ethnicity, disability status, and veteran status, it is usually easiest to filter by diversity type before filtering by diversity value.

Diversity Type

These filter values represent the four types of data included in the chart: Disability, Ethnicity, Gender, and Veterans. Click a value to update the chart so that it shows only data related to the selected diversity type.

Posting Title

Filtering by posting title is useful when you want to eventually drill down to a single job opening. Filtering by posting title reduces the number of values in the Job Opening ID filter to a more manageable list.

Applications that do not include a job opening have a posting title of No Job Opening.

Job Opening ID

Use this filter to review the diversity data for specific job openings.

Applications that do not include a job opening have a job opening ID of 0 (zero).

Applicant Status

These filter values represent the applicant’s overall status, not the disposition of specific applications. Applicants that are included in this analytic always have a status of Active or Hired.


Enables you to filter based on the primary recruiter for the job opening.

Hiring Manager

Enables you to filter based on the primary hiring manager for the job opening.


Enables you to filter based on the primary job code for the job opening.

Job Family

Enables you to filter based on the job family for the job opening.

Recruiting Location

Enables you to filter based on the primary recruiting location for the job opening.

Business Unit

Enables you to filter based on the business unit of the job opening.


Enables you to filter based on the department of the job opening.

Understanding Applicants Versus Applications

Diversity data is associated with an applicant, so it is the same for all of the applicant’s job applications. (Applicant diversity data can change over time, but the Refresh Diversity Analytics process always loads current values into the diversity analytic table. The disclosure date for disability data is not considered.)

Although diversity data is associated with applicants, the diversity analytics table stores data by job application. This architecture enables you to review diversity data based on job-related criteria. For example, you can look at applicant diversity for specific departments or recruiting locations.

For example, if applicant Maya Hill submits three applications on a particular day, then when you load that day’s data into the analytics table, there are three rows of data for Maya. Maya’s diversity information is included in the chart as long as any of her three applications meet your filtering criteria.

In the chart on the right frame of the page, each diversity type counts each applicant just once, regardless of how many applications have been submitted. Maya, who submitted three applications, is counted as one female, not three. The following example illustrates this scenario.

Image: Applicant Diversity Overview pivot grid showing one applicant with three applications

This example illustrates the Applicant Diversity Overview pivot grid for a data set that includes one applicant with three applications. The chart shows one applicant for each diversity type.

Applicant Diversity Overview pivot grid showing one applicant with three applications

Although the chart counts each applicant just once per diversity type, the counts that appear in parentheses next to filter values follow different rules.

The following table summarizes how the counts are determined for each filter type. The Example column refers to Maya’s three applications as shown in the previous illustration.


Associated Count


Diversity Value

Counts applications.

Maya submitted three applications, so even though the bar chart shows that there is one female, the Female filter shows a count of 3.

Diversity Type

Counts applications. All diversity types show the same count, which represents the total number of applications in the chart.

All four diversity types show a count of 3 because Maya submitted three applications.

All other filters

When all four diversity types appear in the chart, the count for these filters is four times the number of applications that meet the criteria. This is because each application appears four times in the chart—once for each diversity type.

If you filter the chart to show only one diversity type, then the counts for these other filters match the number of applications.

Each of Maya’s three job applications are represented four times in the chart: once for disability, once for ethnicity, once for gender, and once for veteran status. So all of the job-related filter values show a count of 4.

The Applicant Status filter does not separate Maya’s applications by job, so the three applications are lumped together under Maya’s applicant status, and then each application is counted four times, for a grand total of 12.

Reviewing Detailed Data

If you drill down into the chart, you can access a grid that displays the source data. The grid lists job applications, so individual applicants can appear more than once.

The grid that appears on-screen when you drill down into the chart shows a maximum of 100 rows. To view the complete data set, use the standard pivot grid export option by clicking the Options icon in the top right corner of the chart. The export is limited to data that falls within the date range you specify in the Prompt fields, but all other filter criteria is ignored.