Turn 1: prompt (sent 2026-11-20T04:47:03.240Z)
Please create a custom report in our Workday tenant called “Org Roster TT-CLA”. 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:55.274Z, 52 s)
I can’t log in to your Workday tenant, so I couldn’t create the report. Below are build steps you can follow in about 10 minutes. I’ve flagged the field and prompt names you should check, because they can vary slightly between tenants.
Build: “Org Roster TT-CLA”
1. Create the report
Task Create Custom Report:
| Setting | Value |
|---|---|
| SettingReport Name | ValueOrg Roster TT-CLA |
| SettingReport Type | ValueAdvanced |
| SettingOptimized for Performance | ValueChecked |
| SettingData Source | ValueWorkers by Organization |
| SettingTemporary Report | ValueUnchecked |
Workers by Organization is a delivered data source. It comes with an organization prompt and an Include Subordinate Organizations checkbox, so the “this org and everything under it” logic is built in. You don’t need a custom filter for the hierarchy, and that keeps the report fast.
2. Columns tab (Business Object: Worker)
| # | Field | Column Heading Override |
|---|---|---|
| #1 | FieldWorker | Column Heading OverrideWorker |
| #2 | FieldEmployee ID | Column Heading OverrideEmployee ID |
| #3 | FieldSupervisory Organization | Column Heading OverrideSupervisory Organization |
| #4 | FieldJob Profile | Column Heading OverrideJob Profile |
| #5 | FieldLocation | Column Heading OverrideLocation |
| #6 | FieldHire Date | Column Heading OverrideHire Date |
| #7 | FieldWorker’s Manager (or Manager) |
Column Heading OverrideManager |
⚠️ Manager field: Some tenants have both Manager and Worker's Manager. For someone who manages their own org, Manager can return that person instead of their boss. Worker's Manager handles this correctly. Use whichever your tenant has, and check the result on a manager in the test org (see step 7).
3. Sort tab
| Sort Field | Direction |
|---|---|
| Sort FieldHire Date | DirectionAscending |
4. Filter tab
Add one filter so the report only shows active workers:
| And/Or | Field | Operator | Comparison Type | Value |
|---|---|---|---|---|
| And/OrAnd | FieldActive Status (boolean; may appear as Active) |
Operatoris true | Comparison TypeValue specified in this filter | Value— |
Optional: if you want employees only and no contingent workers, add Worker Type in the selection list Employee. If you leave contingent workers in, their Employee ID cell will be blank.
5. Prompts tab
- Check Populate Undefined Prompt Defaults. This shows the data source’s prompts.
- Organization prompt: set the Label Override to
Supervisory Organizationand mark it required. Leave the default blank so users have to choose. You could temporarily default it toHCM1119 Outfitterswhile testing. - Include Subordinate Organizations prompt: default it to Yes/checked and check Do Not Prompt at Runtime. That way subordinate orgs are always included and users can’t accidentally turn it off.
ℹ️ Depending on your tenant, the organization prompt may let users pick any org type, not only supervisory orgs. If that’s a problem, tell me and I’ll give you a version that limits the choice to supervisory orgs.
6. Share tab
Share it with the security groups or users who need it. Then click OK to save.
7. Test with HCM1119 Outfitters
Run the report, pick HCM1119 Outfitters, and check:
- Hierarchy: Workers from orgs under HCM1119 Outfitters show up, not only people assigned directly to it. Compare the row count with the org chart or the delivered Workers by Organization report run with subordinates included.
- Active only: No terminated workers appear. Workers on leave should still appear, since they’re still active.
- Sort: The earliest Hire Date is at the top.
- Manager: For a manager inside the org, the Manager column shows their boss, not themselves.
- Employee ID: No blanks, unless you chose to include contingent workers.
If you’d like, I can also write a short description and help text for the report, or a version that adds a headcount subtotal for each supervisory org.
Sources:
- Workday Admin Guide: Data Sources
- Workday Education: Sorting, Filtering, Prompting and Totaling
- Geisinger Workday Training: Prompts and Filters (PDF)
- ServiceNow: Configure Workday report (Workers by Organization prompt setup)
- Texas A&M: Commonly Used Workday Reports
Turn 2: follow-up (sent 2026-11-20T05:24:46.610Z)
Step 1 says to set Data Source to “Workers by Organization” with “Optimized for Performance” checked. On the Create Custom Report screen (Report Type Advanced, Optimized for Performance checked) there is no data source named “Workers by Organization”. Typing “Workers by Organization” in the Data Source prompt and pressing Enter selects “Calculated Balances for Organization (by Worker)” as the only match. Typing “Workers” lists: Workers for HCM Reporting, Indexed All Workers, Trended Workers, Absence Occurrences for Workers (Indexed), Buy Time Off Events for Workers, Sell Time Off Events for Workers, Former Worker, Project Worker Days, Project Worker Holidays. The suggested shortcuts shown under the prompt are: Customer Invoices, Journal Lines for Financial Reporting, Positions for HCM Reporting, Trended Workers, Workers for HCM Reporting.
Turn 2: answer (2026-11-20T05:25:12.906Z, 26.3 s)
Step 1 was my mistake. When Optimized for Performance is checked, Workday lists only indexed data sources. Workers by Organization isn’t indexed, so it’s hidden, and Enter picked the nearest match. Don’t keep “Calculated Balances for Organization (by Worker)”. It’s the wrong business object.
You can fix this one of two ways. I’d try Option A first.
Option A (recommended): Workers for HCM Reporting, keep Optimized checked
This is Workday’s standard indexed data source for worker reports, so the report stays fast.
- On Create Custom Report, set Data Source =
Workers for HCM Reporting. Keep Optimized for Performance checked, then click OK. - On the Data Source Filter field above the tabs, open the dropdown. Look for an organization filter that has an Include Subordinate Organizations option, usually something like “…by Organization” or “Filter Workers by Organization”. I couldn’t confirm the exact name online, so pick the one whose prompts are an organization plus Include Subordinates.
- If you find it, the rest of my steps stay the same. On the Prompts tab, rename the org prompt to
Supervisory Organizationand make it required. Default Include Subordinates to Yes and set it to Do Not Prompt at Runtime. - Keep the Active Status is true filter from step 4. This data source can include terminated workers, so you need that filter.
Option B (fallback): uncheck Optimized for Performance
If Option A has no organization filter:
- On Create Custom Report, uncheck Optimized for Performance.
- Type
Workers by Organizationin Data Source. It should now show up. If it still doesn’t, tell me exactly what typing “Workers” lists with the box unchecked. - Follow steps 2–7 from my first message unchanged.
With an organization the size of HCM1119 Outfitters, you won’t notice the speed difference. It only matters when the data source is scanning the whole company.
Either way
Nothing has been saved yet, so starting again is fine. Click Cancel and redo step 1 with the settings above. Once you’ve opened the Data Source Filter dropdown in Option A, tell me what it lists and I’ll tell you which entry to pick.
Sources:
- Workday Admin Guide: Data Sources
- Workday Education: Reporting with HCM Data
- NSU: Workday Reporting – Reports Navigation
- Texas A&M: Commonly Used Workday Reports
- Scribd: Workday Data Sources list (unofficial)
Turn 3: follow-up (sent 2026-11-20T05:31:27.999Z)
Option A: I set Data Source = Workers for HCM Reporting (Optimized for Performance checked) and clicked OK. Workday opened the report editor as “Org Roster TT-CLA” (the report is saved; the page shows it as a Temporary Report). The Data Source Filter field defaulted to “All Active Workers”. Its dropdown lists exactly 10 entries: All Active Impacted Workers, All Active Workers, All Active Workers (All Types), All Employees, All Terminated Workers, All Workers, All Workers for Manage Work Schedule Assignments, All Workers for Mass Submit Time, All Workers with In Progress Calibration Event, Workers by Job Profile and Compensation Grade. None of them is an organization filter and none mentions subordinate organizations. Option B: I cancelled the editor and opened Create Custom Report again. After entering Report Name “Org Roster TT-CLA” Workday shows: “Error: Enter a unique name for the report. Another report already has this name.” So step 1 cannot be redone under that name, because the report from Option A already exists. Data Source cannot be changed on the existing report (it is shown as plain text in the editor).
Turn 3: answer (2026-11-20T05:31:48.632Z, 20.6 s)
The cleanest fix is to delete the report from Option A and create it again with Option B. Check that Option B will work before you delete anything, though.
1. Check that Workers by Organization exists
- Open Create Custom Report and enter a placeholder name such as
zz test. Set Report Type to Advanced and uncheck Optimized for Performance. - Type
Workers by Organizationin Data Source. Don’t click OK.- If it appears: click Cancel and go to step 2.
- If it doesn’t: click Cancel, stop here, and tell me what typing
Workerslists with the box unchecked. In that case, keeping the existing report and adding an organization-hierarchy filter may be the better route.
2. Delete the Option A report
- Search for
Org Roster TT-CLA. Before you delete it, check that it’s the one you just made: you’re the owner, it was created today, the data source is Workers for HCM Reporting, it has no columns, and it’s flagged Temporary. - From its related actions, choose Custom Report → Delete, or run the Delete Custom Report task, and confirm.
Deleting can’t be undone, but this report has nothing in it yet, so you lose nothing.
(Some tenants let you rename a custom report from its related actions. If yours does, you could rename it to free up the name instead of deleting it. Deleting is the simpler way to clean up.)
3. Recreate it
Run Create Custom Report again with:
- Report Name:
Org Roster TT-CLA - Report Type: Advanced
- Optimized for Performance: unchecked
- Data Source: Workers by Organization
- Temporary Report: unchecked. This is what caused the “Temporary Report” flag on the last one.
Then follow steps 2–7 from my first message: columns, Hire Date ascending sort, the Active Status is true filter, prompts (org prompt labeled Supervisory Organization and required; Include Subordinates defaulted to Yes with Do Not Prompt at Runtime), sharing, and the HCM1119 Outfitters test.
Once you’re in the new editor, tell me the exact prompt names under Populate Undefined Prompt Defaults and I’ll confirm how to set each one.