Skip to content
KiweelyKiweelyKiweely

T2 · CL · Claude: Anthropic Claude Opus 5.5 (effort high) via Claude Code CLI

On this page

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 Organization and mark it required. Leave the default blank so users have to choose. You could temporarily default it to HCM1119 Outfitters while 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:

  1. 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.
  2. Active only: No terminated workers appear. Workers on leave should still appear, since they’re still active.
  3. Sort: The earliest Hire Date is at the top.
  4. Manager: For a manager inside the org, the Manager column shows their boss, not themselves.
  5. 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:

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.

This is Workday’s standard indexed data source for worker reports, so the report stays fast.

  1. On Create Custom Report, set Data Source = Workers for HCM Reporting. Keep Optimized for Performance checked, then click OK.
  2. 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.
  3. If you find it, the rest of my steps stay the same. On the Prompts tab, rename the org prompt to Supervisory Organization and make it required. Default Include Subordinates to Yes and set it to Do Not Prompt at Runtime.
  4. 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:

  1. On Create Custom Report, uncheck Optimized for Performance.
  2. Type Workers by Organization in Data Source. It should now show up. If it still doesn’t, tell me exactly what typing “Workers” lists with the box unchecked.
  3. 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:

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

  1. Open Create Custom Report and enter a placeholder name such as zz test. Set Report Type to Advanced and uncheck Optimized for Performance.
  2. Type Workers by Organization in 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 Workers lists 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

  1. 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.
  2. 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.