Skip to content

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)
Changes to This Document
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.