RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE 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
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPEAL_DATE Appeal Date. DATE

PERAPPT

PERAPPT_APPEAL_DATE

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

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

PERAPPT

PERAPPT_BEGIN_DATE

APPOINTMENT_COMMENTS Appointment comments. VARCHAR2(4000)

PERAPPT

PERAPPT_COMMENT

APPOINTMENT_DECISION Appointment decision. VARCHAR2(63)

PERAPPT

PERAPPT_DECISION

APPOINTMENT_DECISION_DATE Date of decision. DATE

PERAPPT

PERAPPT_DECISION_DATE

APPOINTMENT_DECISION_DESC Appointment decision description. VARCHAR2(255)

CALCULATION

DECODE(PERAPPT_DECISION)

APPOINTMENT_DISCIPLINE Discipline code. VARCHAR2(63)

PERAPPT

PERAPPT_DISP_CODE

APPOINTMENT_DISCIPLINE_DESC Discipline code description. VARCHAR2(255)

PTVDISP

PTVDISP_DESC

APPOINTMENT_EFFECTIVE_DATE Appointment Effective Date. DATE

PERAPPT

PERAPPT_APPT_EFF_DATE

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

PERAPPT

PERAPPT_END_DATE

APPOINTMENT_FACULTY_TYPE Faculty type code. VARCHAR2(63)

PERAPPT

PERAPPT_FTYP_CODE

APPOINTMENT_FACULTY_TYPE_DESC Faculty type code description. VARCHAR2(255)

PTRFTYP

PTRFTYP_DESC

APPOINTMENT_NEXT_REVIEW_DATE Appointment Next Review Date. DATE

PERAPPT

PERAPPT_NEXT_DATE

APPOINTMENT_REVIEW Appointment review code. VARCHAR2(63)

PERAPPT

PERAPPT_REVT_REAPP_CODE

APPOINTMENT_REVIEW_DESC Appointment review code description. VARCHAR2(255)

PTVREVT

PTVREVT_DESC

APPOINT_DECISION_DEFERRAL_DATE Decision deferred to date. DATE

PERAPPT

PERAPPT_DECISION_DEFER_DATE

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

INITIAL_TENURE_IND Initial tenure record. VARCHAR2(63)

PERAPPT

PERAPPT_INITIAL_TENURE

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)

FUNCTION

PERAPPT_SUFF

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORGANIZATION_CODE Organization code. VARCHAR2(63)

FUNCTION

PERAPPT_ORGN

ORGANIZATION_DESC Organization code desc. VARCHAR2(255)

FTVORGN

PTVORGN

FTVORGN_DESC

PTVORGN_DESC

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

PERAPPT

PERAPPT_PIDM

POSITION Employee position number. VARCHAR2(63)

FUNCTION

PERAPPT_POSN

POSITION_TITLE Employee position description. VARCHAR2(255)

NBRJOBS

NBRJOBS_DESC

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

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

NA

NA

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

PERAPPT

PERAPPT_TENURE_CODE

TENURE_CREDIT Tenure credit this appointment. NUMBER

PERAPPT

PERAPPT_CREDIT

TENURE_DESC Tenure description. VARCHAR2(255)

PTRTENR

PTRTENR_DESC

TENURE_EFFECTIVE_DATE Tenure effective date. DATE

PERAPPT

PERAPPT_TENURE_EFF_DATE

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

PERAPPT

PERAPPT_TENURE_FTE

TENURE_REVIEW Tenure review code. VARCHAR2(63)

PERAPPT

PERAPPT_REVT_TENURE_CODE

TENURE_REVIEW_DATE Tenure review date. DATE

PERAPPT

PERAPPT_TENURE_REV_DATE

TENURE_REVIEW_DESC Tenure review code description. VARCHAR2(255)

PTVREVT

PTVREVT_DESC

TENURE_TRACKING_BEGIN_DATE Date when tenure tracking started. DATE

PERAPPT

PERAPPT_TENURE_TRAC_BEGIN_DATE

TERMINAL_APPOINTMENT_IND Terminal appointment. VARCHAR2(63)

PERAPPT

PERAPPT_TERMINAL_APPT

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

FTVCOAS

FTVCOAS_TITLE

TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts. VARCHAR2(63)

FUNCTION

PERAPPT_COAS_CODE



Ver: 3.1