Enhancement to UKG Connector
AnsweredConnector name: UKG Pro Workforce Management
We need access to the cost center information associated with the employee.
Table name: Persons/Employee details endpoint that includes jobAssignment.primaryLaborAccounts
The cost center in UKG WFM is typically sourced from one of these:
- Persons API (/api/v1/commons/persons) — includes jobAssignment with primaryLaborAccounts that contain cost center assignments. This is the most common source for "Home Cost Center."
- Organizational Jobs / Locations (/api/v1/commons/locations, /api/v1/commons/jobs) — the job path in your report (e.g., B/1261/PSC/HlthFair/NEW) encodes the org hierarchy. The cost center is embedded in the location/job tree structure. The location path segments likely map to the cost center.
- Labor Category Profiles/Lists (/api/v1/commons/labor_category_profiles) — if cost center is configured as a labor category in your UKG instance (it isn't currently flowing as one in the Actual Totals).
Recommendation
The most practical path is to ask Fivetran to enable the Persons/Employee details endpoint that includes jobAssignment.primaryLaborAccounts — this will give you the home cost center per employee. You can then join it to the time card data by EMPLOYEE_ID.
-
Official comment
Hi David,
Thank you for submitting your feature request for the UKG Pro WFM connector.
We will be starting our analysis to evaluate the feasibility of building and maintaining a high-quality Fivetran connector. As we move forward, we may reach out with additional questions or clarifications to ensure the connector aligns with your requirements and expectations.
We appreciate your feedback and continued support - it plays a key role in shaping our roadmap.
Best regards,
Sahu
Please sign in to leave a comment.
Comments
1 comment