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

Banner Operational Data Store
Composite View Target: AN_SUPERVISOR

Description Provides information about employees' supervisors by first selecting the specific job data from the Assignment Repeating Table but when it is blank using a function to select the person who has an assignment that equals the position noted as the supervisor for the Postion Definition or base table. Note if supervisor job assignments are being maintained on the Assignment Repeating Table, they will be available and display even when the supervisor on the assignment record has been terminated. Data derived using the Position Definition will exclude terminated job assignments when displaying a current supervisor on the Employee reporting view. Employee Postion will contain all assignment records with their status including those where either the employee and or the supervisor are terminated.

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

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: