Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AP_PAYROLL_EARNING

Description Contains earnings 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   DATE    
DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)    
EARNINGS Earnings Code. VARCHAR2(3)    
EARNINGS_AMOUNT Amount Associated with the Earn Code. NUMBER(12, 2)    
EARNINGS_DESC Earnings code long description. VARCHAR2(30)    
EMPLOYEE_CLASS_TYPE Identifies a type of employee class that is potentially eligible for a shift premium. VARCHAR2(4)    
EMPLOYEE_CLASS_TYPE_DESC Employee Class type code description. VARCHAR2(30)    
EMPLOYMENT_INSURANCE_HOURS Hours reportable for employment insurance purposes. For example, Canadian Employment Insurance deemed hours. NUMBER(6, 2)    
EVENT_SEQUENCE_NUMBER Sequence of the pay event. NUMBER(2)    
HOURLY_RATE Rate of pay for this earnings code. NUMBER(12, 6)    
HOURLY_SPECIAL_RATE Contains rate if special rate is required for this earnings code NUMBER(12, 6)    
HOURS Total hours for this employee for this earnings code during this pay period. NUMBER(6, 2)    
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(2)    
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_IDENTIFIER Pay identification number to which this Employee_Position belongs. VARCHAR2(2)    
PAYROLL_IDENTIFIER_DESC Payroll code description or title. 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)    
REDISTRIBUTION_IND Indicates when earnings have been redistributed. VARCHAR2(1)    
SENIORITY_ACCRUED_IND Denotes whether the earned hours will be included in the seniority hours. VARCHAR2(1)    
SHIFT_NUMBER Identifies a time period during which the employee works. VARCHAR2(1)    
SHIFT_PREMIUM_AMOUNT The additional amount (above their regular rate) an employee will earn when working this shift number. NUMBER    
SHIFT_PREMIUM_PERCENT The additional percent (above their regular rate) an employee will earn when working this shift number. NUMBER    
TIMESHEET_CHART_DESC Chart of accounts code description or title. VARCHAR2(35)    
TIMESHEET_CHART_OF_ACCOUNTS Timesheet chart of accounts. VARCHAR2(1)    
TIMESHEET_METHOD Indicates the type of time reporting document that is generated for this employee. VARCHAR2(1)    
TIMESHEET_METHOD_DESC Timesheet method description. VARCHAR2(30)    
TIMESHEET_ORGANIZATION Organization to which the time sheet for this position is sent. VARCHAR2(6)    
TIMESHEET_ORGANIZATION_DESC Organization to which this Employee_Positions time sheet is sent. VARCHAR2(35)    
ZONE_VALUE Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)    


Ver: 8.0