Go To View:  RETURN TO COMPOSITE VIEW 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 Domain column for future use, not currently populated. VARCHAR2(6)    
APPLICABLE_GROSS_QTR1   NUMBER    
APPLICABLE_GROSS_QTR2   NUMBER    
APPLICABLE_GROSS_QTR3   NUMBER    
APPLICABLE_GROSS_QTR4   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   NUMBER    
EMPLOYEE_CONTRIBUTION_QTR2   NUMBER    
EMPLOYEE_CONTRIBUTION_QTR3   NUMBER    
EMPLOYEE_CONTRIBUTION_QTR4   NUMBER    
EMPLOYEE_CONTRIBUTION_YTD   NUMBER    
EMPLOYER_CONTRIBUTION_QTR1   NUMBER    
EMPLOYER_CONTRIBUTION_QTR2   NUMBER    
EMPLOYER_CONTRIBUTION_QTR3   NUMBER    
EMPLOYER_CONTRIBUTION_QTR4   NUMBER    
EMPLOYER_CONTRIBUTION_YTD   NUMBER    
GROSS_COMPENSATION_YTD   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(4)    
PERSON_UID System generated number that is internally generated to uniquely identify the person. NUMBER(8)    
PROCESS_GROUP Zone column for future use, not currently populated. VARCHAR2(6)    


Ver: 8.0