Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_REVIEW

Description Source composite view contains information pertaining to employee performance reviews.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
COMMENTS   Free form comments recorded for an employee review. VARCHAR2(4000)  

PERREVW

PERREVW_COMMENT

CURRENT_DATE   System current date (sysdate) or date the data was extracted. DATE  

NA

SYSDATE

DOMAIN_VALUE   Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)  

NA

NA

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

NA

NA

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

NA

NA

NEXT_REVIEW_DATE   Next review date. DATE  

FUNCTION

POKODSF.F_NEXT_REVIEW_DATE

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

PERREVW

PERREVW_PIDM

POSITION   Position. VARCHAR2(0)  

NA

NA

POSITION_CLASS   Position class. VARCHAR2(0)  

NA

NA

POSITION_CLASS_DESC   Position class description. VARCHAR2(0)  

NA

NA

POSITION_TITLE   Position description. VARCHAR2(0)  

NA

NA

REVIEWER_UID   Internal identification number of person responsible for the review. NUMBER(8)  

PERREVW

PERREVW_REVIEWER_PIDM

REVIEW_COMPLETED_DATE   Date the review was completed. DATE  

PERREVW

PERREVW_COMPLETED_DATE

REVIEW_DATE   Date this review type is due for completion. DATE  

PERREVW

PERREVW_REVT_DATE

REVIEW_RATING   A user defined rating system for completed review types. VARCHAR2(6)  

PERREVW

PERREVW_REVT_RATING

REVIEW_TYPE   A code identifying the type of review. VARCHAR2(2)  

PERREVW

PERREVW_REVT_CODE

REVIEW_TYPE_COMPLETE_IND   Code used to identify if this review type has been completed. VARCHAR2(1)  

PERREVW

PERREVW_REVT_COMPLETE

REVIEW_TYPE_DESC   Review type description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA



Ver: