Reporting View Source: PERAPPT

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: PERAPPT Human Resources Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
PERAPPT_ACTION_DATE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_ACTION_DATE APPOINTMENT_ACTION_DATE
PERAPPT_APPEAL_DATE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPEAL_DATE APPEAL_DATE
PERAPPT_APPT_EFF_DATE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_EFFECTIVE_DATE APPOINTMENT_EFFECTIVE_DATE
PERAPPT_BEGIN_DATE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_BEGIN_DATE APPOINTMENT_BEGIN_DATE
PERAPPT_COMMENT	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_COMMENTS APPOINTMENT_COMMENTS
PERAPPT_CREDIT	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_CREDIT TENURE_CREDIT
PERAPPT_DECISION	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_DECISION APPOINTMENT_DECISION
PERAPPT_DECISION_DATE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_DECISION_DATE APPOINTMENT_DECISION_DATE
PERAPPT_DECISION_DEFER_DATE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINT_DECISION_DEFERRAL_DATE APPOINT_DECISION_DEFERRAL_DATE
PERAPPT_DISP_CODE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_DISCIPLINE APPOINTMENT_DISCIPLINE
PERAPPT_END_DATE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_END_DATE APPOINTMENT_END_DATE
PERAPPT_FTYP_CODE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_FACULTY_TYPE APPOINTMENT_FACULTY_TYPE
PERAPPT_INITIAL_TENURE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	INITIAL_TENURE_IND INITIAL_TENURE_IND
PERAPPT_NEXT_DATE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_NEXT_REVIEW_DATE APPOINTMENT_NEXT_REVIEW_DATE
PERAPPT_PIDM	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	PERSON_UID PERSON_UID
PERAPPT_PREV_GRT_TENR	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	PREVIOUS_TENURE_GRANT PREVIOUS_TENURE_GRANT
PERAPPT_REVT_REAPP_CODE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_REVIEW APPOINTMENT_REVIEW
PERAPPT_REVT_TENURE_CODE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_REVIEW TENURE_REVIEW
PERAPPT_TENURE_CODE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	TENURE TENURE
PERAPPT_TENURE_EFF_DATE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_EFFECTIVE_DATE TENURE_EFFECTIVE_DATE
PERAPPT_TENURE_FTE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_FULL_TIME_EQUIVALENCY TENURE_FULL_TIME_EQUIVALENCY
PERAPPT_TENURE_REV_DATE	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	TENURE_REVIEW_DATE TENURE_REVIEW_DATE
PERAPPT_TENURE_TRAC_BEGIN_DATE	PEAFACT	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_TRACKING_BEGIN_DATE TENURE_TRACKING_BEGIN_DATE
PERAPPT_TERMINAL_APPT	PEAFACT	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	TERMINAL_APPOINTMENT_IND TERMINAL_APPOINTMENT_IND

Ver: 8.3