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.
Segment Name = ACTIVE, Segment Type = S0
Segment Name = ACTPSN, Parent = ACTIVE, Segment Type = S1
|
|
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