One of the questions we are frequently asked is how to identify full time faculty. Although the answer may seem simple - employees with CBID of 'R03' and a time base value of 'FT' - it can be more involved.
If your report request has a screening statement for time base equal to full-time (IF AC:TIMEBASE EQ FT) then only employees with a single full-time position will be selected. Your report will not include those employees who have multiple part-time positions whose total time base is full-time or greater. To identify those employees, sum the full time equivalent (FTE) value for all positions held by an employee. Then, screen on the summed value to identify those employees with a total FTE of 1.0 or greater.
For example: SUM AC:FTE BY AC:SSA WHERE TOTAL AC:FTE GE 1.0
Generally, any employee with a CBID of R03 is considered to be faculty. However, based on your campus reporting needs, you may want to include additional classifications such as Teaching Associates (2353 and 2354) or Instructional Faculty Extension (2363). To capture these employees in your report, you'll need to use a compound screening statement.
For example: WHERE (AC:CBID EQ 'R03) OR (AC:CLASS EQ '2353' or '2354' or '2363')
This report request uses the commands discussed above along with multiple verbs to identify all active/onleave employees whose total time base of all R03 or related classes is full-time. Note: The sort phrases are indented to emphasize that any sorts associated with the first verb (SUM) must also be used with the subsequent verb (PRINT). For more information, refer to the topic: How To Use Multiple Verbs.
TABLE FILE AC
PRINT AC:POSITION AC:TIMEBASE
WHERE TOTAL AC:FTE GE 1.0
WHERE (AC:CBID EQ 'R03) OR
(AC:CLASS EQ '2353' or '2354' or '2363')
AC:SSA AC:WNAME FTE aC:POSIT16 ac:Timebase
------ -------- --- ---------- -----------
001-11-1111 Frog, abe 1.000 000-111-3306-001 ft
000-22-2222 ox, ann 1.000 000-112-2360-001 001/002
001-11-1111 BEAR, BOB 1.000 000-111-3306-001 ft
Last Updated: August 4, 2006