RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Human Resources Reporting View Reports

SGHE Operational Data Store
Reporting View Target: MONTHLY_DEDUCTION

Description Contains monthly details regarding all employee deductions.
Key & Frequency One row per person per employer per payroll deduction month per payroll deduction year per carrier.
Recommended Search Columns PERSON_UID, PAYROLL_DEDUCTION_YEAR, CARRIER, PAYROLL_DEDUCTION_MONTH
PERSON_UID, PAYROLL_DEDUCTION_YEAR, EMPLOYER, CARRIER, PAYROLL_DEDUCTION_MONTH

Target Column Business Definition Database Data Type Source Name Source Column
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

APPLICABLE_GROSS_AMOUNT Total gross compensation toward which deduction is applicable. NUMBER

PERDTOT

PERDTOT_APPL_GRS

BENEFIT_GROUP Benefit group. VARCHAR2(63)

PTRBDCA

PTRBDCA_BDTY_CODE

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

PERDTOT

PERDTOT_BDCA_CODE

CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(255)

NA

NA

EMPLOYEE_CONTRIBUTION_AMOUNT Employee contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPL_AMT

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

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

EMPLOYER Employer identification code. VARCHAR2(63)

PERDTOT

PERDTOT_EMPR_CODE

EMPLOYER_CONTRIBUTION_AMOUNT Employer contribution amount toward the deduction. NUMBER

PERDTOT

PERDTOT_EMPR_AMT

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

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

GROSS_COMPENSATION_FYTD Fiscal year to date gross contribution. NUMBER

FUNCTION

POKODSF.F_CALC_DEDUCTIONS_FYTD

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PAYROLL_DEDUCTION_MONTH 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