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:

  • This request generates a position count - not a head count - because data is being retrieved from the position segment of the SAC file.  For more information on obtaining a head count, refer to the topic:  Systemwide Head Counts.

  • A logical define is used to identify employee positions as management, staff, tenured and non-tenured faculty.  

  • The SAC file does not have student or special consultant positions, so those positions are not included in the report.   

  • The COLUMNS command is used to specify the order of the columns (which overrides the default alpha order).  

  • A screening statement is used to exclude Chancellor's Office records from the report.

  • The ROW-TOTAL command is used to generate a total for each campus and the COLUMN-TOTAL command generates a total for each employee group.