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