Applicant Trending Page

Use the Applicant Trending page to provide an overview of applicant trends and characteristics for your organization.

Navigation

select Dashboards, then select HCM: Human Capital Management, then select HCM: Recruitment Analysis, then select Applicant Trending

Image: Applicant Trending page

This example illustrates the fields and controls on the Applicant Trending page. You can find definitions for the fields and controls later on this page.

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

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

Applicant Tracking Report

Use the Applicant Tracking report, which enables you to analyze applicant offer, acceptance, hire, and head counts.

Image: Applicant Tracking report, part 1

This example illustrates the fields and controls on the Applicant Tracking report, part 1. You can find definitions for the fields and controls later on this page.

Image: Applicant Tracking report, part 2

This example illustrates the fields and controls on the Applicant Tracking report, part 2. You can find definitions for the fields and controls later on this page.

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.

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

Applicant Characteristics Report

Use the Applicant Characteristics report, which enables you to analyze applicant characteristics, such as ethnic group, marital status, disability, and highest education level.

Image: Applicant Characteristics report, part 1

This example illustrates the fields and controls on the Applicant Characteristics report, part 1. You can find definitions for the fields and controls later on this page.

Image: Applicant Characteristics report, part 2

This example illustrates the fields and controls on the Applicant Characteristics report, part 2. You can find definitions for the fields and controls later on this page.

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)

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)

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