Turn 1
Sent: 2026-11-20T05:21:59Z Read: 2026-11-20T05:22:53Z
User: Please create a custom report in our Workday tenant called “Org Roster TT-WD”. When someone runs it, it should ask them to pick a supervisory organization and then list the active workers in that organization and all of its subordinate organizations. Columns: Worker, Employee ID, Supervisory Organization, Job Profile, Location, Hire Date, Manager. Sort it by Hire Date, earliest first. Our main test organization is “HCM1119 Outfitters”. Please build it in our Development tenant.
Agent reply:
I cannot create a custom report on your behalf as I do not have direct administrative tools to build, configure, or modify reports in your Workday tenants.
To create the “Org Roster TT-WD” report in your Development tenant, you will need to log in to that environment and build it manually. Here are the configuration details you can use to set it up:
Search for the Task: Search for the Create Custom Report task in your search bar. Report Setup:
- Report Name: Org Roster TT-WD
- Report Type: Advanced
- Data Source: Active Employees (or a similar data source containing active workers, depending on your tenant setup). Prompts:
- Add a prompt for Supervisory Organization.
- Ensure the prompt is configured to include subordinate organizations so that the report returns workers in both the selected organization and its subordinates. Columns to Add: Worker; Employee ID; Supervisory Organization; Job Profile; Location; Hire Date; Manager Sort Configuration: Set the sorting field to Hire Date and choose Ascending (earliest first). Testing: Run the report using your main test organization, HCM1119 Outfitters, to verify that the active workers, subordinates, and columns display as expected.
Follow-up 1 (Agent Chat greyed out while the task page was open and came back as a new conversation, so the original prompt was re-sent first)
Re-sent original prompt: 2026-11-20T05:32:51Z Agent reply (second conversation, again steps only; differs: Data Source “Active and Terminated Workers (or another worker-based data source containing active workers)”; prompts: enable “Include Subordinate Organizations”; same columns and sort).
Follow-up sent: 2026-11-20T05:33:44Z
Columns step says add a column Manager. In Create Custom Report, Columns tab, with data source Workers for HCM Reporting, searching the Field prompt for “Manager” returns 80 results and none is named exactly “Manager”. The list starts: 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 shows Manager’s Default Supervisory Organization, Manager and HR Partner Roles, Is Manager, Worker’s Manager, Worker’s Manager(s), Worker’s Matrix Manager, All Worker’s Manager(s), Previous Worker Manager.
Agent reply (read 2026-11-20T05:34:34Z):
When building a custom report on the worker business object (such as with the Workers for HCM Reporting data source), there are several fields related to managers depending on whether a worker has a single manager, multiple managers, or matrix relationships.
To display the worker’s direct primary manager, you should use one of the following fields from your search results:
Worker’s Manager: This field returns the single primary manager assigned to the worker. This is typically the most appropriate field for a standard roster report when you want to display a single manager name per worker. Worker’s Manager(s): This field returns all direct managers assigned to the worker. This is useful if your organization permits multiple direct managers for a single position.
Recommendation: For your “Org Roster TT-WD” report, select Worker’s Manager in the Field column. You can then change the Column Header Override text to simply read “Manager” so it displays exactly as you intended on the final report output.
Follow-up 2 (new conversation again; original prompt re-sent first at 2026-11-20T05:40:09Z; its reply was steps only again, same shape as turn 1)
Follow-up sent: 2026-11-20T05:40:59Z
Prompts step says go to the Prompts tab and add a prompt for Supervisory Organization. On the Prompts tab of Edit Custom Report (Org Roster TT-WD, data source Workers for HCM Reporting, filter All Active Workers), the table is “Prompt Defaults”; its Field prompt, when searched for “Supervisory Organization”, shows “No matches found”. Browsing All shows only 3 items: Contingent Worker Type, Employee Type, Worker Types. The Prompts tab has no option to include subordinate organizations; the row shows only Prompt Qualifier, Label for Prompt, Default Type, Default Value, Required and a Do Not Prompt at Runtime checkbox. The Sort tab Sort Direction field defaulted to “Alphabetical - Ascending” for Hire Date.
Agent reply (read 2026-11-20T05:41:54Z):
Why “Supervisory Organization” Is Missing from “Prompt Defaults”: the fields in the Prompt Defaults grid are determined by the Data Source Filter ... To prompt for a Supervisory Organization: Go to the Filter tab of your custom report definition. Add a new row to the filter criteria. Set the Field to Supervisory Organization. Set the Operator to “in the selection list”. Under the Value column, select “Prompt the user for the value” and choose the default prompt option (often named “Value from launch window” or similar). Once you save this filter configuration, Workday will automatically generate a runtime prompt for “Supervisory Organization”.
How to Include Subordinate Organizations: using a simple filter on the Supervisory Organization field alone will restrict results to only that exact level. On the Filter tab, instead of filtering on the field Supervisory Organization, use the built-in Workday hierarchical filter field. In the Field column, search for and select “Supervisory Organizations - Subordinate Organizations Included” or “Organizations - Subordinate Organizations Included” (depending on the exact fields enabled on your data source). Set the Operator to “in the selection list” or “contains”. Set the Value to “Prompt the user for the value” (value from launch window). At runtime, when the user selects “HCM1119 Outfitters”, Workday’s hierarchical engine will fetch workers from that organization and all nested subordinate teams.
Correcting the Sort Direction for “Hire Date”: Workday defaults to sorting dates alphabetically ... Change the Sort Direction from “Alphabetical - Ascending” to “Value - Ascending” or “Ascending” (which respects the underlying calendar value of the date field).