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_DEDUCTION

Description Contains payroll deduction information specific to each payroll.

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name

APPLICABLE_GROSS_AMOUNT Total gross compensation toward which deduction is applicable. The applicable gross is arrived at by taking the gross pay and reducing it by the pre-tax deductions and by adding to the gross pay taxable benefits.

ARREARAGE_RECOVERED_AMOUNT The amount of arrearage recovered this pay period.

ARREARAGE_TAKEN_AMOUNT The amount of arrearage generated during this pay period.

CALENDAR_YEAR The Calendar Year associated with the Payroll Identifier

CURRENT_DATE System current date (sysdate) or date the data was extracted.
NA

SYSDATE

DEDUCTION Identifies the specific Benefit/deduction.

DEDUCTION_LONG_DESC Benefit/deduction long description.

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.

EFFECTIVE_DATE The effective date associated with the deduction for this pay period.

EMPLOYEE_DEDUCTION_AMOUNT Employee deduction amount.

EMPLOYER User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas.

EMPLOYER_DEDUCTION_AMOUNT Employer deduction amount.

EMPLOYER_DESC Employer_Code description.

EVENT_SEQUENCE_NUMBER Sequence of the pay event.

MIF_DESC Institution description when the optional multi-institution facility feature has been applied.

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

PAYROLL_IDENTIFIER Pay identification number to which this Employee_Position belongs.

PAYROLL_IDENTIFIER_DESC Payroll code description or title.

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

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

STATUS Status of the deduction.

STATUS_DESC Status description.

TAX_DEDUCTION_IND Indicates if the deduction is a tax deduction.

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

Ver: 8.3

ODS Column	ODS Business Definition	Banner Source Name	Banner Source Column
APPLICABLE_GROSS_AMOUNT	Total gross compensation toward which deduction is applicable. The applicable gross is arrived at by taking the gross pay and reducing it by the pre-tax deductions and by adding to the gross pay taxable benefits.
ARREARAGE_RECOVERED_AMOUNT	The amount of arrearage recovered this pay period.
ARREARAGE_TAKEN_AMOUNT	The amount of arrearage generated during this pay period.
CALENDAR_YEAR	The Calendar Year associated with the Payroll Identifier
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	NA	SYSDATE
DEDUCTION	Identifies the specific Benefit/deduction.
DEDUCTION_LONG_DESC	Benefit/deduction long description.
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
EFFECTIVE_DATE	The effective date associated with the deduction for this pay period.
EMPLOYEE_DEDUCTION_AMOUNT	Employee deduction amount.
EMPLOYER	User-defined code used as part of the Employee_Position definition. It is often used, for example, as a means to identify different campuses within an institution, or different major functional areas.
EMPLOYER_DEDUCTION_AMOUNT	Employer deduction amount.
EMPLOYER_DESC	Employer_Code description.
EVENT_SEQUENCE_NUMBER	Sequence of the pay event.
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.
PAYROLL_IDENTIFIER	Pay identification number to which this Employee_Position belongs.
PAYROLL_IDENTIFIER_DESC	Payroll code description or title.
PAYROLL_NUMBER	The Pay Number is used to uniquely identify a pay period within a fiscal year.
PERSON_UID	System generated unique internal identification number assigned to this person.
STATUS	Status of the deduction.
STATUS_DESC	Status description.
TAX_DEDUCTION_IND	Indicates if the deduction is a tax deduction.
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.