Systemwide Pay Scales Master File Description

This a FOCUS database file that contains all current information pertaining to active and abolished classes. No historical information is available. A production format of this file is available for downloading. Refer to the Pay Scales Production file for a description and instructions.

File Name: PS

Update Schedule: N/A. Updated as needed per collective bargaining.

Files Automatically Joined: None
Pre-programmed Joins: JACPS, JACPS1, JANPS, JANPS1, JEHPSAG, JLBPS, JLXPS, JPHPSAG, JSACPS, JSACPS1, JSANPS, JSANPS1, JSPPS, JSPPS1, JSTRPSAG, JTRPSAG

Files Automatically Joined: Employee Category, Collective Bargaining Id, Occupational Index

Sample FOCUS Request: FOC1010

Segment Name = PAYSC, Segment Type = S1

Defined	Field Name	Format Type	Format Length	Data Element Description
	PS:CLASSRNG	A	5	Class and Range Key
	PS:CLASS	A	4	Class Code
	PS:RANGE	A	1	Range Code
	PS:EFFDATE	DT	MDYY	Effective Date (MMDDYYYY)
	PS:EFFYYYY	DT	YY	Effective Year
	PS:EFFMM	DT	M	Effective Month
	PS:EFFDD	DT	D	Effective Day
	PS:EFFYMD	DT	YYMD	Effective Date (YYYYMMDD)
	PS:ESTDATE	DT	YYMD	Class Established Date
	PS:CLSSTATUS	A	1	Class Code Status
	PS:PAYLETTR	A	4	Pay Letter Number
	PS:TITLEA	A	13	Class Title, Abbreviated
	PS:TITLE	A	61	Class Title, Full
	PS:TITLER	A	19	Range Title
	PS:FTNOTE	A	2	Footnote / Trade Rate Code
	PS:FLSA	A	4	Fair Labor Standards Act Status
	PS:PRMOT	A	1	Premium Overtime
	PS:SISA	A	1	Six Month Increase (SISA)
	PS:SHIFTDIF	A	1	Shift Differential
	PS:OCINDEXR	A	2	Occupational Index Reference
	PS:JOBFAM	A	1	Job Family, AA
	PS:JOBGRP	A	2	Job Group, AA
	PS:JOBFAMNA	A	40	Job Family Name
	PS:AFFCODE	A	3	Affirmative Action Code
	PS:EMPCATG	A	1	Employee Category
	PS:PROBTEN	A	12	Probationary Period/Tenure Track
	PS:VACACCRU	A	1	Vacation Rate Code
	PS:LICTYPE	A	1	Professional License Type
	PS:MPPAGL	A	1	MPP AGL Indicator
	PS:BUDCODE	A	2	Budget Occupational Code
	PS:SALPER	A	1	Salary Per
	PS:RCLS	A	20	Reallocation Class Code
	PS:CAMPUSCD	A	2	Campus Code
	PS:SUSPNCD	A	1	Suspended Class Code
	PS:STEPMAX	A	2	Step Maximum
	PS:STEPMIN	A	2	Step Minimum
	PS:ACADMYR	A	1	Academic Year Class
	PS:DTLSTCHG	DT	MDYY	Record Changed Date
	PS:TSTEPFLG	A	1	T-Step Flag
	PS:FACTOR	I	2	Computational Factor, Annual
	PS:CBID	A	3	Collective Bargaining Id. Code
	PS:PAYPLAN	A	1	Pay Plan Indicator
	PS:BASECLAS	A	4	Base Class
	PS:BASERNG	A	1	Base Range
	PS:BASCLSRG	A	5	Base Class And Range
	PS:GSIAMT	P	8.3	GSI Amount #1
	PS:GSIAMT2	P	8.3	GSI Amount #2
	PS:SSICOUNT	A	2	SSI Maximum Counter
	PS:SALPLAN	A	3	Salary Plan
	PS:SSIAMT	P	8.3	SSI Amount
	PS:RECTYPE	A	1	Record Type

Segment Name = STEPRATE, Parent = PAYSC, Segment Type = S1

Note: The following fields are valid for Record Type C only.

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PS:CTYPE	A	1	Type Field, C-Step Rates
	PS:NSTEPS	A	2	Number Of Steps
	PS:ST1	P	12.2	Step 1 Rate - Step 45 Rate
	PS:ST2	P	12.2	Step 2
	PS:ST3	P	12.2	Step 3
	PS:ST4	P	12.2	Step 4
	PS:ST5	P	12.2	Step 5
	PS:ST6	P	12.2	Step 6
	PS:ST7	P	12.2	Step 7
	PS:ST8	P	12.2	Step 8
	PS:ST9	P	12.2	Step 9
	PS:ST10	P	12.2	Step 10
	PS:ST11	P	12.2	Step 11
	PS:ST12	P	12.2	Step 12
	PS:ST13	P	12.2	Step 13
	PS:ST14	P	12.2	Step 14
	PS:ST15	P	12.2	Step 15
	PS:ST16	P	12.2	Step 16
	PS:ST17	P	12.2	Step 17
	PS:ST18	P	12.2	Step 18
	PS:ST19	P	12.2	Step 19
	PS:ST20	P	12.2	Step 20
	PS:ST21	P	12.2	Step 21
	PS:ST22	P	12.2	Step 22
	PS:ST23	P	12.2	Step 24
	PS:ST24	P	12.2	Step 24
	PS:ST25	P	12.2	Step 25
	PS:ST26	P	12.2	Step 26
	PS:ST27	P	12.2	Step 27
	PS:ST28	P	12.2	Step 28
	PS:ST29	P	12.2	Step 29
	PS:ST30	P	12.2	Step 30
	PS:ST31	P	12.2	Step 31
	PS:ST32	P	12.2	Step 32
	PS:ST33	P	12.2	Step 33
	PS:ST34	P	12.2	Step 34
	PS:ST35	P	12.2	Step 35
	PS:ST36	P	12.2	Step 36
	PS:ST37	P	12.2	Step 37
	PS:ST38	P	12.2	Step 38
	PS:ST39	P	12.2	Step 39
	PS:ST40	P	12.2	Step 40
	PS:ST41	P	12.2	Step 41
	PS:ST42	P	12.2	Step 42
	PS:ST43	P	12.2	Step 43
	PS:ST44	P	12.2	Step 44
	PS:ST45	P	12.2	Step 45
	PS:ADVSTEP	A	2	Number Of Steps To Advance
	PS:SSIMAXST	A	2	SSI Maximum Step

Segment Name = ANUALSAL, Parent = PAYSC, Segment = S1

Note: The following fields are valid for Record Type D only.

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PS:DTYPE	A	1	Type Field, D - Annual Salary
	PS:ANNUALRTE	P	12.2	Annual Salary Rate

Segment Name = EXTEN, Parent = PAYSC, Segment = S1

Note: The following fields are valid for Record Type E only.

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PS:ETYPE	A	1	Type Field, E - Extension Faculty
	PS:MAXSEM	P	10.2	Extension Faculty Semester Rate, Maximum
	PS:MAXQTR	P	10.2	Extension Faculty Quarter Rate, Maximum
	PS:RNGBSEM	P	10.2	Semester Rate, Range B
	PS:RNGBQTR	P	10.2	Quarter Rate, Range B
	PS:RNGCSEM	P	10.2	Semester Rate, Range C
	PS:RNGCQTR	P	10.2	Quarter Rate, Range C
	PS:EXTHOUR	P	10.2	Extension Faculty Hourly Rate
	PS:EXTMAXG	P	10.2	Extension Faculty Maximum Rate, Range G

Segment Name = MINMAX, Parent = PAYSC Segment Type = S1

Note: The following fields are valid for Record Type F only.

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PS:FTYPE	A	1	Type Field, F - Special Variable Rate
	PS:MIN	P	10.2	Minimum Rate
	PS:MAX	P	10.2	Maximum Rate
	PS:SSI	P	10.2	SSI Rate

Segment Name = SUB, Parent = PAYSC, Segment Type = S1

Note: The following fields are valid for Record Type G only.

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PS:GTYPE	A	1	Type Field, G - Substitute Faculty
	PS:LECTURE	P	10.2	Lecture Hourly Rate
	PS:LABRATE	P	10.2	Laboratory / Activity Hourly Rate

Segment Name = SUMMER, Parent = PAYSC Segment Type = S1

Note: The following fields are valid for Record Type H only.

Defined	Fieldname	Format Type	Format Length	Data Element Description
	PS:HTYPE	A	1	Type Field, H - Summer Session Faculty
	PS:SUMASEM	P	10.2	Summer Semester Rate, Range A
	PS:SUMAQTR	P	10.2	Summer Quarter Rate, Range A
	PS:SUMBSEM	P	10.2	Summer Semester Rate, Range B
	PS:SUMBQTR	P	10.2	Summer Quarter Rate, Range B
	PS:SUMCMIN	P	10.2	Summer Minimum, Rate Range C
	PS:SUMCMAX	P	10.2	Summer Maximum Rate, Range C

Last Updated: March 1, 2004