Go To View:  RETURN TO COMPOSITE VIEW 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 Definition Database Data Type 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: 8.0