• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Enterprise Data Warehouse
Logo, Texas A&M University System, Office of Information Technology
  • Home
  • About
    • Governance
    • Security
      • Quarterly User Review Process
      • Quarterly User Review Form
      • Authorized Security Requesters
  • Documentation
  • Report Inventory
    • All Commonly Used Reports
    • Reports Grouped by Process
  • Universes
    • HCM Universes
    • Financial Universes
    • Payroll Universes
    • Historic BPP Universes
  • Training
  • Data Status
    • Academic Data Status
    • Budget Load Status
    • Data Load Status
    • Payroll Data Status
  • Office of Information Technology
    • Services
    • Contact the Office of Information Technology
    • Search OIT
Home / Universes / HCM Universes / HCM Benefits Enrollment

HCM Benefits Enrollment

Purpose

The HCM Benefits Enrollment universe contains a record for each employee and dependent benefit enrollment as of the prior day or last day of month for prior months.  Benefits include insurance and retirement plans.  An enrollment record is considered the choice to participate in a plan, so any choice to waive or decline participation is not included.

This information is sourced from Workday and reflects the enrollments that were effective as of the prior day or last day of month for prior months.  If retroactive changes are made, the enrollments on prior months are not adjusted to reflect the retroactive change.  For example, in May an action is taken in Workday to end an enrollment effective in March.  The March and April data will still reflect active enrollments for those months because as of March 31st and April 30th, the enrollments were active in Workday.

Common report uses include:

  • Estimated employer benefit contribution (SGIP) month to month (NOT payroll actual)
  • Participation Counts in plans and coverage levels (Employee Only, Employee and Family, etc.)
  • Participation in optional retirement plans (TDA and DCP)

Type

The HCM Benefits Enrollment universe is of type Snapshot.  Queries should be run for a single year and month.  If multiple years and months are used – consider comparing the data over time.

Grain

A record is kept in this universe for each employee and dependent enrollment by type (medical, dental, OL, ORP, TDA, etc.), plan, and provider, per fiscal year and fiscal month.

Measures

These measures are additive over time, but if multiple time periods are selected, consideration should be given to if the data should be compared over time.  These amounts not do reflect actual deductions taken in payroll, only the expected amounts based on the enrollment.

  • Employee Cost Monthly – Employee cost per benefit enrollment for the month.  Does not reflect wellness credit.
  • Employee Cost per Pay Period – Employee cost per benefit enrollment for their next pay period (bi-weekly employees will show half the monthly deduction).  Does not reflect wellness credit.
  • Employee Cost Adjusted for Wellness – Employee cost per benefit enrollment for the month less any applicable wellness credit.
  • Employer Contribution – Employer cost per benefit enrollment
  • Plan Enrollment – Used to count participation in a plan, including dependents.

      Note:  Employee Costs and Employer Contribution measures are only populated on the Policyholder’s enrollment records, the dependent records show zero dollars.

Filters

The following filters are available:

  • Current Enrollment Profile – Filter to view current snapshot only
  • Policyholder Enrollment Only – Filter to view only policyholder’s enrollment, excludes the dependent records
  • Dependent Enrollment Only – Filter to view only dependent enrollments
  • Retirees and Survivors Only – Filter to view only retiree, working retiree, and survivor enrollments
  • Active Employees Only – Filter to view only individuals’ enrollments who are working or are on leave and not retired
  • Exclude Retirement Plans – Exclude mandatory (ORP and TRS) and voluntary (TDA and DCP) retirement records.

Primary Sidebar

Related

  • HCM Benefits Enrollment
  • HCM Position
  • HCM Position Source
  • HCM Time Off Balance
  • HCM Time Off Transactions
  • HCM Worker

Copyright © 2025 Texas A&M University System All rights reserved.

301 Tarrow Street, College Station, TX 77840 | MAP | Phone: (979) 458-7700 | email: support@tamus.edu
State of Texas | Texas Homeland Security | Texas Veterans Portal | Statewide Search | Risk, Fraud & Misconduct Hotline | Privacy | Web Accessibility | State Link Policy | Campus Carry

Texas A&M University System