RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_LEAVE_ACCRUAL

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(3)    
PERSON_UID System generated unique internal identification number assigned to this person. NUMBER(8)    
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(6, 2)    
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(6, 2)    
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)    


Ver: 3.1