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	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	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	Administrative-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)	SIRICNT	SIRICNT_CNTR_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_FCNT_CODE
DEFAULT_CONTRACT_TYPE_DESC	Default contract type description.	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	Faculty members employment home college. College is the first or highest layer of the institutions organization.	VARCHAR2(63)	SIRDPCL	SIRDPCL_COLL_CODE
HOME_COLLEGE_DESC	Home college description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HOME_DEPARTMENT	Faculty members employment home department. Department is the third layer of the institutions organization.	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. This information may be retrieved from the student data in SIBFACD or if NULL then from the faculty information in PERAPPT.	VARCHAR2(63)	FUNCTION	F_GET_TENURE
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: 9.1