SPRS User Guide –
SPRS Personnel Input Record Matrix
240 Record
Updated: Sept. 2, 2014 – View Changes
240 Record – Employee Deduction Information
Deduction Field Requirements | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Data Fields | 401 | 403 | 457 | BAN | CCD | CSC | CSP | CUF | CUP | DCC | DCL | DDP | FGO | INS | LEV | LON | ORD | PRD | PRO | PYB | R01 | R57 | SPM | STU | TOB | TPF | TTF | TXF |
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 | 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 | 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 | 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 | KM |
ACTION CODE | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M | M |
DED CODE | 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 | KM |
DED SEQ 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 | 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 | KM |
DED AUTH AMT | X | M | M | M | M | M | M | M | M | M | M | M | O | M | O | M | M | M | M | M | X | M | M | O | M | M | M | M |
DED AUTH RATE | M | X | X | X | X | X | X | X | X | X | X | X | O | X | X | X | X | X | X | X | M | X | X | O | X | X | X | X |
Field Requirements Key
Code | Description |
---|---|
KM | Key/Mandatory |
M | Mandatory |
O | Optional |
X | Protected (Not Applicable for Transaction) |
Date | Updates |
---|---|
09/02/2014 | Added deduction code DDP (Dental Discount Program) effective 09/01/2014. |
02/16/2012 | Added deduction codes TOB (Tobacco User Premium Differential) effective 01/01/2012, R01 (Roth 401k Contribution) and R57 (Roth 457 Deferred Compensation) effective 02/01/2012. |
07/31/2009 | Removed Deduction Code CHI (Child Support). Authorized child support deduction transactions will no longer be required for any type of child support deduction. |
05/11/2009 | Added Deduction Code TPF (Texas Tuition Promise Fund). This new deduction requires authorized personnel setup before the deduction can be made on payroll. |