FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

SPRS User Guide > previous | next

SPRS Personnel Input Record Matrix
210 Record

210 Record – Employee Descriptive Information

  Field Requirements by Reason Code
Data Fields LEG 010 012 038 043 057 060 063-064 065 067-068 069
AGY NO KM KM KM KM KM KM KM KM KM KM KM
BATCH NO KM KM KM KM KM KM KM KM KM KM KM
REC ID KM KM KM KM KM KM KM KM KM KM KM
SSN KM KM KM KM KM KM KM KM KM KM KM
PROC SEQ ID O1 O1 O1 O O O O O O O O
EFFECTIVE DT KM KM KM KM KM KM KM KM KM KM KM
REASON CD KM KM KM KM KM KM KM KM KM KM KM
REV IND O O O O O O O O O O O
LWOP IND X X X O M X X X X X X
FIRST NAME M M M O X X X X X X X
MIDDLE NAME O O O O X X X X X X X
LAST NAME M M M O X X X X X X X
SP3 – NAME X X X O X X X X X X O
ADDRESS 1 M M M O X O O O O O O
ADDRESS 2 O O O O X O O O O O O
CITY M M M O X O O O O O O
STATE M M M O X O O O O O O
ZIP CD O O O O X O O O O O O
CNTRY/ZONE M M M O X O O O O O O
BIRTH DT M M M O X X X X X X X
RACE M M M O X X X X X X X
SEX M M M O X X X X X X X
VET IND M M M O X X X X X X X
VET PREF IND M M M O X X X X X X X
CITIZEN STATUS O O O O X X X X X X X
CITIZEN CNTRY O O O O X X X X X X X
CNTY CD MAIL X X X X X X X X X X X
CPO IND M M M O X X X X X X X
RETIREMENT CD M M M O X X X X X X X
FICA EXEMPT M M M O X X X X X X X
BRP ELIG IND M M M O O X X X X X X
STATUS ATTR M M M O X X X X X X X
AGY TRN FROM M X M O X X X X X X X
AGY TRN TO X X X O X X X X M X X
EFF SVC DT M M M O O2 O O O O O O
6 CNT SVC IND O O O O O O O O O O O
RELEASE ADDRESS M M M O X X X X X X X
RELEASE HOME PHONE M M M O X X X X X X X
RELEASE SSN M M M O X X X X X X X
RELEASE FAMILY INFO M M M O X X X X X X X
RELEASE EMERG CONTACT M M M O X X X X X X 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
12/14/2011 Removed Data Release Indicator and added Release Address, Release Home Phone, Release SSN, Release Family Information and Release Emergency Contact effective 10/01/2011.
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