RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_MONTHLY_DEDUCTION

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

Target Column Business Definition Database Data Type Source Name Source Column
APPLICABLE_GROSS_AMOUNT Total gross compensation toward which deduction is applicable. NUMBER(11, 2)

PERDTOT

PERDTOT_APPL_GRS

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

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

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

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

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

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

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

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

BENEFIT_GROUP Benefit group. VARCHAR2(2)

PTRBDCA

PTRBDCA_BDTY_CODE

CARRIER Identifies the specific benefit/deduction provider. VARCHAR2(3)

PERDTOT

PERDTOT_BDCA_CODE

CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

COVERAGE_OPTION Coverage option associated with this benefit. VARCHAR2(0)

NA

NA

COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(0)

NA

NA

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

NA

SYSDATE

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

NA

NA

EMPLOYEE_CONTRIBUTION_AMOUNT Employee contribution amount toward the deduction. NUMBER(11, 2)

PERDTOT

PERDTOT_EMPL_AMT

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

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

EMPLOYEE_CONTRIBUTION_QRT1 Quarter 1 employee total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT2 Quarter 2 employee total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT3 Quarter 3 employee total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT4 Quarter 4 employee total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_YTD Year to date employee contribution for a specific deduction. NUMBER

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

EMPLOYER Employer identification code. VARCHAR2(4)

PERDTOT

PERDTOT_EMPR_CODE

EMPLOYER_CONTRIBUTION_AMOUNT Employer contribution amount toward the deduction. NUMBER(11, 2)

PERDTOT

PERDTOT_EMPR_AMT

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

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

EMPLOYER_CONTRIBUTION_QTR1 Quarter 1 employer total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR2 Quarter 2 employer total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR3 Quarter 3 employer total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR4 Quarter 4 employer total contribution for a specific deduction. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_YTD Year to date employer contribution for a specific deduction. NUMBER

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

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

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

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

NA

NA

PAYROLL_DEDUCTION_MONTH Calendar month in which the payroll deduction took place. NUMBER(2)

PERDTOT

PERDTOT_MONTH

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

PERDTOT

PERDTOT_YEAR

PERSON_UID System generated, unique, internal identification number assigned to this person. NUMBER(8)

PERDTOT

PERDTOT_PIDM

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

NA

NA



Ver: 3.1