Skip to main content

B0034 Employee Grievance Data

REPORT DESCRIPTION

This report lists all Grievance Issues filed by active employees. It includes all associated detail for each grievance basis along with status information such as informal and formal steps taken. Provides jump to 'B0022: Comments' report.

REPORT LOCATION

PA: Grievances

REPORT USES

  • This data can be used to track and report events occurring in the EEO Informal Complaint and Grievance process, and the Policy Violation Grievance process beginning with the informal complaint step through the disposition of a complaint at the Office of Administrative Hearings (OAH).
  • The data captured will reflect the State’s activity for employee complaints and grievances. The data will also be used to determine training and/or educational needs for employees.

DATA LOAD FREQUENCY

The data for this report is loaded every weekday morning, excluding holidays. This report will include any changes that were made to the data on the previous day, including retroactive changes.

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
  • From Day (Single Value, Mandatory)
  • To Day (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(s) - (Optional)
  • Employee Subgroup(s) - (Optional)
  • Employee(s) PersNo. - (Optional)
  • Grievance Issue(s) - (Optional)

Initial Layout

The report lists all grievances based on the prompt selections. Below is a sample of the initial layout rendered.

Continued…

Continued...

Continued...

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

  • Age
  • Agency Hire Date
  • Appeal to OAH?
  • Comments?
  • Date FAD Issued
  • Date Formal Grievance Filed
  • Date Informal Completed
  • Date of Alleged Event or Action
  • Date Step 1 Completed
  • Decision Date
  • Discrimination Action
  • Discrimination Basis
  • Emp Pay Area
  • Emp Pay Group
  • Emp Pay Level
  • Emp Pay Type
  • Employee
  • Employee Group
  • Employee Subgroup
  • Employee’s Name
  • Employment Status
  • ESGCAP
  • Ethnic Orgin
  • FAD Exceeded Timeline
  • Formal Grievance Filed?
  • Gender
  • Grievable Issue
  • Grievance End Date
  • Grievance Filed Timely?
  • Grievance Start Date
  • Informal Step Taken
  • Job
  • Military Status
  • OAH Case Number
  • OAH Case Status
  • OAH Deadline
  • OAH Filing Date
  • OAH Final Decision
  • OAH Remand Back to Agency
  • Organizational Unit
  • Original Hire Date
  • OSHR Reviewed FAD
  • Personnel Area
  • Personnel Subarea
  • Policy Violation Action
  • Position
  • Record Complete
  • Remand Date
  • Sequence Number
  • State SOC Category
  • State SOC Subcategory
  • Step 1 Result/Mediation
  • Step 2 Filed?
  • Step 2 Result/FAD
  • Veteran Status

Measures

  • Grievance Count
  • Reason Count

Variables

  • Prompt Response Employee Group
  • Prompt Response Employee PersNo
  • Prompt Response Employee Subgroup
  • Prompt Response From Day – To Day
  • Prompt Response Grievance Issues
  • Prompt Response Organizational Unit

Special Report Considerations/Features

  • Report lists the grievances that are valid as of (report run date) for the date ranges entered in ’From Day – To Day’ prompts. This report brings in all the grievances that are within the ‘From Day’ ‘To Day’ date range given in the prompt screen. These records may have begun before the ‘From Day’ or beyond the “To Day” however, if they are valid at any point between the ranges given, they will be selected.

For example, with a date range of ‘From Day’ 6/11/2019 and ‘To Day’ 12/14/2019 the following records would be selected with the following date ranges:

Valid From   Valid To Example Type
6/11/2019   12/14/2019 Validity dates match record
5/1/2019   12/31/9999 Validity dates start before and ends after selected range
6/13/2019   8/20/2019 Validity dates start before and ends before selected range
5/18/2019   5/18/2020 Validity dates start before and ends after selected range
  • When an employee files a grievance under multiple discrimination factors in the SAP ERP system, this report breaks out the multiple discrimination factors on individual rows. The Grievance Count reflects the count per Grievable Issue. The Reason Count reflects the count per unique combinations of Discrimination Action and Discrimination Basis for each Grievable Issue.

In this example, an employee filed a Discrimination grievance on multiple factors of Race, Age and National Origin.

The report will reflect the different factors individually as shown below.

Here the Reason Count shows the count for each individual discrimination factor based on the Discrimination Basis type. The Grievance Count reflects the count for each Grievable Issue such as Policy Violation, Discrimination, Harassment or Retaliation. The discrimination factors are broken out into 3 separate rows, but they all pertain to the same Grievable Issue. Hence the Grievance Count is marked as 1 on only one of the rows while the others are marked as zero. This is done so that the total Grievance Count does not over-inflate when summarized.

First Published

Last Updated