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

SGHE Banner Operational Data Store
Composite View Target: AN_SALARY_RATE

Description Source composite view contains salary table information for specified salary groups.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
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

POSITION_HIGH_SALARY_RATE   High end of the range for the salary table and grade being defined. NUMBER(13, 4)  

NTRSALB

NTRSALB_HIGH

POSITION_LOW_SALARY_RATE   Low end of the range for the salary table and grade being defined. NUMBER(13, 4)  

NTRSALB

NTRSALB_LOW

POSITION_MID_SALARY_RATE   Midpoint of the salary range being defined. Midpoint is used in the budget roll process for position using the 'sum of the midpoint' method. NUMBER(13, 4)  

NTRSALB

NTRSALB_MIDPOINT

SALARY_GRADE   Salary grade associated with the salary table being defined. VARCHAR2(5)  

NTRSALB

NTRSALB_GRADE

SALARY_GROUP   Group code associated with a set of salary tables and grades. VARCHAR2(6)  

NTRSALB

NTRSALB_SGRP_CODE

SALARY_GROUP_DESC   Salary group description. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

SALARY_RATE_IND   Indicates if the salaries/rates being defined are hourly rates or annual salaries. VARCHAR2(1)  

NTRSALB

NTRSALB_IND

SALARY_TABLE   Salary table being defined. VARCHAR2(2)  

NTRSALB

NTRSALB_TABLE

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

NA

NA



Ver: