Turn 1: prompt (sent 2026-11-20T04:52:43.603Z)
Set up an outbound integration in our Workday tenant called “Worker Contacts TT-CLA” that produces a CSV file of the active workers in the supervisory organization “HCM1119 IT”, with columns Employee ID, Legal Name, Work Email, Manager, Hire Date. Then launch it once so we get the file. Please give me what I need to set it up.
Turn 1: answer (2026-11-20T04:53:20.473Z, 36.9 s)
I can’t get into your Workday tenant from here, so I haven’t built or launched anything. The steps below are for you or a Workday integration admin to follow, and should take about 15–20 minutes. Field and data source names are the standard delivered ones, but tenants can differ, so use the closest match if a name doesn’t appear in yours.
Before you start: two things to decide
- Subordinate orgs: Should the file include only workers directly in “HCM1119 IT”, or also workers in the orgs under it?
- Contingent workers: “Active workers” can mean employees only, or employees plus contingent workers. Contingent workers don’t have an Employee ID. If you want them included, also add Contingent Worker ID, or use a worker ID field if your tenant has one.
Step 1: Build the custom report (this is the data source)
Task: Create Custom Report
| Setting | Value |
|---|---|
| SettingReport Name | ValueWorker Contacts TT-CLA - Data |
| SettingReport Type | ValueAdvanced |
| SettingData Source | ValueWorkers by Organization (indexed, fast). Or use All Active Employees / All Workers plus a filter |
| SettingOptimized for Performance | ValueYes, if available |
Columns tab. Set the Column Heading Override so the CSV headers come out exactly right. Also set a matching XML alias, e.g. Employee_ID.
| Field (Business Object: Worker) | Column Heading Override |
|---|---|
| Field (Business Object: Worker)Employee ID | Column Heading OverrideEmployee ID |
| Field (Business Object: Worker)Legal Name | Column Heading OverrideLegal Name |
| Field (Business Object: Worker)Primary Work Email (or Email – Primary Work) | Column Heading OverrideWork Email |
| Field (Business Object: Worker)Manager | Column Heading OverrideManager |
| Field (Business Object: Worker)Hire Date | Column Heading OverrideHire Date |
Prompts / Filter tab:
- If you used Workers by Organization: set the Organizations prompt default to
HCM1119 IT. Set Include Subordinate Organizations based on decision 1. - If you used another data source: add a filter Supervisory Organization in the selection list
HCM1119 IT. - Add a filter Active Status is equal to
Yes. This guarantees only active workers, whichever data source you used.
Advanced tab: Check Enable As Web Service. EIB needs this to use the report.
Share tab: Share the report with the integration owner and with the Integration System User (ISU), if you use one.
Click OK, then run the report once to check the row count and data before going further.
Step 2: Create the outbound EIB
Task: Create EIB
| Setting | Value |
|---|---|
| SettingName | ValueWorker Contacts TT-CLA |
| SettingSource | ValueWorkday (outbound) |
| SettingData Source Type | ValueCustom Report |
| SettingCustom Report | ValueWorker Contacts TT-CLA - Data |
| SettingFormat | ValueCSV |
| SettingDelivery Method | ValuePick one: SFTP (host, directory, credentials), Email, or leave the file on the integration event if you just need a one-time download |
Configure Integration Transformation: Choose a CSV / Custom Report transformation. Leave the header row on.
Configure Integration File Utilities (optional): Set a file name pattern such as Worker_Contacts_TT-CLA_${current-date}.csv.
Security: Whoever launches the integration (or the ISU) needs view access to these domains:
- Worker Data: Public Worker Reports
- Worker Data: Work Contact Information (email)
- Worker Data: Employment Data (hire date)
- Worker Data: Current Staffing Information
- Integration Build / Integration Process for the EIB itself
Missing access usually shows up as empty columns, not an error. So if Work Email comes back blank, check security first.
Step 3: Launch it once
- Task: Launch / Schedule Integration
- Integration:
Worker Contacts TT-CLA - Run Frequency: Run Now
- Confirm the prompt values (Organization =
HCM1119 IT), then click OK. - Open the process from My Background Processes (or Process Monitor), wait for status Completed, then go to Output Files and download the CSV.
Checks before you trust the file
- Hire Date format: Workday usually outputs
YYYY-MM-DD(e.g.2024-03-15). If you need another format, change it in the transformation or with a calculated field. - Manager column: This outputs the manager’s display name. If you’d rather have the manager’s ID, add a related field (Manager → Employee ID).
- Which tenant: If you can, build and test in a sandbox or implementation tenant first, then migrate the report and EIB to production with Object Transporter, or rebuild them there.
If you tell me your delivery method, I can give you the exact delivery settings and file naming, or a schedule if you want this to run regularly.
Turn 2: follow-up (sent 2026-11-20T06:51:08.027Z)
Step 1, Columns tab, says to add the field Manager (Business Object: Worker). In the Field search for the Worker business object (data source Workers for HCM Reporting) there is no field named just “Manager”. Searching “Manager” shows 80 results, the first ones being: Manager Change, Manager ID, Manager Role, Manager’s Position, Manager - Effective Dated, Manager - Level 01, Manager - Level 02, Manager - Level 03, Manager - Level 04, Manager - Level 05 ... and further down Previous Worker Manager, Worker’s Manager(s), Worker’s Matrix Manager, All Worker’s Manager(s), Is People Manager (with prompts), Workers as Leadership (including Manager).
Also, the data source “Workers by Organization” does not exist in the Data Source list (with Optimized for Performance ticked it offers only: Customer Invoices, Journal Lines for Financial Reporting, Positions for HCM Reporting, Trended Workers, Workers for HCM Reporting). I used Workers for HCM Reporting. Its Data Source Filter defaulted to “All Active Workers”.
Turn 2: answer (2026-11-20T06:51:35.139Z, 27.1 s)
Both of those make sense. I guessed some names from the standard delivered setup and got them wrong for your tenant. Here’s what to do.
Manager field: use Worker’s Manager(s)
- Add Worker’s Manager(s) and set its Column Heading Override to
Manager. It returns the worker’s direct manager, i.e. the manager of their primary supervisory org. For someone who manages that org themselves, it should return their boss in the org above, not themselves. Check this on one manager’s row in your test. - Don’t use Manager – Level 01 … 05. Those count down from the top of the org chart, so Level 01 is usually the CEO, not the direct manager.
- Manager ID gives an ID, not a name. Add it as an extra column only if you want both.
- Manager – Effective Dated needs a date prompt, which you don’t need here.
One thing to watch: Worker’s Manager(s) can hold more than one value, because an org can have more than one manager. If HCM1119 IT has a single manager, this won’t matter. If it has more, the CSV cell may contain several names. You can fix that with a calculated field:
- Task: Create Calculated Field
- Name:
CF Primary Manager - Business Object: Worker
- Function: Extract Single Instance
- Name:
- Source Field: Worker’s Manager(s). Leave the condition blank and choose to return the first instance.
- Use
CF Primary Managerin the report instead of Worker’s Manager(s), still headedManager.
Data source: Workers for HCM Reporting is the right pick
That’s fine, and keeping Data Source Filter = All Active Workers handles the “active only” part. You can drop the extra Active Status = Yes filter I gave you, since it’s redundant (leaving it in does no harm).
To limit the report to the org, go to the Filter tab and add:
| Field | Operator | Value |
|---|---|---|
| FieldSupervisory Organization | Operatorin the selection list | ValueHCM1119 IT |
This gives you only workers whose primary position sits directly in HCM1119 IT. It doesn’t include workers in orgs below it.
If you need the orgs underneath too: open the Data Source Filter dropdown and see whether there’s an organization-based option, e.g. “Workers for Organization” or similar with an Include Subordinate Organizations option. If there is, use it with HCM1119 IT. Run it once to make sure it still leaves out terminated workers. If there isn’t one, tell me which fields come up when you search “Superior” or “Organization” in the filter field picker, and I’ll point you to the right one. I don’t want to guess the field name again.
Also check before you finish the report
All Active Workers includes contingent workers. Contingent workers will have an empty Employee ID. If you only want employees, add a filter Worker Type = Employee. If you want everyone, add Contingent Worker ID as an extra column.
After that, run the report on its own once. Check the row count, and make sure the Manager column shows one name per row. Then go on to Step 2 (the EIB).
Turn 3: follow-up (sent 2026-11-20T07:10:36.167Z)
After building the five columns, adding the Filter row (Supervisory Organization - Primary Position, in the selection list, HCM1119 IT) and ticking Enable As Web Service on the Advanced tab, clicking OK on the custom report gives this error and the report is not saved: “Because the report is web service enabled, the field: Worker Types and prompt qualifier: combination must be specified in the Prompt Defaults grid on the Prompts tab.”
Turn 3: answer (2026-11-20T07:10:47.342Z, 11.2 s)
Workday shows this error when a report is set up as a web service and has a prompt that isn’t listed in the Prompt Defaults grid. The All Active Workers filter brings an optional Worker Types prompt with it, so that prompt needs a row in the grid. You don’t need to change anything else.
Fix
- Go to the Prompts tab.
- Under the Prompt Defaults grid, click Populate Undefined Prompt Defaults. This adds a row for Worker Types with prompt qualifier (none). If you don’t see the button, add the row yourself: Field = Worker Types, Prompt Qualifier left blank.
- Fill in the row based on who should be in the file:
| You want | Default Value | Do Not Prompt at Runtime |
|---|---|---|
| You wantEmployees only | Default ValueEmployee |
Do Not Prompt at Runtime✔ ticked |
| You wantEmployees + contingent workers | Default Valueleave blank | Do Not Prompt at Runtime✔ ticked |
Ticking Do Not Prompt at Runtime means the integration won’t stop to ask for a value when it’s launched.
- Click OK. The report should now save.
Notes
- If you pick Employees only here, you don’t need the separate Worker Type = Employee filter I mentioned last time. This default does the same job.
- If you leave it blank, the report should include all worker types. Run the report once to confirm that contingent workers show up (with an empty Employee ID) if you expected them.
- Supervisory Organization – Primary Position is the right filter field. It’s the same thing I meant by “Supervisory Organization”.
If Workday asks for another prompt default when you click OK, click Populate Undefined Prompt Defaults again and handle the new row the same way. Once the report saves, run it on its own to check the rows and the Manager column, then go on to Step 2 (Create EIB).