Composite View Target: AP_LEAVE

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_ACCRUAL

Description Contains leave accrual information specific to each payroll.

Target Column Business Definition Database Data Type Source Name Source Column

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

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 to this record. Institution defined. VARCHAR2(6)

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(6)

LEAVE Code identifying the type of leave accrued during the payroll period. VARCHAR2(4)

LEAVE_DESC Leave description. VARCHAR2(30)

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

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

PAYROLL_CALCULATION_TYPE Indicates if the pay event was calculated manually or by the system. VARCHAR2(1)

PAYROLL_CALCULATION_TYPE_DESC Pay event calculation description. VARCHAR2(30)

PAYROLL_IDENTIFIER Pay identification code to which this Employee_Position belongs. VARCHAR2(2)

PAYROLL_IDENTIFIER_DESC Payroll identification code description. VARCHAR2(30)

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

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

POSITION Employee Position number. VARCHAR2(6)

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

POSITION_TITLE Description of the Employee_Position. Defaults from the position title if left blank. VARCHAR2(30)

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

TIME_BANKED_IND Indicates if hours accrued are to be banked. VARCHAR2(1)

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

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

Ver:

Target Column	Business Definition	Database Data Type	Source Name	Source Column
CALENDAR_YEAR	The Calendar Year associated with the Payroll Identifier.	VARCHAR2(4)
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 to this record. Institution defined.	VARCHAR2(6)
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(6)
LEAVE	Code identifying the type of leave accrued during the payroll period.	VARCHAR2(4)
LEAVE_DESC	Leave description.	VARCHAR2(30)
MAXIMUM_HOURS	The maximum leave hours an employee will be allowed to take.	NUMBER
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)
PAYROLL_CALCULATION_TYPE	Indicates if the pay event was calculated manually or by the system.	VARCHAR2(1)
PAYROLL_CALCULATION_TYPE_DESC	Pay event calculation description.	VARCHAR2(30)
PAYROLL_IDENTIFIER	Pay identification code to which this Employee_Position belongs.	VARCHAR2(2)
PAYROLL_IDENTIFIER_DESC	Payroll identification code description.	VARCHAR2(30)
PAYROLL_NUMBER	The Pay Number is used to uniquely identify a pay period within a fiscal year.	NUMBER
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER
POSITION	Employee Position number.	VARCHAR2(6)
POSITION_BEGIN_DATE	Date an Employee_Position became effective in the payroll system.	DATE
POSITION_TITLE	Description of the Employee_Position. Defaults from the position title if left blank.	VARCHAR2(30)
TIME_ACCRUED	Number of hours accrued during the current pay period.	NUMBER
TIME_BANKED_IND	Indicates if hours accrued are to be banked.	VARCHAR2(1)
TIME_TAKEN	Number of hours taken during the current pay period.	NUMBER
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)