Reporting View Target: LEAVE

Go To View:	RETURN TO BANNER ODS META DATA REPORTS LIST
	Human Resources Reporting View Reports

Banner Operational Data Store
Reporting View Target: LEAVE_ACCRUAL

Description Contains leave accrual information specific to each payroll.
Key & Frequency One row per payroll identifier per calendar year per payroll number per leave per person or one row per payroll identifier per calendar year per payroll number per leave per position (depending on whether the value in mpt_leave_accrual_position_accrual_indicator = N or Y)
Recommended Search Columns CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID

Target Column Business Name Business Definition Database Data Type Source Name Source Column

ADMINISTRATIVE_GROUP Administrative Group Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

CALENDAR_YEAR Calendar Year The Calendar Year associated with the Payroll Identifier. VARCHAR2(63)
PHRACCR

PHRACCR_YEAR

ID ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

JOB_SUFFIX Job Suffix Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another. VARCHAR2(63)
PHRJACR

PHRJACR_SUFF

LEAVE Leave Code identifying the type of leave accrued during the payroll period. VARCHAR2(63)
PHRACCR

PHRACCR_LEAV_CODE

LEAVE_DESC Leave Description Leave description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

MAXIMUM_HOURS Maximum Hours The maximum leave hours an employee will be allowed to take. NUMBER
PHRJACR

PHRJACR_MAX_HRS

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Name Combination of the person's first, middle initial, and last name into one value. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAYROLL_CALCULATION_TYPE Payroll Calculation Type Indicates if the pay event was calculated manually or by the system. VARCHAR2(63)
PHRACCR

PHRACCR_CALC_GEN_IND

PAYROLL_CALCULATION_TYPE_DESC Payroll Calculation Type Description Pay event calculation description. VARCHAR2(255)
CALCULATION

DECODE(PHRACCR_CALC_GEN_IND)

PAYROLL_IDENTIFIER Payroll Identifier Pay identification code to which this Employee_Position belongs. VARCHAR2(63)
PHRACCR

PHRACCR_PICT_CODE

PAYROLL_IDENTIFIER_DESC Payroll Identifier Description Payroll identification code description. VARCHAR2(255)
FUNCTION

GOKODSF.F_GET_DESC

PAYROLL_NUMBER Payroll Number The Pay Number is used to uniquely identify a pay period within a fiscal year. NUMBER
PHRACCR

PHRACCR_PAYNO

PERSON_UID Person UID System generated unique internal identification number assigned to this person. NUMBER
PHRACCR

PHRACCR_PIDM

POSITION Position Employee Position number. VARCHAR2(63)
PHRJACR

PHRJACR_POSN

POSITION_BEGIN_DATE Position Begin Date Date an Employee_Position became effective in the payroll system. DATE
PHRJACR

PHRJACR_EFFECTIVE_DATE

POSITION_TITLE Position Title Description of the Employee_Position. Defaults from the position title if left blank. VARCHAR2(255)
NBRJOBS

NBRJOBS_DESC

PROCESS_GROUP Process Group Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)
NA

NA

TIME_ACCRUED Time Accrued Number of hours accrued during the current pay period. NUMBER
PHRACCR

PHRACCR_CURR_ACCR

TIME_BANKED_IND Time Banked Indicator Indicates if hours accrued are to be banked. VARCHAR2(63)
PHRACCR

PHRACCR_BANK_IND

TIME_TAKEN Time Taken Number of hours taken during the current pay period. NUMBER
PHRACCR

PHRACCR_CURR_TAKEN

Ver: 9.2

Description	Contains leave accrual information specific to each payroll.
Key & Frequency	One row per payroll identifier per calendar year per payroll number per leave per person or one row per payroll identifier per calendar year per payroll number per leave per position (depending on whether the value in mpt_leave_accrual_position_accrual_indicator = N or Y)
Recommended Search Columns	CALENDAR_YEAR, PAYROLL_IDENTIFIER, PAYROLL_NUMBER, PERSON_UID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
CALENDAR_YEAR	Calendar Year	The Calendar Year associated with the Payroll Identifier.	VARCHAR2(63)	PHRACCR	PHRACCR_YEAR
ID	ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
JOB_SUFFIX	Job Suffix	Suffix allows users to define a job with more precision. For example, a user could denote daytime faculty with one suffix and evening school with another.	VARCHAR2(63)	PHRJACR	PHRJACR_SUFF
LEAVE	Leave	Code identifying the type of leave accrued during the payroll period.	VARCHAR2(63)	PHRACCR	PHRACCR_LEAV_CODE
LEAVE_DESC	Leave Description	Leave description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
MAXIMUM_HOURS	Maximum Hours	The maximum leave hours an employee will be allowed to take.	NUMBER	PHRJACR	PHRJACR_MAX_HRS
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Combination of the person's first, middle initial, and last name into one value.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAYROLL_CALCULATION_TYPE	Payroll Calculation Type	Indicates if the pay event was calculated manually or by the system.	VARCHAR2(63)	PHRACCR	PHRACCR_CALC_GEN_IND
PAYROLL_CALCULATION_TYPE_DESC	Payroll Calculation Type Description	Pay event calculation description.	VARCHAR2(255)	CALCULATION	DECODE(PHRACCR_CALC_GEN_IND)
PAYROLL_IDENTIFIER	Payroll Identifier	Pay identification code to which this Employee_Position belongs.	VARCHAR2(63)	PHRACCR	PHRACCR_PICT_CODE
PAYROLL_IDENTIFIER_DESC	Payroll Identifier Description	Payroll identification code description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
PAYROLL_NUMBER	Payroll Number	The Pay Number is used to uniquely identify a pay period within a fiscal year.	NUMBER	PHRACCR	PHRACCR_PAYNO
PERSON_UID	Person UID	System generated unique internal identification number assigned to this person.	NUMBER	PHRACCR	PHRACCR_PIDM
POSITION	Position	Employee Position number.	VARCHAR2(63)	PHRJACR	PHRJACR_POSN
POSITION_BEGIN_DATE	Position Begin Date	Date an Employee_Position became effective in the payroll system.	DATE	PHRJACR	PHRJACR_EFFECTIVE_DATE
POSITION_TITLE	Position Title	Description of the Employee_Position. Defaults from the position title if left blank.	VARCHAR2(255)	NBRJOBS	NBRJOBS_DESC
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
TIME_ACCRUED	Time Accrued	Number of hours accrued during the current pay period.	NUMBER	PHRACCR	PHRACCR_CURR_ACCR
TIME_BANKED_IND	Time Banked Indicator	Indicates if hours accrued are to be banked.	VARCHAR2(63)	PHRACCR	PHRACCR_BANK_IND
TIME_TAKEN	Time Taken	Number of hours taken during the current pay period.	NUMBER	PHRACCR	PHRACCR_CURR_TAKEN