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.