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_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
ADMINISTRATIVE_GROUP Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(6)    
APPLICABLE_GROSS_QTR1 Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER    
APPLICABLE_GROSS_QTR2 Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER    
APPLICABLE_GROSS_QTR3 Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER    
APPLICABLE_GROSS_QTR4 Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax. NUMBER    
CARRIER The code which identifies the benefit/deduction. VARCHAR2(3)    
CARRIER_DESC Benefit / Deduction long description. VARCHAR2(30)    
CURRENT_DATE This is the system current date (sysdate). DATE    
EMPLOYEE_CONTRIBUTION_QTR1 Quarter 1 employee contribution. NUMBER    
EMPLOYEE_CONTRIBUTION_QTR2 Quarter 2 employee contribution. NUMBER    
EMPLOYEE_CONTRIBUTION_QTR3 Quarter 3 employee contribution. NUMBER    
EMPLOYEE_CONTRIBUTION_QTR4 Quarter 4 employee contribution. NUMBER    
EMPLOYEE_CONTRIBUTION_YTD Year to date employee contribution for a specific deduction. NUMBER    
EMPLOYER_CONTRIBUTION_QTR1 Quarter 1 employer total contribution for a specific deduction. NUMBER    
EMPLOYER_CONTRIBUTION_QTR2 Quarter 2 employer total contribution for a specific deduction. NUMBER    
EMPLOYER_CONTRIBUTION_QTR3 Quarter 3 employer total contribution for a specific deduction. NUMBER    
EMPLOYER_CONTRIBUTION_QTR4 Quarter 4 employer total contribution for a specific deduction. NUMBER    
EMPLOYER_CONTRIBUTION_YTD Year to date employer contribution for a specific deduction. NUMBER    
GROSS_COMPENSATION_YTD Year to date gross contribution. NUMBER    
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)    
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)    
PAYROLL_DEDUCTION_YEAR Deduction Year. NUMBER    
PERSON_UID System generated number that is internally generated to uniquely identify the person. NUMBER    
PROCESS_GROUP Zone column for future use, not currently populated. VARCHAR2(6)    


Ver: