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**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
PERAPPT_ACTION_DATE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_ACTION_DATE APPOINTMENT_ACTION_DATE	NA
PERAPPT_APPEAL_DATE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPEAL_DATE APPEAL_DATE	NA
PERAPPT_APPT_EFF_DATE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_EFFECTIVE_DATE APPOINTMENT_EFFECTIVE_DATE	NA
PERAPPT_BEGIN_DATE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_BEGIN_DATE APPOINTMENT_BEGIN_DATE	NA
PERAPPT_COAS_CODE	NA	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_TIMESHEET_CHART TIMESHEET_CHART_OF_ACCOUNTS
PERAPPT_COMMENT	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_COMMENTS APPOINTMENT_COMMENTS	NA
PERAPPT_CREDIT	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_CREDIT TENURE_CREDIT	NA
PERAPPT_DECISION	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_DECISION APPOINTMENT_DECISION	NA
PERAPPT_DECISION_DATE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_DECISION_DATE APPOINTMENT_DECISION_DATE	NA
PERAPPT_DECISION_DEFER_DATE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINT_DECISION_DEFERRAL_DATE APPOINT_DECISION_DEFERRAL_DATE	NA
PERAPPT_DISP_CODE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_DISCIPLINE APPOINTMENT_DISCIPLINE	NA
PERAPPT_END_DATE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_END_DATE APPOINTMENT_END_DATE	NA
PERAPPT_FTYP_CODE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_FACULTY_TYPE APPOINTMENT_FACULTY_TYPE	NA
PERAPPT_INITIAL_TENURE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	INITIAL_TENURE_IND INITIAL_TENURE_IND	NA
PERAPPT_NEXT_DATE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_NEXT_REVIEW_DATE APPOINTMENT_NEXT_REVIEW_DATE	NA
PERAPPT_NON_TENURE_CONTRACT	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY	CONTRACT_LENGTH
PERAPPT_ORGN	NA	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	ORGANIZATION_CODE APPOINTMENT_ORGANIZATION_CODE
PERAPPT_PIDM	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	PERSON_UID PERSON_UID	NA
PERAPPT_POSN	NA	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	POSITION APPOINTMENT_POSITION
PERAPPT_PREV_GRT_TENR	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	PREVIOUS_TENURE_GRANT PREVIOUS_TENURE_GRANT	NA
PERAPPT_REVT_REAPP_CODE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	APPOINTMENT_REVIEW APPOINTMENT_REVIEW	NA
PERAPPT_REVT_TENURE_CODE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_REVIEW TENURE_REVIEW	NA
PERAPPT_SUFF	NA	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	APPOINTMENT_JOB_SUFFIX JOB_SUFFIX
PERAPPT_TENURE_CODE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	TENURE TENURE	NA
PERAPPT_TENURE_EFF_DATE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_EFFECTIVE_DATE TENURE_EFFECTIVE_DATE	NA
PERAPPT_TENURE_FTE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_FULL_TIME_EQUIVALENCY TENURE_FULL_TIME_EQUIVALENCY	NA
PERAPPT_TENURE_REV_DATE	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	TENURE_REVIEW_DATE TENURE_REVIEW_DATE	NA
PERAPPT_TENURE_TRAC_BEGIN_DATE	PEAFACT	REPORTING VIEW	FACULTY_APPOINTMENT_HISTORY FACULTY_TRACKING	TENURE_TRACKING_BEGIN_DATE TENURE_TRACKING_BEGIN_DATE	NA
PERAPPT_TERMINAL_APPT	PEAFACT	REPORTING VIEW	FACULTY_TRACKING FACULTY_APPOINTMENT_HISTORY	TERMINAL_APPOINTMENT_IND TERMINAL_APPOINTMENT_IND	NA

Ver: 9.0