Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
APPEAL_DATE	Appeal Date	Appeal Date.	DATE		PERAPPT	PERAPPT_APPEAL_DATE
APPOINTMENT_ACTION_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	Appointment Begin Date	This records the offical begin date of the faculty member's appointment or reappointment.	DATE		PERAPPT	PERAPPT_BEGIN_DATE
APPOINTMENT_COMMENTS	Appointment Comments	Appointment comments.	VARCHAR2(4000)		PERAPPT	PERAPPT_COMMENT
APPOINTMENT_DECISION	Appointment Decision	Appointment decision.	VARCHAR2(63)		PERAPPT	PERAPPT_DECISION
APPOINTMENT_DECISION_DATE	Appointment Decision Date	Date of decision.	DATE		PERAPPT	PERAPPT_DECISION_DATE
APPOINTMENT_DECISION_DESC	Appointment Decision Description	Appointment decision description.	VARCHAR2(255)		CALCULATION	DECODE(PERAPPT_DECISION)
APPOINTMENT_DISCIPLINE	Appointment Discipline	Discipline code.	VARCHAR2(63)		PERAPPT	PERAPPT_DISP_CODE
APPOINTMENT_DISCIPLINE_DESC	Appointment Discipline Description	Discipline code description.	VARCHAR2(255)		PTVDISP	PTVDISP_DESC
APPOINTMENT_EFFECTIVE_DATE	Appointment Effective Date	Appointment Effective Date.	DATE		PERAPPT	PERAPPT_APPT_EFF_DATE
APPOINTMENT_END_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	Appointment Faculty Type	Faculty type code.	VARCHAR2(63)		PERAPPT	PERAPPT_FTYP_CODE
APPOINTMENT_FACULTY_TYPE_DESC	Appointment Faculty Type Description	Faculty type code description.	VARCHAR2(255)		PTRFTYP	PTRFTYP_DESC
APPOINTMENT_NEXT_REVIEW_DATE	Appointment Next Review Date	Appointment Next Review Date.	DATE		PERAPPT	PERAPPT_NEXT_DATE
APPOINTMENT_REVIEW	Appointment Review	Appointment review code.	VARCHAR2(63)		PERAPPT	PERAPPT_REVT_REAPP_CODE
APPOINTMENT_REVIEW_DESC	Appointment Review Description	Appointment review code description.	VARCHAR2(255)		PTVREVT	PTVREVT_DESC
APPOINT_DECISION_DEFERRAL_DATE	Appoint Decision Deferral Date	Decision deferred to date.	DATE		PERAPPT	PERAPPT_DECISION_DEFER_DATE
CONTRACT_LENGTH	Contract Length	Contract type for non tenure faculty or those with a tenure track equal to ineligible.	VARCHAR2(63)		PERAPPT	PERAPPT_NON_TENURE_CONTRACT
CONTRACT_LENGTH_DESC	Contract Length Description	Contract type description.	VARCHAR2(255)		MGT_VALIDATION	SELECT SUBSTR (VALUE_DESCRIPTION, 1, 255) FROM MGT_VALIDATION WHERE TABLE_NAME = 'CONTRACT_LENGTH' AND VALUE = CONTRACT_LENGTH
ID	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_TENURE_IND	Initial Tenure Indicator	Initial tenure record.	VARCHAR2(63)		PERAPPT	PERAPPT_INITIAL_TENURE
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(63)		PERAPPT	PERAPPT_SUFF
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	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	Organization code.	VARCHAR2(63)		PERAPPT	PERAPPT_ORGN
ORGANIZATION_DESC	Organization Description	Organization code desc.	VARCHAR2(255)		FTVORGN PTVORGN	FTVORGN_DESC PTVORGN_DESC
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		PERAPPT	PERAPPT_PIDM
POSITION	Position	Employee position number.	VARCHAR2(63)		PERAPPT	PERAPPT_POSN
POSITION_TITLE	Position Title	Employee position description.	VARCHAR2(255)		NBRJOBS	NBRJOBS_DESC
PREVIOUS_TENURE_GRANT	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
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
TENURE	Tenure	Identifies whether this faculty or academic member of staff has tenure.	VARCHAR2(63)		PERAPPT	PERAPPT_TENURE_CODE
TENURE_CREDIT	Tenure Credit	Tenure credit this appointment.	NUMBER		PERAPPT	PERAPPT_CREDIT
TENURE_DESC	Tenure Description	Tenure description.	VARCHAR2(255)		PTRTENR	PTRTENR_DESC
TENURE_EFFECTIVE_DATE	Tenure Effective Date	Tenure effective date.	DATE		PERAPPT	PERAPPT_TENURE_EFF_DATE
TENURE_FULL_TIME_EQUIVALENCY	Tenure Full Time Equivalency	Full Time Equivalency of Tenure for employee by department granting tenure.	NUMBER		PERAPPT	PERAPPT_TENURE_FTE
TENURE_REVIEW	Tenure Review	Tenure review code.	VARCHAR2(63)		PERAPPT	PERAPPT_REVT_TENURE_CODE
TENURE_REVIEW_DATE	Tenure Review Date	Tenure review date.	DATE		PERAPPT	PERAPPT_TENURE_REV_DATE
TENURE_REVIEW_DESC	Tenure Review Description	Tenure review code description.	VARCHAR2(255)		PTVREVT	PTVREVT_DESC
TENURE_TRACKING_BEGIN_DATE	Tenure Tracking Begin Date	Date when tenure tracking started.	DATE		PERAPPT	PERAPPT_TENURE_TRAC_BEGIN_DATE
TERMINAL_APPOINTMENT_IND	Terminal Appointment Indicator	Terminal appointment.	VARCHAR2(63)		PERAPPT	PERAPPT_TERMINAL_APPT
TIMESHEET_CHART_DESC	Timesheet Chart Description	Chart of accounts code description or title.	VARCHAR2(255)		FTVCOAS	FTVCOAS_TITLE
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart Of Accounts	Timesheet chart of accounts.	VARCHAR2(63)		PERAPPT	PERAPPT_COAS_CODE

Ver: 9.0