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.​