Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
AAUP_MEMBER_IND	Aaup Member Indicator	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	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	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_TITLE	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	Academic year associated with the academic period on this record.	VARCHAR2(63)	FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_YEAR_DESC	Academic Year Description	Academic year description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ACAD_PER_EFF_COLL_DEPT	Acad Period Eff Coll Department	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	Acad Period Eff Coll Department Description	Academic period description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ADMINISTRATIVE_GROUP	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	Advising This Period Indicator	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	Appointment Date	Date the appointment was made to the faculty position.	DATE	SIBINST	SIBINST_APPOINT_DATE
ATTRIBUTE_COUNT	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	College Department 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	Contract Rule	Faculty contract rule associated with an instructional assignment.	VARCHAR2(63)	SIRICNT	SIRICNT_CNTR_CODE
CONTRACT_RULE_COUNT	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	Contract Rule Description	Faculty member contract rule description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
DEFAULT_CONTRACT_TYPE	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	Default contract type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
ELIGIBLE_TO_ADVISE_IND	Eligible To Advise Indicator	Indicates whether the faculty member is available to be an advisor.	VARCHAR2(1)	FUNCTION	F_FACULTY_ADVISING_IND
ELIGIBLE_TO_BE_SCHEDULED_IND	Eligible To Be Scheduled Indicator	Indicates whether the faculty member is eligible to have instructional assignments.	VARCHAR2(1)	FUNCTION	F_FACULTY_SCHEDULED_IND
FACULTY_MEMBER_CATEGORY	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	Faculty member category description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
FACULTY_MEMBER_STAFF_TYPE	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	Faculty member staff type description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
FACULTY_MEMBER_STATUS	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	Faculty member status date.	DATE	SIBINST	SIBINST_FCST_DATE
FACULTY_MEMBER_STATUS_DESC	Faculty Member Status Description	Faculty member status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HOME_ADMIN_COLL_DEPT_IND	Home Admin Coll Department Indicator	Home administrative college department indicator.	VARCHAR2(1)	SIRDPCL	SIRDPCL_HOME_IND
HOME_COLLEGE	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	Home college description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HOME_DEPARTMENT	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	Home department description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
HOME_PERCENT_RESPONSIBILITY	Home Percent Responsibility	Home percentage responsibility.	NUMBER	SIRDPCL	SIRDPCL_PERCENTAGE
ID	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	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	Job Suffix	Position number suffix.	VARCHAR2(63)	SIRASGN	SIRASGN_SUFF
LAST_SABBATICAL_DATE	Last Sabbatical Date	Faculty last sabbatical date for the faculty member.	DATE	SIBFACD	SIBFACD_LAST_SABB_DATE
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	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	Next Sabbatical Date	Faculty next sabbatical date for the faculty member.	DATE	SIBFACD	SIBFACD_NEXT_SABB_DATE
NONINST_ASSIGNMENT_COUNT	Noninst Assignment Count	Non-instructional assignment count.	NUMBER	FUNCTION	MSKFUNC.F_COUNT_NONINST_ASSIGNMENT
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	SIBINST	SIBINST_PIDM
POSITION	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	Position Title	Employee position description.	VARCHAR2(63)	NBRJOBS	NBRJOBS_DESC
PRIMARY_ACTIVITY	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	Primary Activity description.	VARCHAR2(255)	CALCULATION	DECODE(SIBFACD_PRIMARY_ACTIVITY)
PROCESS_GROUP	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	Scheduled This Period Indicator	Indicates whether faculty is scheduled in an instructional assignment for this academic period.	VARCHAR2(1)	FUNCTION	F_FACULTY_SCHEDULED_IND
STATE_PROVINCE_OF_BIRTH	State Province Of Birth	Birth State.	VARCHAR2(3)	PERBFAC SIBFACD	PERBFAC_BIRTH_STATE SIBFACD_BIRTH_STATE
TENURE	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	Tenure Date	Date of the faculty tenure.	DATE	SIBFACD	SIBFACD_TENURE_DATE
TENURE_DESC	Tenure Description	Tenure description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
TENURE_REVIEW_DATE	Tenure Review Date	Date for the next tenure review for this faculty.	DATE	SIBFACD	SIBFACD_TENURE_REV_DATE
WORKLOAD	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	Workload Description	Description for the faculty member workload rule.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
YEARS_EXPERIENCE	Years Experience	Academic staff or faculty member as the current number of years experience.	NUMBER	SIBFACD	SIBFACD_YRS_EXP

Ver: 9.2