Cost Center & Company

The two organization types that connect people to money. Company is the legal entity that employs and pays. The cost center is where the cost lands in finance, and the key that joins Workday to the ERP.

RuleOne cost center dimension, shared by the people facts and, mapped, by the ERP modelNeverlet Workday and ERP cost center codes drift unmapped. Every cross-system report fails there first.

◆ The two types— company answers who employs and pays; cost center answers where the cost lands.

Type	What it answers	Note
Company	Which legal entity employs the worker and runs the payroll.	The statutory rollup: tax, filings, entity-level cost.
Cost Center	Which budget the cost hits.	The management rollup, organized in hierarchies, and the key finance plans against.

Both are assigned to a worker through the position, effective-dated. They answer different questions: cost by company is the legal view, cost by cost center is the management view. A report should say which one it is.

◆ Reporting traps— split costing, code drift, and moves that are not reorgs.

Trap	What goes wrong
Costing allocations	A worker's pay can be split across several cost centers by a costing allocation. Headcount rolls to one cost center; cost may roll to several. Count people by assignment, cost by allocation, and label which a report shows.
Code drift	Cost centers are maintained in Workday and in the ERP. Codes drift: renamed here, retired there, created in one system only. Unmapped drift is why people cost and financial spend refuse to reconcile. The fix is one mapped dimension, below.
Cost center change is not a reorg	A worker can move cost centers without changing manager, and change manager without moving cost centers. They are separate effective-dated assignments; track both. See Supervisory Organization.
Company transfers	Moving a worker between companies is a legal-entity event with payroll consequences. In the model it is a new assignment row, not an exit and a hire; count it as internal movement.

◆ How we model it: dim_cost_center— one dimension carrying both systems' codes, so people cost joins financial spend.

The build lands Workday's cost centers, joins the ERP code map, and keeps validity dates:

-- stg_wd_cost_center from Workday; map_cost_center maintained once, in the warehouse
SELECT cc.cost_center_id,
       cc.cost_center_name,
       cc.company_code,
       m.erp_cost_center      AS erp_code,
       m.erp_system,
       cc.valid_from, cc.valid_to
FROM stg_wd_cost_center cc
LEFT JOIN map_cost_center m ON cc.cost_center_id = m.wd_cost_center_id

The finished dimension, sample rows. The first two match by code; the third is the drift case, different codes in each system, mapped on one row:

cost_center_id	name	company	erp_code	erp_system	valid_from	valid_to
CC_4100	Field Sales West	US001 · Acme US	4100	SAP	2024-01-01	9999-12-31
CC_4200	Sales Ops	US001 · Acme US	4200	SAP	2024-01-01	9999-12-31
CC_MKTG	Marketing	US001 · Acme US	3200	SAP	2024-01-01	9999-12-31

With this one dimension, payroll cost per cost center from Workday joins spend per cost center from the SAP model or the Oracle model in a single query: fully loaded cost per department, revenue per head, plan versus actual. When codes drift, the fix is one row in the map, not a reconciliation project. See the enterprise model. Sample values are illustrative, never client data.

Want people cost joined to financial spend?

We build the mapped cost center dimension across Workday and your ERP, reconciled on both sides, and you own every line.

Talk to us

Terms on this page

company: The legal entity that employs the worker and runs payroll. The statutory rollup.
cost center: The budget a cost hits. The management rollup, and the key shared with finance.
organization assignment: A worker's membership in each organization type, set on the position, effective-dated.
costing allocation: A rule splitting a worker's pay across cost centers. Cost can land in several; the person counts in one.
code drift: Workday and ERP cost center codes falling out of step. The reason cross-system reports fail.
code map: The table pairing each Workday cost center with its ERP code. Maintained once, in the warehouse.
conformed dimension: One dimension shared by every fact, and here by two systems, so a value means one thing.
fully loaded cost: Pay plus employer burden, joined to the department's other spend.