The organisation as governed master data: units, positions, their managers and cost centres, versioned so every system shows the same structure on the same day.
Tables are read through the Table API and, for volume, exports; the rows stay in ServiceNow.
| Object | Read from | Fields the domain uses | Freshness |
|---|---|---|---|
| Departments | cmn_department | sys_id · name · parent · dept_head · cost_center | live; polled or event-driven |
| Assignment groups | sys_user_group | name · manager · parent | live; polled or event-driven |
The first object above carries the strong keys; the standardised attributes come from the same rows. Positions link to golden employees and cost centres, so an approval route, a headcount plan and a ticket queue read one structure.
Writes go through the Table API or Import Sets with a coalesce field; each call returns the sys_id or the error, logged beside the change.
| Interface | Used for | Result |
|---|---|---|
Table API PUT on cmn_department and sys_user_group by coalesce on the golden unit code | golden values approved for write-back: unit; position; mappings | the id or error ServiceNow 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.
ServiceNow roles and ACLs are mapped to Lima policies once.
Organisation units and positions on
Other domains on ServiceNow
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.
Grant the read access and the write interfaces listed above and agree the refresh method. Nothing is installed in ServiceNow.
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.
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.
