Systemwide Active Current Status Master File Description

This file contains a snapshot of current employment history transactions for all active and onleave faculty, staff and management positions within the CSU system.  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 would be used for systemwide statistical reporting.  

 

  • File Name:  SAC

  • Update Schedule:  Weekly. Data as of close of business on Friday, available on Monday.

 


Segment Name = Active, Segment Type = S0

Defined

Fieldname

 Format
Type

Format
Length

Data Element Description

  •  

SAC:BRTHDATE

DT

MDYY

Birthdate

  •  

SAC:AGE

I

6

Age

 

SAC:SEX

A

1

Sex Code

 

SAC:ETHNIC

A

1

Ethnic Origin

 

SAC:ETHNICGRP

A

3

Ethnic Group

 

SAC:DISABLE

A

3

Disability Status

  •  

SAC:DISAB

A

1

Disability Status Code

  •  

SAC:DISFACT

A

2

Disability Status Factors

  •  

SAC:DAO

DT

MDYY

Data as of Date

 

 

Segment Name = Actpsn, Parent = Active, Segment Type = S1

Defined

Fieldname

 Format
Type

Format
Length

Data Element Description

 

SAC:PSNSEQ

A

2

Position Sequence Number

 

SAC:AGYUNIT

A

6

Agency and Unit Key

 

SAC:SEPCODE

A

1

Separation Code

  •  

SAC:CAMPUSCD

A

2

Campus Numeric Code

 

SAC:CAMPUS

A

10

Campus Name Abbreviated

 

SAC:CBID

A

3

Collective Bargaining Id, Code

 

SAC:TRANCODE

A

3

Transaction Code, Personnel

  •  

SAC:TRANNAME

A

35

Transaction Code Name

  •  

SAC:TRANTYPE

A

24

Transaction Code Type

  •  

SAC:EFFDATE

DT

MDYY

Effective Date

  •  

SAC:EFFYYYY

DT

YY

Effective Year

  •  

SAC:EFFMM

DT

M

Effective Month

  •  

SAC:EFFDD

DT

D

Effective Day

  •  

SAC:EFFYMD

DT

YYMD

Effective Date

 

SAC:AGENCY

A

3

Agency Code

 

SAC:UNIT

A

3

Reporting Unit

 

SAC:CLASS

A

4

Class Code

 

SAC:SERIAL

A

3

Serial Number

  •  

SAC:POSIT16

A

16

Position Number

  •  

SAC:POSITION

A

13

Position

 

SAC:DEPT

A

3

Department Code

 

SAC:APPTTYPE

A

1

Appointment Type (Leave Code)

  •  

SAC:SALARY

P

12.2

Salary Total

 

SAC:SALPER

A

1

Salary Per

  •  

SAC:BASEPAY

P

12.2

Base Pay

 

SAC:ANNIDATE

A

6

Anniversary Date

 

SAC:TIMEBASE

A

6

Time Base

  •  

SAC:NUMER

I

3

Time Base, Numerator

  •  

SAC:DENOM

I

3

Time Base, Denominator

  •  

SAC:FTE

P

11.5

Full-Time Equivalent

  •  

SAC:PTTOT

P

7

Part-Time Total

  •  

SAC:FTTOT

P

7

Full-Time Total

  •  

SAC:APPTXDTE

DT

MDYY

Appointment Expiration Date

 

SAC:PROBCODE

A

1

Probationary Period Code

 

SAC:PROBDATE

A

8MDYY

Probationary Period Ending Date

  •  

SAC:PROBGROUP

A

12

Probationary Period Group

  •  

SAC:TEMPSTAT

I

5

Status, Temporary

  •  

SAC:PERMSTAT

I

5

Status, Permanent

  •  

SAC:PROBSTAT

I

5

Status, Probationary

  •  

SAC:NOPROB

I

5

Status, No Probation

 

SAC:SAFETY

A

3

Safety Member

 

SAC:SURVIVOR

A

3

Survivors Benefits

 

SAC:SSMED

A

3

Social Security/Medicare Member

 

SAC:LICTYPE

A

1

Professional License Type

 

SAC:LICDATE

A

8MDYY

Professional License, Expiration Date

  •  

SAC:MULTIR1

P

8.2

Multiple Hourly Rate

  •  

SAC:MULTIR2

P

8.2

Multiple Hourly Rate 2

  •  

SAC:MULTIR3

P

8.2

Multiple Hourly Rate 3

  •  

SAC:MULTIR4

P

8.2

Multiple Hourly Rate 4

 

SAC:INJYCODE

A

1

Injury / Illness Code

  •  

SAC:INJYDATE

DT

MDYY

Injury / Illness Date

  •  

SAC:SCIFDATE

DT

MDYY

SCIF / IDL Date (Benefits Date)

  •  

SAC:SEPXDATE

DT

MDYY

Separation Expiration Date (Payroll Return Date)

 

SAC:LEGREFAN

A

7

Legal Reference for Annuitant

 

SAC:FINALANNI

A

6

Final Salary Anniversary Date

 

SAC:NONCITZN

A

10

Noncitizen Status Code

  •  

SAC:VISA

A

1

Noncitizen Immigration/Visa Category

  •  

SAC:COUNTRY

A

2

Noncitizen Tax Treaty Country Code

  •  

SAC:RESIDENT

A

1

Noncitizen Tax Residency Status

  •  

SAC:WAED

A

6

Noncitizen Work Authorization Exp. Date

 

SAC:MSACNT

A

1

SSI Counter

 

SAC:STEP

A

2

Salary Step

 

SAC:DEGLEV

A

1

Degree, Education Level Code

 

SAC:SCHOOLCD

A

2

School Code

 

SAC:WORKLOC

A

8

Work Location

  •  

SAC:EMPDATE

DT

MDYY

Employment Date

  •  

SAC:EMPMTHS

I

6

Employment Months

  •  

SAC:EMPYRS

I

6

Employment Years

  •  

SAC:ASSNSAL

P

12.2

Assigned Salary Rate

 

SAC:DEGINST

A

6

Degree, Institute Code

 

SAC:HIGHDEG

A

4

Degree, Highest Degree Date

 

SAC:MGMTDATA1

A

6

Management Data Element #1

 

SAC:MGMTDATA2

A

6

Management Data Element #2

 

SAC:RELOCCD

A

2

Recruitment Location, Type of School

 

SAC:RECFICE

A

6

Recruitment Location, FICE Code

  •  

SAC:REDCIRC

P

12.2

Red Circle Rate (Plus Salary)

 

SAC:DURAPPT

A

2

Duration Of Appointment Code

 

SAC:RANGE

A

1

Range Code

 

SAC:SABBELIG

A

6

Sabbatical Leave Eligibility Date

 

SAC:MGMTDATA3

A

6

Management Data Element #3

  •  

SAC:LASTWORK

DT

MDYY

Last Day Physically Worked

 

SAC:DTTRANCD

A

2

Detail Transaction Code

 

SAC:FSALETTR

A

4

HR Letter

 

SAC:JOBCODE

A

4

Job Code

 

SAC:ACCNTCD

A

2

Retirement System Account Code

 

SAC:CLASSRNG

A

5

Class and Range Key

 

SAC:ELIGSUB

A

2

Eligibility Substantiation (Furlough Code)

  •  

SAC:FTE3

P

9.3

Full-Time Equivalent 3 Decimal Places

 

 

 

Last Updated: May 19, 2011