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 HOURS
orPAYROLL 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 | 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 |
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 |
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 |
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 |
PROC SEQ ID | 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 |
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 |
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 |
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 |
EMPL TYPE | 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 | 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 | 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 | 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 | 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 | 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 |
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 |
DAILY RATE | 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 | 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 |
EEO JOB CAT | 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 | 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 | 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 | 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 | 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 HOURS
orPAYROLL 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 | 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 |
BATCH NO | 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 |
SSN | 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 |
JOB NO | 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 |
REASON CD | 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 |
EMPL TYPE | O | O | O | O | M | M | M | X | O | O | O | O | M | O | O | O | O | O | X |
CLASS CD | X | M | M | O | M | M | M | 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 | X | M1 | M1 | X |
SALARY TYPE | X | X | X | X | X | X | M | 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 | M | O | O | O | O | O | X |
ASSND WK HRS | O | O | O | O | O | O | M | X | 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 |
HOURLY RATE | M3 | M3 | M3 | M3 | M3 | M3 | M3 | X | M3 | X | 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 |
CNTY CD WORK | O | O | O | O | O | O | M | X | 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 | X |
EEO JOB CAT | O | O | O | O | O | O | M | X | 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 | M | X | X | X | X | X | X |
FLSA IND | O | O | O | O | O | O | M | X | 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 | 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 | X |
Field Requirements Key
Code | Description |
---|---|
KM | Key/Mandatory |
M | Mandatory |
O | Optional |
X | Protected (Not Applicable for Transaction) |
Date | Updates |
---|---|
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 |