Faculty/Staff Table 3 Documentation: Faculty Salaries

Displays the average salaries for full-time, ranked regular faculty for the past five fiscal years. The data are presented by rank (Professor, Associate Professor, Assistant Professor, and Instructor) by service basis (9 month and 12 month). 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 3:

( SELECT "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"."EMP_PERS"."ACAD_RANK" as rankin,

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

"UIDS"."EMP_PERS"."FISCAL_YR" as year,

"UIDS"."EMP_APPT"."SVC_BAS_DESC" as basis,

"UIDS"."EMP_APPT"."SVC_BAS_PAY_TRMS" as bcode,

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

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

FROM "UIDS"."EMP_PERS",

"UIDS"."UIDS_LINK",

"UIDS"."EMP_APPT"

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

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

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

( "UIDS"."EMP_PERS"."CMP_CD_HOME" = "UIDS"."EMP_APPT"."CMP_CD_HOME" ) and

( "UIDS"."EMP_PERS"."FED_ID_NO" = "UIDS"."EMP_APPT"."FED_ID_NO" ) and

( "UIDS"."EMP_PERS"."FISCAL_YR" = "UIDS"."EMP_APPT"."FISCAL_YR" ) and

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

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

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

( UIDS."EMP_PERS"."FTE" >= 100 ) AND

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

( UIDS."EMP_APPT"."APPT_CAT" = 'PRIMARY' ) );