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

SGHE Banner 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 Name Business Definition Database Data Type Domain Value Source Name Source Column
ADMINISTRATIVE_GROUP Administrative Group Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)  

NA

NA

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

PERRANK

PERRANK_INITIAL

JOB_SUFFIX 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 Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)  

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

ORGANIZATION_CODE Organization Code Organization code. VARCHAR2(63)  

PERRANK

PERRANK_ORGN

ORGANIZATION_DESC Organization Description Organization code desc. VARCHAR2(255)  

FTVORGN

PTVORGN

FTVORGN_DESC

PTVORGN_DESC

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

PERRANK

PERRANK_PIDM

POSITION Position Employee position number. VARCHAR2(63)  

PERRANK

PERRANK_POSN

POSITION_TITLE Position Title Employee position description. VARCHAR2(255)  

NBRJOBS

NBRJOBS_DESC

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

NA

NA

RANK Rank Rank code. VARCHAR2(63)  

PERRANK

PERRANK_RANK_CODE

RANK_ACADEMIC_TITLE Rank Academic Title Academic title. VARCHAR2(255)  

PERRANK

PERRANK_ACADEMIC_TITLE

RANK_ACTION_DATE Rank Action Date Rank action date. DATE  

PERRANK

PERRANK_ACTION_DATE

RANK_APPEAL_DATE Rank Appeal Date Appeal date. DATE  

PERRANK

PERRANK_APPEAL_DATE

RANK_BEGIN_DATE Rank Begin Date Rank effective date. DATE  

PERRANK

PERRANK_BEGIN_DATE

RANK_COMMENT Rank Comment Rank comments. VARCHAR2(4000)  

PERRANK

PERRANK_COMMENT

RANK_DECISION Rank Decision Decision for rank. VARCHAR2(63)  

PERRANK

PERRANK_DECISION

RANK_DECISION_DATE Rank Decision Date Decision date for rank. DATE  

PERRANK

PERRANK_DECISION_DATE

RANK_DECISION_DEFERRAL_DATE Rank Decision Deferral Date Decision deferred to date. DATE  

PERRANK

PERRANK_DECISION_DEFER_DATE

RANK_DECISION_DESC Rank Decision Description Rank decision description. VARCHAR2(255)  

FUNCTION

GOKODSF.F_GET_DESC

RANK_DESC Rank Description Rank code description. VARCHAR2(255)  

PTRRANK

PTRRANK_DESC

RANK_EMERITUS_STATUS Rank Emeritus Status Emeritue status. VARCHAR2(63)  

PERRANK

PERRANK_EMERITUS_STATUS

RANK_NEXT_REVIEW_DATE Rank Next Review Date Rank next review Date. DATE  

PERRANK

PERRANK_NEXT_DATE

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

FTVCOAS

FTVCOAS_TITLE

TIMESHEET_CHART_OF_ACCOUNTS Timesheet Chart Of Accounts Timesheet chart of accounts. VARCHAR2(63)  

PERRANK

PERRANK_COAS_CODE



Ver: 9.0