RETURN TO REPORTING VIEW REPORTS LIST
Human Resources Reporting View Reports

SGHE Operational Data Store
Reporting View Target: MONTHLY_DEDUCT_SLOT

Description Uses data from the MONTHLY_DEDUCTION view, displays 12 months of employee and employer deductions from payroll and summarizes those amounts by quarter.
Key & Frequency One row per person per payroll deduction year per carrier.
Recommended Search Columns PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER
ACTIVITY_DATE

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated DATE

NA

NA

ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPLICABLE_GROSS_AMOUNT1 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT10 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT11 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT12 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT2 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT3 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT4 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT5 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT6 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT7 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT8 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_AMOUNT9 Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

APPLICABLE_GROSS_QTR1 Applicable gross quarter 1. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

APPLICABLE_GROSS_QTR2 Applicable gross quarter 2 NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

APPLICABLE_GROSS_QTR3 Applicable gross quarter 3. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

APPLICABLE_GROSS_QTR4 Applicable gross quarter 4. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

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

PERDTOT

PERDTOT_BDCA_CODE

EMPLOYEE_CONTRIBUTION_AMOUNT1 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT10 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT11 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT12 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT2 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT3 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT4 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT5 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT6 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT7 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT8 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_AMOUNT9 Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

EMPLOYEE_CONTRIBUTION_QRT1 Employee contribution quarter 1. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT2 Employee contribution quarter 2. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT3 Employee contribution quarter 3. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_QRT4 Employee contribution quarter 4. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYEE_CONTRIBUTION_YTD Employee contribution year to date. NUMBER

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_AMOUNT1 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT10 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT11 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT12 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT2 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT3 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT4 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT5 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT6 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT7 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT8 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_AMOUNT9 Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

EMPLOYER_CONTRIBUTION_QTR1 Employer contribution quarter 1. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR2 Employer contribution quarter 2. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR3 Employer contribution quarter 3. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_QTR4 Employer contribution quarter 4. NUMBER

FUNCTION

F_QUATERLY_DEDUCTION_TOTAL

EMPLOYER_CONTRIBUTION_YTD Employer contribution year to date. NUMBER

FUNCTION

F_YEARLY_DEDUCTION_TOTAL

GROSS_COMPENSATION_YTD Gross Compensation year to date. NUMBER

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

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

NA

NA

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

NA

NA

PAYROLL_DEDUCTION_MONTH1 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH10 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH11 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH12 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH2 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH3 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH4 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH5 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH6 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH7 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH8 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

PAYROLL_DEDUCTION_MONTH9 Calendar month in which the payroll deduction took place. NUMBER

PERDTOT

PERDTOT_MONTH

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

PERDTOT

PERDTOT_YEAR

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

PERDTOT

PERDTOT_PIDM

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

NA

NA



Ver: 3.1