Research: Topics: Business & Labor: Grievance Tracking System
Users' Guide to the Governor's Office of Employee Relations Grievance Tracking System (1984-1990)
1. Grievance File
The Grievance Files consist of 35,049 cases captured by 50 variables. There is one record per case. The data were gathered by means of a Monthly Grievance Report submitted by agencies. The essential information in this file is: grievant's name, bargaining unit, appropriate step, grievance type, contract article(s) for contract grievances or subject for non-contract grievances, initial file date, appropriate decision and decision data to correspond to each step appealed. If a grievance step was waived, code 07 was used for decision and the date was given as none. This information was required. No grievance case was closed unless this information was supplied.
A. Table of Fields and Data Validity
The table containing the Layout of Grievance Files summarizes the basic statistics about the data in this file with information on field position, length, type, total number of cases, missing cases, and invalid cases. Detailed explanation of the fields, including codes, are provided in Section B. The table is not available in this html version; contact the State Archives for a copy.
Layout of Grievance Files
| Field | Name | Column | Width | Type | # of Cases that can have valid values | % of cases with invalid values |
|---|---|---|---|---|---|---|
| 1 | Record (Case) Number | 1-8 | 8 | Numeric | 35,049 | 0.00% |
| 2 | Agency | 9-23 | 15 | Character | 35,049 | 0.00% |
| 3 | Agency Case Number | 24-38 | 15 | Character | 35,049 | 0.00% |
| 4 | Bargaining Unit | 39-40 | 2 | Numeric | 35,049 | 0.02% |
| 5 | Grievant Name | 41-70 | 30 | Character | 35,049 | 0.00% |
| 6 | Professional Title | 71-90 | 20 | Character | 35,049 | 0.00% |
| 7 | Facility/Location | 91-105 | 15 | Character | 35,049 | 0.00% |
| 8 | Step-1 Action | 106 | 1 | Character | 32,312 3 | 0.01% |
| 9 | Step-2 Action | 107 | 1 | Character | 19,138 4 | 0.00% |
| 10 | Step-3 Action | 108 | 1 | Character | 8,518 5 | 0.01% |
| 11 | Step-4 Action | 109 | 1 | Character | 54 6 | 1.85% |
| 12 | Arbitration | 110 | 1 | Character | 1,548 7 | 0.19% |
| 13 | Grievance Type | 111-113 | 3 | Character | 35,049 | 0.00% |
| 14 | Article 1 | 114-123 | 10 | Character | 35,049 | 0.00% |
| 15 | Article 2 | 124-133 | 10 | Character | 35,049 | 0.00% |
| 16 | Article 3 | 134-143 | 10 | Character | 35,049 | 0.00% |
| 17 | Non-Contract Subject | 144-158 | 15 | Character | 35,049 | 0.00% |
| 18 | Initial Filing Date (Month/Date/Year) | 159-164 | 6 | Numeric | 35,049 | 0.10% |
| 19 | Initial Filing Date (Month) | 159-160 | 2 | Numeric | 35,049 | 0.01% |
| 20 | Initial Filing Date (Day) | 161-162 | 2 | Numeric | 35,049 | 0.01% |
| 21 | Initial Filing Date (Year) | 163-164 | 2 | Numeric | 35,049 | 0.01% |
| 22 | Step-1 Decision | 165-166 | 2 | Numeric | 32,312 | 3.50% |
| 23 | Step-2 Decision | 167-168 | 2 | Numeric | 19,138 | 0.63% |
| 24 | Step-3 Decision | 169-170 | 2 | Numeric | 8,515 | 0.61% |
| 25 | Step-4 Decision | 171-172 | 2 | Numeric | 54 | 0.00% |
| 26 | Step-1 Decision Date (Month/Day/Year) | 173-178 | 6 | Numeric | 32,312 | 0.00% |
| 27 | Step-1 Decision Date (Month) | 173-174 | 2 | Numeric | 32,312 | 0.00% |
| 28 | Step-1 Decision Date (Day) | 175-176 | 2 | Numeric | 32,312 | 0.00% |
| 29 | Step-1 Decision Date (Year) | 177-178 | 2 | Numeric | 32,312 | 0.00% |
| 30 | Step-2 Decision Date (Month/Day/Year) | 179-184 | 6 | Numeric | 19,138 | 0.00% |
| 31 | Step-2 Decision Date (Month) | 179-180 | 2 | Numeric | 19,138 | 0.00% |
| 32 | Step-2 Decision Date (Day) | 181-182 | 2 | Numeric | 19,138 | 0.00% |
| 33 | Step-2 Decision Date (Year) | 183-184 | 2 | Numeric | 19,138 | 0.00% |
| 34 | Step-3 Decision Date (Month/Day/Year) | 185-190 | 6 | Numeric | 8,518 | 0.00% |
| 35 | Step-3 Decision Date (Month) | 185-186 | 2 | Numeric | 8,518 | 0.00% |
| 36 | Step-3 Decision Date (Day) | 187-188 | 2 | Numeric | 8,518 | 0.00% |
| 37 | Step-3 Decision Date (Year) | 189-190 | 2 | Numeric | 8,518 | 0.00% |
| 38 | Step-4 Decision Date (Month/Day/Year) | 191-196 | 6 | Numeric | 54 | 0.00% |
| 39 | Step-4 Decision Date (Month) | 191-192 | 2 | Numeric | 54 | 0.00% |
| 40 | Step-4 Decision Date (Day) | 193-194 | 2 | Numeric | 54 | 0.00% |
| 41 | Step-4 Decision Date (Year) | 195-196 | 2 | Numeric | 54 | 0.00% |
| 42 | Arbitration Decision Date (Month/Day/Year) | 197-202 | 6 | Numeric | 1,548 | 0.00% |
| 43 | Arbitration Decision Date (Month) | 197-198 | 2 | Numeric | 1,548 | 0.00% |
| 44 | Arbitration Decision Date (Day) | 199-200 | 2 | Numeric | 1,548 | 0.00% |
| 45 | Arbitration Decision Date (Year) | 201-202 | 2 | Numeric | 1,548 | 0.00% |
| 46 | Closed | 203 | 1 | Character | 35,049 | 0.02% |
| 47 | Step-3 Case Number | 204-212 | 9 | Character | 8,518 | 0.07% |
| 48 | Step-3 Decision Date (Year) | 204-205 | 2 | Character | 8,518 | 0.07% |
| 49 | Step-3 Bargaining Unit | 206-207 | 2 | Numeric | 8,518 | 0.07% |
| 50 | Step-3 File Number | 208-212 | 5 | Numeric | 8,518 | 0.07% |
