Systemwide Pay Scales - Production Format File Description

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.  

 

  • File Name: PD.CSUCFOC.RPTUSER.PERMLRG.userid

  • Record Length: 456

  • Organization: One record per class and range.

 


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