This file is a production format of the Systemwide Pay Scales (PS) file. Selecting this format will result in a file that mirrors the same format that exists within the Personnel and Payroll system. Note: Data in this file format can only be downloaded. It cannot be used to generate ad hoc reports in CIRS.
The file is available the day after pay scales changes are put into production. It can be used by campuses to download information to their campus mainframe or PC application immediately after an update, instead of waiting for that information on tape.
To download this file, go to OTHER on the main menu action bar and select 'Download Pay Scales File'. Select option 1 to submit a batch job to populate your PERMLRG file with the pay scales data. After confirming a successful execution (option 2), select option 3 to download your PERMLRG file.
The following is a COBOL file description of the data.
Segment Occurs = 1 time, Segment Size = 456
*01 CURRENT-PAYSCALES-RECORD.
03 CPS-PAY-SCALES-RECORD.
05 CPS-DELETE-BYTE PIC X.
05 CPS-PAYSCALES-KEY.
07 CPS-CLASS-TYPE-CSUC PIC X.
07 CPS-CLASS-CODE PIC 9999.
07 CPS-RANGE PIC X.
07 CPS-CLASS-ACTION-EFFECT-DATE-X.
09 CPS-CLASS-ACTION-EFFECT-DATE PIC 9(8).
09 RDF 09 FILLER
REDEFINES CPS-CLASS-ACTION-EFFECT-DATE.
11 CPS-CLASS-ACTION-EFF-CC PIC 99.
11 CPS-CLASS-ACTION-EFF-YY PIC 99.
11 CPS-CLASS-ACTION-EFF-MM PIC 99.
11 CPS-CLASS-ACTION-EFF-DD PIC 99.
05 CPS-DATA.
07 CPS-CLASS-ESTABLISH-DATE-X.
09 CPS-CLASS-ESTABLISH-DATE PIC 9(8).
09 RDF 09 FILLER
REDEFINES CPS-CLASS-ESTABLISH-DATE.
11 CPS-CLASS-EST-CC PIC 99.
11 CPS-CLASS-EST-YY PIC 99.
11 CPS-CLASS-EST-MM PIC 99.
11 CPS-CLASS-EST-DD PIC 99.
07 CPS-CLASS-STATUS PIC X.
07 CPS-PAY-LETTER-NO PIC 9999.
07 RDF 07 FILLER
REDEFINES CPS-PAY-LETTER-NO.
09 CPS-PAY-LETTER-NO-1-2 PIC 99.
09 CPS-PAY-LETTER-NO-3-4 PIC 99.
07 CPS-ABBR-CLASS-TITLE-CSUC PIC X(13).
07 CPS-FULL-CLASS-TITLE.
09 CPS-CLASS-TITLE PIC X(61).
09 CPS-RANGE-TITLE PIC X(19).
07 CPS-PAY-SCALE-FOOTNOTES PIC XX.
* SEE RECORD-TYPE 88 LEVEL FOR VALUE 'B', WHICH DENOTES
* A FOOTNOTE-DEFINED-CLASS.
88 CPS-FOOTNOTE-DEFINED-CLASS VALUES '50' THRU '59'.
07 CPS-WWG PIC XXXX.
07 CPS-PREMIUM-OVERTIME-FLAG PIC X.
07 CPS-SISA PIC X.
07 CPS-SHIFT-DIFFER-ELIG PIC X.
07 CPS-OCCUPATIONAL-INDEX-REF.
09 CPS-OCCUP-INDEX-1 PIC X.
09 CPS-OCCUP-INDEX-2 PIC X.
07 CPS-AFFIRMATIVE-ACTION-CODE.
09 CPS-AFFIRM-CODE-1 PIC X.
09 CPS-AFFIRM-CODE-2-3 PIC XX.
07 CPS-EMPLOYEE-CATEGORY-CODE PIC X.
07 CPS-VACATION-ACCRUAL-CODE PIC X.
07 CPS-LICENSE-TYPE PIC X.
07 CPS-SCHEDULE-TYPE-CSUC PIC X.
07 CPS-FLSA PIC X.
07 CPS-CB-HEERA-CODE REDEFINES
CPS-FLSA PIC X.
07 CPS-MPP-AGL-IND REDEFINES
CPS-FLSA PIC X.
07 CPS-BUDGET-OCCUPATION-CODE PIC XX.
07 CPS-SALARY-PER PIC X.
07 CPS-REALLOC-CLASS-CODE PIC XXXX OCCURS 5.
07 CPS-CAMPUS-CODE PIC XX.
07 CPS-SUSPEND-CLASS-CODE PIC X.
07 CPS-STEP-MAX PIC 99.
07 CPS-STEP-MIN PIC 99.
07 CPS-SSI-A-B PIC X.
07 FILLER PIC X.
07 CPS-CHAIN-CODE PIC X.
07 CPS-ACADEMIC-YEAR-CLASS PIC X.
07 CPS-DATE-LAST-CHANGED PIC X(8).
07 CPS-T-STEP-FLAG PIC X.
07 CPS-ANNUAL-FACTOR-X.
09 CPS-ANNUAL-FACTOR PIC 99.
07 CPS-COLL-BARGAIN-ID.
09 CPS-COLL-BARGAIN-ID-DESIG PIC X.
09 CPS-COLL-BARGAIN-ID-UNIT PIC XX.
07 FILLER PIC X.
07 CPS-PAY-PLAN PIC X.
07 CPS-BASE-CLASS-RNG.
09 CPS-BASE-CLASS PIC X(4).
09 CPS-BASE-RANGE PIC X.
07 CPS-GSI-TYPE PIC X.
07 CPS-GSI-AMOUNT PIC S9(4)V999 COMP-3.
07 CPS-GSI-TYPE2 PIC X.
07 CPS-GSI-AMOUNT2 PIC S9(4)V999 COMP-3.
07 CPS-SSI-COUNTER PIC XX.
07 CPS-SALARY-PLAN PIC XXX.
07 CPS-SSI-TYPE PIC X.
07 CPS-SSI-AMOUNT PIC S9(4)V999 COMP-3.
07 FILLER PIC X(18).
07 CPS-RECORD-TYPE PIC X.
88 CPS-RECORD-TYPE-VALID VALUES 'A'
THRU 'H'.
88 CPS-TITLE-RECORD VALUE 'A'.
* SEE PAY-SCALE-FOOTNOTES 88 LEVEL FOR VALUES '50' THRU '59',
* WHICH CORRESPOND TO RECORD-TYPE 'B'.
88 CPS-FOOTNOTE-DEFINED-RECORD VALUE 'B'.
88 CPS-STEP-RATE-RECORD VALUE 'C'.
88 CPS-ANNUAL-RECORD VALUE 'D'.
88 CPS-EXTENSION-RECORD VALUE 'E'.
88 CPS-VAR-SPECIAL-RECORD VALUE 'F'.
88 CPS-SUBSTITUTE-RECORD VALUE 'G'.
88 CPS-SUMMER-RECORD VALUE 'H'.
07 CPS-REDEFINED-SALARY-DATA PIC X(222).
*** RECORD TYPE 'A' DOES NOT HAVE SALARY DATA ***
*** RECORD TYPE 'B' DOES NOT HAVE SALARY DATA ***
************** RECORD TYPE 'C' SALARY DATA DEFINITION ***
07 RDF 07 CPS-STEP-RATE-SALARY-DATA
REDEFINES CPS-REDEFINED-SALARY-DATA.
09 FILLER PIC X(2).
09 CPS-STEPS-NUMBER PIC 99.
09 CPS-STEPS-RATES PIC S9(5)V99 COMP-3 OCCURS 45.
09 CPS-T-STEP-RATE PIC S9(5)V99 COMP-3.
09 FILLER PIC X(10).
09 CPS-NUM-STEPS-TO-ADVANCE PIC XX.
09 CPS-SSI-MAX-STEP PIC XX.
09 FILLER PIC X(20).
************** RECORD TYPE 'D' SALARY DATA DEFINITION ***
07 RDF 07 CPS-ANNUAL-SALARY-DATA
REDEFINES CPS-REDEFINED-SALARY-DATA.
09 CPS-ANNUAL-SALARY PIC S9(7)V99 COMP-3.
09 FILLER PIC X(217).
************* RECORD TYPE 'E' SALARY DATA DEFINITION ***
07 RDF 07 CPS-EXTENSION-SALARY-DATA
REDEFINES CPS-REDEFINED-SALARY-DATA.
09 CPS-SEMESTER-RATE-A PIC S9(5)V99 COMP-3.
09 CPS-QUARTER-RATE-A PIC S9(7)V99 COMP-3.
09 CPS-SEMESTER-RATE-B PIC S9(5)V99 COMP-3.
09 CPS-QUARTER-RATE-B PIC S9(7)V99 COMP-3.
09 CPS-SEMESTER-RATE-C PIC S9(5)V99 COMP-3.
09 CPS-QUARTER-RATE-C PIC S9(7)V99 COMP-3.
09 CPS-MINIMUM-RATE-G PIC S9(5)V99 COMP-3.
09 CPS-MAXIMUM-RATE-G PIC S9(5)V99 COMP-3.
09 FILLER PIC X(187).
************* RECORD TYPE 'F' SALARY DATA DEFINITION ***
07 RDF 07 CPS-VAR-SPECIAL-SALARY-DATA
REDEFINES CPS-REDEFINED-SALARY-DATA.
09 CPS-SPECIAL-RATE-MIN-V PIC S9(5)V99 COMP-3.
09 CPS-SPECIAL-RATE-MAX-V PIC S9(5)V99 COMP-3.
09 CPS-SPECIAL-RATE-SSI-V PIC S9(5)V99 COMP-3.
09 FILLER PIC X(210).
************* RECORD TYPE 'G' SALARY DATA DEFINITION ***
07 RDF 07 CPS-SUBSTITUTE-SALARY-DATA
REDEFINES CPS-REDEFINED-SALARY-DATA.
09 CPS-LECTURER-RATE PIC S9(3)V99 COMP-3.
09 CPS-LAB-RATE PIC S9(3)V99 COMP-3.
09 FILLER PIC X(216).
************* RECORD TYPE 'H' SALARY DATA DEFINITION ***
07 RDF 07 CPS-SUMMER-SALARY-DATA
REDEFINES CPS-REDEFINED-SALARY-DATA.
09 CPS-SUMMER-SEMESTER-RATE-A PIC S9(5)V99 COMP-3.
09 CPS-SUMMER-QUARTER-RATE-A PIC S9(7)V99 COMP-3.
09 CPS-SUMMER-SEMESTER-RATE-B PIC S9(5)V99 COMP-3.
09 CPS-SUMMER-QUARTER-RATE-B PIC S9(7)V99 COMP-3.
09 CPS-SUMMER-SESSION-MIN PIC S9(5)V99 COMP-3.
09 CPS-SUMMER-SESSION-MAX PIC S9(5)V99 COMP-3.
09 FILLER PIC X(196).
Last Updated: October 1, 2003