SPRS User Guide –
SPRS Personnel Input Record Matrix
220 Record
Table of Contents
220 Record – Employee Job Information (Reason Codes F25 – 024)
Valid Field Requirements:
- *Reason code 048 valid for agencies 537 and 539 only.
- **Reason code 049 valid for Schedule C only.
- ***Reason code 025 not valid for Schedule C employees.
- [1] Employees on Schedule C only. Protected for employees on Schedules A and B, unclassified and exempt.
- [2] Salaried employees on Schedule A, B or C, or unclassified or exempt. For Schedule C, field is used to verify that the salary is consistent between SPRS and agency's internal system.
- [3] Hourly employees on Schedule A, B or C, or unclassified or exempt. For Schedule C, field is used to verify that the hourly rate is consistent between SPRS and agency's internal system.
- [4] Compensatory board members only. Protected for all other employees.
- [5] Mandatory for classified, unclassified and exempt salaried employees when making a change to
ASSIGNED WORK HOURSorPAYROLL CYCLE; protected for all other changes. - [6] If submitted, must equal value sent on corresponding 210 transaction.
- [7] Mandatory for agency 696; optional for all other agencies.
- [8] Mandatory for employees with a class code being mapped directly to a new class code; protected for all others.
| Field Requirements | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Data Fields | F26 | F25 | F24 | F23 | F22 | F21 | F20 | F19 | F18 | F17 | F16 | F15 | F14 | F13 | F12 | F11 | F10 | F09 | F08 | LEG | 001 | 002-003 | 008 | 009 | 010 | 012 | 020-024 |
| AGY NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| BATCH NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| REC ID | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| SSN | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| PROC SEQ ID | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O6 | O | O | O | O | O6 | O6 | O |
| JOB NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| EFFECTIVE DATE | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| REASON CD | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| REV IND | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |
| EMPL TYPE | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | O | X | X | M | M | M | M | O |
| CLASS CD | X | X | X | X | X8 | X | X8 | X | X8 | X | X8 | X | X8 | X | X | X | X8 | X | X | M | X | X | M | M | M | M | M |
| SALARY STEP | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | M1 | X | M1 | M1 | X | M1 | M1 | M1 |
| SALARY TYPE | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | M | X | X | X | X | M | M | X |
| PAY CYCLE | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | M | X | O | O | O | M | M | O |
| ASSND WK HRS | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | O | X | X | X | X | M | M | O |
| SAL AUTH BASE | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 |
| HOURLY RATE | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 |
| DAILY RATE | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | M4 | X | X | X | X | X | M4 | X | X |
| CNTY CD WORK | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | M | O | O | O | O | M | M | O |
| UNIT NO | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |
| EEO JOB CAT | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | M | O | O | O | O | M | M | O |
| EEO FUNC CD | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | M | X | X | X | X | M | M | X |
| FLSA IND | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | M | X | X | X | X | M | M | O |
| HAZ DUTY IND | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | O | X | X | X | X | O | O | O |
| LOC CD | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | X | X | X | X | O | O | O |
Field Requirements Key
| Code | Description |
|---|---|
| KM | Key/Mandatory |
| M | Mandatory |
| O | Optional |
| X | Protected (Not Applicable for Transaction) |
220 Record – Employee Job Information (Reason Codes 025 – 050)
Valid Field Requirements:
- *Reason code 048 valid for agencies 537 and 539 only.
- **Reason code 049 valid for Schedule C only.
- ***Reason code 025 not valid for Schedule C employees.
- [1] Employees on Schedule C only. Protected for employees on Schedule A and B, unclassified and exempt.
- [2] Salaried employees on Schedule A, B or C, or unclassified or exempt. For Schedule C, field is used to verify that the salary is consistent between SPRS and agency's internal system.
- [3] Hourly employees on Schedule A, B or C, or unclassified or exempt. For Schedule C, field is used to verify that the hourly rate is consistent between SPRS and agency's internal system.
- [4] Compensatory board members only. Protected for all other employees.
- [5] Mandatory for classified, unclassified and exempt salaried employees when making a change to
ASSIGNED WORK HOURSorPAYROLL CYCLE; protected for all other changes. - [6] If submitted, must equal value sent on corresponding 210 transaction.
- [7] Mandatory for agency 696; optional for all other agencies.
- [8] Mandatory for employees with a class code being mapped directly to a new class code; protected for all others.
| Field Requirements | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Data Fields | ***025 | 026 | 027-028 | 029 | 030 | 031 | 032 | 033 | 034 | 038 | 040 | L40 | 041 | 042 | 044 | 046 | 047 | *048 | **049 | 050 |
| AGY NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| BATCH NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| REC ID | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| SSN | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| PROC SEQ ID | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |
| JOB NO | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| EFFECTIVE DATE | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| REASON CD | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM | KM |
| REV IND | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O | O |
| EMPL TYPE | O | O | O | O | M | M | M | X | O | O | O | O | O | M | O | O | O | O | O | X |
| CLASS CD | X | M | M | O | M | M | M | X | X | X | X | X | M | M | M | M | X | X | X | X |
| SALARY STEP | M1 | M1 | M1 | X | M1 | X | M1 | X | M1 | X | X | M1 | M1 | M1 | M1 | M1 | X | M1 | M1 | X |
| SALARY TYPE | X | X | X | X | X | X | M | X | X | X | X | X | X | X | X | X | X | X | X | M |
| PAY CYCLE | O | O | O | O | O | O | M | X | O | O | O | O | O | M | O | O | O | O | O | X |
| ASSND WK HRS | O | O | O | O | O | O | M | X | O | O | O | O | O | M | O | O | O | O | O | X |
| SAL AUTH BASE | M2 | M2 | M2 | M2 | M2 | M2 | M2 | X | M2 | M5 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 | M2 |
| HOURLY RATE | M3 | M3 | M3 | M3 | M3 | M3 | M3 | X | M3 | X | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 | M3 |
| DAILY RATE | X | X | X | X | X | X | X | X | X | O4 | X | X | X | X | X | X | X | X | X | X |
| CNTY CD WORK | O | O | O | O | O | O | M | X | O | O | O | O | O | M | O | O | O | O | O | X |
| UNIT NO | O | O | O | O | O | O | O | X | O | O | O | O | O | O | O | O | O | O | O | X |
| EEO JOB CAT | O | O | O | O | O | O | M | X | O | O | O | O | O | M | O | O | O | O | O | X |
| EEO FUNC CD | X | X | X | X | X | X | M | X | X | O | X | X | X | M | X | X | X | X | X | X |
| FLSA IND | O | O | O | O | O | O | M | X | O | O | O | O | O | M | O | O | O | O | O | X |
| HAZ DUTY IND | O | O | O | O | O | O | O | X | O | O | O | O | O | O7 | O | O | O | O | O | X |
| LOC CD | O | O | O | O | O | O | O | X | O | O | O | O | O | O | O | O | O | O | O | X |
Field Requirements Key
| Code | Description |
|---|---|
| KM | Key/Mandatory |
| M | Mandatory |
| O | Optional |
| X | Protected (Not Applicable for Transaction) |
| Date | Updates |
|---|---|
| 09/29/2025 | Added reason code L40 |
| 01/13/2023 | Added reason code F23 effective 09/01/2022 |
| 10/12/2021 | Added reason code F19 effective 09/01/2018, F20 effective 09/01/2019, F21 effective 09/01/2020 and F22 effective 09/01/2021 |
| 10/26/2017 | Added reason code F18 effective 09/01/2017; F17 effective 09/01/2016; and F16 effective 09/01/2015 |