Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Human Resources Composite View Reports

Banner Operational Data Store
Composite View Target: AP_YEARLY_DEDUCTION

Description Contains summarized payroll deduction information for each quarter and year-to-date (YTD).

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)       NO
APPLICABLE_GROSS_QTR1 Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER       NO
APPLICABLE_GROSS_QTR2 Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER       NO
APPLICABLE_GROSS_QTR3 Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER       NO
APPLICABLE_GROSS_QTR4 Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER       NO
CARRIER The code which identifies the benefit/deduction. VARCHAR2(3)       NO
CARRIER_DESC Benefit / Deduction long description. VARCHAR2(30)       NO
CURRENT_DATE This is the system current date (sysdate). DATE       NO
EMPLOYEE_CONTRIBUTION_QTR1 Quarter 1 employee contribution. NUMBER       NO
EMPLOYEE_CONTRIBUTION_QTR2 Quarter 2 employee contribution. NUMBER       NO
EMPLOYEE_CONTRIBUTION_QTR3 Quarter 3 employee contribution. NUMBER       NO
EMPLOYEE_CONTRIBUTION_QTR4 Quarter 4 employee contribution. NUMBER       NO
EMPLOYEE_CONTRIBUTION_YTD Year to date employee contribution for a specific deduction. NUMBER       NO
EMPLOYER_CONTRIBUTION_QTR1 Quarter 1 employer total contribution for a specific deduction. NUMBER       NO
EMPLOYER_CONTRIBUTION_QTR2 Quarter 2 employer total contribution for a specific deduction. NUMBER       NO
EMPLOYER_CONTRIBUTION_QTR3 Quarter 3 employer total contribution for a specific deduction. NUMBER       NO
EMPLOYER_CONTRIBUTION_QTR4 Quarter 4 employer total contribution for a specific deduction. NUMBER       NO
EMPLOYER_CONTRIBUTION_YTD Year to date employer contribution for a specific deduction. NUMBER       NO
GROSS_COMPENSATION_YTD Year to date gross contribution. NUMBER       NO
MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)       NO
MULTI_SOURCE_DESC The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)       NO
PAYROLL_DEDUCTION_YEAR Deduction Year. NUMBER       NO
PERSON_UID System generated number that is internally generated to uniquely identify the person. NUMBER       NO
PROCESS_GROUP Zone column for future use, not currently populated. VARCHAR2(6)       NO


Ver: