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
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
INITIAL_RANK_IND	Rank initial record indicator.	VARCHAR2(63)	PERRANK	PERRANK_INITIAL	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)	PERRANK	PERRANK_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
ORGANIZATION_CODE	Organization code.	VARCHAR2(63)	PERRANK	PERRANK_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	PERRANK	PERRANK_PIDM	NO	NO
POSITION	Employee position number.	VARCHAR2(63)	PERRANK	PERRANK_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
RANK	Rank code.	VARCHAR2(63)	PERRANK	PERRANK_RANK_CODE	NO	NO
RANK_ACADEMIC_TITLE	Academic title.	VARCHAR2(255)	PERRANK	PERRANK_ACADEMIC_TITLE	NO	NO
RANK_ACTION_DATE	Rank action date.	DATE	PERRANK	PERRANK_ACTION_DATE	NO	NO
RANK_APPEAL_DATE	Appeal date.	DATE	PERRANK	PERRANK_APPEAL_DATE	NO	NO
RANK_BEGIN_DATE	Rank effective date.	DATE	PERRANK	PERRANK_BEGIN_DATE	NO	NO
RANK_COMMENT	Rank comments.	VARCHAR2(4000)	PERRANK	PERRANK_COMMENT	NO	NO
RANK_DECISION	Decision for rank.	VARCHAR2(63)	PERRANK	PERRANK_DECISION	NO	NO
RANK_DECISION_DATE	Decision date for rank.	DATE	PERRANK	PERRANK_DECISION_DATE	NO	NO
RANK_DECISION_DEFERRAL_DATE	Decision deferred to date.	DATE	PERRANK	PERRANK_DECISION_DEFER_DATE	NO	NO
RANK_DECISION_DESC	Rank decision description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
RANK_DESC	Rank code description.	VARCHAR2(255)	PTRRANK	PTRRANK_DESC	NO	NO
RANK_EMERITUS_STATUS	Emeritue status.	VARCHAR2(63)	PERRANK	PERRANK_EMERITUS_STATUS	NO	NO
RANK_NEXT_REVIEW_DATE	Rank next review Date.	DATE	PERRANK	PERRANK_NEXT_DATE	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)	PERRANK	PERRANK_COAS_CODE	NO	NO

Ver: 9.2