---
title: "Custom report, ChatGPT: the full transcript — Kiweely"
description: "Every turn of ChatGPT 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-cg
---

# T2 · CG · ChatGPT: OpenAI GPT-6.2 Astra (reasoning high) via Codex CLI

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

1.  **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](https://doc.workday.com/workday-education/en-us/course-manuals/advanced-workday-reporting-for-hcm/reporting-with-hcm-data.html)
    
2.  **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.
    
3.  **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 |
    | --- | --- |
    | Field | Supervisory Organization |
    | Operator | In the selection list |
    | Comparison Type | Value from another field |
    | Comparison Value | Prompt – Supervisory Organizations and Subordinates |
    
4.  **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](https://doc.workday.com/workday-education/en-us/course-manuals/creating-and-securing-integrations/building-custom-reports.html)
    
    | Prompt | Default | Runtime setting |
    | --- | --- | --- |
    | Supervisory Organization | No default value | Select **Required** and leave **Do Not Prompt at Runtime** unchecked |
    | Include Subordinate Organizations |  **Specify default value** and check **Yes** | Select **Do Not Prompt at Runtime** |
    
5.  **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.

1.  **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.
    
2.  **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 |
    | --- | --- |
    | Field |  **Supervisory Organization - Primary Position** |
    | Operator |  **in the selection list** |
    | Comparison Type |  **Value from another field** |
    | Comparison Value | Search 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](https://doc.workday.com/admin-guide/en-us/reporting-and-analytics/custom-reports-and-analytics/set-up-reports/dan1370796447961.html)
    
3.  **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](https://doc.workday.com/workday-education/en-us/course-manuals/creating-and-securing-integrations/building-custom-reports.html)
    
4.  **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.
