Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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)		NA	NA
ACADEMIC_TITLE	Academic Title	Name for the academic staff member title or position at the institution.	VARCHAR2(80)		PERBFAC	PERBFAC_ACADEMIC_TITLE
COMMITMENT_FULFILL_DATE	Commitment Fulfill Date	Sabbatical/leave commitment fulfillment date.	DATE		PERSABB	PERSABB_COMM_FULL_DATE
COMMITMENT_FULFILL_DUE_DATE	Commitment Fulfill Due Date	Sabbatical/leave commitment fulfillment due date.	DATE		PERSABB	PERSABB_COMM_FULL_DUE_DATE
CURRENT_DATE	Current Date	System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA
EMERITUS_STATUS_IND	Emeritus Status Indicator	Emeritus Status.	VARCHAR2(1)		PERBFAC	PERBFAC_EMERITUS_STATUS
FACULTY_TYPE	Faculty Type	Faculty Type Code.	VARCHAR2(6)		PERBFAC	PERBFAC_FTYP_CODE
FACULTY_TYPE_DESC	Faculty Type Description	Description of the faculty type code.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
JOB_SUFFIX	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(2)		PERSABB	PERSABB_SUFF
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
NEXT_SABBATICAL_REASON	Next Sabbatical Reason	Type of academic sabbatical/leave the faculty member is eligible to take in the future.	VARCHAR2(2)		PERSABB	PERSABB_LREA_CODE_NEXT
NEXT_SABBATICAL_REASON_DESC	Next Sabbatical Reason Description	Next sabbatical/leave type description.	VARCHAR2(30)		PTRLREA	PTRLREA_DESC
ORGANIZATION_CODE	Organization Code	Organization code.	VARCHAR2(6)		PERSABB	PERSABB_ORGN
ORGANIZATION_DESC	Organization Description	Organization code desc.	VARCHAR2(35)		FTVORGN	FTVORGN_DESC
ORIGINAL_APPOINT_BEGIN_DATE	Original Appointment Begin Date	Original Appointment Begin Date.	DATE		PERBFAC	PERBFAC_ORIG_BEGIN_DATE
ORIGINAL_APPOINT_END_DATE	Original Appointment End Date	Original Appointment End Date.	DATE		PERBFAC	PERBFAC_ORIG_END_DATE
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		PERSABB	PERSABB_PIDM
POSITION	Position	Employee position number.	VARCHAR2(6)		PERSABB	PERSABB_POSN
POSITION_TITLE	Position Title	Employee position description.	VARCHAR2(30)		NBRJOBS	NBRJOBS_DESC
PREVIOUS_INSTITUTION_CREDIT	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(5, 2)		NA	NA
PRIMARY_ACTIVITY	Primary Activity	Indicates whether the primary activity of the faculty member is instructional, research, or administrative.	VARCHAR2(1)		NA	NA
PRIMARY_ACTIVITY_DESC	Primary Activity Description	Primary Activity description.	VARCHAR2(30)		NA	NA
PRIMARY_DISCIPLINE	Primary Discipline	Primary Discipline Code.	VARCHAR2(6)		PERBFAC	PERBFAC_DISP_CODE
PRIMARY_DISCIPLINE_DESC	Primary Discipline Description	Primary discipline code description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
SABBATICAL_ACTION_DATE	Sabbatical Action Date	Action Date.	DATE		PERSABB	PERSABB_ACTION_DATE
SABBATICAL_APPEAL_DATE	Sabbatical Appeal Date	Sabbatical/leave appeal date.	DATE		PERSABB	PERSABB_APPEAL_DATE
SABBATICAL_BEGIN_DATE	Sabbatical Begin Date	Sabbatical/leave requested from date.	DATE		PERSABB	PERSABB_BEGIN_DATE
SABBATICAL_COMMENT	Sabbatical Comment	Sabbatical/leave comments.	VARCHAR2(4000)		PERSABB	PERSABB_COMMENT
SABBATICAL_DECISION	Sabbatical Decision	Sabbatical approval decision.	VARCHAR2(1)		PERSABB	PERSABB_DECISION
SABBATICAL_DECISION_DATE	Sabbatical Decision Date	Date of sabbatical/leave decision.	DATE		PERSABB	PERSABB_DECISION_DATE
SABBATICAL_DECISION_DEFER_DATE	Sabbatical Decision Deferred Date	Sabbatical/leave decision deferred to date.	DATE		PERSABB	PERSABB_DECISION_DEFER_DATE
SABBATICAL_DECISION_DESC	Sabbatical Decision Description	Sabbatical approval decision description.	VARCHAR2(30)		FUNCTION	GOKODSF.F_GET_DESC
SABBATICAL_DEFER_BEGIN	Sabbatical Deferred Begin	Approved sabbatical/leave begin date.	DATE		PERSABB	PERSABB_DEFER_BEGIN
SABBATICAL_DEFER_END	Sabbatical Deferred End	Approved sabbatical/leave end date.	DATE		PERSABB	PERSABB_DEFER_END
SABBATICAL_END_DATE	Sabbatical End Date	Sabbatical/leave requested To date.	DATE		PERSABB	PERSABB_END_DATE
SABBATICAL_NEXT_DATE	Sabbatical Next Date	Sabbatical next eligibility date.	DATE		PERSABB	PERSABB_NEXT_DATE
SABBATICAL_REASON	Sabbatical Reason	Sabbatical/leave reason code.	VARCHAR2(2)		PERSABB	PERSABB_LREA_CODE
SABBATICAL_REASON_DESC	Sabbatical Reason Description	Sabbatical/leave reason description.	VARCHAR2(30)		PTRLREA	PTRLREA_DESC
SABBATICAL_TYPE	Sabbatical Type	Classifies the type of sabbatical which is being tracked on this leave action.	VARCHAR2(4)		PERSABB	PERSABB_SBTY_CODE
SABBATICAL_TYPE_DESC	Sabbatical Type Description	Sabbatical/leave type description.	VARCHAR2(30)		PTVSBTY	PTVSBTY_DESC
STATE_PROVINCE_OF_BIRTH	State Province Of Birth	State or Province of the faculty's birth place.	VARCHAR2(3)		PERBFAC	PERBFAC_BIRTH_STATE
TIMESHEET_CHART_DESC	Timesheet Chart Description	Chart of accounts code description or title.	VARCHAR2(35)		FTVCOAS	FTVCOAS_TITLE
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart Of Accounts	Timesheet chart of accounts.	VARCHAR2(1)		PERSABB	PERSABB_COAS_CODE
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: