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 Reporting View Source: PERAPPT - NULL

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