Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
AAUP_MEMBER_IND		Indicates the academic staff or faculty member belongs to the American Association of University Professors.	VARCHAR2(1)		SIBFACD	SIBFACD_AAUP_MEM_IND
ACADEMIC_PERIOD_END		Ending academic period or time frame for this faculty member to have a instructional assignment.	VARCHAR2(6)		FUNCTION	SOKODSF.F_GET_END_SIBINST_TERM
ACADEMIC_PERIOD_END_DESC		Academic period description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
ACADEMIC_PERIOD_START		Academic period or time frame when the academic staff can have instructional assignments.	VARCHAR2(6)		SIBINST	SIBINST_TERM_CODE_EFF
ACADEMIC_PERIOD_START_DESC		Academic period description.	VARCHAR2(30)		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)		SIBFACD	SIBFACD_ACADEMIC_TITLE
ACADEMIC_YEAR		Academic year associated with the academic period on this record.	VARCHAR2(0)		STVTERM	STVTERM_ACYR_CODE
ACADEMIC_YEAR_DESC		Academic year description.	VARCHAR2(0)		NA	NA
APPOINTMENT_DATE		Date the appointment was made to the faculty position.	DATE		SIBINST	SIBINST_APPOINT_DATE
CONTRACT_RULE		Faculty contract rule that is associated with an instructional assignment.	VARCHAR2(2)		SIBINST	SIBINST_FCNT_CODE
CONTRACT_RULE_DESC		Faculty member contract rule description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
ELIGIBLE_TO_ADVISE_IND		Indicates whether the faculty member is available to be an advisor.	VARCHAR2(1)		SIBINST	SIBINST_ADVR_IND
ELIGIBLE_TO_BE_SCHEDULED_IND		Indicates whether the faculty member is eligible to have instructional assignments.	VARCHAR2(1)		SIBINST	SIBINST_SCHD_IND
FACULTY_MEMBER_CATEGORY		Category assigned to the faculty or academic staff member. Included categories may be professor, associate professor, auxiliary, etc.	VARCHAR2(6)		SIBINST	SIBINST_FCTG_CODE
FACULTY_MEMBER_CATEGORY_DESC		Faculty member category description.	VARCHAR2(30)		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(4)		SIBINST	SIBINST_FSTP_CODE
FACULTY_MEMBER_STAFF_TYPE_DESC		Faculty member staff type description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
FACULTY_MEMBER_STATUS		Current status associated with the faculty or academic staff member.	VARCHAR2(2)		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(30)		FUNCTION	GOKODSF.F_GET_DESC
LAST_SABBATICAL_DATE		Faculty last sabbatical date for the faculty member.	DATE		SIBFACD	SIBFACD_LAST_SABB_DATE
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NEXT_SABBATICAL_DATE		Faculty next sabbatical date for the faculty member.	DATE		SIBFACD	SIBFACD_NEXT_SABB_DATE
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		SIBINST	SIBINST_PIDM
PRIMARY_ACTIVITY		Indicates whether the primary activity of the faculty member is instructional, research, or administrative.	VARCHAR2(1)		SIBFACD	SIBFACD_PRIMARY_ACTIVITY
PRIMARY_ACTIVITY_DESC		Primary Activity description.	VARCHAR2(30)
STATE_OF_BIRTH		Faculty member's state/province at the time of birth.	VARCHAR2(3)		SIBFACD	SIBFACD_BIRTH_STATE
SUB_ACADEMIC_PERIOD		A session, portion or part of the academic period.	VARCHAR2(0)		NA	NA
SUB_ACADEMIC_PERIOD_DESC		Sub academic period description.	VARCHAR2(0)		NA	NA
TENURE		Identifies whether this faculty or academic member of staff has tenure.	VARCHAR2(2)		SIBFACD	SIBFACD_TENR_CODE
TENURE_DATE		Date of the faculty tenure.	DATE		SIBFACD	SIBFACD_TENURE_DATE
TENURE_DESC		Tenure description.	VARCHAR2(30)		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(6)		SIBINST	SIBINST_WKLD_CODE
WORKLOAD_DESC		Description for the faculty member workload rule.	VARCHAR2(30)		NA	NA
YEARS_EXPERIENCE		Academic staff or faculty member as the current number of years experience.	NUMBER(2)		SIBFACD	SIBFACD_YRS_EXP
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: