RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE Operational Data Store
Reporting View Target: FACULTY_RANK_HISTORY

Description Provides historical information about faculty rankings.
Key & Frequency One row per person per action date.
Recommended Search Columns PERSON_UID, RANK_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

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_RANK_IND Rank initial record indicator. VARCHAR2(63)

PERRANK

PERRANK_INITIAL

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)

PERRANK

PERRANK_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)

PERRANK

PERRANK_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

PERRANK

PERRANK_PIDM

POSITION Employee position number. VARCHAR2(63)

PERRANK

PERRANK_POSN

POSITION_TITLE Employee position description. VARCHAR2(255)

NBRJOBS

NBRJOBS_DESC

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

NA

NA

RANK Rank code. VARCHAR2(63)

PERRANK

PERRANK_RANK_CODE

RANK_ACADEMIC_TITLE Academic title. VARCHAR2(255)

PERRANK

PERRANK_ACADEMIC_TITLE

RANK_ACTION_DATE Rank action date. DATE

PERRANK

PERRANK_ACTION_DATE

RANK_APPEAL_DATE Appeal date. DATE

PERRANK

PERRANK_APPEAL_DATE

RANK_BEGIN_DATE Rank effective date. DATE

PERRANK

PERRANK_BEGIN_DATE

RANK_COMMENT Rank comments. VARCHAR2(4000)

PERRANK

PERRANK_COMMENT

RANK_DECISION Decision for rank. VARCHAR2(63)

PERRANK

PERRANK_DECISION

RANK_DECISION_DATE Decision date for rank. DATE

PERRANK

PERRANK_DECISION_DATE

RANK_DECISION_DEFERRAL_DATE Decision deferred to date. DATE

PERRANK

PERRANK_DECISION_DEFER_DATE

RANK_DECISION_DESC Rank decision description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

RANK_DESC Rank code description. VARCHAR2(255)

PTRRANK

PTRRANK_DESC

RANK_EMERITUS_STATUS Emeritue status. VARCHAR2(63)

PERRANK

PERRANK_EMERITUS_STATUS

RANK_NEXT_REVIEW_DATE Rank next review Date. DATE

PERRANK

PERRANK_NEXT_DATE

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)

PERRANK

PERRANK_COAS_CODE



Ver: 3.1