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, 1880, 1881, 1882, 1883, 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.

File Name: AC
Update Schedule: Weekly. Data as of close of business on Friday, available on Monday.
Files Automatically Joined: Agency/Campus/Fund, Budget Function, Degree Level, Department, Collective Bargaining Id, HEGIS, Job Code, School
Pre-programmed Joins: JACPS, JACPS1
Sample FOCUS Request: FOC1400B
See Also: Employment Data Files Comparison

Segment Name = ACTIVE, Segment Type = S1

Defined	Fieldname	Format 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