RETURN TO COMPOSITE VIEW REPORTS LIST
Human Resources Composite View Reports

SGHE Operational Data Store
Composite View Target: AP_BENEFIT_DEDUCTION

Description Source composite view contains benefit and deduction information for an employee. Data includes information on benefits and deductions, coverage options and begin and end dates. The view returns one row per person per benefit.

Target Column Business Definition Database Data Type Source Name Source Column
AMOUNT1 First amount field for the benefit/deduction. NUMBER(11, 2)

PDRDEDN

PDRDEDN_AMOUNT1

AMOUNT1_TITLE Long description associated with amount 1. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT1_TITLE

AMOUNT2 Second amount field for the benefit/deduction. NUMBER(11, 2)

PDRDEDN

PDRDEDN_AMOUNT2

AMOUNT2_TITLE Long description associated with amount 2. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT2_TITLE

AMOUNT3 Third amount field for the benefit/deduction. NUMBER(11, 2)

PDRDEDN

PDRDEDN_AMOUNT3

AMOUNT3_TITLE Long description associated with amount 3. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT3_TITLE

AMOUNT4 Fourth amount field for the benefit/deduction. NUMBER(11, 2)

PDRDEDN

PDRDEDN_AMOUNT4

AMOUNT4_TITLE Long description associated with amount 1. VARCHAR2(8)

PTRBDCA

PTRBDCA_AMT4_TITLE

BENEFIT_DEDUCTION_IND Indicates if this is a benefit deduction. VARCHAR2(30)

FUNCTION

POKODSF.F_GET_DEDUCTION_OPTIONS

BENEFIT_DEDUCTION_TYPE Benefit deduction type. VARCHAR2(2)

PTRBDCA

PTRBDCA_BDTY_CODE

BENEFIT_DEDUCTION_TYPE_DESC Benefit deduction type description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

BENEFIT_GROUP Benefit group. VARCHAR2(2)

PTRBDCA

PTRBDCA_BDTY_CODE

BOND_BALANCE If the deduction is for savings bonds this field contains the balance available toward the purchase of a bond. NUMBER(11, 2)

PDRBDED

PDRBDED_BOND_BALANCE

CALCULATION_RULE This rule defines how a benefit or deduction is processed by the system. VARCHAR2(2)    
CARRIER Identifies the specific benefit/deduction provider. VARCHAR2(3)

PDRDEDN

PDRDEDN_BDCA_CODE

CARRIER_LONG_DESC Benefit/deduction long description. VARCHAR2(30)

PTRBDCA

PTRBDCA_LONG_DESC

CARRIER_SHORT_DESC Benefit/deduction short description. VARCHAR2(8)

PTRBDCA

PTRBDCA_SHORT_DESC

COVERAGE_BEGIN_DATE Date the benefit/deduction begins. DATE

PDRBDED

PDRBDED_BEGIN_DATE

COVERAGE_END_DATE Date the benefit/deduction ends. DATE

PDRBDED

PDRBDED_END_DATE

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

PDRDEDN

PDRDEDN_OPT_CODE1

COVERAGE_OPTION_DESC Coverage option description. VARCHAR2(30)

PDRDEDN

PDRDEDN_OPT_CODE1

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

EFFECTIVE_DATE Date the benefit/deduction becomes effective. DATE

PDRDEDN

PDRDEDN_EFFECTIVE_DATE

EFFECTIVE_END_DATE End effective date. DATE

FUNCTION

POKODSF.F_GET_END_PDRDEDN_DATE

EFFECTIVE_START_DATE Start effective date. DATE

PDRDEDN

PDRDEDN_EFFECTIVE_DATE

EMPLOYEE_ANNUAL_DEDN_LIMIT Maximum annual employee cost for benefit/deduction. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_BOND_PURCHASE_AMOUNT Bond amount increment in which the employee desires to purchase Savings Bonds. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_DEDN_LTD_LIMIT Maximum life-to-date employee cost. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_DEDN_MTD_LIMIT Maximum month-to-date employee cost. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_DEDUCTION_AMOUNT Employee cost or deduction amount per pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_DEDUCTION_PERCENT Employee cost; percentage of gross pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_MINIMUM_EARNINGS Minimum amount the employee can be paid per pay. Used to determine if deduction, or portion thereof, can be processed in current pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYEE_MINIMUM_YTD_GROSS Minimum amount the employee must earn in a calendar year before this deduction is taken. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYER_DEDUCTION_AMOUNT Employer cost; flat amount deduction per pay. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

EMPLOYER_IDENTIFICATION_NUMBER Employer identification number. VARCHAR2(0)

NA

NA

LIFE_INSURANCE_OVERRIDE_AMOUNT Manually entered life insurance coverage amount for employee. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

LIFE_INSURANCE_PREMIUM Employee or employer cost of the life insurance benefit. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

LIFE_INSURANCE_SALARY Employee salary used to calculated the insurance coverage. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

LIFE_INSURANCE_TYPE_IND Indicates whether the life insurance deduction is employee or employer paid. VARCHAR2(30)

FUNCTION

POKODSF.F_GET_DEDUCTION_OPTIONS

LIFE_INSURANE_COVERAGE_AMOUNT Coverage amount of the employees life insurance when no override is entered. NUMBER

FUNCTION

POKODSF.F_GET_DEDUCTION_AMOUNTS

MAXIMUM_REARS_RECOVERY Maximum amount of arrears allowed to be recovered in a pay event. This is the maximum amount to be recovered during a pay period when an arrears balance exists. NUMBER(11, 2)

PDRBDED

PDRBDED_ARR_RECOVER_MAX

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

OPTION1 First option code for the benefit/deduction code. The use of this field is determined by the calculation rule assigned to the benefit/ deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE1

OPTION1_TITLE Option 1 description. Six character title that prompts user for what option to enter. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION1_TITLE

OPTION2 Second option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE2

OPTION2_TITLE Option 2 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION2_TITLE

OPTION3 Third option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE3

OPTION3_TITLE Option 3 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION3_TITLE

OPTION4 Fourth option code for the benefit/deduction. The use of this field is determined by the calculation rule assigned to the benefit/ deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE4

OPTION4_TITLE Option 4 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION4_TITLE

OPTION5 Fifth option code for the benefit/deduction code. The use of this field is determined by the calculation rule assigned to the benefit/ deduction. VARCHAR2(2)

PDRDEDN

PDRDEDN_OPT_CODE5

OPTION5_TITLE Option 5 description. VARCHAR2(8)

PTRBDCA

PTRBDCA_OPTION5_TITLE

PAYROLL_DEDUCTION_YEAR Deduction year. VARCHAR2(0)

NA

NA

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

PDRDEDN

PDRDEDN_PIDM

PROFILE_DATE Profile Date associated with this record. VARCHAR2(0)

FUNCTION

F_YEAR

REARS_BALANCE Arrears balance due the employer. NUMBER(11, 2)

PDRBDED

PDRBDED_ARR_BALANCE

STATUS Status of the benefit/deduction. VARCHAR2(1)

PDRDEDN

PDRDEDN_STATUS

STATUS_DESC Status description. VARCHAR2(30)

CALCULATION

DECODE(PDRDEDN_STATUS,'A','ACTIVE','B','EXEMPT','W','WAIVE','T','TERMINATED',')

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