Active Current Status Master File Description

This file contains a snapshot of current employment history transactions for active and on-leave positions at your campus for management, faculty, and staff.  This file does not include separated positions, student data (class codes 0100, 1870, 1871, 1872, 1874, 1875, 1876 and 1868), special pay appointments (transaction A54), disability retirements (transaction S71) or layoffs (transaction S30).  For additional information, refer to the topic: Tips For Using The Active Current Status File.


Segment Name = ACTIVE, Segment Type = S1

Defined

Fieldname

Form​at
Type

Format
Length

Data Element Description

  •  

AC:SSA

A

11

Social Security Number

  •  

AC:SSAFOUR

A

4

Social Security Number, Last 4 Digits

  •  

AC:SSAMASK

A

11

Social Security Number, Masked

 

AC:LASTNAME

A

21

Name, Last

 

AC:FRSTNAME

A

16

Name, First

  •  

AC:WNAME

A

39

Name, Whole

  •  

AC:BRTHDATE

DT

MDYY

Birthdate

  •  

AC:AGE

I

6

Age

 

AC:SEX

A

1

Sex Code

 

AC:ETHNIC

A

1

Ethnic Origin

  •  

AC:ETHNICGRP

A

3

Ethnic Group

 

AC:STREET

A

28

Employee Address, Street

 

AC:CTYST

A

25

Employee Address, City and State

 

AC:ZIP

A

5

Employee Address, Zip Code

 

AC:DISABLE

A

3

Disability Status

  •  

AC:DISAB

A

1

Disability Status Code

 

AC:DISFACT

A

2

Disability Status Factors

 

AC:ADDRWH

A

1

Address Withheld Indicator

 

AC:DAO

DT

MDYY

Data as of Date

 

 

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

Defined

Fieldname

Format
Type

Format
Length

Data Element Description

 

AC:PSNSEQ

A

2

Position Sequence Number

 

AC:SSAPSN

A

11

SSA / Position Sequence Key

 

AC:DOCT

A

4

Document Processing Number

 

AC:AGYUNIT

A

6

Agency and Unit Key

 

AC:SEPCODE

A

1

Separation Code

 

AC:CAMPUSCD

A

2

Campus Numeric Code

 

AC:CAMPUS

A

10

Campus Name Abbreviated

 

AC:CBID

A

3

Collective Bargaining Id, code

 

AC:TRANCODE

A

3

Transaction Code, Personnel

  •  

AC:TRANNAME

A

35

Transaction Code, Name

  •  

AC:TRANTYPE

A

24

Transaction Code, Type

 

AC:EFFDATE

DT

MDYY

Effective Date

  •  

AC:EFFYYYY

DT

YY

Effective Year

  •  

AC:EFFMM

DT

M

Effective Month

  •  

AC:EFFDD

DT

D

Effective Day

  •  

AC:EFFYMD

DT

YYMD

Effective Date

 

AC:AGENCY

A

3

Agency Code

 

AC:UNIT

A

3

Reporting Unit

 

AC:CLASS

A

4

Class Code

 

AC:SERIAL

A

3

Serial Number

  •  

AC:POSIT16

A

16

Position Number

  •  

AC:POSITION

A

13

Position

 

AC:DEPT

A

3

Department Code

 

AC:APPTTYPE

A

1

Appointment Type (Leave Code)

 

AC:REMARKS

A

20

Employment History Remarks

  •  

AC:SALARY

P

12.2

Salary Total

 

AC:SALPER

A

1

Salary Per

  •  

AC:BASEPAY

P

12.2

Base Pay

 

AC:ANNIDATE

A

6

Anniversary Date

 

AC:TIMEBASE

A

6

Time Base

  •  

AC:NUMER

I

3

Time Base, Numerator

  •  

AC:DENOM

I

3

Time Base, Denominator

  •  

AC:FTE

P

11.5

Full-Time Equivalent

  •  

AC:PTTOT

P

7

Part-Time Total

  •  

AC:FTTOT

P

7

Full-Time Total

  •  

AC:APPTXDTE

DT

MDYY

Appointment Expiration Date

 

AC:PROBCODE

A

1

Probationary Period Code

 

AC:PROBDATE

A

8MDYY

Probationary Period Ending Date

  •  

AC:PROBGROUP

A

12

Probationary Period Group

  •  

AC:TEMPSTAT

I

5

Status, Temporary

  •  

AC:PERMSTAT

I

5

Status, Permanent

  •  

AC:PROBSTAT

I

5

Status, Probationary

  •  

AC:NOPROB

I

5

Status, No Probation

 

AC:SAFETY

A

3

Safety Member

 

AC:SURVIVOR

A

3

Survivors Benefits

 

AC:SSMED

A

3

Social Security/Medicare Member

 

AC:LICTYPE

A

1

Professional License Type

 

AC:LICDATE

A

8MDYY

Professional License, Expiration Date

  •  

AC:MULTIR1

P

8.2

Multiple Hourly Rate 1

  •  

AC:MULTIR2

P

8.2

Multiple Hourly Rate 2

  •  

AC:MULTIR3

P

8.2

Multiple Hourly Rate 3

  •  

AC:MULTIR4

P

8.2

Multiple Hourly Rate 4

 

AC:INJYCODE

A

1

Injury / Illness Code

  •  

AC:INJYDATE

DT

MDYY

Injury / Illness Date

  •  

AC:SCIFDATE

DT

MDYY

SCIF / IDL Date (Benefits Date)

  •  

AC:SEPXDATE

DT

MDYY

Separation Expiration Date (Payroll Return Date)

 

AC:LEGREFAN

A

7

Legal Reference for Annuitant

 

AC:FINALANNI

A

6

Final Salary Anniversary Date

 

AC:MSACNT

A

1

SSI Counter

 

AC:NONCITZN

A

10

Noncitizen Status Code

  •  

AC:VISA

A

1

Noncitizen Immigration/Visa Category

  •  

AC:COUNTRY

A

2

Noncitizen Tax Treaty Country Code

  •  

AC:RESIDENT

A

1

Noncitizen tax Residency Status

  •  

AC:WAED

A

6

Noncitizen Work Authorization Exp. Date

 

AC:STEP

A

2

Salary Step

 

AC:DEGLEV

A

1

Degree, Education Level Code

 

AC:SCHOOLCD

A

2

School Code

 

AC:WORKLOC

A

8

Work Location

  •  

AC:EMPDATE

DT

MDYY

Employment Date

  •  

AC:EMPMTHS

I

6

Employment Months

  •  

AC:EMPYRS

I

6

Employment Years

  •  

AC:ASSNSAL

P

12.2

Assigned Salary Rate

 

AC:DEGINST

A

6

Degree, Institute Code

 

AC:HIGHDEG

A

4

Degree, Highest Degree Date

 

AC:MGMTDATA1

A

6

Management Data Element #1

 

AC:MGMTDATA2

A

6

Management Data Element #2

 

AC:RELOCCD

A

2

Recruitment Location, Type of School

 

AC:RECFICE

A

6

Recruitment Location, FICE Code

  •  

AC:REDCIRC

P

12.2

Red Circle Rate (Plus Salary)

 

AC:DURAPPT

A

2

Duration Of Appointment Code

 

AC:RANGE

A

1

Range Code

 

AC:SABBELIG

A

6

Sabbatical Leave Eligibility Date

 

AC:MGMTDATA3

A

4

Management Data Element #3

  •  

AC:LASTWORK

DT

MDYY

Last Day Physically Worked

 

AC:DTTRANCD

A

2

Detail Transaction Code

 

AC:FSALETTR

A

4

HR Letter

 

AC:JOBCODE

A

4

Job Code

 

AC:ACCNTCD

A

2

Retirement System Account Code

 

AC:CLASSRNG

A

5

Class and Range Key

 

AC:ELIGSUB

A

2

eligibility Substantiation (Furlough Code)

  •  

AC:FTE3

P

9.3

Full-Time Equivalent 3 Decimal Places

 

 

Last Updated: May 19, 2011