Unemployment Insurance Costs Master File Description

Contains unemployment insurance cost data back to the first quarter of 1982. Users are restricted to only their campus.

Update Schedule: Quarterly. Updated mid-month each January, April, August and October.

Files Automatically Joined: Agency/Campus/Fund File, Employee Category, Collective Bargaining Id
Sample FOCUS Request: UI9293

Segment Name = EMP, Segment Type = S1

Defined	Field Name	Format Type	Format Length	Data Element Description
	UI:SSA	A	11	Social Security Number
	UI:SSAFOUR	A	4	Social Security Number, Last 4 Digits
	UI:SSAMASK	A	11	Social Security Number, Masked
	UI:LASTNAME	A	21	Name, Last
	UI:FRSTNAME	A	16	Name, First
	UI:WNAME	A	39	Name, Whole
	UI:DAO	A	8	Data as of Date

Segment Name = PSN, Parent = EMP, Segment Type = S1

Defined	Fieldname	Format Type	Format Length	Data Element Description
	UI:PSNSEQ	A	2	Position Sequence Number
	UI:SSAPSN	A	11	SSA / Position Sequence Key
	UI:AGENCY	A	3	Agency Code
	UI:UNIT	A	3	Reporting Unit
	UI:CLASS	A	4	Class Code
	UI:SERIAL	A	3	Serial Number
	UI:POSIT16	A	16	Position Number
	UI:POSITION	A	13	Position
	UI:AGYUNIT	A	6	Agency and Unit Key
	UI:EFFDATE	DT	MDYY	Effective Date
	UI:EFFYYYY	DT	YY	Effective Year
	UI:EFFMM	DT	M	Effective Month
	UI:EFFDD	DT	D	Effective Day
	UI:EFFYMD	DT	YYMD	Effective Date
	UI:EMPDATE	DT	MDYY	Employment Date
	UI:EMPCATG	A	1	Employee Category
	UI:PROBTEN	A	12	Probationary Period/Tenure Track
	UI:TRANCODE	A	3	Transaction Code, Personnel
	UI:TRANNAME	A	35	Transaction Code Name
	UI:TRANTYPE	A	24	Transaction Code Type
	UI:SEPREASN	A	2	Reason For Separation (Resignation)
	UI:CBID	A	3	Collective Bargaining Id, Code

Segment Name = QTR, Parent = PSN, Segment Type = S1

Segment Name = TRANS, Parent = QTR, Segment Type = S1

Last Updated: January 3, 2006