Reference: Data Type Mapping
Workday supports a fixed set of data types in its reports. Report Designer data types can
differ slightly. This table describes how Workday data types map to Report Designer
data types.
Workday Data Type | Report Designer Data Type | Notes |
|---|---|---|
Text | String | |
Decimal | Decimal | |
Boolean | Boolean | By default, Boolean data type values display as true or false in a
report's PDF. However, you can add logic to the report design (using a
JavaScript expression, for example) to have it display yes or
no in the PDF instead. |
Date | Date | |
DateTime | Timestamp | |
Currency | Decimal | Workday provides a Show Currency Code Column option for
currency values. If you select this option when creating or editing a custom
report, Workday displays an additional Currency
column when you run the report. In Report Designer, this selection
translates to an additional Currency field in the
data set. |
Multi-instance | Secondary Data Set | Multi-instance type fields represent the one-to-many relationship a
primary business object has with a related business object. A multi-instance
field can contain multiple values, with each value representing an instance
in the related business object that is linked to the primary business
object. |
Reference ID | String | A Reference ID is a unique identifier for a specific instance of a
business object in Workday. |
Rich Text | String | Report Designer treats rich text values as strings. However, these values can contain HTML
tags. To display the formatted text in a PDF, rather than the HTML tags,
use the Dynamic Text component from the Report
Designer palette. |