Skip to main content

B0170 Agency EEO Plan (Fixed Format)

Purpose

The purpose of this Report Description is to explain how to access the Agency EEO Plan (Fixed Format) BOBJ report in the Integrated HR-Payroll System.

Report Description

This report compares an agency’s work force to the NC population and the NC occupation specific labor force by State SOC Subcategory, State SOC Category and All Occupations and is associated with three reporting views. Note: The NC population and labor force are defined through the most recent US census data.

Agency staff data prior to October 2022 is compared with 2010 Census. Agency staff data from October 2022 and after is compared with 2020 Census.

The reporting tab ‘Employee Distribution’ compares an agency’s work force to the NC population and the NC occupation specific labor force by State SOC Category or Subcategory.

The reporting tab ‘Agency Total’ compares an agency’s overall work force data to the NC population and the NC all occupations specific labor force by demographic groups. This tab provides an overall agency view of workforce by demographics.

The reporting tab ‘Job Opening Estimates Form’ compares an agency’s work force to the NC population and the NC occupation specific labor force by State SOC Category or Subcategory. This tab is intended for Agencies to use for their annual EEO goal planning. It includes a section for agencies to manually enter their Employment Objectives (once exported to Excel).

Report Location

PA: EEO

Report Uses

  • This report is used to analyze the composition of an agency’s workforce and shows the comparison to the NC Census data. It can be useful in determining the distribution of employees in an agency’s workforce and is helpful in EEO planning to help create a more diverse workforce.
  • Employment objectives are to be entered on the JOB OPENING ESTIMATES form. Once the position openings for the next year have been estimated for each occupational category for which underutilization has been identified (having five or more workers), employment objectives are established for each underutilized group, by either number, percentage, or both. These objectives should be meaningful and obtainable. The employment objective setting process must be flexible and account for various factors that may affect the agency’s ability to recruit qualified underutilized employees in target classifications. It also must be based on reasonable expectations of success, as outlined in the action steps.

Note: Please refer to OSHR guidelines for more detailed information on how this form should be used to generate an agency’s EEO Plan.

How to Generate This Report

This report is generated after selecting values for the mandatory prompts.  All mandatory prompts must have values selected before the Run Icon can be used to generate the report. Mandatory prompts can be identified as mandatory by the exclamation mark inside of the yellow-orange triangle, the square with the checkmark, or the display of (Mandatory).  Detailed instructions for interaction with each prompt can be found on the Web Intelligence Prompt List on the OSC website.

The Mandatory prompts for this report are:  

  • Organizational Unit
  • Calendar Month/Year (Single Value, Mandatory)
  • EEO Job Category View (Single Value, Mandatory)

This report can also be further limited by utilizing the Optional prompts to further limiting the amount of data that retrieved into the body of the report. Optional prompts are indicated as optional in parentheses beside the prompt.

The Optional prompts are: 

  • Employee Group (SPA)

Exclusion prompts exclude specified data by default while allowing customers the flexibility of changing them when necessary. Exclusion prompts are identified by the term Exclude followed by the prompt.

The Exclusion prompts are: 

  • Exclude Employee Subgroup (Contractors) 

Initial Layout

This report contains four report tabs. 

Prompt Selections:

  • EEO Job Category View:  SOC Category
    • Employee Distribution -InfoOnly

  • Agency Total (All Occupations)

  • Job Opening Estimates Form 

Prompt Selections:

  • EEO Job Category View:  SOC Subcategory
    • Employee Distribution -InfoOnly 

Agency Total (All Occupations) 

Job Opening Estimates Form

Report Info

  • This tab contains information about the values selected for each of the prompts.  It also contains definitions about the different sections represented in the report content. 

Available Objects

This is a list of the available objects that can be added to the report, from the Document Dictionary once in the Design mode: 

Dimensions

  • EEO Row Label
  • EEO Row Type
  • Personnel Area
  • State SOC Category
  • State SOC Subcategory
  • U.S. Census Year

Measures

  • AIAN Fem Census Pct
  • AIAN Female
  • AIAN Mal Census Pct
  • AIAN Male
  • Asian Fem Census Pct
  • Asian Female
  • Asian Mal Census Pct
  • Asian Male
  • Black Fem Census Pct
  • Black Female
  • Black Mal Census Pct
  • Black Male
  • Disabled
  • Disabled Census Pct
  • Emp Count
  • Ethnicity Unknown
  • Female
  • Hisp Fem Census Pct
  • Hisp Female
  • Hisp Mal Census Pct
  • Hisp Male
  • Minority
  • National Guard
  • NHPI Fem Census Pct
  • NHPI Female
  • NHPI Mal Census Pct
  • NHPI Male
  • Two+ Fem Census Pct
  • Two+ Female
  • Two+ Mal Census Pct
  • Two+ Male
  • Veteran
  • White Fem Census Pct
  • White Female
  • White Mal Census Pct
  • White Male

Variables

  • EEO Row Type Custom Text
  • Prompt Response Calendar Month/Year
  • Prompt Response EEO Comparison View
  • Prompt Response EEO Job Category View
  • Prompt Response Employee Group
  • Prompt Response Exclude Employee Subgroup
  • Prompt Response Organizational Unit
  • Report Controls Selected
  • SOC Cat or Subcat
  • AIAN Fem
  • AIAN Fem All Occ
  • AIAN Female Diff Nbr
  • AIAN Female Diff Pct
  • AIAN Female Exp
  • AIAN Female Pct
  • AIAN Mal
  • AIAN Mal All Occ
  • AIAN Male Diff Nbr
  • AIAN Male Diff Pct
  • AIAN Male Exp
  • AIAN Male Pct
  • Asian Female Exp
  • Asian Male Exp
  • Asian+ Fem
  • Asian+ Fem All Occ
  • Asian+ Female
  • Asian+ Female Diff Nbr
  • Asian+ Female Diff Pct
  • Asian+ Female Pct
  • Asian+ Mal
  • Asian+ Mal All Occ
  • Asian+ Male
  • Asian+ Male Diff Nbr
  • Asian+ Male Diff Pct
  • Asian+ Male Pct
  • Black Fem
  • Black Fem All Occ
  • Black Female Diff Nbr
  • Black Female Diff Pct
  • Black Female Exp
  • Black Female Pct
  • Black Mal
  • Black Mal All Occ
  • Black Male Diff Nbr
  • Black Male Diff Pct
  • Black Male Exp
  • Black Male Pct
  • Disab
  • Disab All Occ
  • Disabled Diff Nbr
  • Disabled Diff Pct
  • Disabled Exp
  • Disabled Pct
  • EmpCount
  • EmpCount All Occ
  • Ethn Unk
  • Ethn Unk All Occ
  • Ethn Unk Pct
  • Fem
  • Fem All Occ
  • Fem Census Pct
  • Female Diff Nbr
  • Female Diff Pct
  • Female Exp
  • Female Pct
  • Hisp Fem
  • Hisp Fem All Occ
  • Hisp Female Diff Nbr
  • Hisp Female Diff Pct
  • Hisp Female Exp
  • Hisp Female Pct
  • Hisp Mal
  • Hisp Mal All Occ
  • Hisp Male Diff Nbr
  • Hisp Male Diff Pct
  • Hisp Male Exp
  • Hisp Male Pct
  • Minority Census Pct
  • Minority Diff Nbr
  • Minority Diff Pct
  • Minority Exp
  • Minority Pct
  • Minority Tot
  • Minority Tot All Occ
  • Nat Guard
  • National Guard All Occ
  • National Guard Pct
  • NHPI Fem
  • NHPI Fem All Occ
  • NHPI Female Diff Nbr
  • NHPI Female Diff Pct
  • NHPI Female Exp
  • NHPI Female Pct
  • NHPI Mal
  • NHPI Mal All Occ
  • NHPI Male Diff Nbr
  • NHPI Male Diff PctNHPI Male Exp
  • NHPI Male Pct
  • Two+ Fem
  • Two+ Fem All Occ
  • Two+ Female Diff Nbr
  • Two+ Female Diff Pct
  • Two+ Female Exp
  • Two+ Female Pct
  • Two+ Mal
  • Two+ Mal All Occ
  • Two+ Male Diff Nbr
  • Two+ Male Diff Pct
  • Two+ Male Exp
  • Two+ Male Pct
  • Vet
  • Veteran All Occ
  • Veteran Pct
  • White Female Exp
  • White Male Exp
  • White+ Fem
  • White+ Fem All Occ
  • White+ Female
  • White+ Female Diff Nbr
  • White+ Female Diff Pct
  • White+ Female Pct
  • White+ Mal
  • White+ Mal All Occ
  • White+ Male
  • White+ Male Diff Nbr
  • White+ Male Diff Pct
  • White+ Male Pct

Special Report Considerations/Features

  • Agency staff data prior to October 2022 is compared with 2010 Census. Agency staff data from
    October 2022 and after is compared with 2020 Census.
  • For Agency staff data prior to October 2022:
    • The Asian ethnicity metric also includes the 'Native Hawaiian or Pacific Islander' designation.
    • The White ethnicity metric also includes the 'Two or More' designation.
  • This report is meant to be a fixed format report and should not be navigated in any way. It is designed with specific margin and page break settings to accommodate (landscape/legal) print format when exporting to PDF.
  • When exporting to Excel, the margin setting on all tabs should be set to ‘Narrow’. Adjusting these margins in Excel will allow for a friendlier print product.
  • The Report Info tab contains detailed information about report content such as definitions of each data section and how calculations are defined.
  • This report does not support current month data. Data are loaded as monthly snapshots once a month closes out. For this reason, we will always be one month behind. Year to date data is supported (minus current month) along with the previous 5 years.
  • Only active employees who are part of the SPA employee groups (shown below) are included on this report.  
Employee Group   Description
A   SPA Employees
B   SPA Law Enforcement
C   SPA Non Teacher 10M
E   SPA Non Teacher 11M
P   SPA Bi-Weekly
Q   SPA LEO Bi-Weekly
Y   SPA Bi-Weekly Grant

Refer to Employee Group (SPA) in Optional Prompts to change the Employee Group selections.

  • By default, Employee Subgroup ‘Contractors’ are excluded in the report, and this can be changed. Refer to Exclude Employee Subgroup (Contractors) in Exclusion Prompts to remove the default value.
  • When calculating the # Expected values, the CEILING function is used so that the result is ALWAYS forced to round up to the next whole number regardless of the decimal value. Since this value represents a person, it is not logical to have part of a person so any decimal portion of a person will always round up to the next whole person.
    • Example: A value of 2.15 will always round up to 3.
    • Example: A value of 2.55 will always round up to 3.

First Published

Last Updated