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 base dataset. These fields help you to uniquely identify rows in the table or base dataset from different integration runs.
If you're new to Workday, you don't have access to create or edit base datasets.
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.