Reference: WPA_ Fields
When you create any table or a base dataset that uses an integration, Workday automatically
creates extra fields in the table or dataset. These fields help you to uniquely
identify rows in the table or dataset from different integration runs.
Field Name | Description |
|---|---|
WPA_LoadID | This field returns a value of type Text containing a unique identifier of the integration
run or data load activity that imported the current row of data into the
dataset or table. Workday adds this field to both tables and datasets. |
WPA_LoadTimestamp | This field returns a value of type Date (to the millisecond) containing the date and time
of the integration run that imported the current row of data into the
dataset or table. Workday adds this field to both tables and datasets. |
WPA_RowID | This field returns a value of type Text containing a unique row identifier for each row in
a data load activity or integration run. Workday adds this field to tables. |
WPA_UpdateID | This field returns a value of type Text containing a unique identifier of the data load
activity that updated the current row of data in the table. Workday adds this field to tables. |
WPA_UpdateTimestamp | This field returns a value of type Date (to the millisecond) containing the date and time
of the data load activity that updated the current row of data in the
table. Workday adds this field to tables. |
You can’t modify or delete these fields, but you can hide them. Use these fields with the
other fields to uniquely identify rows of data in the table or dataset from multiple
integrations.
You can also use these fields to group data together from a single data load or integration.
Example: you can create a Group By stage and group on the WPA_LoadID field and Count
the number of rows from each integration run.