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.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

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

NA

NA

 
MIF_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

NA

NA

 
POSITION_HIGH_SALARY_RATE High end of the range for the salary table and grade being defined.    

NTRSALB

NTRSALB_HIGH

 
POSITION_LOW_SALARY_RATE Low end of the range for the salary table and grade being defined.    

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.    

NTRSALB

NTRSALB_MIDPOINT

 
SALARY_GRADE Salary grade associated with the salary table being defined.    

NTRSALB

NTRSALB_GRADE

 
SALARY_GROUP Group code associated with a set of salary tables and grades.    

NTRSALB

NTRSALB_SGRP_CODE

 
SALARY_GROUP_DESC Salary group description.    

FUNCTION

GOKODSF.F_GET_DESC

 
SALARY_RATE_IND Indicates if the salaries/rates being defined are hourly rates or annual salaries.    

NTRSALB

NTRSALB_IND

 
SALARY_TABLE Salary table being defined.    

NTRSALB

NTRSALB_TABLE

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

NA

NA

 


Ver: 8.3