Peoplesoft Base Benefit Tables

Base Benefit Tables

PS_BEN_PROG_PARTIC - EE Benefit program participation.
PS_BENEFIT_PARTIC - Ben Plan type enrollment control
PS_BENEF_COMMENT - Benefit Comments

Dependent Details table

PS_DEPENDENT_BENEF - View Dependents/Beneficiaries
PS_DEP_BEN - EE Dependents/Beneficiaries
PS_DEP_BEN_EFF - EE Dependents Details EFFDT
PS_DEP_BENEF_VW - EE Dependent Only View
PS_DEP_BEN_ADDR - EE Dependent Address details
PS_BEN_NAME - EE Dependent Name
PS_DEP_BENEF_NID - Dependent / Benef National ID s
PS_DEPENDENT_PHONE - Dependent/Benef Phone Numbers

Health Plan Tables – Plan types – 1%

PS_HEALTH_PLAN_TBL - Health Plan Attributes Table
PS_HEALTH_PLAN_VW - Health Plans types View with its long descr plan type LIKE ‘1%’
PS_HEALTH_PLAN_LNG - Health Plans types view with its long descr lng plan type like ‘1%’

PS_HEALTH_BENEFIT - Health Benefits EE Elections
PS_HEALTH_DEPENDNT - Health Benefits EE Dependent Elections

PS_HEALTH_VW - EE Current Health Elections

Savings Plan Tables – Plan types - 4%

PS_SAVINGS_PLN_TBL -Savings Plan Attributes Table.
PS_SAVINGS_INV_TBL - Describing a specific investment option
Available within a Savings Plan type.
PS_ SAVINGS_PLN_VW -Savings Plan types view with its long description

PS_SAVINGS_PLAN -Savings Plan Enrollment Table.
PS_SAVINGS_BENEFIC -Savings Plan Beneficiaries.
PS_SAVINGS_INVEST -Savings Plan Enrollment Investment option.
PS_SAVINGS_PLAN_VW -Savings Plan Enrollment view

Life Plan Tables – Plan types - 2%

PS_LIFE_ADD_TBL -Life AD/D Ben Plan Parameters
PS_LIFE_PLAN_VW -Life AD/D Plan type views

PS_LIFE_ADD_BEN -EE Life AD/D Benefit Enrollment
PS_LIFE_ADD_BENEFC -EE Life AD/D Beneficiaries
PS_LIFE_VW -EE Current Life AD/D Benefits

FSA Plan Tables – Plan types - 6%

PS_FSA_BENEF_TBL -FSA Benefit Plan Parameters
PS_FSA_PLAN_VW -FSA Plan Type with its long description.

PS_ FSA_BENEFIT -EE FSA Benefit Enrollment View
PS_FSA_BENEFIT_VW -EE FSA Benefit Enrollment View

Retirement Plan Tables – Plan Types – 7%

PS_RTRMNT_PLAN_TBL -Retirement Plan Attributes Table
PS_RTRMNT_PLAN_VW -Retirement Plan types view

PS_RTRMNT_PLAN -EE Retirement Enrollment Table
PS_RTRMNT_VW -EE Current Retirement Benefits

Simple Plan Tables – Plan Types – A%

PS_SIMPLE_BENEFIT - EE Simple Benefits Plans Enrollments
PS_SIMPLE_PLAN_TBL - Plan attributes table.
PS_SIMPLE_PLAN_VW - Simple Plan Types view with long description.

Disability benefit plan table

PS_DISABILITY_BEN EE Disability Ben Enrollments
PS_DISABILITY_VW EE Current Disability Bens

 

0 comments: