This file contains a snapshot of current employment history transactions for separated position sequences from 1/1/1987 forward for your faculty, staff, management and special consultant (transaction A54) employees. Student positions are not included in this file. Any active or on-leave position sequences an employee might have would be in the Active Current Status (AC) file. For additional information, refer to the topic: Tips For Using The Separated Current Status File.
Segment Name = SEPS, Segment Type = S1
*This defined field retrieves data (SP:EFFDATE) from the lower segment.
Segment Name = SPPSNS, Parent = SEPS, Segment Type = S1
|
|
SP:PSNSEQ
|
A
|
2
|
Position Sequence Number
|
|
|
SP:SSAPSN
|
A
|
11
|
SSA / Position Sequence Key
|
|
|
SP:DOCT
|
A
|
4
|
Document Processing Number
|
|
|
SP:AGYUNIT
|
A
|
6
|
Agency and Unit Key
|
|
|
SP:SEPCODE
|
A
|
1
|
Separation Code
|
|
|
SP:CAMPUSCD
|
A
|
2
|
Campus Code
|
|
|
SP:CAMPUS
|
A
|
10
|
Campus Name Abbreviated
|
|
|
SP:CBID
|
A
|
3
|
Collective Bargaining Id, Code
|
|
|
SP:TRANCODE
|
A
|
3
|
Transaction Code, Personnel
|
|
|
SP:TRANNAME
|
A
|
35
|
Transaction Code Name
|
|
|
SP:TRANTYPE
|
A
|
24
|
Transaction Code Type
|
|
|
SP:EFFDATE
|
DT
|
MDYY
|
Effective Date (MMDDYYYY)
|
|
|
SP:EFFYYYY
|
DT
|
YY
|
Effective Year
|
|
|
SP:EFFMM
|
DT
|
M
|
Effective Month
|
|
|
SP:EFFDD
|
DT
|
D
|
Effective Day
|
|
|
SP:EFFYMD
|
DT
|
YYMD
|
Effective Date (YYYYMMDD)
|
|
|
SP:AGENCY
|
A
|
3
|
Agency Code
|
|
|
SP:UNIT
|
A
|
3
|
Reporting Unit
|
|
|
SP:CLASS
|
A
|
4
|
Class Code
|
|
|
SP:SERIAL
|
A
|
3
|
Serial Number
|
|
|
SP:POSIT16
|
A
|
16
|
Position Number
|
|
|
SP:POSITION
|
A
|
13
|
Position
|
|
|
SP:DEPT
|
A
|
3
|
Department Code
|
|
|
SP:APPTTYPE
|
A
|
1
|
Appointment Type (Leave Code)
|
|
|
SP:SALARY
|
P
|
12.2
|
Salary Total
|
|
|
SP:SALPER
|
A
|
1
|
Salary Per
|
|
|
SP:BASEPAY
|
P
|
12.2
|
Base Pay
|
|
|
SP:ANNIDATE
|
A
|
6
|
Anniversary Date
|
|
|
SP:TIMEBASE
|
A
|
6
|
Time Base
|
|
|
SP:NUMER
|
I
|
3
|
Time Base, Numerator
|
|
|
SP:DENOM
|
I
|
3
|
Time Base, Denominator
|
|
|
SP:FTE
|
P
|
11.5
|
Full-Time Equivalent
|
|
|
SP:PTTOT
|
P
|
7
|
Part-Time Total
|
|
|
SP:FTTOT
|
P
|
7
|
Full-Time Total
|
|
|
SP:APPTXDTE
|
DT
|
MDYY
|
Appointment Expiration Date
|
|
|
SP:PROBCODE
|
A
|
1
|
Probationary Period Code
|
|
|
SP:PROBDATE
|
A
|
8MDYY
|
Probationary Period Ending Date
|
|
|
SP:PROBGROUP
|
A
|
12
|
Probationary Period Group
|
|
|
SP:TEMPSTAT
|
I
|
5
|
Status, Temporary
|
|
|
SP:PERMSTAT
|
I
|
5
|
Status, Permanent
|
|
|
SP:PROBSTAT
|
I
|
5
|
Status, Probationary
|
|
|
SP:NOPROB
|
I
|
5
|
Status, No Probation
|
|
|
SP:SAFETY
|
A
|
3
|
Safety Member
|
|
|
SP:SURVIVOR
|
A
|
3
|
Survivors Benefits
|
|
|
SP:SSMED
|
A
|
3
|
Social Security/Medicare Member
|
|
|
SP:LICTYPE
|
A
|
1
|
Professional License Type
|
|
|
SP:LICDATE
|
A
|
8MDYY
|
Professional License, Expiration Date
|
|
|
SP:MULTIR1
|
P
|
8.2
|
Multiple Hourly Rate
|
|
|
SP:MULTIR2
|
P
|
8.2
|
Multiple Hourly Rate
|
|
|
SP:MULTIR3
|
P
|
8.2
|
Multiple Hourly Rate
|
|
|
SP:MULTIR4
|
P
|
8.2
|
Multiple Hourly Rate
|
|
|
SP:INJYCODE
|
A
|
1
|
Injury / Illness Code
|
|
|
SP:INJYDATE
|
DT
|
MDYY
|
Injury / Illness Date
|
|
|
SP:SCIFDATE
|
DT
|
MDYY
|
SCIF / IDL Date (Benefits Date)
|
|
|
SP:SEPREASN
|
A
|
2
|
Reason For Separation (Resignation)
|
|
|
SP:SEPXDATE
|
DT
|
MDYY
|
Separation Expiration Date (Payroll Return Date)
|
|
|
SP:LEGREFAN
|
A
|
7
|
Legal Reference for Annuitant
|
|
|
SP:LEVRETIR
|
A
|
4
|
Sick Leave At Retirement
|
|
|
SP:FINALANNI
|
A
|
6
|
Final Salary Anniversary Date
|
|
|
SP:MSACNT
|
A
|
1
|
SSI Counter
|
|
|
SP:VISA
|
A
|
1
|
Noncitizen Immigration/Visa Status
|
|
|
SP:STEP
|
A
|
2
|
Salary Step
|
|
|
SP:DEGLEV
|
A
|
1
|
Degree, Education Level Code
|
|
|
SP:SCHOOLCD
|
A
|
2
|
School Code
|
|
|
SP:WORKLOC
|
A
|
8
|
Work Location
|
|
|
SP:EMPDATE
|
DT
|
MDYY
|
Employment Date
|
|
|
SP:EMPMTHS
|
I
|
6
|
Months Employed
|
|
|
SP:ASSNSAL
|
P
|
12.2
|
Assigned Salary Rate
|
|
|
SP:DEGINST
|
A
|
6
|
Degree, Institute Code
|
|
|
SP:HIGHDEG
|
A
|
4
|
Degree, Highest Degree Date
|
|
|
SP:MGMTDATA1
|
A
|
6
|
Management Data Element #1
|
|
|
SP:MGMTDATA2
|
A
|
6
|
Management Data Element #2
|
|
|
SP:RELOCCD
|
A
|
2
|
Recruitment Location, Type of School
|
|
|
SP:RECFICE
|
A
|
6
|
Recruitment Location, FICE Code
|
|
|
SP:REDCIRC
|
P
|
12.2
|
Red Circle Rate (Plus Salary)
|
|
|
SP:DURAPPT
|
A
|
2
|
Duration Of Appointment Code
|
|
|
SP:RANGE
|
A
|
1
|
Range Code
|
|
|
SP:SABBELIG
|
A
|
6
|
Sabbatical Leave Eligibility Date
|
|
|
SP:SPECPAY
|
P
|
9.2
|
Special Pay, Amount Due
|
|
|
SP:TERMLOC
|
A
|
2
|
Termination Destination, Location
|
|
|
SP:TERMFICE
|
A
|
6
|
Termination Destination, FICE Code
|
|
|
SP:MGMTDATA3
|
A
|
6
|
Management Data Element #3
|
|
|
SP:LASTWORK
|
DT
|
MDYY
|
Last Day Physically Worked
|
|
|
SP:DTTRANCD
|
A
|
2
|
Detail Transaction Code
|
|
|
SP:FSALETTR
|
A
|
4
|
HR Letter
|
|
|
SP:JOBCODE
|
A
|
4
|
Job Code
|
|
|
SP:ACCNTCD
|
A
|
2
|
Retirement System Account Code
|
|
|
SP:CLASSRNG
|
A
|
5
|
Class and Range Key
|
|
|
SP:ELIGSUB
|
A
|
2
|
Eligibility Substantiation (Furlough Code)
|
|
|
SP:FTE3
|
P
|
9.3
|
Full-Time Equivalent 3 Decimal Places
|
Last Updated: May 19, 2011