This file contains a snapshot of current employment history transactions for students in class codes 0100, 1874, 1875, 1876 and 1868 and selected fields for Student Payroll Action Requests (SPAR) for class codes 1870, 1871, and 1872. Data is available for transactions keyed by your campus which are effective in the current and 5 prior fiscal years. This file includes active and separated employees. Note: Students appointed the SPAR do not have data for the following fields: Appointment Expiration Date, Salary Total, Noncitizen and Disability. For additional information, refer to the topic: Tips For Using The Student Assistant File.
-
Files Automatically Joined: None
-
Pre-programmed Joins: None
-
Sample FOCUS Request: FOC1080B
Segment Name = STUDENT, Segment Type = S1
|
|
ST:SSA
|
A
|
11
|
Social Security Number
|
|
|
ST:SSAFOUR
|
A
|
4
|
Social Security Number, Last 4 Digits
|
|
|
ST:SSAMASK
|
A
|
11
|
Social Security Number, Masked
|
|
|
ST:SSAPSN
|
A
|
11
|
SSA / Position Sequence Key
|
|
|
ST:LASTNAME
|
A
|
21
|
Name, Last
|
|
|
ST:FRSTNAME
|
A
|
16
|
Name, First & Middle Initial
|
|
|
ST:WNAME
|
A
|
39
|
Name, Full
|
|
|
ST:SEX
|
A
|
1
|
Sex Code
|
|
|
ST:ETHNIC
|
A
|
1
|
Ethnic Origin
|
|
|
ST:ETHNICGRP
|
A
|
3
|
Ethnic Group
|
|
|
ST:BRTHDATE
|
DT
|
MDYY
|
Birthdate
|
|
|
ST:ADDRWH
|
A
|
1
|
Address Withheld Indicator
|
|
|
ST:STREET
|
A
|
28
|
Employee Address, Street
|
|
|
ST:CTYST
|
A
|
25
|
Employee Address, City and State
|
|
|
ST:ZIP
|
A
|
5
|
Employee Address, Zip Code
|
|
|
ST:CAMPUSCD
|
A
|
2
|
Campus Numeric Code
|
|
|
ST:PSNSEQ
|
A
|
2
|
Position Sequence Number
|
|
|
ST:TRANCODE
|
A
|
3
|
Transaction Code, Personnel
|
|
|
ST:EFFDATE
|
DT
|
MDYY
|
Effective Date (MMDDYYYY)
|
|
|
ST:APPTXDTE
|
DT
|
MDYY
|
Appointment Expiration Date
|
|
|
ST:AGENCY
|
A
|
3
|
Agency Code
|
|
|
ST:UNIT
|
A
|
3
|
Reporting Unit
|
|
|
ST:AGYUNIT
|
A
|
6
|
Agency and Unit Key
|
|
|
ST:CLASS
|
A
|
4
|
Class Code
|
|
|
ST:SERIAL
|
A
|
3
|
Serial Number
|
|
|
ST:SALARY
|
P
|
12.2
|
Salary Total
|
|
|
ST:TITLEA
|
A
|
13
|
Class Title, Abbreviated
|
|
|
ST:TITLE
|
A
|
38
|
Class Title, Full
|
|
|
ST:POSITION
|
A
|
13
|
Position
|
|
|
ST:POSIT16
|
A
|
16
|
Position Number
|
|
|
ST:NONCITZN
|
A
|
10
|
Noncitizen Status Code
|
|
|
ST:VISA
|
A
|
1
|
Noncitizen Immigration/Visa Category
|
|
|
ST:COUNTRY
|
A
|
2
|
Noncitizen tax Treaty Country
|
|
|
ST:RESIDENT
|
A
|
1
|
Noncitizen Tax Residency Status
|
|
|
ST:WAED
|
A
|
6
|
Noncitizen Work Authorization Exp. Date
|
|
|
ST:DISABLE
|
A
|
3
|
Disability Status
|
|
|
ST:DISAB
|
A
|
1
|
Disability Status Code
|
|
|
ST:ENTRYDTE
|
DT
|
MDYY
|
Entry Date
|
|
|
ST:ACCNTCDE
|
A
|
2
|
Retirement System Account Code
|
|
|
ST:SEPCODE
|
A
|
1
|
Separation Code
|
Last Updated: May 8, 2006