How Do I Link Cost Centers to Journal Entries in Workday Financial Management?

Question

How do I link cost centers to journal entries in Workday Financial Management?

Environment

Connector: Workday Financial Management

Answer

To link cost centers with journal entries in Workday Financial Management via Fivetran:

• Cost center details are stored in the cost_center table.
• Journal entries are represented in the journal_entry and journal_entry_line tables. Each journal entry can have multiple associated lines.
• Worktags are a flexible attribution system within Workday that associate financial transactions, including journal entry lines, with attributes like cost center, project, and others.
• Cost centers are linked to journal entry lines through worktags:
  • Each record in journal_entry_line may link to one or more worktags via a worktag association ID or reference column.
  • Join journal_entry_line with the worktag table, for example, on journal_entry_line.worktag_id = worktag.id, where worktag.attribute = Cost_Center_Reference_ID.
  • The resulting worktag.value will match the id column in the cost_center table.
  • Join this value to the cost_center table to retrieve the cost center details, for example, worktag.value = cost_center.id.
• There is no direct 1:1 mapping between journal entries and cost centers—linkages are derived via worktag associations per line item.

Example join workflow

1. Identify journal entry lines in journal_entry_line.
2. Join to worktag on worktag_id. Filter where worktag.attribute = 'Cost_Center_Reference_ID'.
3. Join to cost_center where worktag.value = cost_center.id.

For more information, see Workday Financial Management.