Skip to content
KiweelyKiweelyKiweely

T2 · GE · Gemini: Google Gemini 4 Neon (High) via Antigravity CLI

On this page

Turn 1: prompt (sent 2026-11-20T04:49:09.217Z)

Please create a custom report in our Workday tenant called “Org Roster TT-GEM”. 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:51:28.016Z, 138.8 s)

I don’t have direct access to your Workday tenant to create the report for you, so here is the complete configuration specification and step-by-step build guide to create Org Roster TT-GEM in Workday Report Writer.


1. Create the Report Definition

Search for and open the Create Custom Report task, then enter:

Setting Value
SettingReport Name ValueOrg Roster TT-GEM
SettingReport Type ValueAdvanced (required to configure Prompts, Filters, and Sort)
SettingOptimized for Performance ValueChecked
SettingTemporary Report ValueUnchecked
SettingData Source ValueWorkers for HCM Reporting (indexed; Primary Business Object = Worker)
SettingData Source Filter ValueActive Workers by Organization (or Workers by Organization — see note below)

Data Source Filter check: Click the related actions (...) next to the Data Source Filter → Data Source Filter > View to confirm:

  1. It restricts to Active workers (if your tenant’s org filter includes terminated workers, add the active filter in Step 4 below).
  2. It exposes built-in prompts for Organizations and Include Subordinate Organizations.

Why use this filter instead of a manual Filter tab rule? A standard Filter tab rule (Supervisory Organization in the selection list) only matches the exact org picked and does not recurse down child organizations. Using a Data Source Filter with the built-in Include Subordinate Organizations prompt handles arbitrary hierarchy depth natively and performs much faster.


2. Configure Columns (Columns tab)

Keep Business Object set to Worker for all 7 rows and add them in this exact order:

# Business Object Field Column Heading Override Notes
#1 Business ObjectWorker FieldWorker Column Heading OverrideWorker NotesFull name (links to worker profile)
#2 Business ObjectWorker FieldEmployee ID Column Heading OverrideEmployee ID NotesNote: Blank for Contingent Workers. If you want IDs for both employees and contingent workers, use Worker ID instead.
#3 Business ObjectWorker FieldSupervisory Organization Column Heading OverrideSupervisory Organization NotesWorker’s assigned supervisory org
#4 Business ObjectWorker FieldJob Profile Column Heading OverrideJob Profile NotesPrimary job profile
#5 Business ObjectWorker FieldLocation Column Heading OverrideLocation NotesPrimary work location
#6 Business ObjectWorker FieldHire Date Column Heading OverrideHire Date NotesMost recent hire date (use Original Hire Date only if you want initial hire date for rehires)
#7 Business ObjectWorker FieldWorker's Manager Column Heading OverrideManager NotesOverride heading to Manager

3. Configure Sorting (Sort tab)

# Field Direction
#1 FieldHire Date DirectionAscending (earliest hire date first)
#2 (optional tie-breaker) FieldWorker DirectionAscending (alphabetical for same-day hires)

4. Configure Filtering (Filter tab)

  • If your Data Source Filter already limits to Active workers: Leave the Filter tab empty.
  • If your Data Source Filter includes terminated workers: Add:
    • Field: Active Status | Operator: equal to | Comparison Type: Value specified in this filter | Comparison Value: Yes
  • Optional scope refinements:
    • Employees only (exclude Contingent Workers): Add Worker Type | in the selection list | Employee.
    • Exclude workers on Leave of Absence: Add On Leave | equal to | No (in Workday, workers on leave still have Active Status = Yes).

5. Configure Runtime Prompts (Prompts tab)

First, check Populate Undefined Prompt Defaults so Workday loads the prompts from your Data Source Filter. Then configure:

  1. Organizations (or Supervisory Organizations)
    • Label for Prompt: Supervisory Organization
    • Required: Checked (prevents users from accidentally running an unfiltered tenant-wide query)
    • Do Not Prompt at Runtime: Unchecked
    • Default Type: Leave blank so users must choose an org each time (or set Specify Default Value → HCM1119 Outfitters if you want it pre-populated while remaining editable).
    • (Tip: If the delivered prompt allows any Organization type rather than only Supervisory Organizations, restrict it to Supervisory Organizations via the prompt’s valid-value/type configuration if available in your Data Source Filter, or select a Supervisory-Organization-specific filter.)
  2. Include Subordinate Organizations
    • Default Type: Specify Default Value
    • Default Value: Checked (Yes)
    • Do Not Prompt at Runtime: Checked (locks subordinates ON automatically so runners only have to pick the supervisory org and don’t have to remember to check the box)

6. Share & Security (Share tab)

  • Leave as Do not share report definition while testing.
  • Once verified, switch to Share with specific authorized groups and users and add the target security groups (e.g., HR Partner, Manager, Report Viewer).
  • Workday will automatically enforce each runner’s existing row-level and field-level security (e.g., Worker Data: Public Worker Reports, Worker Data: Current Staffing Information), so users only see workers they are authorized to view.

7. Save and Test with HCM1119 Outfitters

  1. Click OK to save the report, then click Run.
  2. At the prompt screen, select HCM1119 Outfitters for Supervisory Organization and click OK.
  3. Verify the output against these checks:
    • Subordinate roll-up: Confirm the Supervisory Organization column contains workers from both HCM1119 Outfitters and its child/subordinate supervisory orgs.
    • Active only: Confirm no terminated workers appear in the results.
    • Columns & order: Confirm the 7 columns appear as Worker, Employee ID, Supervisory Organization, Job Profile, Location, Hire Date, Manager.
    • Sort order: Confirm rows start with the oldest/earliest Hire Date at the top and progress chronologically downward.
    • Contingent workers (if applicable): Check whether any contingent workers under HCM1119 Outfitters have blank Employee ID or Hire Date values and adjust per Steps 2 & 4 if needed.

Turn 2: follow-up (sent 2026-11-20T05:31:17.654Z)

Step 1 says set the Data Source Filter to “Active Workers by Organization” (or “Workers by Organization”). Searching the Data Source Filter prompt for “Active Workers by Organization” shows “No matches found”. The Data Source Filter list shows: 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, and more. Searching for “Organization” returns 3 results: Workers by Learning Organization, Workers for all Organizations, Workers in Organizations - Employee Reviews. There is no filter named “Workers by Organization”. The field is required and currently shows “All Active Workers” by default.

Turn 2: answer (2026-11-20T05:33:45.892Z, 148.2 s)

Good catch — Active Workers by Organization / Workers by Organization is not a Data Source Filter on Workers for HCM Reporting. Use Workers for all Organizations from the 3 results you found.

What to select in Step 1

  • Data Source: Workers for HCM Reporting
  • Data Source Filter: Workers for all Organizations

(Quick check before clicking OK: click the related actions ... on Workers for all Organizations → Data Source Filter > View to confirm what prompts it brings in and whether it includes terminated workers.)

Adjustments for Steps 4 & 5 with Workers for all Organizations

  1. Filter tab (ensure Active workers only): Unlike All Active Workers, Workers for all Organizations can return terminated/inactive workers. Unless it has a built-in prompt that excludes them, add this row on the Filter tab:

    • Field: Active Status
    • Operator: equal to
    • Comparison Type: Value specified in this filter
    • Comparison Value: Yes (if your tenant uses a status list instead, use Worker Status in the selection list Active)
  2. Prompts tab: Check Populate Undefined Prompt Defaults to reveal the filter’s built-in prompts, then configure:

    • Organization prompt (e.g., Organizations):
      • Label for Prompt: Supervisory Organization
      • Required: Checked
      • Do Not Prompt at Runtime: Unchecked
    • Include Subordinate Organizations (if exposed):
      • Default Type: Specify Default Value
      • Default Value: Checked (Yes)
      • Do Not Prompt at Runtime: Checked (so subordinates are always included automatically)
    • (If an Include Terminated Workers or similar status prompt appears, default it to unchecked/No and check Do Not Prompt at Runtime.)

If Workers for all Organizations does not include an Include Subordinate Organizations prompt

Let me know what prompts appear after clicking Populate Undefined Prompt Defaults, and we can either:

  1. Keep All Active Workers as the Data Source Filter and filter on the Filter tab using Worker‘s hierarchy/all-organizations field (so it captures the selected supervisory org and every subordinate org below it), or
  2. Switch the Data Source itself (not the filter) to a delivered org-prompted Data Source like Workers by Organization or Employees by Organization (if present in your tenant).

Turn 3: follow-up (sent 2026-11-20T05:58:18.325Z)

Applied “Workers for all Organizations” as the Data Source Filter, the Active Status filter row, and the prompt settings. Populate Undefined Prompt Defaults filled 8 prompt rows: Organizations by Type, Contingent Worker Type, Employee Type, Worker Types, Active, Include Subordinate Organizations, Include Terminated Workers, Remove Exclude From Headcount. I set Organizations by Type to label “Supervisory Organization” (Required checked, Do Not Prompt unchecked), and Include Subordinate Organizations to Specify default value with the Default Value box checked and Do Not Prompt at Runtime checked. For Include Terminated Workers I chose Default Type “Specify default value”, left the Default Value box unchecked, and checked Do Not Prompt at Runtime. On OK, Workday does not save and shows: “Default Value (Row 7 Column 7) - The field Default Value is required and must have a value.” The Default Value for that row is a single checkbox, and it is unchecked as the answer says. Nothing is saved until this error is resolved.

Turn 3: answer (2026-11-20T05:59:08.610Z, 50.3 s)

That’s a classic Workday checkbox-prompt quirk: for a single-checkbox (Boolean) prompt, Workday treats an unchecked box in Default Value as blank, so choosing Specify default value only validates when the checkbox is checked (True).

How to fix Row 7 (Include Terminated Workers)

Because Include Terminated Workers is an optional (non-required) checkbox prompt, leave its default blank to make it evaluate as unchecked (False) at runtime:

  1. Change Default Type from Specify default value to blank / No default value (clear the field).
  2. Leave Default Value unchecked/blank.
  3. Keep Do Not Prompt at Runtime checked.

To ensure the report only asks the user to pick a Supervisory Organization (and hides the other 7 prompts cleanly), configure all 8 rows like this:

Row Prompt Label for Prompt Default Type Default Value Required Do Not Prompt at Runtime
Row1 PromptOrganizations by Type Label for PromptSupervisory Organization Default Type(blank) Default Value(blank) RequiredChecked Do Not Prompt at RuntimeUnchecked
Row2 PromptContingent Worker Type Label for Prompt(default) Default Type(blank) Default Value(blank) RequiredUnchecked Do Not Prompt at RuntimeChecked
Row3 PromptEmployee Type Label for Prompt(default) Default Type(blank) Default Value(blank) RequiredUnchecked Do Not Prompt at RuntimeChecked
Row4 PromptWorker Types Label for Prompt(default) Default Type(blank) Default Value(blank) RequiredUnchecked Do Not Prompt at RuntimeChecked
Row5 PromptActive Label for Prompt(default) Default TypeSpecify default value Default ValueChecked (or Yes) RequiredUnchecked Do Not Prompt at RuntimeChecked
Row6 PromptInclude Subordinate Organizations Label for Prompt(default) Default TypeSpecify default value Default ValueChecked RequiredUnchecked Do Not Prompt at RuntimeChecked
Row7 PromptInclude Terminated Workers Label for Prompt(default) Default Type(blank / No default value) Default Value(blank) RequiredUnchecked Do Not Prompt at RuntimeChecked
Row8 PromptRemove Exclude From Headcount Label for Prompt(default) Default Type(blank / No default value) Default Value(blank) RequiredUnchecked Do Not Prompt at RuntimeChecked

Two quick notes on Rows 5 & 8:

  • Row 5 (Active): Setting this to checked + hidden filters to active workers right at the Data Source Filter level (you can keep your Active Status = Yes row on the Filter tab as a safeguard, or remove it after verifying).
  • Row 8 (Remove Exclude From Headcount): Leaving this unchecked/blank excludes any positions flagged Exclude from Headcount (Workday’s standard roster/headcount behavior). If you want those workers included too, switch Row 8 to Specify default value + Checked.

Click OK after clearing Default Type on Row 7 — the report should save cleanly, and running it will prompt only for Supervisory Organization.