AVAILABILITY/UTILIZATION REPORT

Use this screen to print a comparison of the employment percentage by race and gender in each EEO Code/Job Group with the availability percentage calculated for each factor. The analysis is based upon the 12-month period before the screen Effective Date. The application can also compare the minority and female availability with the percentage of minorities and females employed to determine whether there is underutilization of either protected class. 

Use the report from this application to compare percentages for each EEO Code/Job Group code for an Affirmative Action Plan. Be sure that the data in the Weighted Percentage Setup and Applicant Data subtasks of the Affirmative Action Plans screen are current and accurate, as well as the data for the Census Code in the Census Data screen.

Select

Use this group box to enter the affirmative action plan for which you want to print.

Affirmative Action Plan

Enter, or use Lookup to select, the affirmative action plan for which you want to print this report. This is a required field. The unlabeled field to the right displays the plan description.

Coverage Start Date

This non-editable field displays the start date of the selected affirmative action plan.

Coverage End Date

This non-editable field displays the end date of the selected affirmative action plan.

Census

Enter, or use Lookup to select, the census company that was used to obtain the relevant census data. This is a required field. Census data is entered under the Affirmative Action Plan Setup menu. The census data description displays in the field to the right. The Start Date and End Date fields display the dates for which the census data is valid for the Census company.

Start Date

This non-editable field displays the start date of the census data for the selected census company.

End Date

This non-editable field displays the end date of the census data for the selected census company.

Effective Date

Enter the effective date of this report. This field defaults with the plan's Coverage Start Date, but can be changed. Employees whose termination date is later than the first day of the plan year and whose hire date is earlier than, or the same as, the first day of the plan year will be included.

Job Groups

Range Option

Use this drop-down box to select the range of job groups to include on the report. Valid options are "All," "One," "Range," "From Beginning," and "To End." Job groups are established under the Affirmative Action Controls menu.

From

Enter, or use Lookup to select, the starting job group to include on the report. If you selected "All" or "From Beginning" in the Range Option field, this field will be inactive.

To

Enter, or use Lookup to select, the ending job group to include on the report. If you selected "All," "One," or "To End" in the Range Option field, this field will be inactive.

EEO Codes

Range Option

Use this drop-down box to select the range of EEO codes to include on the report. Valid options are "All," "One," "Range," "From Beginning," and "To End." EEO codes are established in the Affirmative Action Controls menu. If you selected the EEO-1 Report radio button in the EEO Setup screen, EEO-1 Codes one through nine will be available in the From and To fields. If you selected the EEO-4 Report radio button in the EEO Setup screen, EEO-4 Codes one through eight will be available in the From and To fields.

From

Enter, or use Lookup to select, the starting EEO code to include on the report. If you selected "All" or "From Beginning" in the Range Option field, this field will be inactive.

To

Enter, or use Lookup to select, the ending EEO code to include on the report. If you selected "All," "One," or "To End" in the Range Option field, this field will be inactive.

Options

Show Functional Job Title Detail

If you select this checkbox, the report will include availability data at the functional job title level (grouped by job group/EEO code), as well as the sum of the availability percentages to determine the job group/EEO code Availability.

Include Utilization Analysis

Select this checkbox to include utilization information on the report. If you select this checkbox, the application will determine whether or not there is an underutilization of females or minorities, and the report will include a utilization column that shows the results. 

Preview/Print

After you populate this screen and select the Preview or Print buttons from the toolbar, the application selects those employees that are assigned to the specified Affirmative Action Plan and employed as of the screen Effective Date.

Additionally, if the Salary Info and History radio button is selected in the Affirmative Action Settings screen, employees are selected based on the following criteria:

If the Basic Employee Info radio button is selected in the Affirmative Action Settings screen, employees are selected according to the following criteria:

Report Column

Column Heading

Screen

Table Name

EEO Code

Salary Info and History

EMPL_LAB_INFO

EEO Description

Salary Info and History

EMPL_LAB_INFO

 

Detail Job Titles

DETL_JOB_TITLES

 

Functional Job Titles

FUNC_JOB_TITLES

 

EEO Setup

EEO_SETTINGS

S_EEO1_CODE

Employment Percentage

Basic Employee Info

EMPL

 

Salary Info and History

EMPL_LAB_INFO