Overview of the UW's Foundation Data Model (FDM)

This section will discuss the following topics:

  1. What is a Worktag?
  2. Driver Worktags, Defaulted Worktags, and Account Posting Rules
  3. Understanding Worktag Hierarchies in Workday

The Workday Foundation Data Model (FDM) is the framework the University of Washington uses to capture and organize financial activity in Workday. It is a flexible and detailed structure that supports budgeting, reporting, and financial analysis across all units.

The FDM is built around worktags; labels or attributes that are assigned to transactions to identify their purpose, funding source, organizational ownership, and other key details. Worktags help ensure that financial data is consistently classified and easily reportable without needing to memorize numeric codes.

What is a Worktag?

A worktag is a keyword or descriptor used to tag financial transactions in Workday. Each worktag represents a specific dimension of financial data and when used in combination, fully describes the financial context of a transaction. By using structured worktags instead of a single budget number or account code, Workday enables more flexible and transparent reporting.

Driver Worktags, Defaulted Worktags, and Account Posting Rules

Required Worktags in Workday

When entering transactions in Workday, certain worktags are always required:

  • All transactions must have: Company, Balancing Unit, Fund, and Ledger worktags.
  • Income Statement transactions (Revenue and Expense type Ledger worktags) also generally require: Resource, Cost Center, and Function worktags.

What Are Driver Worktags?

Workday simplifies data entry through driver worktags. A driver worktag (such as a Grant, Gift, Program, or Cost Center) is configured to automatically populate other defaulted worktags on a transaction. This helps:

  • Reduce data entry errors
  • Ensure compliance with UW's financial structure
  • Save time by avoiding repeated manual entry
worktag diagram

Important Details About Driver Worktags:

  • Order matters: If you enter multiple driver worktags, one can override the defaults set by another, potentially resulting in incorrect worktag combinations on the transaction.
  • No cascading: Defaults from a driver worktag do not trigger additional defaults from the worktags they populate.
  • Typical setup: Driver worktags are often configured to default the full set of required worktags for Income Statement transactions (i.e. Cost Center, Resource, Fund, Function, Balancing Unit).

Finding Driver Worktags in Workday

While ubiquitous across Workday clients like UW, the term "driver worktag" doesn't actually appear in the Workday user interface (UI). To check if a worktag is a driver:

  1. Select the worktag in question.
  2. View the Related Worktags table on the first screen (generally on the first screen that comes up when a worktag is selected).
  3. If the Default Worktags column has values listed, the worktag is acting as a driver.
worktag example in Workday

 

Similarly for accounting worktags, Account Posting Rules (APRs) determine how Revenue Categories and Spend Categories interact with the Ledger worktag. 

Common Worktag-Specific Driver Behavior

Worktag as a DriverConfigured Defaulted Worktags
Cost CenterFunction
Balancing Unit
Stand-Alone GrantVaries depending on configuration – review in Workday
ProgramVaries depending on configuration – review in Workday
ActivityVaries depending on configuration – review in Workday
GrantResource
Fund
Function
Cost Center
Balancing Unit
GiftResource
Fund
Function
Cost Center
Balancing Unit

Illustrative Examples of Driver and Defaulted Worktag Relationships

Driver and defaulted worktag relationships

 

Driver and defaulted worktag relationships 2

 

Driver and defaulted worktag relationships 3

 

By relying on configured relationships between worktags, Workday helps ensure that transactions are consistently coded and aligned with institutional reporting standards.

Understanding Worktag Hierarchies in Workday

Worktag Hierarchies in Workday are structured groupings of worktags used for reporting and, in some cases, for assigning transaction approvers and fiscal responsibility.