ctcLink Reference CenterHuman Capital ManagementBenefits Benefits Configuration - 09Understanding Benefit Programs and Rate Configurations-09

Understanding Benefit Programs and Rate Configurations-09

Purpose:  Use this document as a reference for how to understand the rate table construction and relationship to program and payroll at a high level in ctcLink.

Audience:  Benefits Administrators

Benefit Program Table

Navigation:  Main Menu > Set  Up HCM > Product Related > Base Benefits > Program Structure > Benefit Program Table

  1. PeopleSoft stores Benefit Programs in which all employees can be sorted:
    • SB0  Only eligible for Savings Plans (403(b) & 457), all programs allow Savings plans
    • SB2  Eligible for all Retirement Plans and Savings Plans
    • SB1  Eligible for all benefits we administer including Health and HCA administered plans
    • SBA  Eligible for same benefits as SB1 (after tax, this is an elective option that mirrors SB1 but takes more out of an employee paycheck for Health related deductions)
  2. Program eligibility is determined by the number of hours worked in a year, here are some highlights:
    • Full time employees (most FTF, Classified, and Exempt) are eligible for SB1 and SBA programs
    • Part time employees (PTF, most Hourly) can become eligible for benefits if they meet certain benchmarks, but default to the SB0 program unless they meet one of the following:
      1. SB1: PTF must be working .50+ FTE for 2 consecutive quarters at one college, the .50 FTE can be a combined calculation of all teaching assignments in one college, it is evaluated on a quarterly basis using a custom Benefits report, and one college must be the sponsor of the Benefits and pay the employer portion to HCA if the PTF works at multiple colleges (the other colleges must assign that PTF an SB2 status an input their Retirement option)
      2. SB1: Hourly must work 480 (non-student) hours in a 6 month period in one job at a single college, a second job at the same college does not count towards this total, the 6 month period is reviewed on a rolling basis
      3. SB2: PTF who qualify for SB1 in the system must be coded as SB2 at all other colleges in the system and given a Retirement deduction at the other work sites
      4. SB2: Hourly employees at one college working 70 or more hours for 5 of 12 months for 2 consecutive years qualify for the Retirement benefit
  3. Every Benefit Program makes sure that it creates a group of options that include: Plan Type, Benefit Plan, and Deduction Code.
  4. The Benefit Program table should be updated when a Plan Type, Benefit Plan, or Deduction Code is changed, added, or deleted.
    • This action is taken by the ERP Benefits team member, often working with ERP Payroll
  5. Every Benefit Program is attached to a Rate ID that is associated with an entry in the Benefits Rates table
    • SB0  CTCMED (Medical is waived only for this Program for system reasons)
    • SB2  none (limited retirement, etc. not controlled by a rate table as they are straight deductions)
Plan Type and Option tab
Cost tab

Benefits Rates Table

Navigation:  Main Menu > Set Up HCM > Product Related > Base Benefits > Rates and Rules > Benefit Rates

  1. Benefit Rates are stored in Benefit Rate tables which reflect the actual amount that will come out in the payroll deduction it has been associated with in the Benefit Program Table.
Benefit Rate Table page
  1. Benefit Rates in all effected tables must be updated at least yearly:
    • Updates must be separated into AS EARNED vs AS PAID Benefit types
      1. AS PAID  the date it is paid is the is the month in which it covers
      2. AS EARNED  the date it is earned is the month in which it covers
    • Life Insurance and Long Term Disability are “AS EARNED” Benefits and updates to the table for these values will go into effect on 1/1/20XX (Note: Life insurance became a deduction only benefit in PeopleSoft paid to MetLife as of 1/1/2017)
    • Health, Tobacco Surcharge, Spouse Surcharge, Dependent Care, Deferred Compensation, FSA/HAS, and VEBA are “AS PAID” Benefits and updates to the table for these valued will go into effect on 12/16/20XX (previous year to the 1/1/20XX update)
  2. Different Benefit Rate tables have different purposes:
    • For example, while the SBCTC After-Tax Medical rate table stores similar plans and coverage codes, it does not contain Before-Tax Rate because the SBA plan is not a before-tax plan and therefore must be tracked and updated separately
  3. The HCA Average Rate is also stored in this table:
    • Update to the HCA Average cost is updated with an effective date of 6/30/20XX as it changes on a fiscal year
Benefit Rate Table page

Deduction Table

Navigation:  Main Menu > Set Up HCM > Product Related > Payroll for North America > Deductions > Deduction Table

  1. Deductions are mapped to a number in the Program Table, and the amount being taken by Payroll is mapped in the Rate table, but the actual Deduction lives in the Payroll area.
  2. The manner in which Payroll takes the Deduction lives in the Payroll module, and a Benefits Admin would need to work with Payroll if they wanted to examine paycheck details and deductions:
    • The amount of money deducted on a paycheck will always be associated with the deduction number that is associated with deduction code, and will be visible on the paycheck
Plan Type page
Setup tab
Paycheck Deductions tab