Faculty/Staff Table 6 Documentation: New Hires, Ranked Faculty

Displays the number of new-hired ranked, regular faculty for the past five years. The counts are displayed by full-time, tenure status, and rank. The tables 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 6:

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

"UIDS"."EMP_PERS"."EMPLMT_BEG_DT" as beg_dt,

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

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

"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"."FTE" = '100' ) AND

( UIDS."EMP_PERS"."TEN_STAT" in ('T','R') ) AND

( UIDS."EMP_PERS"."FISCAL_YR" >= '1992' ) AND

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

( (UIDS."EMP_PERS"."CENSUS"-UIDS."EMP_PERS"."EMPLMT_BEG_DT")/365.25 <= '1' ) ) );