FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

SPRS User Guide > previous | next

SPRS Personnel Input Record Matrix
220 Record

Table of Contents

220 Record – Employee Job Information (Reasons Codes F18 – 024)

Valid Field Requirements:

  Field Requirements
Data Fields 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
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 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
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 X X X X X X X X X X X O X X M M M M O
CLASS CD 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 X M1 M1 X M1 M1 M1
SALARY TYPE 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 M X O O O M M O
ASSND WK HRS 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
HOURLY RATE 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 X X X X X M4 X X
CNTY CD WORK 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
EEO JOB CAT 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 M X X X X M M X
FLSA IND 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 O X X X X O O O
LOC CD 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)

Return to Top

220 Record – Employee Job Information (Reasons Codes 025 – 050)

Valid Field Requirements:

  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)

Return to Top

Document Changes

Revision Date Revision Description
10/26/2017 Added Reason Code F18 effective 09/01/2017; F17 effective 09/01/2016; and F16 effective 09/01/2015
07/24/2014 Added Reason Code F15, effective 09/01/2014
10/01/2013 Added Reason Code F14, effective 09/01/2013
07/19/2012 Added Reason Code F13, effective 09/01/2012
Added Reason Code F12, effective 09/01/2011
09/01/2010 Added Reason Code F11, effective 09/01/2010
08/21/2009 Added Reason Code F10, effective 09/01/2009
Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy