Users with advanced knowledge of logical operators and the SQL programming language can create custom fields. Adding a custom field allows you to combine fields and functions into an SQL expression that is calculated on running the report. These SQL expressions can use functions and aggregates, as well as arithmetic, logical, and comparison operators.
Note: Currently, Dayforce doesn't support grouping custom fields configured with an aggregation function. Don’t apply the Group By checkbox to custom fields that are configured functions in the Fields tab of the ad hoc report builder. See Configure Grouping.
For a list of the functions and operators supported by custom fields, see Custom Field Functions Library. More information on SQL functions and examples of how they work are available from several online sources, including http://msdn.microsoft.com/en-us/library/ ms174318.aspx.
You can include fields in your expression that are available in your report's dataset. Some report topics come with preconfigured custom fields. For custom fields in reports based on V1 topics, you can include other custom fields in your expressions. For reports based on V2 topics and reports created from a blank dataset, custom fields are displayed in gray in the expression editor and you can't add them to your expression.
You can control access to the data in a custom field by specifying which access authorizations and people role security settings apply to it. Access authorizations control which data users can see based on the settings for their user role. If a user doesn’t have Can Read permissions for the access authorization that you select for the field, all of the data in that column is masked (****) in the report output.
People role security controls access to data for specific users at the user role level. If a user’s role has restrictions for certain other user roles for the people role security option selected, field values for individual employees are blank.
The following topics contain more information about custom fields: