Turn 1: prompt (sent 2026-11-20T04:46:50.397Z)
Please create a custom report in our Workday tenant called “Org Roster TT-GPT”. 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 give me what I need to build it.
Turn 1: answer (2026-11-20T04:47:39.357Z, 49 s)
I’ll check what Workday access is available here, then use that to build the report or give you the exact setup and a way to test it with HCM1119 Outfitters.
I don’t have a connection to your Workday tenant, so Org Roster TT-GPT still needs to be created and tested there. Here’s the build definition.
Create the report. Open Create Custom Report and enter Org Roster TT-GPT as the name. Select Advanced as the report type, Workers for HCM Reporting as the data source, and All Active Workers as the data source filter. This gives you one row per active worker, including active contingent workers. Workday HCM reporting guide
Add the columns in this order. On Columns, use the Worker business object and add Worker, Employee ID, Supervisory Organization, Job Profile, Location, Hire Date, and Manager. For workers with multiple jobs, use the primary job for organization membership, job profile, location, and manager so the row describes one assignment.
Filter by the selected hierarchy. On Filter, add one row with the settings below. This compares each worker’s supervisory organization with the selected organization and its descendants.
Filter setting Value Filter settingField ValueSupervisory Organization Filter settingOperator ValueIn the selection list Filter settingComparison Type ValueValue from another field Filter settingComparison Value ValuePrompt – Supervisory Organizations and Subordinates Show one required prompt. On Prompts, select Populate Undefined Prompt Defaults. Configure the rows below. If optional worker-type prompts appear, leave their values blank and select Do Not Prompt at Runtime for each. Workday custom report prompt guide
Prompt Default Runtime setting PromptSupervisory Organization DefaultNo default value Runtime settingSelect Required and leave Do Not Prompt at Runtime unchecked PromptInclude Subordinate Organizations DefaultSpecify default value and check Yes Runtime settingSelect Do Not Prompt at Runtime Set the sort and save. On Sort, add Hire Date as the first and only sort field and choose Ascending. Save the report.
Test with HCM1119 Outfitters. Run the report, select HCM1119 Outfitters at the prompt, and confirm that a direct worker and a worker in the deepest populated subordinate organization each appear once, under their own supervisory organizations. Check that a terminated worker and a worker from a sibling organization are both absent, and that the earliest hire date appears first. Run it again with a child organization to confirm the roster narrows to that branch.
Turn 2: follow-up (sent 2026-11-20T05:38:09.965Z)
I applied your steps in the Development tenant. Report “Org Roster TT-GPT” was created (Create Custom Report, type Advanced, data source Workers for HCM Reporting; the Data Source Filter field shows All Active Workers). Two things cannot be done as written.
Step 2: Worker business object. The columns Worker, Employee ID, Supervisory Organization, Job Profile, Location and Hire Date were each found by exactly that field name. For the column Manager, searching the field list for “Manager” returns 80 results and none is named just “Manager”. The names shown include: Manager Change, Manager ID, Manager Role, Manager’s Position, Manager - Effective Dated, Manager - Level 01 to Level 10, Manager’s Assigned Position, Manager’s Position(s), Manager’s Supervisory Organization, Manager’s Default Supervisory Organization, Manager and HR Partner Roles, Manager, Primary Recruiter, and Recruiter Roles, Manager Change as of Effective Date, Manager Preferred Name in General Display Format, Manager Preferred Name in Reporting Display Format, Worker’s Manager(s), Worker’s Matrix Manager, All Worker’s Manager(s), All Managers in Management Chain, All Worker’s Managers, All Worker’s Managers in Management Chain, Management Level, Organizations Managed.
Step 3: Filter tab. After adding the row, the Field prompt for the filter was searched for “Supervisory Organization”. It returns 4 results and none is named “Supervisory Organization”: Supervisory Organization - All Positions, Supervisory Organization - Primary Position, Supervisory Organization and Superior Organizations Viewable by Everyone, Plan Dimension as Supervisory Organization. So the filter row cannot be built with Field = Supervisory Organization.
I have not saved the changes made on the Edit Custom Report screen after these steps (columns 1 to 6 are entered, column 7 and the filter row are empty). Please give the corrected steps.
Turn 2: answer (2026-11-20T05:38:52.284Z, 42.3 s)
I’ll check how Workday defines the manager and organization fields you found, then give you the edits to make from the open screen.
Continue in the open Edit Custom Report screen for Org Roster TT-GPT. Keep columns 1–6 and the All Active Workers data source filter. My earlier steps gave two field names that don’t match your Development tenant’s pickers.
Columns, row 7. Set Business Object to Worker, select Manager Preferred Name in Reporting Display Format, and enter Manager in Column Heading Override. This displays the manager’s preferred name under the requested heading.
Filter. Complete the empty row as follows. This uses the worker’s primary position to determine roster membership. The comparison value supplies the selected organization and its descendants.
Setting Selection SettingField SelectionSupervisory Organization - Primary Position SettingOperator Selectionin the selection list SettingComparison Type SelectionValue from another field SettingComparison Value SelectionSearch for Subordinates and select Prompt – Supervisory Organizations and Subordinates The Comparison Value picker is a separate picker that you haven’t reached yet. If that prompt is missing, the exact choices returned by a search for Subordinates in that picker are what I’d need to identify the tenant-specific equivalent. Workday filter operator reference
Prompts. Click Populate Undefined Prompt Defaults. For Supervisory Organization, choose No default value, check Required, and leave it visible at runtime. For Include Subordinate Organizations, choose Specify default value, check the default value for Yes, and check Do Not Prompt at Runtime. If the data source adds optional worker-type prompts, leave their defaults blank and hide them at runtime. The runner should see just the organization picker. Workday prompt configuration guide
Sort and test. Set Hire Date to Ascending as the only sort, then save and run the report. Select HCM1119 Outfitters. Check that a direct worker and a worker from a nested subordinate organization both appear, that a worker from a sibling organization and a terminated worker are excluded, and that the earliest hire date is first. Spot-check one Manager value against the worker’s profile.