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(63)	PERBFAC	PERBFAC_AAUP_IND
ACADEMIC_TITLE	Name for the academic staff member title or position at the institution. Examples may include, associate professor, adjunct faculty member, etc.	VARCHAR2(255)	PERBFAC SIBFACD	PERBFAC_ACADEMIC_TITLE SIBFACD_ACADEMIC_TITLE
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
APPEAL_DATE	Appeal Date.	DATE	PERAPPT	PERAPPT_APPEAL_DATE
APPOINTMENT_ACTION_DATE	The Action Date will generally be the date in which the information was intiated on behalf of the faculty member and typically reflects a date for work organization.	DATE	PERAPPT	PERAPPT_ACTION_DATE
APPOINTMENT_BEGIN_DATE	This records the offical begin date of the faculty member's appointment or reappointment.	DATE	PERAPPT	PERAPPT_BEGIN_DATE
APPOINTMENT_CHART_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
APPOINTMENT_COMMENTS	Appointment comments.	VARCHAR2(4000)	PERAPPT	PERAPPT_COMMENT
APPOINTMENT_DECISION	Appointment decision.	VARCHAR2(63)	PERAPPT	PERAPPT_DECISION
APPOINTMENT_DECISION_DATE	Date of decision.	DATE	PERAPPT	PERAPPT_DECISION_DATE
APPOINTMENT_DECISION_DESC	Appointment decision description.	VARCHAR2(255)	CALCULATION	DECODE(PERAPPT_DECISION)
APPOINTMENT_DISCIPLINE	Discipline code.	VARCHAR2(63)	PERAPPT	PERAPPT_DISP_CODE
APPOINTMENT_DISCIPLINE_DESC	Discipline code description.	VARCHAR2(255)	PTVDISP	PTVDISP_DESC
APPOINTMENT_EFFECTIVE_DATE	Appointment Effective Date.	DATE	PERAPPT	PERAPPT_APPT_EFF_DATE
APPOINTMENT_END_DATE	This records the offical end date of the faculty member's appointment or reappointment.	DATE	PERAPPT	PERAPPT_END_DATE
APPOINTMENT_FACULTY_TYPE	Faculty type code.	VARCHAR2(63)	PERAPPT	PERAPPT_FTYP_CODE
APPOINTMENT_FACULTY_TYPE_DESC	Faculty type code description.	VARCHAR2(255)	PTRFTYP	PTRFTYP_DESC
APPOINTMENT_JOB_SUFFIX	Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.	VARCHAR2(63)	PERAPPT	PERAPPT_SUFF
APPOINTMENT_NEXT_REVIEW_DATE	Appointment Next Review Date.	DATE	PERAPPT	PERAPPT_NEXT_DATE
APPOINTMENT_ORGANIZATION_CODE	Organization code.	VARCHAR2(63)	PERAPPT	PERAPPT_ORGN
APPOINTMENT_ORGANIZATION_DESC	Organization code desc.	VARCHAR2(255)	FTVORGN PTVORGN	FTVORGN_DESC PTVORGN_DESC
APPOINTMENT_POSITION	Employee position number.	VARCHAR2(63)	PERAPPT	PERAPPT_POSN
APPOINTMENT_POSITION_TITLE	Employee position description.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC
APPOINTMENT_REVIEW	Appointment review code.	VARCHAR2(63)	PERAPPT	PERAPPT_REVT_REAPP_CODE
APPOINTMENT_REVIEW_DESC	Appointment review code description.	VARCHAR2(255)	PTVREVT	PTVREVT_DESC
APPOINTMENT_TIMESHEET_CHART	Timesheet chart of accounts.	VARCHAR2(63)	PERAPPT	PERAPPT_COAS_CODE
APPOINT_DECISION_DEFERRAL_DATE	Decision deferred to date.	DATE	PERAPPT	PERAPPT_DECISION_DEFER_DATE
COMMITMENT_FULFILL_DATE	Sabbatical/leave commitment fulfillment date.	DATE	PERSABB	PERSABB_COMM_FULL_DATE
COMMITMENT_FULFILL_DUE_DATE	Sabbatical/leave commitment fulfillment due date.	DATE	PERSABB	PERSABB_COMM_FULL_DUE_DATE
EMERITUS_STATUS_IND	Emeritus status.	VARCHAR2(63)	PERBFAC	PERBFAC_EMERITUS_STATUS
FACULTY_TYPE	Faculty type code.	VARCHAR2(63)	PERBFAC	PERBFAC_FTYP_CODE
FACULTY_TYPE_DESC	Faculty type code description.	VARCHAR2(255)	PTRFTYP	PTRFTYP_DESC
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
INITIAL_RANK_IND	Rank initial record indicator.	VARCHAR2(63)	PERRANK	PERRANK_INITIAL
INITIAL_TENURE_IND	Initial tenure record.	VARCHAR2(63)	PERAPPT	PERAPPT_INITIAL_TENURE
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_REASON	Type of academic sabbatical/leave the faculty member is eligible to take in the future.	VARCHAR2(63)	PERSABB	PERSABB_LREA_CODE_NEXT
NEXT_SABBATICAL_REASON_DESC	Next sabbatical/leave type description.	VARCHAR2(255)	PTRLREA	PTRLREA_DESC
ORIGINAL_APPOINT_BEGIN_DATE	Original appointment begin date.	DATE	PERBFAC	PERBFAC_ORIG_BEGIN_DATE
ORIGINAL_APPOINT_END_DATE	Original appointment end date.	DATE	PERBFAC	PERBFAC_ORIG_END_DATE
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERAPPT PERBFAC PERRANK PERSABB	PERAPPT_PIDM PERBFAC_PIDM PERRANK_PIDM PERSABB_PIDM
PREVIOUS_INSTITUTION_CREDIT	Credit toward the number of years of service the employe may have from prior insitutions that may have some bearing on current faculty action eligibility. For Canadian College installations, this field is reported on the Annual Statistics Canada Report for Colleges. Two decimal places.	NUMBER	PERBFAC	PERBFAC_PREV_INST_CREDIT
PREVIOUS_TENURE_GRANT	Records tenure credit, awarded at a previous institution, being considered for credit at this institution. It may also be used to record credit given in a negotiated appointment or lapse in service.	NUMBER	PERAPPT	PERAPPT_PREV_GRT_TENR
PRIMARY_ACTIVITY	Indicates whether the primary activity of the faculty member is instructional, research, or administrative.	VARCHAR2(63)	PERBFAC	PERBFAC_PRIMARY_ACTIVITY
PRIMARY_ACTIVITY_DESC	Primary activity description.	VARCHAR2(255)	CALCULATION	DECODE(PERBFAC_PRIMARY_ACTIVITY)
PRIMARY_DISCIPLINE	Primary discipline code.	VARCHAR2(63)	PERBFAC	PERBFAC_DISP_CODE
PRIMARY_DISCIPLINE_DESC	Primary discipline code description.	VARCHAR2(255)	PTVDISP	PTVDISP_DESC
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
RANK	Rank code.	VARCHAR2(63)	PERRANK	PERRANK_RANK_CODE
RANK_ACADEMIC_TITLE	Academic title.	VARCHAR2(255)	PERRANK	PERRANK_ACADEMIC_TITLE
RANK_ACTION_DATE	Rank action date.	DATE	PERRANK	PERRANK_ACTION_DATE
RANK_APPEAL_DATE	Appeal date.	DATE	PERRANK	PERRANK_APPEAL_DATE
RANK_BEGIN_DATE	Rank effective date.	DATE	PERRANK	PERRANK_BEGIN_DATE
RANK_COMMENT	Rank comments.	VARCHAR2(4000)	PERRANK	PERRANK_COMMENT
RANK_DECISION	Decision for rank.	VARCHAR2(63)	PERRANK	PERRANK_DECISION
RANK_DECISION_DATE	Decision date for rank.	DATE	PERRANK	PERRANK_DECISION_DATE
RANK_DECISION_DEFERRAL_DATE	Decision deferred to date.	DATE	PERRANK	PERRANK_DECISION_DEFER_DATE
RANK_DECISION_DESC	Rank decision description.	VARCHAR2(255)	CALCULATION	DECODE(PERRANK_DECISION)
RANK_DESC	Rank code description.	VARCHAR2(255)	PTRRANK	PTRRANK_DESC
RANK_EMERITUS_STATUS	Emeritue status.	VARCHAR2(63)	PERRANK	PERRANK_EMERITUS_STATUS
RANK_JOB_SUFFIX	Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.	VARCHAR2(63)	PERRANK	PERRANK_SUFF
RANK_NEXT_REVIEW_DATE	Rank next review Date.	DATE	PERRANK	PERRANK_NEXT_DATE
RANK_ORGANIZATION_CODE	Organization code.	VARCHAR2(63)	PERRANK	PERRANK_ORGN
RANK_ORGANIZATION_DESC	Organization code desc.	VARCHAR2(255)	PTVORGN	PTVORGN_DESC
RANK_POSITION	Employee position number.	VARCHAR2(63)	PERRANK	PERRANK_POSN
RANK_POSITION_TITLE	Employee position description.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC
RANK_TIMESHEET_CHART	Chart of accounts code as defined by the Banner Finance system.	VARCHAR2(63)	PERRANK	PERRANK_COAS_CODE
RANK_TIMESHEET_CHART_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
SABBATICAL_ACTION_DATE	Action Date.	DATE	PERSABB	PERSABB_ACTION_DATE
SABBATICAL_APPEAL_DATE	Sabbatical/leave appeal date.	DATE	PERSABB	PERSABB_APPEAL_DATE
SABBATICAL_BEGIN_DATE	Sabbatical/leave requested from date.	DATE	PERSABB	PERSABB_BEGIN_DATE
SABBATICAL_CHART_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
SABBATICAL_COMMENT	Sabbatical/leave comments.	VARCHAR2(4000)	PERSABB	PERSABB_COMMENT
SABBATICAL_DECISION	Sabbatical approval decision.	VARCHAR2(63)	PERSABB	PERSABB_DECISION
SABBATICAL_DECISION_DATE	Date of sabbatical/leave decision.	DATE	PERSABB	PERSABB_DECISION_DATE
SABBATICAL_DECISION_DEFER_DATE	Sabbatical/leave decision deferred to date.	DATE	PERSABB	PERSABB_DECISION_DEFER_DATE
SABBATICAL_DECISION_DESC	Sabbatical approval decision description.	VARCHAR2(255)	CALCULATION	DECODE(PERSABB_DECISION)
SABBATICAL_DEFER_BEGIN	Approved sabbatical/leave begin date.	DATE	PERSABB	PERSABB_DEFER_BEGIN
SABBATICAL_DEFER_END	Approved sabbatical/leave end date.	DATE	PERSABB	PERSABB_DEFER_END
SABBATICAL_END_DATE	Sabbatical/leave requested To date.	DATE	PERSABB	PERSABB_END_DATE
SABBATICAL_JOB_SUFFIX	Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.	VARCHAR2(63)	PERSABB	PERSABB_SUFF
SABBATICAL_NEXT_DATE	Sabbatical next eligibility date.	DATE	PERSABB	PERSABB_NEXT_DATE
SABBATICAL_ORGANIZATION_CODE	Organization code.	VARCHAR2(63)	PERSABB	PERSABB_ORGN
SABBATICAL_ORGANIZATION_DESC	Organization code desc.	VARCHAR2(255)	FTVORGN PTVORGN	FTVORGN_DESC PTVORGN_DESC
SABBATICAL_POSITION	Employee position number.	VARCHAR2(63)	PERSABB	PERSABB_POSN
SABBATICAL_POSITION_TITLE	Employee position description.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC
SABBATICAL_REASON	Sabbatical/leave reason code.	VARCHAR2(63)	PERSABB	PERSABB_LREA_CODE
SABBATICAL_REASON_DESC	Sabbatical/leave reason description.	VARCHAR2(255)	PTRLREA	PTRLREA_DESC
SABBATICAL_TIMESHEET_CHART	Chart of Accounts Code.	VARCHAR2(63)	PERSABB	PERSABB_COAS_CODE
SABBATICAL_TYPE	Classifies the type of sabbatical which is being tracked on this leave action.	VARCHAR2(63)	PERSABB	PERSABB_SBTY_CODE
SABBATICAL_TYPE_DESC	Sabbatical/leave type description.	VARCHAR2(255)	PTVSBTY	PTVSBTY_DESC
STATE_PROVINCE_OF_BIRTH	Birth State.	VARCHAR2(63)	PERBFAC	PERBFAC_BIRTH_STATE
TENURE	Identifies whether this faculty or academic member of staff has tenure.	VARCHAR2(63)	PERAPPT	PERAPPT_TENURE_CODE
TENURE_CREDIT	Tenure credit this appointment.	NUMBER	PERAPPT	PERAPPT_CREDIT
TENURE_DESC	Tenure description.	VARCHAR2(255)	PTRTENR	PTRTENR_DESC
TENURE_EFFECTIVE_DATE	Date of the faculty tenure.	DATE	PERAPPT	PERAPPT_TENURE_EFF_DATE
TENURE_FULL_TIME_EQUIVALENCY	Full Time Equivalency of Tenure for employee by department granting tenure.	NUMBER	PERAPPT	PERAPPT_TENURE_FTE
TENURE_REVIEW	Tenure review code.	VARCHAR2(63)	PERAPPT	PERAPPT_REVT_TENURE_CODE
TENURE_REVIEW_DATE	Tenure review date.	DATE	PERAPPT	PERAPPT_TENURE_REV_DATE
TENURE_REVIEW_DESC	Tenure review code description.	VARCHAR2(255)	PTVREVT	PTVREVT_DESC
TENURE_TRACKING_BEGIN_DATE	Date when tenure tracking started.	DATE	PERAPPT	PERAPPT_TENURE_TRAC_BEGIN_DATE
TERMINAL_APPOINTMENT_IND	Terminal appointment.	VARCHAR2(63)	PERAPPT	PERAPPT_TERMINAL_APPT

Ver: 9.1