Systemwide Annual Current Status Master File Description

This file contains a snapshot of current employment history transactions for active and on-leave faculty, staff and management staff positions in the CSU system as of close of business March and October. Data is available for a given year back to 1984 for October snap shots and 2005 for March snap shots. The reporting period of 10/31 represents the most statistically valid CSU employee population.  This file does not include students (class codes: 0100, 1870, 1871, 1872, 1874, 1875, 1876 and 1868), special pay appointments (transaction A54), disability retirements (transaction S71) or layoffs (transaction S30). Confidential data is excluded (i.e., SSA name, address, remarks). This file should be used for all types of statistical reports.

 

  • File Name:  SAN

  • Update Schedule:  Annual. Updated at close of business March and October for each year.

  • Files Automatically Joined:  None

  • Pre-programmed Joins:  JSANPS, JSANPS1

 


Segment Name = ACTIVE, Segment Type = S0

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

  •  

SAN:BRTHDATE

DT

MDYY

Birthdate

  •  

SAN:AGE

I

6

Age

 

SAN:SEX

A

1

Sex Code

 

SAN:ETHNIC

A

1

Ethnic Origin

  •  

SAN:ETHNICGRP

A

3

Ethnic Group

 

SAN:DISAB

A

1

Disability Status Code

 

SAN:DAO

DT

MDYY

Data as of Date

 

 

Segment Name = ACTPSN, Parent = ACTIVE, Segment Type = S1

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

 

SAN:PSNSEQ

A

2

Position Sequence Number

 

SAN:AGYUNIT

A

6

Agency and Unit Key

 

SAN:SEPCODE

A

1

Separation Code

 

SAN:CAMPUSCD

A

2

Campus Numeric Code

 

SAN:CAMPUS

A

10

Campus Name Abbreviated

 

SAN:CBID

A

3

Collective Bargaining Id, Code

 

SAN:TRANCODE

A

3

Transaction Code, Personnel

  •  

SAN:TRANNAME

A

35

Transaction Code Name

  •  

SAN:TRANTYPE

A

24

Transaction Code Type

  •  

SAN:EFFDATE

DT

MDYY

Effective Date (MMDDYYYY)

  •  

SAN:EFFYYYY

DT

YY

Effective Year

  •  

SAN:EFFMM

DT

M

Effective Month

  •  

SAN:EFFDD

DT

D

Effective Day

  •  

SAN:EFFYMD

DT

YYMD

Effective Date (YYYYMMDD)

 

SAN:AGENCY

A

3

Agency Code

 

SAN:UNIT

A

3

Reporting Unit

 

SAN:CLASS

A

4

Class Code

 

SAN:SERIAL

A

3

Serial Number

  •  

SAN:POSIT16

A

16

Position Number

  •  

SAN:POSITION

A

13

Position

 

SAN:DEPT

A

3

Department Code

 

SAN:APPTTYPE

A

1

Appointment Type (Leave Code)

  •  

SAN:SALARY

P

12.2

Salary Total

 

SAN:SALPER

A

1

Salary Per

  •  

SAN:BASEPAY

P

12.2

Base Pay

 

SAN:ANNIDATE

A

6

Anniversary Date

 

SAN:TIMEBASE

A

6

Time Base

  •  

SAN:NUMER

I

3

Time Base, Numerator

  •  

SAN:DENOM

I

3

Time Base, Denominator

  •  

SAN:FTE

P

11.5

Full-Time Equivalent

  •  

SAN:PTTOT

P

7

Part-Time Total

  •  

SAN:FTTOT

P

7

Full-Time Total

  •  

SAN:APPTXDTE

DT

MDYY

Appointment Expiration Date

 

SAN:PROBCODE

A

1

Probationary Period Code

 

SAN:PROBDATE

A

8MDYY

Probationary Period Ending Date

  •  

SAN:PROBGROUP

A

12

Probationary Period Group

  •  

SAN:TEMPSTAT

I

5

Status, Temporary

  •  

SAN:PERMSTAT

I

5

Status, Permanent

  •  

SAN:PROBSTAT

I

5

Status, Probationary

  •  

SAN:NOPROB

I

5

Status, No Probation

 

SAN:SAFETY

A

3

Safety Member

 

SAN:SURVIVOR

A

3

Survivors Benefits

 

SAN:SSMED

A

3

Social Security/Medicare Member

 

SAN:LICTYPE

A

1

Professional License Type

 

SAN:LICDATE

A

8MDYY

Professional License, Expiration Date

  •  

SAN:MULTIR1

P

8.2

Multiple Hourly Rate 1

  •  

SAN:MULTIR2

P

8.2

Multiple Hourly Rate 2

  •  

SAN:MULTIR3

P

8.2

Multiple Hourly Rate 3

  •  

SAN:MULTIR4

P

8.2

Multiple Hourly Rate 4

 

SAN:INJYCODE

A

1

Injury/Illness Code

  •  

SAN:INJYDATE

DT

MDYY

Injury/Illness Date

  •  

SAN:SCIFDATE

DT

MDYY

SCIF/IDL Date (Benefits Date)

  •  

SAN:SEPXDATE

DT

MDYY

Separation Expiration Date (Payroll Return Date)

 

SAN:LEGREFAN

A

7

Legal Reference for Annuitant

 

SAN:FINALANNI

A

6

Final Salary Anniversary Date

 

SAN:MSACNT

A

1

SSI Counter

 

SAN:VISA

A

1

Noncitizen Immigration/Visa Status

 

SAN:STEP

A

2

Salary Step

 

SAN:DEGLEV

A

1

Degree, Education Level Code

 

SAN:SCHOOLCD

A

2

School Code

 

SAN:WORKLOC

A

8

Work Location

  •  

SAN:EMPMTHS

I

6

Employment Months

  •  

SAN:EMPYRS

I

6

Employment Years

  •  

SAN:EMPDATE

DT

MDYY

Employment Date

  •  

SAN:ASSNSAL

P

12.2

Assigned Salary Rate

 

SAN:DEGINST

A

6

Degree, Institute Code

 

SAN:HIGHDEG

A

4

Degree, Highest Degree Date

 

SAN:MGMTDATA1

A

6

Management Data Element #1

 

SAN:RELOCCD

A

2

Recruitment Location, Type of School

 

SAN:MGMTDATA2

A

6

Management Data Element #2

 

SAN:RECFICE

A

6

Recruitment Location, FICE Code

  •  

SAN:REDCIRC

P

12.2

Red Circle Rate (Plus Salary)

 

SAN:DURAPPT

A

2

Duration Of Appointment Code

 

SAN:RANGE

A

1

Range Code

 

SAN:SABBELIG

A

6

Sabbatical Leave Eligibility Date

 

SAN:MGMTDATA3

A

6

Management Data Element #3

  •  

SAN:LASTWORK

DT

MDYY

Last Day Physically Worked

 

SAN:DTTRANCD

A

2

Detail Transaction Code

 

SAN:FSALETTR

A

4

HR Letter

 

SAN:JOBCODE

A

4

Job Code

 

SAN:ACCNTCD

A

2

Retirement System Account Code

 

SAN:CLASSRNG

A

5

Class and Range Key

 

SAN:ELIGSUB

A

2

Eligibility Substantiation (Furlough Code)

  •  

SAN:FTE3

P

9.3

Full-Time Equivalent 3 Decimal Places

 

 

 

Last Updated:  May 19, 2011