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. |