Separated Current Status Master File Description

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.

 

  • File Name:  SP

  • Update Schedule:  Monthly. Updated at the close of the calendar month and available on the 2nd workday of the new calendar month.

 


Segment Name = SEPS, Segment Type = S1

Defined

Field Name

 Format
Type

 Format
Length

 Data Element Description

  •  

SP:SSA

A

11

Social Security Number

  •  

SP:SSAFOUR

A

4

Social Security Number, Last 4 Digits

  •  

SP:SSAMASK

A

11

Social Security Number, Masked

 

SP:LASTNAME

A

21

Name, Last

 

SP:FRSTNAME

A

16

Name, First

  •  

SP:WNAME

A

39

Name, Full

  •  

SP:BRTHDATE

DT

MDYY

Birthdate

  •  

SP:AGE

I

6

Age

 

SP:SEX

A

1

Sex Code

 

SP:ETHNIC

A

1

Ethnic Origin

  •  

SP:ETHNICGRP*

A

3

Ethnic Group

 

SP:STREET

A

28

Employee Address, Street

 

SP:CTYST

A

25

Employee Address, City and State

 

SP:ZIP

A

5

Employee Address, Zip Code

  •  

SP:DISAB

A

1

Disability Status Code

 

SP:DISABLE

A

3

Disability Status

  •  

SP:DISAFACT

A

2

Disability Status Factors

 

SP:ADDRWH

A

1

Address Withheld Indicator

  •  

SP:DAO

DT

MDYY

Data as of Date

*This defined field retrieves data (SP:EFFDATE) from the lower segment.

 

Segment Name = SPPSNS, Parent = SEPS, Segment Type = S1

Defined

Fieldname

 Format
Type

 Format
Length

 Data Element Description

 

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