Understanding Diversity Analytics

Diversity analytics provide a mechanism to review your recruitment practices and your compliance with affirmative action and equal employment opportunity programs. The Diversity analytics are pivot grids that chart information about four important types of diversity: disability, ethnicity, gender, and veteran status.  The charts offer a variety of filter criteria for viewing specific slices of data.

Diversity Charts

The system provides two pivot grids with different ways of looking at diversity information:

  • Applicant Diversity Overview: This pivot grid counts each included applicant just once, regardless of how many times the applicant has applied. You can see applicant data for all four diversity types at once, or you can drill down for a closer look at a specific diversity type.

  • Diversity by Application: This pivot grid counts each application separately, so an applicant who applies for multiple jobs is counted once for each application. (However, if an applicant has more than one application for a single job opening, only the most recent application is counted.) This pivot grid shows one diversity type at a time and provides prompts so you can change which diversity type is displayed.

Access both charts from the Diversity Analytics Pagelet on the Recruiting Home page.

Effective Dated Diversity Data

Disability and veteran statuses are both effective dated. Gender and ethnicity data is not effective-dated.

The two pivot grids handle the effective-dated data differently:

  • The Applicant Diversity Overview pivot grid always shows current applicant data. This is appropriate for an analysis of applicants (rather than applications).

  • The Diversity by Application pivot grid uses the disability and veteran information from the time of the most recent disposition change. This architecture supports the ability to analyze the diversity of your applicant pool at different stages of the recruiting process. For example, you can compare the diversity of all applicants who apply versus the diversity of applicants who reach the interview phase, the offer phase, and the hiring phase. This analysis involved drilling down to view the data by disposition.

    See Diversity By Applications Pivot Grid

Notes on Specific Diversity Values

This list provides important information about certain diversity values that appear in the charts:

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

  • 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 actual database values that are delivered by PeopleSoft.

Loading Diversity Data

The pivot grids for diversity analytics do not read data directly from the main recruiting tables. Instead, two Application Engine processes load diversity data into dedicated analytics tables:

  • The Refresh Diversity Analytics process (HRS_PG_DA) loads data for the Applicant Diversity Overview pivot grid.

  • The Refresh Application Diversity process (HRS_DA_APPLICATION) loads data for the Diversity by Application pivot grid.

When you run this process, you can specify the date range for the data 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.