PRINT AVAILABILITY/UTILIZATION REPORT
From the Print Availability/Utilization Report screen, you can print a comparison of the employment percentage by race and gender in each Equal Employment Opportunity (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 on the Manage Applicant Data screen and Weighted Percentages subtask of the Manage Affirmative Action Plans screen are current and accurate, as well as the data for the Census Code on the Manage Affirmative Action Census Data screen.
After you populate this screen and click the Print 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 Employee Salary Information option is selected on the Configure Affirmative Action Settings screen, employees are selected based on the following criteria:
-
The employee record's Affirmative Action Plan is the same as the specified Affirmative Action Plan on this screen.
-
The Effective Date (in this screen) falls within the Effective Date and End Date for the employee record on the Manage Employee Salary Information screen.
-
The Effective Date is Term Date check box is not selected for the employee record on the Manage Employee Salary Information screen.
If the Basic Employee Information option is selected on the Configure Affirmative Action Settings screen, employees are selected according to the following criteria:
-
The employee record's Affirmative Action Plan is the same as the specified Affirmative Action Plan on this screen.
-
The Effective Date (on this screen) falls within the Effective Date and End Date for the employee record on the Manage Employee Salary Information screen.
-
On the Manage Employee Information screen, the employee's Termination date is null or is later than screen's Effective Date, or
-
The employee's Current Hire date or Adj Hire date is the same as, or earlier than, this screen's Effective Date.
This report contains the following columns:
|
Column Heading
|
Screen
|
Table Name
|
|
EEO Code
|
Manage Employee Salary Information
|
EMPL_LAB_INFO
|
|
EEO Description
|
Manage Employee Salary Information
|
EMPL_LAB_INFO
|
|
|
Manage Detail Job Titles
|
DETL_JOB_TITLES
|
|
|
Manage Functional Job Titles
|
FUNC_JOB_TITLES
|
|
|
Configure Affirmative Action Settings
|
EEO_SETTINGS
S_EEO1_CODE
|
|
Employment Percentage
|
Manage Employee Information
|
EMPL
|
|
|
Manage Employee Salary Information
|
EMPL_LAB_INFO
|
Location
Identification
Use the fields in this block to create a new parameter ID or to retrieve
a previously saved parameter ID. A parameter ID represents a set of screen
selection parameters. After you have saved a parameter ID and its related
parameters, you can retrieve them using Query.
You can use the retrieved parameters to produce reports and run processes
more efficiently and with greater consistency. The saved parameters are
also useful and necessary when you want to run the process as part of
a batch job. Many users save a unique set of parameters for each different
way they run a report or process. When you select a previously saved parameter
ID or parameter description, the associated saved screen selection parameters
automatically display as selection defaults. The page setup and print
options are also included in the saved parameter ID if there are any.
You can change any of the associated selection defaults as necessary.
Parameter ID
Enter, or click 
to select, a parameter
ID of up to 15 alphanumeric characters. Choose characters for your parameter
ID that help identify the type of selections you made in the screen, such
as PERIOD or QUARTERLY.
When you save your record, all the selections made in the screen are
stored with the parameter ID. Later, you can retrieve the parameter using
Query.
You can use the parameter to run the process more efficiently because
you can select the parameter ID with its previously defined screen selections.
After the default selections display in the screen, you can override the
defaults.
Description
Enter, or click to select, a parameter
description of up to 30 alphanumeric characters.
Selection Ranges
Use this group box to enter the affirmative action plan that you want to print.
Affirmative Action Plan
Option
This field displays One which means that you can enter only one affirmative action plan for the report.
Start
Enter, or click 
to select, the affirmative action plan for which you want to print this report.
After you enter the affirmative action plan in this field, the Start and End fields for the Effective Date range display the Coverage Start Date and Coverage End Date of the plan. You can change these default dates, but the Start and End date range must be within the plan's coverage dates.
Census
Option
This field displays One which means that you can enter only one census company for the report.
Start
Enter, or click to select, the census company code that was used to obtain the relevant census data. 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 in the Census Dates group box display the dates for which the census data is valid for the Census company.
Effective Date
Option
This field displays One which means that you can enter only one effective date for the report.
Start
Enter, or click to select, the effective date of this report. This field defaults with the plan's Coverage Start Date. 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 are included.
Job Group
Option
From the drop-down list , select the range option for job groups to include on the report. Valid options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
You can establish Job groups in the Affirmative Action Controls menu.
Start
Enter, or click to select, the starting job group to include on the report. If you selected All or From Beginning in the Option field, this field will be inactive.
End
Enter, or click to select, the ending job group to include on the report. If you selected All, One, or To End in the Option field, this field is inactive.
EEO Code
Option
From the drop-down list, select the range option for EEO codes to include on the report. Valid options are:
-
All
-
One
-
Range
-
From Beginning
-
To End
EEO codes are established in the Affirmative Action Controls menu. If you selected the EEO-1 Report option on the Configure Affirmative Action Settings screen, EEO-1 Codes one through nine are available in the Start and End fields. If you selected the EEO-4 Report option on the Configure Affirmative Action Settings, EEO-4 Codes one through eight are available in the Start and End fields.
Start
Enter, or click 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 is inactive.
End
Enter, or click 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 is inactive.
Coverage Dates
Start Date
This field displays the start date of the selected affirmative action plan.
End Date
This field displays the end date of the selected affirmative action plan.
Census Dates
Start Date
This field displays the start date of the census data for the selected census company.
End Date
This field displays the end date of the census data for the selected census company.
Options
Show Functional Job Title Detail
If you select this check box, 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 check box to include utilization information on the report. If you select this check box, the application determines whether or not there is an underutilization of females or minorities, and the report includes a utilization column that displays the results.