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).

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Domain column for future use, not currently populated.          
APPLICABLE_GROSS_QTR1            
APPLICABLE_GROSS_QTR2            
APPLICABLE_GROSS_QTR3            
APPLICABLE_GROSS_QTR4            
CARRIER The code which identifies the benefit/deduction.          
CARRIER_DESC Benefit / Deduction long description.          
CURRENT_DATE This is the system current date (sysdate)          
EMPLOYEE_CONTRIBUTION_QTR1            
EMPLOYEE_CONTRIBUTION_QTR2            
EMPLOYEE_CONTRIBUTION_QTR3            
EMPLOYEE_CONTRIBUTION_QTR4            
EMPLOYEE_CONTRIBUTION_YTD            
EMPLOYER_CONTRIBUTION_QTR1            
EMPLOYER_CONTRIBUTION_QTR2            
EMPLOYER_CONTRIBUTION_QTR3            
EMPLOYER_CONTRIBUTION_QTR4            
EMPLOYER_CONTRIBUTION_YTD            
GROSS_COMPENSATION_YTD            
MULTI_SOURCE The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.          
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.          
PAYROLL_DEDUCTION_YEAR Deduction Year.          
PERSON_UID System generated number that is internally generated to uniquely identify the person.          
PROCESS_GROUP Zone column for future use, not currently populated.          


Ver: 8.3