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.

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.

Last Updated: September 5, 2006