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_MONTHLY_DEDUCTION

Description Source composite view contains deduction information relating to an employee.

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.    

PERDTOT

PERDTOT_APPL_GRS

 
APPLICABLE_GROSS_QTR1 Quarter 1 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
APPLICABLE_GROSS_QTR2 Quarter 2 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
APPLICABLE_GROSS_QTR3 Quarter 3 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
APPLICABLE_GROSS_QTR4 Quarter 4 gross contribution (total employee contribution plus total employee contribution) for a specific deduction or tax.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
BENEFIT_GROUP Benefit group.    

PTRBDCA

PTRBDCA_BDTY_CODE

 
CARRIER Identifies the specific benefit/deduction provider.    

PERDTOT

PERDTOT_BDCA_CODE

 
CARRIER_LONG_DESC Benefit/deduction long description.    

FUNCTION

GOKODSF.F_GET_DESC

 
CARRIER_SHORT_DESC Benefit/deduction short description.    

FUNCTION

GOKODSF.F_GET_DESC

 
COVERAGE_OPTION Coverage option associated with this benefit.    

FUNCTION

POKODSF.F_GET_COVERAGE_OPTION

 
COVERAGE_OPTION_DESC Coverage option description.    

FUNCTION

POKODSF.F_GET_COVERAGE_OPTION_DESC

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

NA

SYSDATE

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

NA

NA

 
EMPLOYEE_CONTRIBUTION_AMOUNT Employee contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPL_AMT

 
EMPLOYEE_CONTRIBUTION_FYTD Fiscal year to date employee contribution for a specific deduction.    

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

 
EMPLOYEE_CONTRIBUTION_QRT1 Quarter 1 employee total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_QRT2 Quarter 2 employee total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_QRT3 Quarter 3 employee total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_QRT4 Quarter 4 employee total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYEE_CONTRIBUTION_YTD Year to date employee contribution for a specific deduction.    

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

 
EMPLOYER Employer identification code.    

PERDTOT

PERDTOT_EMPR_CODE

 
EMPLOYER_CONTRIBUTION_AMOUNT Employer contribution amount toward the deduction.    

PERDTOT

PERDTOT_EMPR_AMT

 
EMPLOYER_CONTRIBUTION_FYTD Fiscal year to date employer contribution for a specific deduction.    

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

 
EMPLOYER_CONTRIBUTION_QTR1 Quarter 1 employer total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_QTR2 Quarter 2 employer total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_QTR3 Quarter 3 employer total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_QTR4 Quarter 4 employer total contribution for a specific deduction.    

FUNCTION

POKODSF.F_QUARTERLY_DEDUCTION_TOTAL

 
EMPLOYER_CONTRIBUTION_YTD Year to date employer contribution for a specific deduction.    

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

 
GROSS_COMPENSATION_FYTD Fiscal year to date gross contribution (total employee contribution plus total employee contribution) for a specific deduction.    

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

 
GROSS_COMPENSATION_YTD Year to date gross contribution (total employee contribution plus total employee contribution) for a specific deduction.    

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

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

NA

NA

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

NA

NA

 
PAYROLL_DEDUCTION_MONTH Calendar month in which the payroll deduction took place.    

PERDTOT

PERDTOT_MONTH

 
PAYROLL_DEDUCTION_YEAR Payroll deduction year; calendar year in which the payroll deduction took place for this record.    

PERDTOT

PERDTOT_YEAR

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

PERDTOT

PERDTOT_PIDM

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

NA

NA

 


Ver: 8.3