Target Column	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
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
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
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
ORGANIZATION_CODE	Organization code.	VARCHAR2(63)	PERRANK	PERRANK_ORGN
ORGANIZATION_DESC	Organization code desc.	VARCHAR2(255)	FTVORGN PTVORGN	FTVORGN_DESC PTVORGN_DESC
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PERRANK	PERRANK_PIDM
POSITION	Employee position number.	VARCHAR2(63)	PERRANK	PERRANK_POSN
POSITION_TITLE	Employee position description.	VARCHAR2(255)	NBRJOBS	NBRJOBS_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)	FUNCTION	GOKODSF.F_GET_DESC
RANK_DESC	Rank code description.	VARCHAR2(255)	PTRRANK	PTRRANK_DESC
RANK_EMERITUS_STATUS	Emeritue status.	VARCHAR2(63)	PERRANK	PERRANK_EMERITUS_STATUS
RANK_NEXT_REVIEW_DATE	Rank next review Date.	DATE	PERRANK	PERRANK_NEXT_DATE
TIMESHEET_CHART_DESC	Chart of accounts code description or title.	VARCHAR2(255)	FTVCOAS	FTVCOAS_TITLE
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet chart of accounts.	VARCHAR2(63)	PERRANK	PERRANK_COAS_CODE

Ver: 8.1