Faculty/Staff Table 4 Documentation: Ranked Regular Faculty Counts

Displays the number of ranked, regular faculty for the past five fiscal years. The counts are displayed by tenure status, rank, and full- or part-time status. The table does not include faculty who are active without pay or who are on leave without pay. In order to report school and departmental data, the UIDS departmental structure, as found in the UIDS.UIDS_LINK table, is used.

SQL used to create Faculty/Staff Table 4:

( SELECT "UIDS"."EMP_PERS"."FISCAL_YR" as fy,

"UIDS"."EMP_PERS"."CMP_CD_HOME" as cmp_cd,

"UIDS"."UIDS_LINK"."UIDS_LINK_CD" as uids_cd,

"UIDS"."UIDS_LINK"."UIDS_LINK_DESC" as depart,

"UIDS"."UIDS_LINK"."UIDS_DIV_CD" as div_cd,

"UIDS"."UIDS_LINK"."UIDS_DIV_DESC" as division,

"UIDS"."EMP_PERS"."ACAD_RANK" as rank,

"UIDS"."EMP_PERS"."BTHDT" as bday,

"UIDS"."EMP_PERS"."FTE" as fte,

"UIDS"."EMP_PERS"."CTZSHP" as cit,

"UIDS"."EMP_PERS"."EDUC_LVL" as ed,

"UIDS"."EMP_PERS"."EDUC_LVL_DESC" as ed_lvl,

"UIDS"."EMP_PERS"."ETHNC" as eth,

"UIDS"."EMP_PERS"."ETHNC_DESC" as eth_des,

"UIDS"."EMP_PERS"."NAME" as name,

"UIDS"."EMP_PERS"."SALARY" as salary,

"UIDS"."EMP_PERS"."SEX" as sex,

"UIDS"."EMP_PERS"."TEN_STAT" as ten_stat,

"UIDS"."EMP_PERS"."TEN_STAT_DESC" as tenure

FROM"UIDS"."EMP_PERS",

"UIDS"."UIDS_LINK"

WHERE ( "UIDS"."EMP_PERS"."FISCAL_YR" = "UIDS"."UIDS_LINK"."FISCAL_YR" ) and

( "UIDS"."EMP_PERS"."CMP_CD_HOME" = "UIDS"."UIDS_LINK"."CMP_CD" ) and

( "UIDS"."EMP_PERS"."DEPT_CD_HOME" = "UIDS"."UIDS_LINK"."EMP_DEPT_CD_HOME") and

( UIDS."EMP_PERS"."ACAD_RANK" is not null ) AND

( UIDS."EMP_PERS"."FISCAL_YR" between '1996' and '2000') AND

( UIDS."EMP_PERS"."EMPLMT_STAT" not in ( 'C','L' ) ) );