Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Student Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: FACULTY

Description Contains detail information from the student administration arena for the academic staff member. The staff members assignments can be viewed and reported using the INSTRUCTIONAL ASSIGNMENT and NON INSTRUCTIONAL ASSIGNMENT reporting view.
Key & Frequency One row per faculty member per academic period.
Recommended Search Columns PERSON_UID
CONTRACT_RULE
PERSON_UID, HOME_COLLEGE, HOME_DEPARTMENT
ACADEMIC_PERIOD

Target Column Business Definition Database Data Type Source Name Source Column
AAUP_MEMBER_IND Indicates the academic staff or faculty member belongs to the American Association of University Professors. VARCHAR2(1)

PERBFAC

SIBFACD

PERBFAC_AAUP_IND

SIBFACD_AAUP_MEM_IND

ACADEMIC_PERIOD Academic period or time frame the faculty member is available for instructional assignments. VARCHAR2(63)

SIBINST

SIBINST_TERM_CODE_EFF

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_TITLE Name for the academic staff member title or position at the institution. Examples may include, associate professor, adjunct faculty member, etc. VARCHAR2(60)

PERBFAC

PERBFAC_ACADEMIC_TITLE

ACADEMIC_YEAR Academic year associated with the academic period on this record. VARCHAR2(63)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACAD_PER_EFF_COLL_DEPT Academic period or time frame for this faculty home college or department assignment. VARCHAR2(63)

SIRDPCL

SIRDPCL_TERM_CODE_EFF

ACAD_PER_EFF_COLL_DEPT_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

ADVISING_THIS_PERIOD_IND Indicates whether the faculty or academic staff member is assigned as an adviser this academic period. VARCHAR2(1)

FUNCTION

F_FACULTY_ADVISING_IND

APPOINTMENT_DATE Date the appointment was made to the faculty position. DATE

SIBINST

SIBINST_APPOINT_DATE

ATTRIBUTE_COUNT Count of faculty attributes recorded for the instructor or member of academic staff. NUMBER

FUNCTION

MSKFUNC.F_COUNT_FACULTY_ATTRIBUTE

COLLEGE_DEPT_ASSIGN_COUNT Count of active college/department assignments recorded for an instructor or member of academic staff. NUMBER

FUNCTION

MSKFUNC.F_COUNT_FACULTY_DEPT_COLL

CONTRACT_RULE Faculty contract rule associated with an instructional assignment. VARCHAR2(63)

SIBINST

SIBINST_FCNT_CODE

CONTRACT_RULE_COUNT Count of the number of contract rules recorded for the faculty member in this time period. NUMBER

FUNCTION

MSKFUNC.F_COUNT_FACULTY_CONTRACT

CONTRACT_RULE_DESC Faculty member contract rule description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

DEFAULT_CONTRACT_TYPE Contract rule used for the academic member of staff in this academic period. VARCHAR2(63)

SIRICNT

SIRICNT_CNTR_CODE

DEFAULT_CONTRACT_TYPE_DESC Description for the contract rule. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ELIGIBLE_TO_ADVISE_IND Indicates whether the faculty member is available to be an advisor. VARCHAR2(1)

FUNCTION

F_FACULTY_ADVISING_IND

ELIGIBLE_TO_BE_SCHEDULED_IND Indicates whether the faculty member is eligible to have instructional assignments. VARCHAR2(1)

FUNCTION

F_FACULTY_SCHEDULED_IND

FACULTY_MEMBER_CATEGORY Category assigned to the faculty or academic staff member. Included categories may be professor, associate professor, auxiliary, etc. VARCHAR2(63)

SIBINST

SIBINST_FCTG_CODE

FACULTY_MEMBER_CATEGORY_DESC Faculty member category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FACULTY_MEMBER_STAFF_TYPE Staff type assigned to the faculty or academic staff member. Included type may be full time, part time, continuing education, etc. VARCHAR2(63)

SIBINST

SIBINST_FSTP_CODE

FACULTY_MEMBER_STAFF_TYPE_DESC Faculty member staff type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

FACULTY_MEMBER_STATUS Current status associated with the faculty or academic staff member. VARCHAR2(63)

SIBINST

SIBINST_FCST_CODE

FACULTY_MEMBER_STATUS_DATE Faculty member status date. DATE

SIBINST

SIBINST_FCST_DATE

FACULTY_MEMBER_STATUS_DESC Faculty member status description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

HOME_ADMIN_COLL_DEPT_IND Home administrative college department indicator. VARCHAR2(1)

SIRDPCL

SIRDPCL_HOME_IND

HOME_COLLEGE Home college. VARCHAR2(63)

SIRDPCL

SIRDPCL_COLL_CODE

HOME_COLLEGE_DESC Home college description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

HOME_DEPARTMENT Home department. VARCHAR2(63)

SIRDPCL

SIRDPCL_DEPT_CODE

HOME_DEPARTMENT_DESC Home department description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

HOME_PERCENT_RESPONSIBILITY Home percentage responsibility. NUMBER

SIRDPCL

SIRDPCL_PERCENTAGE

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

INST_ASSIGNMENT_COUNT Count of the number of instructional assignments for the instructor for this academic period. NUMBER

FUNCTION

MSKFUNC.F_COUNT_INST_ASSIGNMENT

JOB_SUFFIX Position number suffix. VARCHAR2(63)

SIRASGN

SIRASGN_SUFF

LAST_SABBATICAL_DATE Faculty last sabbatical date for the faculty member. DATE

SIBFACD

SIBFACD_LAST_SABB_DATE

MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NAME Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NEXT_SABBATICAL_DATE Faculty next sabbatical date for the faculty member. DATE

SIBFACD

SIBFACD_NEXT_SABB_DATE

NONINST_ASSIGNMENT_COUNT Non-instructional assignment count. NUMBER

FUNCTION

MSKFUNC.F_COUNT_NONINST_ASSIGNMENT

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

SIBINST

SIBINST_PIDM

POSITION Position number, which is used to tie the faculty member's assignment to a position defined in the Human Resources system. VARCHAR2(63)

NBRJOBS

SIRASGN

NBRJOBS_POSN

SIRASGN_POSN

POSITION_TITLE Employee position description. VARCHAR2(63)

NBRJOBS

NBRJOBS_DESC

PRIMARY_ACTIVITY Indicates whether the primary activity of the faculty member is instructional, research, or administrative. VARCHAR2(1)

PERBFAC

SIBFACD

PERBFAC_PRIMARY_ACTIVITY

SIBFACD_PRIMARY_ACTIVITY

PRIMARY_ACTIVITY_DESC Primary Activity description. VARCHAR2(255)

CALCULATION

DECODE(SIBFACD_PRIMARY_ACTIVITY)

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

SCHEDULED_THIS_PERIOD_IND Indicates whether faculty is scheduled in an instructional assignment for this academic period. VARCHAR2(1)

FUNCTION

F_FACULTY_SCHEDULED_IND

STATE_PROVINCE_OF_BIRTH Birth State. VARCHAR2(3)

PERBFAC

SIBFACD

PERBFAC_BIRTH_STATE

SIBFACD_BIRTH_STATE

TENURE Identifies whether this faculty or academic member of staff has tenure. VARCHAR2(63)

SIBFACD

SIBFACD_TENR_CODE

TENURE_DATE Date of the faculty tenure. DATE

SIBFACD

SIBFACD_TENURE_DATE

TENURE_DESC Tenure description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

TENURE_REVIEW_DATE Date for the next tenure review for this faculty. DATE

SIBFACD

SIBFACD_TENURE_REV_DATE

WORKLOAD Workload rule code that defines the contractual measures for the instructional assignments for this faculty member for the time frame. VARCHAR2(63)

SIBINST

SIBINST_WKLD_CODE

WORKLOAD_DESC Description for the faculty member workload rule. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

YEARS_EXPERIENCE Academic staff or faculty member as the current number of years experience. NUMBER

SIBFACD

SIBFACD_YRS_EXP



Ver: 8.0