FACULTY - Report
Data Element |
Business Definition |
Data Type |
Source Name |
Source Data Element |
Form Name |
PERSON_UID |
SYSTEM INTERNALLY GENERATED TO UNIQUELY IDENTIFY THE PERSON OR ENTITY. |
|
SIBINST |
SIBINST_PIDM |
UNKNOWN |
ACADEMIC_YEAR |
ACADEMIC YEAR ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_ACYR_CODE |
UNKNOWN |
ACADEMIC_YEAR_DESC |
DESCRIPTION OF THE ACADEMIC YEAR ASSOCIATED WITH THIS RECORD. |
|
STVACYR |
STVACYR_DESC |
UNKNOWN |
ACADEMIC_PERIOD |
IDENTIFIES THE ACADEMIC PERIOD OR TERM ASSOCIATED WITH THIS INFORMATION. |
|
SIBINST |
SIBINST_TERM_CODE_EFF |
UNKNOWN |
ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
SUB_ACADEMIC_PERIOD |
IDENTIFIES THE SUB ACADEMIC PERIOD OR PART OF TERM ASSOCIATED WITH THE INFORMATION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
SUB_ACADEMIC_PERIOD_DESC |
DESCRIPTION OF THE SUB ACADEMIC PERIOD OR SESSION. |
|
NA |
NOT AVAILABLE |
UNKNOWN |
ELIGIBLE_TO_ADVISE_IND |
FACULTY MEMBER AVAILABLE OF ADVISEMENT INDICATOR |
|
MSKFUNC |
F_FACULTY_ADVISING_IND |
UNKNOWN |
ADVISING_THIS_PERIOD_IND |
INDICATES THAT THE FACULTY MEMBER IS ADVISING THIS ACADEMIC PERIOD. |
|
FUNCTION |
F_FACULTY_ADVISING_IND |
UNKNOWN |
ELIGIBLE_TO_BE_SCHEDULED_IND |
FACULTY MEMBER ELIGIBLE TO BE SCHEDULED INDICATOR. |
|
MSKFUNC |
F_FACULTY_SCHEDULED_IND |
UNKNOWN |
SCHEDULED_THIS_PERIOD_IND |
INDICATES THAT THE FACULTY MEMBER IS SCHEDULED THIS ACADEMIC PERIOD. |
|
FUNCTION |
F_FACULTY_SCHEDULED_IND |
UNKNOWN |
WORKLOAD |
FACULTY MEMBER WORKLOAD RULE CODE |
|
SIBINST |
SIBINST_WKLD_CODE |
UNKNOWN |
WORKLOAD_DESC |
DESCRIPTION ASSOCIATED WITH THE WORKLOAD RULES CODE |
|
STVWKLD |
STVWKLD_DESC |
UNKNOWN |
TENURE |
FACULTY TENURE CODE |
|
SIBFACD |
SIBFACD_TENR_CODE |
UNKNOWN |
TENURE_DESC |
TENURE DESCRIPTION |
|
PTRTENR |
PTRTENR_DESC |
UNKNOWN |
TENURE_DATE |
FACULTY TENURE DATE |
|
SIBFACD |
SIBFACD_TENURE_DATE |
UNKNOWN |
TENURE_REVIEW_DATE |
FACULTY TENURE REVIEW DATE |
|
SIBFACD |
SIBFACD_TENURE_REV_DATE |
UNKNOWN |
LAST_SABBATICAL_DATE |
FACULTY LAST SABBATICAL DATE |
|
SIBFACD |
SIBFACD_LAST_SABB_DATE |
UNKNOWN |
NEXT_SABBATICAL_DATE |
FACULTY NEXT SABBATICAL DATE |
|
SIBFACD |
SIBFACD_NEXT_SABB_DATE |
UNKNOWN |
YEARS_EXPERIENCE |
YEARS EXPERIENCE |
|
SIBFACD |
SIBFACD_YRS_EXP |
UNKNOWN |
STATE_PROVINCE_OF_BIRTH |
STATE OF BIRTH |
|
SIBFACD |
SIBFACD_BIRTH_STATE |
UNKNOWN |
AAUP_MEMBER_IND |
AMERICAN ASSOCIATION OF UNIVERSITY PROFESSORS MEMBER INDICATOR |
|
SIBFACD |
SIBFACD_AAUP_MEM_IND |
UNKNOWN |
ACADEMIC_TITLE |
FORMAL TITLE FOR THIS FACULTY MEMBER. |
|
SIBFACD |
SIBFACD_ACADEMIC_TITLE |
UNKNOWN |
PRIMARY_ACTIVITY |
INDICATE WHETHER PRIMARY ACTIVITY IS INSTRUCTIONAL |
|
SIBFACD |
SIBFACD_PRIMARY_ACTIVITY |
UNKNOWN |
FACULTY_MEMBER_STATUS |
FACULTY MEMBER STATUS |
|
SIBINST |
SIBINST_FCST_CODE |
UNKNOWN |
FACULTY_MEMBER_STATUS_DESC |
NAME OF FACULTY MEMBER STATUS CODE |
|
STVFCST |
STVFCST_DESC |
UNKNOWN |
FACULTY_MEMBER_STATUS_DATE |
FACULTY MEMBER STATUS DATE |
|
SIBINST |
SIBINST_FCST_DATE |
UNKNOWN |
FACULTY_MEMBER_CATEGORY |
FACULTY MEMBER CATEGORY |
|
SIBINST |
SIBINST_FCTG_CODE |
UNKNOWN |
FACULTY_MEMBER_CATEGORY_DESC |
NAME OF FACULTY MEMBER CATEGORY CODE |
|
STVFCTG |
STVFCTG_DESC |
UNKNOWN |
FACULTY_MEMBER_STAFF_TYPE |
FACULTY MEMBER STAFF TYPE WHICH IS REQUIRED FOR WORKLOAD CALCULATION |
|
SIBINST |
SIBINST_FSTP_CODE |
UNKNOWN |
FACULTY_MEMBER_STAFF_TYPE_DESC |
NAME OF FACULTY MEMBER STAFF TYPE CODE |
|
SVTFSTP |
STVFSTP_DESC |
UNKNOWN |
CONTRACT_RULE |
FACULTY MEMBER CONTRACT RULE USED FOR WORKLOAD CALCULATION |
|
SIBINST |
SIBINST_FCNT_CODE |
UNKNOWN |
CONTRACT_RULE_DESC |
NAME OF THE FACULTY MEMBER CONTRACT RULE. |
|
STVFCNT |
STVFCNT_DESC |
UNKNOWN |
DEFAULT_CONTRACT_TYPE |
DEFAULT CONTRACT TYPE THAT IS ASSOCIATED WITH THIS FACULTY MEMBER |
|
SIRICNT |
SIRICNT_CNTR_CODE |
UNKNOWN |
DEFAULT_CONTRACT_TYPE_DESC |
DEFAULT CONTRACT TYPE. |
|
STVCNTR |
STVCNTR_DESC |
UNKNOWN |
APPOINTMENT_DATE |
DATE THE APPOINTMENT WAS AWARDED |
|
SIBINST |
SIBINST_APPOINT_DATE |
UNKNOWN |
ACAD_PER_EFF_COLL_DEPT |
BEGINNING ACADEMIC PERIOD. |
|
SIRDPCL |
SIRDPCL_TERM_CODE_EFF |
UNKNOWN |
ACAD_PER_EFF_COLL_DEPT_DESC |
DESCRIPTION OF THE ACADEMIC PERIOD ASSOCIATED THIS RECORD. |
|
STVTERM |
STVTERM_DESC |
UNKNOWN |
HOME_COLLEGE |
FIRST LAYER OF THE INSTITUTION ORGANIZATION. |
|
SIRDPCL |
SIRDPCL_COLL_CODE |
UNKNOWN |
HOME_COLLEGE_DESC |
NAME OF THE FIRST LAYER (COLLEGE) OF THE INSTITUTION ORGANIZATION. |
|
STVCOLL |
STVCOLL_DESC |
UNKNOWN |
HOME_DEPARTMENT |
THIRD LAYER OF THE INSTITUTION ORGANIZATION. |
|
SIRDPCL |
SIRDPCL_DEPT_CODE |
UNKNOWN |
HOME_DEPARTMENT_DESC |
NAME OF THE THIRD LAYER (DEPARTMENT) OF THE INSTITUTION ORGANIZATION. |
|
STVDEPT |
STVDEPT_DESC |
UNKNOWN |
HOME_PERCENT_RESPONSIBILITY |
HOME PERCENTAGE RESPONSIBILITY. |
|
SIRDPCL |
SIRDPCL_PERCENTAGE |
UNKNOWN |
HOME_ADMIN_COLL_DEPT_IND |
HOME ADMINISTRATIVE COLLEGE DEPARTMENT INDICATOR. |
|
SIRDPCL |
SIRDPCL_HOME_IND |
UNKNOWN |
INST_ASSIGNMENT_COUNT |
NUMBER OF INSTRUCTIONAL ASSIGNMENTS ASSOCIATED WITH THE PERSON AS A FACULTY MEMBER. |
|
MSKFUNC |
F_COUNT_INST_ASSIGNMENT |
UNKNOWN |
NONINST_ASSIGNMENT_COUNT |
NUMBER OF NON INSTRUCTIONAL ASSIGNMENTS ASSOCIATED WITH THE PERSON AS A FACULTY MEMBER. |
|
MSKFUNC |
F_COUNT_NONINST_ASSIGNMENT |
UNKNOWN |
ATTRIBUTE_COUNT |
NUMBER OF ATTRIBUTES ASSOCIATED WITH THE PERSON AS A FACULTY MEMBER. |
|
MSKFUNC |
F_COUNT_FACULTY_ATTRIBUTE |
UNKNOWN |
COLLEGE_DEPT_ASSIGN_COUNT |
COUNT OF THE NUMBER OF COLLEGE AND OR DEPARTMENTS TO WHICH THIS FACULTY MEMBER IS ASSIGNED. |
|
MSKFUNC |
F_COUNT_FACULTY_DEPT_COLL |
UNKNOWN |
CONTRACT_RULE_COUNT |
FACULTY MEMBER CONTRACT RULE USED FOR WORKLOAD CALCULATION |
|
MSKFUNC |
F_COUNT_FACULTY_CONTRACT |
UNKNOWN |