Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: FACULTY_APPOINTMENT_HISTORY

Description Provides historical information about faculty appointments.
Key & Frequency One row per person per action date.
Recommended Search Columns PERSON_UID, APPOINTMENT_ACTION_DATE

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
APPEAL_DATE Appeal Date. DATE

PERAPPT

PERAPPT_APPEAL_DATE

NO

NO
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

NO

NO
APPOINTMENT_BEGIN_DATE This records the offical begin date of the faculty member's appointment or reappointment. DATE

PERAPPT

PERAPPT_BEGIN_DATE

NO

NO
APPOINTMENT_COMMENTS Appointment comments. VARCHAR2(4000)

PERAPPT

PERAPPT_COMMENT

NO

NO
APPOINTMENT_DECISION Appointment decision. VARCHAR2(63)

PERAPPT

PERAPPT_DECISION

NO

NO
APPOINTMENT_DECISION_DATE Date of decision. DATE

PERAPPT

PERAPPT_DECISION_DATE

NO

NO
APPOINTMENT_DECISION_DESC Appointment decision description. VARCHAR2(255)

CALCULATION

DECODE(PERAPPT_DECISION)

NO

NO
APPOINTMENT_DISCIPLINE Discipline code. VARCHAR2(63)

PERAPPT

PERAPPT_DISP_CODE

NO

NO
APPOINTMENT_DISCIPLINE_DESC Discipline code description. VARCHAR2(255)

PTVDISP

PTVDISP_DESC

NO

NO
APPOINTMENT_EFFECTIVE_DATE Appointment Effective Date. DATE

PERAPPT

PERAPPT_APPT_EFF_DATE

NO

NO
APPOINTMENT_END_DATE This records the offical end date of the faculty member's appointment or reappointment. DATE

PERAPPT

PERAPPT_END_DATE

NO

NO
APPOINTMENT_FACULTY_TYPE Faculty type code. VARCHAR2(63)

PERAPPT

PERAPPT_FTYP_CODE

NO

NO
APPOINTMENT_FACULTY_TYPE_DESC Faculty type code description. VARCHAR2(255)

PTRFTYP

PTRFTYP_DESC

NO

NO
APPOINTMENT_NEXT_REVIEW_DATE Appointment Next Review Date. DATE

PERAPPT

PERAPPT_NEXT_DATE

NO

NO
APPOINTMENT_REVIEW Appointment review code. VARCHAR2(63)

PERAPPT

PERAPPT_REVT_REAPP_CODE

NO

NO
APPOINTMENT_REVIEW_DESC Appointment review code description. VARCHAR2(255)

PTVREVT

PTVREVT_DESC

NO

NO
APPOINT_DECISION_DEFERRAL_DATE Decision deferred to date. DATE

PERAPPT

PERAPPT_DECISION_DEFER_DATE

NO

NO
CONTRACT_LENGTH Contract type for non tenure faculty or those with a tenure track equal to ineligible. VARCHAR2(63)

PERAPPT

PERAPPT_NON_TENURE_CONTRACT

NO

NO
CONTRACT_LENGTH_DESC 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

NO

NO
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

NO

NO
INITIAL_TENURE_IND Initial tenure record. VARCHAR2(63)

PERAPPT

PERAPPT_INITIAL_TENURE

NO

NO
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

NO

NO
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)

NA

NA

NO

NO
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

NO

NO
NAME Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

NO

NO
ORGANIZATION_CODE Organization code. VARCHAR2(63)

PERAPPT

PERAPPT_ORGN

NO

NO
ORGANIZATION_DESC Organization code desc. VARCHAR2(255)

FTVORGN

PTVORGN

FTVORGN_DESC

PTVORGN_DESC

NO

NO

NO
PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER

PERAPPT

PERAPPT_PIDM

NO

NO
POSITION Employee position number. VARCHAR2(63)

PERAPPT

PERAPPT_POSN

NO

NO
POSITION_TITLE Employee position description. VARCHAR2(255)

NBRJOBS

NBRJOBS_DESC

NO

NO
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

NO

NO
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

NO

NO
TENURE Identifies whether this faculty or academic member of staff has tenure. VARCHAR2(63)

PERAPPT

PERAPPT_TENURE_CODE

NO

NO
TENURE_CREDIT Tenure credit this appointment. NUMBER

PERAPPT

PERAPPT_CREDIT

NO

NO
TENURE_DESC Tenure description. VARCHAR2(255)

PTRTENR

PTRTENR_DESC

NO

NO
TENURE_EFFECTIVE_DATE Tenure effective date. DATE

PERAPPT

PERAPPT_TENURE_EFF_DATE

NO

NO
TENURE_FULL_TIME_EQUIVALENCY Full Time Equivalency of Tenure for employee by department granting tenure. NUMBER

PERAPPT

PERAPPT_TENURE_FTE

NO

NO
TENURE_REVIEW Tenure review code. VARCHAR2(63)

PERAPPT

PERAPPT_REVT_TENURE_CODE

NO

NO
TENURE_REVIEW_DATE Tenure review date. DATE

PERAPPT

PERAPPT_TENURE_REV_DATE

NO

NO
TENURE_REVIEW_DESC Tenure review code description. VARCHAR2(255)

PTVREVT

PTVREVT_DESC

NO

NO
TENURE_TRACKING_BEGIN_DATE Date when tenure tracking started. DATE

PERAPPT

PERAPPT_TENURE_TRAC_BEGIN_DATE

NO

NO
TERMINAL_APPOINTMENT_IND Terminal appointment. VARCHAR2(63)

PERAPPT

PERAPPT_TERMINAL_APPT

NO

NO
TIMESHEET_CHART_DESC Chart of accounts code description or title. VARCHAR2(255)

FTVCOAS

FTVCOAS_TITLE

NO

NO
TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts. VARCHAR2(63)

PERAPPT

PERAPPT_COAS_CODE

NO

NO


Ver: 9.2