Composite View Target: AP_PAYROLL

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_PAYROLL_EARNING

Description Contains earnings information specific to each payroll.

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

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

CURRENT_DATE Current Date DATE

DOMAIN_VALUE Domain Value Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)

EARNINGS Earnings Earnings Code. VARCHAR2(3)

EARNINGS_AMOUNT Earnings Amount Amount Associated with the Earn Code. NUMBER(12, 2)

EARNINGS_DESC Earnings Description Earnings code long description. VARCHAR2(30)

EMPLOYEE_CLASS_TYPE 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 Description Employee Class type code description. VARCHAR2(30)

EMPLOYMENT_INSURANCE_HOURS Employment Insurance Hours Hours reportable for employment insurance purposes. For example, Canadian Employment Insurance deemed hours. NUMBER(6, 2)

EVENT_SEQUENCE_NUMBER Event Sequence Number Sequence of the pay event. NUMBER(2)

HOURLY_RATE Hourly Rate Rate of pay for this earnings code. NUMBER(12, 6)

HOURLY_SPECIAL_RATE Hourly Special Rate Contains rate if special rate is required for this earnings code NUMBER(12, 6)

HOURS Hours Total hours for this employee for this earnings code during this pay period. NUMBER(6, 2)

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

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

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

PAYROLL_IDENTIFIER Payroll Identifier Pay identification number to which this Employee_Position belongs. VARCHAR2(2)

PAYROLL_IDENTIFIER_DESC Payroll Identifier Description Payroll code description or title. VARCHAR2(30)

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

PERSON_UID Person UID System generated unique internal identification number assigned to this person. NUMBER(8)

POSITION Position Employee Position number. VARCHAR2(6)

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

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

REDISTRIBUTION_IND Redistribution Indicator Indicates when earnings have been redistributed. VARCHAR2(1)

SENIORITY_ACCRUED_IND Seniority Accrued Indicator Denotes whether the earned hours will be included in the seniority hours. VARCHAR2(1)

SHIFT_NUMBER Shift Number Identifies a time period during which the employee works. VARCHAR2(1)

SHIFT_PREMIUM_AMOUNT Shift Premium Amount The additional amount (above their regular rate) an employee will earn when working this shift number. NUMBER

SHIFT_PREMIUM_PERCENT Shift Premium Percent The additional percent (above their regular rate) an employee will earn when working this shift number. NUMBER

TIMESHEET_CHART_DESC Timesheet Chart Description Chart of accounts code description or title. VARCHAR2(35)

TIMESHEET_CHART_OF_ACCOUNTS Timesheet Chart Of Accounts Timesheet chart of accounts. VARCHAR2(1)

TIMESHEET_METHOD Timesheet Method Indicates the type of time reporting document that is generated for this employee. VARCHAR2(1)

TIMESHEET_METHOD_DESC Timesheet Method Description Timesheet method description. VARCHAR2(30)

TIMESHEET_ORGANIZATION Timesheet Organization Organization to which the time sheet for this position is sent. VARCHAR2(6)

TIMESHEET_ORGANIZATION_DESC Timesheet Organization Description Organization to which this Employee_Positions time sheet is sent. VARCHAR2(35)

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

Ver:

Target Column	Business Name	Business Definition	Database Data Type
CALENDAR_YEAR	Calendar Year	The Calendar Year associated with the Payroll Identifier	VARCHAR2(4)
CURRENT_DATE	Current Date		DATE
DOMAIN_VALUE	Domain Value	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)
EARNINGS	Earnings	Earnings Code.	VARCHAR2(3)
EARNINGS_AMOUNT	Earnings Amount	Amount Associated with the Earn Code.	NUMBER(12, 2)
EARNINGS_DESC	Earnings Description	Earnings code long description.	VARCHAR2(30)
EMPLOYEE_CLASS_TYPE	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 Description	Employee Class type code description.	VARCHAR2(30)
EMPLOYMENT_INSURANCE_HOURS	Employment Insurance Hours	Hours reportable for employment insurance purposes. For example, Canadian Employment Insurance deemed hours.	NUMBER(6, 2)
EVENT_SEQUENCE_NUMBER	Event Sequence Number	Sequence of the pay event.	NUMBER(2)
HOURLY_RATE	Hourly Rate	Rate of pay for this earnings code.	NUMBER(12, 6)
HOURLY_SPECIAL_RATE	Hourly Special Rate	Contains rate if special rate is required for this earnings code	NUMBER(12, 6)
HOURS	Hours	Total hours for this employee for this earnings code during this pay period.	NUMBER(6, 2)
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(2)
MIF_DESC	MIF Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)
MIF_VALUE	MIF Value	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)
PAYROLL_IDENTIFIER	Payroll Identifier	Pay identification number to which this Employee_Position belongs.	VARCHAR2(2)
PAYROLL_IDENTIFIER_DESC	Payroll Identifier Description	Payroll code description or title.	VARCHAR2(30)
PAYROLL_NUMBER	Payroll Number	The Pay Number is used to uniquely identify a pay period within a fiscal year.	NUMBER(3)
PERSON_UID	Person UID	System generated unique internal identification number assigned to this person.	NUMBER(8)
POSITION	Position	Employee Position number.	VARCHAR2(6)
POSITION_BEGIN_DATE	Position Begin Date	Date an Employee_Position became effective in the payroll system.	DATE
POSITION_TITLE	Position Title	Description of the Employee_Position. Defaults from the position title if left blank.	VARCHAR2(30)
REDISTRIBUTION_IND	Redistribution Indicator	Indicates when earnings have been redistributed.	VARCHAR2(1)
SENIORITY_ACCRUED_IND	Seniority Accrued Indicator	Denotes whether the earned hours will be included in the seniority hours.	VARCHAR2(1)
SHIFT_NUMBER	Shift Number	Identifies a time period during which the employee works.	VARCHAR2(1)
SHIFT_PREMIUM_AMOUNT	Shift Premium Amount	The additional amount (above their regular rate) an employee will earn when working this shift number.	NUMBER
SHIFT_PREMIUM_PERCENT	Shift Premium Percent	The additional percent (above their regular rate) an employee will earn when working this shift number.	NUMBER
TIMESHEET_CHART_DESC	Timesheet Chart Description	Chart of accounts code description or title.	VARCHAR2(35)
TIMESHEET_CHART_OF_ACCOUNTS	Timesheet Chart Of Accounts	Timesheet chart of accounts.	VARCHAR2(1)
TIMESHEET_METHOD	Timesheet Method	Indicates the type of time reporting document that is generated for this employee.	VARCHAR2(1)
TIMESHEET_METHOD_DESC	Timesheet Method Description	Timesheet method description.	VARCHAR2(30)
TIMESHEET_ORGANIZATION	Timesheet Organization	Organization to which the time sheet for this position is sent.	VARCHAR2(6)
TIMESHEET_ORGANIZATION_DESC	Timesheet Organization Description	Organization to which this Employee_Positions time sheet is sent.	VARCHAR2(35)
ZONE_VALUE	Zone Value	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)