Systemwide Transaction Data Master File Description

This file contains selected fields for transactions on the EHDB from 1976 through the prior work day for the CSU system. All transactions are included with the exception of voids, deletes, fixes, eliminates, EAR, retirement system (R02) and student assistant/bridge student transactions. Confidential data (i.e., SSA, name, address) is excluded. This file would be used to obtain systemwide statistical information regarding transactions.

File Name: STR

Update Schedule: Daily. Updated after close of business each weekday.

Files Automatically Joined: None
Pre-programmed Join: JSTRPSAG, JSTRPSG1

Sample FOCUS Request: FOC1000

Segment Name = TRAN, Segment Type = S0

Defined	Fieldname	Format Type	Format Length	Data Element Description
	STR:CAMPALL	A	16	All Campuses
	STR:RETFLAG	A	1	Retire Flag
	STR:STATUS	A	1	Employee Status Code
	STR:LSTUPD	P	7	Last Update
	STR:SEX	A	1	Sex Code
	STR:ETHNIC	A	1	Ethnic Origin
	STR:ETHNICGRP*	A	3	Ethnic Group
	STR:TRNCNT	P	4	Transaction Count

*This defined field retrieves data (SSTR:EFFDATE) from the lower segment.

Segment Name = HSTPSN, Parent = TRAN, Segment Type = S1

Defined	Fieldname	Format Type	Format Length	Data Element Description
	STR:LISTCNT	P	4	List Count
	STR:PSNSEQ	A	2	Position Sequence Number
	STR:CBID	A	3	Collective Bargaining Id, Code
	STR:TRANCODE	A	3	Transaction Code, Personnel
	STR:TRANNAME	A	35	Transaction Code Name
	STR:TRANTYPE	A	24	Transaction Code Type
	STR:DURAPPT	A	2	Duration Of Appointment Code
	STR:PROBCODE	A	1	Probationary Period Code
	STR:PROBGROUP	A	12	Probationary Period Group
	STR:PERMSTAT	I	5	Status, Permanent
	STR:PROBSTAT	I	5	Status, Probationary
	STR:TEMPSTAT	I	5	Status, Temporary
	STR:NOPROB	I	5	Status, No Probation
	STR:TIMEBASE	A	6	Time Base
	STR:NUMBER	I	3	Time Base, Numerator
	STR:DENOM	I	3	Time Base, Denominator
	STR:FTE	P	11.5	Full-Time Equivalent
	STR:RETIRED	A	1	Retired Status
	STR:EFFYMD	DT	YYMD	Effective Date (YYYYMMDD)
	STR:EFFMM	DT	M	Effective Month
	STR:EFFDD	DT	D	Effective Day
	STR:EFFYYYY	DT	YY	Effective Year
	STR:EFFDATE	DT	MDYY	Effective Date (MMDDYYYY)
	STR:DTTRANCD	A	2	Detail Transaction Code
	STR:SEPCODE	A	1	Separation Code
	STR:AGENCY	A	3	Agency Code
	STR:UNIT	A	3	Reporting Unit
	STR:CLASS	A	4	Class Code
	STR:SERIAL	A	3	Serial Number
	STR:POSITION	A	13	Position
	STR:POSIT16	A	16	Position Number
	STR:RANGE	A	1	Range Code
	STR:CLASSRNG	A	5	Class and Range Key
	STR:STEP	A	2	Salary Step
	STR:BASEPAY	P	8.2M	Base Pay
	STR:SALARY	P	8.2M	Salary Total
	STR:REDCIRC	P	8.2	Red Circle Rate (Plus Salary)
	STR:APPTXDTE	DT	MDYY	Appointment Expiration Date
	STR:ANNIDATE	A	6	Anniversary Date
	STR:CAMPX	A	1	Campus Alpha Code
	STR:CAMPUSCD	A	2	Campus Numeric Code
	STR:FTE3	P	9.3	Full-Time Equivalent 3 Decimal Places
	STR:CAMPUS	A	10	Campus Name, Abbreviated

Last Updated: July 13, 2011