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