---
title: "Custom report, Claude: the full transcript — Kiweely"
description: "Every turn of Claude on the custom report task in Kiweely’s Workday tenant test, word for word with its times."
url: https://kiweely.com/tenant-test/transcripts/t2-cl
---

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

## 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 |
| --- | --- |
| Report Name | `Org Roster TT-CLA` |
| Report Type |  **Advanced** |
| Optimized for Performance | Checked |
| Data Source |  **Workers by Organization** |
| Temporary Report | Unchecked |

**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 | Worker | Worker |
| 2 | Employee ID | Employee ID |
| 3 | Supervisory Organization | Supervisory Organization |
| 4 | Job Profile | Job Profile |
| 5 | Location | Location |
| 6 | Hire Date | Hire Date |
| 7 | Worker’s Manager *(or `Manager`)* | Manager |

⚠️ **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 |
| --- | --- |
| Hire Date |  **Ascending** |

### 4\. Filter tab

Add one filter so the report only shows active workers:

| And/Or | Field | Operator | Comparison Type | Value |
| --- | --- | --- | --- | --- |
| And | Active Status *(boolean; may appear as `Active`)* | is true | Value specified in this filter | — |

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:

-   [Workday Admin Guide: Data Sources](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/data-sources/bqs1550609116077.html)
-   [Workday Education: Sorting, Filtering, Prompting and Totaling](https://doc.workday.com/workday-education/en-us/course-manuals/workday-reporting/sorting-filtering-prompting-and-totaling.html)
-   [Geisinger Workday Training: Prompts and Filters (PDF)](https://workdaytraining.geisinger.org/PDFContent/J132_PromptsAndFilters.pdf)
-   [ServiceNow: Configure Workday report (Workers by Organization prompt setup)](https://www.servicenow.com/docs/r/u~ldaY8ZPxJiUgZ1Inf6mw/wabaJhz7U8C_vuGv~QCvlQ)
-   [Texas A&M: Commonly Used Workday Reports](https://employees.tamu.edu/Data-Analytics/workday-reports.html)

## 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.

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:

-   [Workday Admin Guide: Data Sources](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/data-sources/cku1571160115869.html)
-   [Workday Education: Reporting with HCM Data](https://doc.workday.com/workday-education/en-us/course-manuals/advanced-workday-reporting-for-hcm/reporting-with-hcm-data.html)
-   [NSU: Workday Reporting – Reports Navigation](https://tdx.nsu.edu/TDClient/30/Portal/KB/Article/287/Workday-Reporting-Reports-Navigation)
-   [Texas A&M: Commonly Used Workday Reports](https://employees.tamu.edu/Data-Analytics/workday-reports.html)
-   [Scribd: Workday Data Sources list (unofficial)](https://www.scribd.com/document/421723913/Workday-Data-Sources-xlsx)

## 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.
