​​

AC - Sample Report

The following common library program: FOC1400B computes base pay statistics for active positions. The join between the Active Current Status file and the Systemwide Pay Scales file (JACPS1) is used for retrieving class title.  

 

EX JACPS1

TABLE FILE AC

HEADING CENTER

"THE CALIFORNIA STATE UNIVERSITY"

"BASE PAY STATISTICS FOR ACTIVE POSITION CLASSIFICATIONS"

"COMMON FOCEXEC: FOC1400B"

"DATA AS OF: <AC:DAO"

"</1"

SUM MIN.AC:BASEPAY AS 'MINIMUM,BASE PAY' IN +1

    MAX.AC:BASEPAY AS 'MAXIMUM,BASE PAY' IN +1

    AVE.AC:BASEPAY AS 'AVERAGE,BASE PAY' IN +1

    CNT.AC:POSIT16 AS 'PSN,TOTAL'

    AC:FTTOT       AS 'FT PSN,TOTAL' IN +1

    AC:PTTOT       AS 'PT PSN,TOTAL' IN +1

    AC:FTE         AS 'FTE,TOTAL' IN +1

BY AC:CBID AS ''

BY AC:CLASS AS ''

BY PS:TITLEA AS ''

WHERE (AC:SALPER EQ 'M') AND (FUND EQ 'GENERAL FUND')

WHERE RECORDLIMIT EQ 100

END

 

The following is only an excerpt from the actual report.

 

                        THE CALIFORNIA STATE UNIVERSITY

            BASE PAY STATISTICS FOR ACTIVE POSITION CLASSIFICATIONS

                            COMMON FOCEXEC: FOC1400B

                              DATA AS OF: 99/99/9999

 

                        MININUM    MAXIMUM    avERAGE  PSN   FT  PT   ftE

                        BASE PAY   BASE PAY   BASE PAY TOTAL TOt TOT  TOTal

                        --------   --------   -------- ----- --- ---  -----

C99 1176 CONF AS-12MO  $5,056.00  $5,056.00  $5,056.00     1   1   0  1.000

E99 0101 HELPER/AID    $1,250.00  $1,250.00  $1,250.00     1   1   0  1.000

M80 3300 ADMIN IV      $9,166.67 $10,492.00  $9,729.53     5   5   0  5.000

    3306 ADMIN III     $5,553.00  $8,917.00  $7,737.00     4   4   0  4.000

R11 2354 TCHNG ASC-AY  $1,981.00  $2,605.00  $2,218.80    10   0  10  3.468

    2355 GRAD ASSIST     $800.00    $918.00    $853.71     7   2   5  4.000

 

 

Last Updated:  May 1, 2005