Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AN_SUPERVISOR

Description Provides information about employees' supervisors.

Target Column Business Definition Database Data Type Source Name Source Column
CURRENT_DATE This is the system current date (sysdate) DATE

NA

SYSDATE

DOMAIN_VALUE Domain column for future use, not currently populated. VARCHAR2(6)

NA

NA

EFFECTIVE_DATE The Date that the Positions record becomes effective. DATE

NBRJOBS

NBRJOBS_EFFECTIVE_DATE

JOB_SUFFIX Position suffix. VARCHAR2(2)

NBRBJOB

NBRBJOB_SUFF

MIF_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)

NA

NA

MIF_VALUE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)

NA

NA

PERSON_UID System generated number that is internally generated to uniquely identify the person. NUMBER(8)

NBRBJOB

NBRBJOB_PIDM

POSITION The position number this position is attached to. VARCHAR2(6)

NBRBJOB

NBRBJOB_POSN

POSITION_CONTRACT_TYPE Indicates whether this is the (P)rimary, (S)econdary, or (O)verload position. VARCHAR2(1)

NBRBJOB

NBRBJOB_CONTRACT_TYPE

POSITION_CONTRACT_TYPE_DESC Indicates whether this is the (P)rimary, (S)econdary, or (O)verload position. VARCHAR2(30)

CALCULATION

DECODE(NBRBJOB_CONTRACT_TYPE, 'P', 'PRIMARY', 'S', 'SECONDARY', 'O', 'OVERLOAD')

POSITION_STATUS The status of the position. Valid values are: A-active, B-leave without pay with benefits, L-leave without pay without benefits, F-leave with full pay and benefits, P-leave with partial pay and benefits, T-terminated. VARCHAR2(1)

NBRJOBS

NBRJOBS_STATUS

POSITION_STATUS_DESC Position Status description. VARCHAR2(40)

CALCULATION

DECODE(NBBPOSN_STATUS,'A',ACTIVE,'C',CANCELLED,'F',FROZEN,'I',INACTIVE)

POSITION_TITLE Description of the position. Defaults from the Position Title if left blank. VARCHAR2(30)

NBRJOBS

NBRJOBS_DESC

SUPERVISOR_JOB_SUFFIX Suffix associated with the supervisors position. VARCHAR2(2)

CALCULATION

NVL(NBRJOBS_SUPERVISOR_SUFF, NOKODSF.F_GET_SUPERVISOR)

SUPERVISOR_POSITION The position number of the supervisor. VARCHAR2(6)

CALCULATION

NVL(NBRJOBS_SUPERVISOR_POSN, NBBPOSN_POSN_REPORTS)

SUPERVISOR_TITLE Title associated with the supervisors position. VARCHAR2(30)

FUNCTION

NOKODSF.F_GET_SUPERVISOR

SUPERVISOR_UID Identification number of the supervisor for this position. NUMBER

CALCULATION

NVL(NBRJOBS_SUPERVISOR_PIDM, NOKODSF.F_GET_SUPERVISOR)

ZONE_VALUE Zone column for future use, not currently populated. VARCHAR2(6)

NA

NA



Ver: 8.0