While you're editing a report, you can open the Add Field dialog box by clicking Fields > Add Field. The Add Field dialog box displays fields that you can add to your report's dataset, grouped into entities.
Role feature access: Reporting and Analytics > Reporting > Report Designer > Dataset Builder
You can click an entity in the list to view more information about it:
You can filter the list of entities using the following fields above the list:
- Categories: Select one or more options to display entities from the selected Dayforce feature areas.
- Keyword: Enter keywords to filter the entity names or field names.
- Related Entity Filter: Select one of the entities that are already in your report's dataset. This filters the list to show entities that can be joined to the selected entity.
- Relationship Levels: Select how many levels of relationships can be used to join the entities. For example, Employee > Employee Employment Status is a level 1 relationship and Employee > Employee Employment Status > Employment Status Reason is a level 2 relationship, and Employee > Employee Employment Status > Employment Status Reason > Employee Work Assignment is a level 3 relationship.
Note: The list can display up to 100 entities. If your filter criteria return too many results, you will be prompted to refine your search. If your search returns no results, change the filter criteria to broaden the search.
When you click the expand icon to the left of an entity, Dayforce displays the fields that it contains. When you select a field in the list, the right-side panel displays more information about the field:
The details about the field and the sample data are intended to help you confirm that you're adding fields to your report that will display the correct data.