Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
COMMITMENT_FULFILL_DATE	Sabbatical/leave commitment fulfillment date.	DATE	PERSABB	PERSABB_COMM_FULL_DATE	NO	NO
COMMITMENT_FULFILL_DUE_DATE	Sabbatical/leave commitment fulfillment due date.	DATE	PERSABB	PERSABB_COMM_FULL_DUE_DATE	NO	NO
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	NO	NO
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	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
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	NO	NO
NEXT_SABBATICAL_REASON_DESC	Next sabbatical/leave type description.	VARCHAR2(255)	PTRLREA	PTRLREA_DESC	NO	NO
ORGANIZATION_CODE	Organization code.	VARCHAR2(63)	PERSABB	PERSABB_ORGN	NO	NO
ORGANIZATION_DESC	Organization code desc.	VARCHAR2(255)	FTVORGN PTVORGN	FTVORGN_DESC PTVORGN_DESC	NO NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERSABB	PERSABB_PIDM	NO	NO
POSITION	Employee position number.	VARCHAR2(63)	PERSABB	PERSABB_POSN	NO	NO
POSITION_TITLE	Employee position description.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
SABBATICAL_ACTION_DATE	Action Date.	DATE	PERSABB	PERSABB_ACTION_DATE	NO	NO
SABBATICAL_APPEAL_DATE	Sabbatical/leave appeal date.	DATE	PERSABB	PERSABB_APPEAL_DATE	NO	NO
SABBATICAL_BEGIN_DATE	Sabbatical/leave requested from date.	DATE	PERSABB	PERSABB_BEGIN_DATE	NO	NO
SABBATICAL_COMMENT	Sabbatical/leave comments.	VARCHAR2(4000)	PERSABB	PERSABB_COMMENT	NO	NO
SABBATICAL_DECISION	Sabbatical approval decision.	VARCHAR2(63)	PERSABB	PERSABB_DECISION	NO	NO
SABBATICAL_DECISION_DATE	Date of sabbatical/leave decision.	DATE	PERSABB	PERSABB_DECISION_DATE	NO	NO
SABBATICAL_DECISION_DEFER_DATE	Sabbatical/leave decision deferred to date.	DATE	PERSABB	PERSABB_DECISION_DEFER_DATE	NO	NO
SABBATICAL_DECISION_DESC	Sabbatical approval decision description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
SABBATICAL_DEFER_BEGIN	Approved sabbatical/leave begin date.	DATE	PERSABB	PERSABB_DEFER_BEGIN	NO	NO
SABBATICAL_DEFER_END	Approved sabbatical/leave end date.	DATE	PERSABB	PERSABB_DEFER_END	NO	NO
SABBATICAL_END_DATE	Sabbatical/leave requested To date.	DATE	PERSABB	PERSABB_END_DATE	NO	NO
SABBATICAL_NEXT_DATE	Sabbatical next eligibility date.	DATE	PERSABB	PERSABB_NEXT_DATE	NO	NO
SABBATICAL_REASON	Sabbatical/leave reason code.	VARCHAR2(63)	PERSABB	PERSABB_LREA_CODE	NO	NO
SABBATICAL_REASON_DESC	Sabbatical/leave reason description.	VARCHAR2(255)	PTRLREA	PTRLREA_DESC	NO	NO
SABBATICAL_TYPE	Classifies the type of sabbatical which is being tracked on this leave action.	VARCHAR2(63)	PERSABB	PERSABB_SBTY_CODE	NO	NO
SABBATICAL_TYPE_DESC	Sabbatical/leave type description.	VARCHAR2(255)	PTVSBTY	PTVSBTY_DESC	NO	NO
TIMESHEET_CHART_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE	NO	NO
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet chart of accounts.	VARCHAR2(63)	PERSABB	PERSABB_COAS_CODE	NO	NO

Ver: 9.2