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