Domain catalogue Reference data on Workday

Calendars and time profiles on Workday

Factory, fiscal and planning calendars as governed reference data: working days, periods, weeks and buckets that every plan and report agrees on.

SOURCES, READ IN PLACEWorkdayHCM · financeASSEMBLED1 · standardise2 · match on the domain keys3 · survive field by field4 · place in the hierarchies5 · run the column and row rules6 · publish the golden viewGOLDEN CALENDARS AND TIME PROFILESCalendars and time profilesone id · every source key keptREAD BYGrids, pivots and drill-downswith the transactionsAPIs, SQL and agentsone policyWrite-back to the systemsacknowledged
The objects the domain reads in place on Workday, the assembly steps, and who reads the result. Writes go through web-service Put operations.
2
objects read in place from Workday
catalogue
4
attribute groups assembled
catalogue
1 days
to production-grade
estimate
1
write path, acknowledged and logged
catalogue
0
rows copied to start
product
What the domain reads

The Workday objects behind the golden record

Objects are read through Workday web services and RaaS reports; the rows stay in Workday.

ObjectRead fromFields the domain usesFreshness
Fiscal schedulesGet_Fiscal_Schedules · Get_Fiscal_YearsFiscal_Schedule_ID · Periodlive through web services; reports on schedule
Holiday calendarsGet_Holiday_CalendarsHoliday_Datelive through web services; reports on schedule
The keys

How calendars and time profiles records match, in this system's fields

calendar idtype + country + year

The first object above carries the strong keys; the standardised attributes come from the same rows. Calendars are dimensions in the bed, so pivots can switch between fiscal periods and planning weeks on the same facts.

What is written back

Through the interfaces Workday supports

Writes go through the Workday web services (Put operations) with the reference id; each call returns the id or the error, logged beside the change.

InterfaceUsed forResult
Put_Fiscal_Schedulegolden values approved for write-back: calendar; days and shifts; periodsthe id or error Workday returns, stored beside the change

Write-back is off per object until a test write succeeds, and approval rules can require a person per object. Reconciliation compares the source row with the golden value on a schedule.

Access and prerequisites

What is in place before the first build

Workday security groups are mapped to Lima policies once; personal data stays under the HR policy.

Register the objects2 objects from the connector catalogue; each shows its rows at once.
Nearby

This domain on other systems, and other domains on Workday

Calendars and time profiles on

Other domains on Workday

Terms on this page

Factory calendarThe working days and shifts of a site.
4-4-5A fiscal pattern of 13-week quarters split into 4, 4 and 5 weeks.
Read in placeThe rows stay in Workday; Lima sends the filter and the columns and Workday returns the matching rows.
Questions

Does this domain copy data out of Workday?

The golden record reads the objects above in place. History the pivot needs at scale is landed in your lake by the Backbone, under the same keys, security and audit.

What does the Workday team need to do?

Grant the read access and the write interfaces listed above and agree the refresh method. Nothing is installed in Workday.

Can we start with reads only?

Yes. Write-back stays off per object until a test write succeeds; the golden view, the API and the pivots work from day one on reads.

See your first domain built on your data

Bring two systems that hold the same customers, suppliers or materials. In one working day we connect them, run the match on live rows, review the queue with your steward and publish the first golden view with its API.