The following common library program: FOC1200 counts your faculty, staff and management positions as of 10/31/-- and sorts the count by job family name, ethnic group and gender. The join between the Annual Current Status file and the Systemwide Pay Scales file (JANPS) is used for retrieving job family name.
EX JAnps
DEFINE FILE AN ADD
GENDER/A6 = DECODE AN:SEX (M 'MALE' F 'FEMALE' ELSE 'N/A');
END
TABLE FILE An
HEADING CENTER
"THE CALIFORNIA STATE UNIVERSITY"
"position count by job family, ethnic group and gender"
"COMMON FOCEXEC: FOC1200"
"DATA AS OF <AN:DAO"
" "
count an:POSITION as ''
BY ps:jobfamna as '' skip-line
BY gender as ''
across an:ethhicgrp as ''
if an:cbid ne 'e99'
if an:timebase ne int or ind
if RECORDLIMIT EQ 100
on table column-total
END
The following is only an excerpt from the actual report.
THE CALIFORNIA STATE UNIVERSITY
position count by job family, ethnic group and gender
COMMON FOCEXEC: FOC1200
DATA AS OF 99/99/9999
AMI ASN BLK HSP WHT
------------------------------------------------------------------------------
EXECUTIVE, ADMINISTRATIVE AND MANAGEMENT FEMALE 0 0 0 0 6
MALE 0 0 0 0 6
FACULTY FEMALE 0 3 0 0 28
MALE 0 3 2 2 33
PROFESSIONAL NON-FACULTY FEMALE 0 1 0 0 6
MALE 0 1 0 0 0
SECRETARIAL/CLERICAL FEMALE 0 3 0 0 28
MALE 0 3 2 2 33
SERVICE/MAINTENANCE FEMALE 0 1 0 0 6
MALE 0 1 0 0 0
SKILLED CRAFT FEMALE 0 3 0 0 28
MALE 0 3 2 2 33
TECHNICAL/PARAPROFESSIONAL FEMALE 0 1 0 0 6
MALE 0 1 0 0 0
TOTAL 1 8 2 2 87
Last Updated: April 15, 2010