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

SGHE Banner Operational Data Store
Composite View Target: AP_LEAVE_BALANCE

Description Source composite view contains leave balance information relating to an employee.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
BANKED_HOURS Number of hours banked for employee's leaves. The amount of leave banked for this leave code and this job.    

PERJLEV

PERLEAV

PERJLEV_HRS_BANKED

PERLEAV_HRS_BANKED

 
BEGINNING_BALANCE Leave balance at the beginning of the year.    

PERJLEV

PERLEAV

PERJLEV_BEGIN_BALANCE

PERLEAV_BEGIN_BALANCE

 
CURRENT_DATE System current date (sysdate) or date the data was extracted.    

NA

SYSDATE

 
DATE_LEAVE_AVAILABLE Date leave becomes available for employee.    

PERJLEV

PERLEAV

PERJLEV_DATE_AVAIL

PERLEAV_DATE_AVAIL

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

NA

NA

 
LEAVE Code identifying the type of leave.    

PERJLEV

PERLEAV

PERJLEV_LEAV_CODE

PERLEAV_LEAV_CODE

 
LEAVE_DESC Leave description.    

FUNCTION

GOKODSF.F_GET_DESC

 
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

 
PERSON_UID System generated, unique, internal identification number assigned to this person.    

PERJLEV

PERLEAV

PERJLEV_PIDM

PERLEAV_PIDM

 
POSITION Position Number of the Assignment.    

PERJLEV

PERJLEV_POSN

 
SUFFIX Suffix of the Assignment.    

PERJLEV

PERJLEV_SUFF

 
TIME_ACCRUED Amount of leave accrued.    

PERJLEV

PERLEAV

PERJLEV_ACCRUED

PERLEAV_ACCRUED

 
TIME_TAKEN Amount of leave taken this year.    

PERJLEV

PERLEAV

PERJLEV_TAKEN

PERLEAV_TAKEN

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

NA

NA

 


Ver: 8.3