PeopleSoft Benefit Administration Business Flow and Tables

        Benefits Administration Is:

       An Automated Eligibility Processing System

       Delivered by PeopleSoft

       Driven by Tables and Rules

       Based on Employee Data

        Ben Admin is Driven By:

       Tables And Rules

       These Include

        Deduction Tables

        Benefit Plan Tables

        Geographic Location Tables

        Benefit Program Tables

        Eligibility Rules

        Event Rules

        Calculation Rules

        Ben Admin Utilizes

       Data from Employee Records

        Personal Data

        Job Data

        Employment Data

       This data helps Ben Admin determine eligibility for various benefit options

        Ben Admin Eligibility Rules

       Benefits for US Employees is primarily driven by:

        Employees Date of Birth

        Home Address

        Work Location

        Company & Paygroup combination

        Employee Class

        Eligibility Configuration 1,2, & 3

       By setting a unique combination of these values, Ben Admin is able to offer employees the appropriate set of benefits options.

        Ben Admin Event Classes

       Event Class, is a way of equating actions on Job to Benefits eligibility events and guaranteeing that they will perform in a certain fashion each time

       Event Classes have

        1:1 correlation from job in some cases

        Default class if no 1:1 correlation

        Open Enrollment event class

        Ben Admin Event Classes

       Examples of Events that have a 1:1 Correlation

        Hire Action = HIR Event

        Family Status Change Action = FSC Event

        Transfer Action = XFR Event

        Termination Action = TER Event

        Retirement Action = RET Event

       There are others that are 1:1 as well        

        Ben Admin Event Classes

       If there is no event class that matches the action on Job, Ben Admin assigns it to the default event class, MSC, or Miscellaneous

       Each event class is assigned to a set of rules

        Ben Admin Event Rules

       Event Rules Define

        The Options that are available to the employee for a particular type of event

        Family Status Changes don’t allow the employee to change their medical or dental plan

        Transfer events allow the employee to change medical and/or dental plans

        What are Benefit Programs

       A Benefit Program is a collection of benefits options that a particular segment of the population is eligible to receive.

        US Benefit programs are primarily driven by Employee Class

        The Working Tables

       Ben Admin does all its work in 6 major tables

        BAS_Partic

        BAS_Partic_Plan

        BAS_Partic_Option

        BAS_Partic_Dependent

        BAS_Partic_Cost

        BAS_Partic_Invest

       These are viewable as the Employee Event Summary panel group in Administer Automated Benefits

       BAS = Benefits Admin System


Bas Partic

  • Contains the high level keys for the whole bas partic structure
  • EmplID, Benefit Program, Event Class
  • The relevant job info
  • Various date features
  • Overall status of the event

Bas Partic Plan

        Primarily the repository of the employee’s current benefit elections

        The benefit plans that the employee had coming into this event

        Where the changes to benefit plans are recorded

Bas Partic Option

        Table that stores all the options for each plan type that the employee is eligible for in their benefit program

Bas Partic Cost

        Contains all the costs associated with each option that Ben Admin has calculated in the Bas Partic Option section of the table

        Contains per pay period information as well as annual amounts

Bas Partic Dependent

        Table that stores the enrolled dependents for medical and/or dental by plan type

        Stores beneficiary designations for Life Insurance elections

Bas Partic Investment

        This records investment options for savings type plans (401(k))

Ben Admin Base Tables

        Once Ben Admin is complete with an event (i.e. Finalized), it copies the plan election and dependent info to the BASE (i.e. posting tables)

        Once the elections are in these BASE tables, Payroll and others are able to view the employees elections

Benefits Administration

        The Posting Tables (Base Tables)

       Employees Elections are recorded in the following tables:

        Health Benefits

       Health Dependent

        Life & AD&D Benefits

       Life & ADD Beneficiary

        Disability Benefits

        FSA Benefits

        Savings Plans

       These tables are viewable under the Use menu in Administer Base Benefits