HR Deduction Administration Universe

Quick Reference Guide

EDW – HR Deduction Administration

Who should use this universe?

  • Anyone who wants to count how many people have signed up for a particular deduction
  • Anyone who wants to track how much people are spending on their deductions

What types of business questions can I answer using this universe?

  • How many people are in the 503B program?
  • How much money was paid for health insurance?
  • How many people are in each health care option?
  • Which employees are on leave with medical benefits?

Universe Description

This universe contains deduction set up amounts. It contains who all is covered for particular employees. You can also get information on who is on family medical leave and leave of absence. You can see how much was withheld from an employee’s paycheck for a particular deduction. You can also get basic information on an employee, his position, job and job detail records.

Data Included in the EDW – HR Deduction Administration Universe

  • Position Number
  • Job Suffix
  • Employee Name
  • Employee UIN
  • Employee Birth Date
  • Current Hire Date
  • Employee Termination Date
  • Employee Detail Benefit Category Code & Description
  • Employee Non Campus Address
  • Family Medical Leave Act (FMLA) Year Begin Date
  • FMLA Year End Date
  • FMLA Status Code and Description
  • FMLA Leave Reason Code and Description
  • FMLA Scheduled Return Date
  • Leave of Absence (LOA) Effective Date
  • LOA Expiration Date
  • LOA Leave Reason Code & Description
  • Payroll Year
  • Payroll ID
  • Payroll Number
  • Payroll Sequence Number
  • Payroll Deduction Code & Description
  • Payroll Deduction Employee Amount
  • Payroll Deduction Employer Amount
  • Benefit Deduction Code & Description
  • Employee Benefit Person Sequence Number
  • Benefit Person Relationship Code & Description
  • Benefit Person Name
  • Person Benefit Deduction Code & Description
  • Person Benefit Deduction Type
  • Person Benefit Deduction Status
  • Person Benefit Deduction Calc Rule Code
  • Person Benefit Deduction Amounts 1 – 4
  • Person Benefit Deduction Options 1 – 5
  • Person Benefit Deduction Plan Description
  • Benefit Deduction Plan Effective Date
  • Benefit Deduction Plan Amounts 1 - 4

Universe Tips & Tricks

  • Very few people have access to this Universe. It is mainly for people in the Benefits Office and/or Payroll Office.
  • Leave of absences are sabbatical leaves.

Data Quality Advisories

  • Prior to 2006, there was no deduction plan information kept in the EDW.