Skip to main content

B0176 Statewide EEO Reports (Fixed Format)

Purpose

The purpose of this report description is to explain how to generate the B0176 Statewide EEO Reports (Fixed Format) report. 

Report Description

This report compares state government’s overall work force to the NC population and the NC occupation specific labor force by State SOC Category and is associated with two reporting views.

The first reporting tab (B0176) compares state government’s overall work force to the NC occupation specific labor force by State SOC Category. (The NC population labor force is defined through the most recent US census data.) This report includes demographic information such as race and gender.

This second reporting tab (B0177) compares state government’s overall work force to the NC population by State SOC Category. (The NC population is defined through the most recent US census data.) This report includes demographic information such as race and gender. 

Report Location

PA: EEO

Report Uses

  • This report is useful in analyzing the composition of state government’s work force and determining underutilization statewide. This report is useful in determining the distribution of employees in state government’s work force statewide.
  • This report is useful in analyzing the composition of state government’s work force and determining underutilization statewide. This report is useful in determining the distribution of employees in state government’s work force.

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:  

  • Calendar Month/Year (Single Value, Mandatory)
  • U.S. Census Year (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 has two report tabs as well as a Report Info report tab.  The first two report tabs provide a different analysis of the U.S. Census data by State SOC Category  

Labor Force Compromise - B0176

This Reporting tab (B0176) compares state government’s overall work force to the NC occupation specific labor force by State SOC Category. (The NC population labor force is defined through the most recent US census data.) This report includes demographic information such as race and gender.  

Labor Force Compromise – B0176 Continued….

Work Force Standard - B0177

This Reporting tab (B0177) compares state government’s overall work force to the NC population by State SOC Category (The NC population is defined through the most recent US census data). This report includes demographic information such as race and gender.

Work Force Standard - B0177 Continued….

Report Info

The Report Info tab displays information about the prompts entered.  

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: 

Note: Please do not add listed Objects below to Default Layout of the report.

Note: See Special Report Considerations/Features below

Dimensions

  • State SOC Category

Measures

  • AIAN Female
  • AIAN Female Pct
  • AIAN Male
  • AIAN Male Pct
  • Asian+ Female
  • Asian+ Female Pct
  • Asian+ Male
  • Asian+ Male Pct
  • Black Female
  • Black Female Pct
  • Black Male
  • Black Male Pct
  • Census AIAN Female Pop
  • Census AIAN Female Pop Pct
  • Census AIAN Female SOC
  • Census AIAN Female SOC Pct
  • Census AIAN Male Pop
  • Census AIAN Male Pop Pct
  • Census AIAN Male SOC
  • Census AIAN Male SOC Pct
  • Census Asian Female Pop
  • Census Asian Female Pop Pct
  • Census Asian Female SOC
  • Census Asian Female SOC Pct
  • Census Asian Male Pop
  • Census Asian Male Pop Pct
  • Census Asian Male SOC
  • Census Asian Male SOC Pct
  • Census Black Female Pop
  • Census Black Female Pop Pct
  • Census Black Female SOC
  • Census Black Female SOC Pct
  • Census Black Male Pop
  • Census Black Male Pop Pct
  • Census Black Male SOC
  • Census Black Male SOC Pct
  • Census Disabled
  • Census Hispanic Female Pop
  • Census Hispanic Female Pop Pct
  • Census Hispanic Female SOC
  • Census Hispanic Female SOC Pct
  • Census Hispanic Male Pop
  • Census Hispanic Male Pop Pct
  • Census Hispanic Male SOC
  • Census Hispanic Male SOC Pct
  • Census Total Female Pop
  • Census Total Female Pop Pct
  • Census Total Female SOC
  • Census Total Female SOC Pct
  • Census Total Minority Pop
  • Census Total Minority Pop Pct
  • Census Total Minority SOC
  • Census Total Minority SOC Pct
  • Census White Female Pop
  • Census White Female Pop Pct
  • Census White Female SOC
  • Census White Female SOC Pct
  • Census White Male Pop
  • Census White Male Pop Pct
  • Census White Male SOC
  • Census White Male SOC Pct
  • Disabled
  • Disabled Census Pct
  • Disabled Pct
  • Ethnicity Unknown
  • Ethnicity Unknown Pct
  • Hispanic Female
  • Hispanic Female Pct
  • Hispanic Male
  • Hispanic Male Pct
  • Over/Under AIAN Female Pop
  • Over/Under AIAN Female SOC
  • Over/Under AIAN Male Pop
  • Over/Under AIAN Male SOC
  • Over/Under Asian Female Pop
  • Over/Under Asian Female SOC
  • Over/Under Asian Male Pop
  • Over/Under Asian Male SOC
  • Over/Under Black Female Pop
  • Over/Under Black Female SOC
  • Over/Under Black Male Pop
  • Over/Under Black Male SOC
  • Over/Under Disabled
  • Over/Under Hispanic Female Pop
  • Over/Under Hispanic Female SOC
  • Over/Under Hispanic Male Pop
  • Over/Under Hispanic Male SOC
  • Over/Under Total Female Pop
  • Over/Under Total Female SOC
  • Over/Under Total Minority Pop
  • Over/Under Total Minority SOC
  • Over/Under White Female Pop
  • Over/Under White Female SOC
  • Over/Under White Male Pop
  • Over/Under White Male SOC
  • Total
  • Total Female
  • Total Female Pct
  • Total Minority
  • Total Minority Pct
  • Total Over/Under AIAN Female SOC
  • Total Over/Under AIAN Male SOC
  • Total Over/Under Asian Female SOC
  • Total Over/Under Asian Male SOC
  • Total Over/Under Black Female SOC
  • Total Over/Under Hispanic Female SOC
  • Total Over/Under Hispanic Male SOC
  • Total Over/Under Total Female SOC
  • Total Over/Under Total Minority SOC
  • Total Over/Under White Female SOC
  • Total Over/Under White Male SOC
  • Total Pct
  • White+ Female
  • White+ Female Pct
  • White+ Male
  • White+ Male Pct

Variables

  • Prompt Response Cal Mth/Yr
  • Prompt Response Employee Group
  • Prompt Response Exclude Employee Subgroup
  • Prompt Response U.S. Census Year

Special Report Considerations/Features

  • Only active employees are included on this report.
  • By default, the Report will provide information only for U.S. Census Year ‘2010’ and this can be changed. Please refer U.S. Census Year (Single Value, Mandatory) in Prompts to remove the default value.
  • By default, the Report will provide information only for ‘SPA’ Employee Groups and this can be changed. Please refer 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. Please refer Exclude Employee Subgroup (Contractors) in Exclusion Prompts to remove the default value.
  • Since this is a fixed format report, please do not apply any Report Filters, Input Controls, and do not add any data elements from Available Objects.
  • You will get below #ERROR message in all Employee count rows when you add any data elements from Available Objects.

Custom Analysis

If custom analysis is required, you can create a new reporting tab and build a custom view without changing the default report tab ‘Labor Force Compromise - B0176’. 

  • Creating new reporting tab:
  1. Make sure that Design Mode is on.
  2. Right-Mouse click on the reporting tab ‘B0031 Staffing by Occupational Category.  
  3. Click New. 

4.    Drag and drop the available objects in the new reporting tab and build a custom view.

  • Applying Page Breaks; When exporting to PDF, you can display State SOC Category (in B0176 and B0177) on separate pages.
  1. Left click to select the desired column.
  2. Right click in the grey area of a section on State SOC Category section area (in B0176) and State SOC Category section area (in B0177). 

  1. Select Format section from the right click menu.
  2. Select Layout Settings.

  1. Under the Page Break Section click on “Start instances on a new Page”.
  2. If “Instant Apply” is checked results will automatically apply or you can click “Apply”.

First Published

Last Updated