Sample Request: Systemwide Position Counts

The report below is a typical example of a systemwide data report and identifies the number of management, staff, tenured faculty and non-tenured faculty positions by campus.  The report is generated using the Systemwide Active Current Status (SAC) file which contains a snapshot of active/onleave positions at all campuses, including the Chancellor's Office, as of the prior Friday.  Only a portion of the actual report is shown below.  The complete report request is available in the CIRS common library as FOC6008.

 

                   mgmt       staff     tenured    non-ten       total

campus

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

bkersfield           71         469         117        343        1000

channel is           67         279           5        193         544

chico               139         873         395        541        1948

dominguez            84         555         141        467        1247

 

Report Request:  

 

EX SAC

DEFINE FILE SAC ADD

GROUP/A10 = IF SAC:CBID EQ 'M80' OR 'M98'

            THEN 'MGMT' ELSE

            IF SAC:CBID EQ 'R03' AND SAC:probgroup eq 'perm stat'

            then 'tenured'

            IF SAC:CBID EQ 'R03' AND SAC:probgroup ne 'perm stat'

            then 'non-ten' else 'staff';

END

table file Sac

count SAC:position

by Sac:campus

Across group as ''

columns 'mgmt' and 'staff' and 'tenured' and 'non-ten'

if sac:campuscd ne 01

on table column-total row-total

end

 

Things to note: