• 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
    • Data Load Status
    • Payroll Data Status
  • Office of Information Technology
    • Services
    • Contact the Office of Information Technology
    • Search OIT
Home / List of Universes / HCM Universes / HCM Worker

HCM Worker

Purpose

The HCM Worker universe may be used to report by Worker (employee). The universe will contain a record for each worker as the day of the snapshot.

This universe is ideal for but not limited to reporting for the following business processes:

  • Head count of Workers
  • Analyzing changes in Worker attributes over time
  • Analyzing Worker attributes

Type

The HCM Worker is of type Snapshot.

Daily snapshots are extracted from Workday daily to update the most current snapshots. The last snapshot of each day is saved in this universe to facilitate analysis over time.

Grain

A record is kept for each employee (one record per EmployeeID \ UIN) for each fiscal year and fiscal month.
Measures

Measures

This universe provides the following measures and significant dimensions.

  • Total Base Pay – Annual Budgeted Salary on Worker Object
  • Original Benefit Salary Amount – The Salary used to calculate Benefits
  • Benefit Salary Amount – Current Benefit Salary Amount
  • Head Count – Measure used to count an individual Worker

Filters

The following filters are available:

  • Worker Type – Employee Only – Filter to include only Employees. – Worker Type will be set to “Employee”
  • Worker Type – Contingent Worker Only – Filter to include only Contingent Worker. – Worker Type will be set to “Contingent Workers”
  • Current Worker Profile Only – Filter to limit results to only the most current snapshot

Dimensions

This universe contains links to the following dimensions. Any attribute in these dimensions can be used to sort, filter, subset, or include on the report or graph.

  • Time Attributes
  • Worker Attributes
  • Organization Attributes
  • Job Profile

Primary Sidebar

Related

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

Copyright © 2023 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