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:
- It restricts to Active workers (if your tenant’s org filter includes terminated workers, add the active filter in Step 4 below).
- 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-inInclude Subordinate Organizationsprompt 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
- Field:
- 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 haveActive Status = Yes).
- Employees only (exclude Contingent Workers): Add
5. Configure Runtime Prompts (Prompts tab)
First, check Populate Undefined Prompt Defaults so Workday loads the prompts from your Data Source Filter. Then configure:
Organizations(orSupervisory 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 Outfittersif 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.)
- Label for Prompt:
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)
- Default Type:
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
- Click OK to save the report, then click Run.
- At the prompt screen, select
HCM1119 Outfittersfor Supervisory Organization and click OK. - Verify the output against these checks:
- Subordinate roll-up: Confirm the
Supervisory Organizationcolumn contains workers from bothHCM1119 Outfittersand 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 Dateat the top and progress chronologically downward. - Contingent workers (if applicable): Check whether any contingent workers under
HCM1119 Outfittershave blankEmployee IDorHire Datevalues and adjust per Steps 2 & 4 if needed.
- Subordinate roll-up: Confirm the
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
...onWorkers 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
Filter tab (ensure Active workers only): Unlike
All Active Workers,Workers for all Organizationscan 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, useWorker Statusin the selection listActive)
- Field:
Prompts tab: Check
Populate Undefined Prompt Defaultsto 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
- Label for Prompt:
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)
- Default Type:
- (If an
Include Terminated Workersor similar status prompt appears, default it to unchecked/Noand check Do Not Prompt at Runtime.)
- Organization prompt (e.g.,
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:
- Keep
All Active Workersas the Data Source Filter and filter on the Filter tab usingWorker‘s hierarchy/all-organizations field (so it captures the selected supervisory org and every subordinate org below it), or - Switch the Data Source itself (not the filter) to a delivered org-prompted Data Source like
Workers by OrganizationorEmployees 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:
- Change Default Type from
Specify default valueto blank /No default value(clear the field). - Leave Default Value unchecked/blank.
- Keep
Do Not Prompt at Runtimechecked.
Recommended settings for all 8 prompt rows
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 yourActive Status = Yesrow 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 toSpecify 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.