Edit a Table

Any of these security requirements:

Prism Datasets: Owner Manage
domain in the Prism Analytics functional area.

Prism Datasets: Manage
domain in the Prism Analytics functional area.

Table Editor
permission on the table.

Table Owner
permission on the table.

Table Schema Editor
permission on the table.

You can edit a table by:

Changing the table display name.

Changing the schema.

You can change the table schema by:

Adding fields.

Deleting fields.

Changing field attributes (including field type).

You can only change field attributes when the table contains no data.

When you edit a table, Workday enables you to change the table schema. If you have no change, you can select

to edit the table attributes by:

Changing the table display name.

Enabling it for analysis.

Adding or removing tags.

Access the

View Table Details

report for a table.

Select

Edit Schema

from the

Quick Actions

button, or from the related actions menu, select

Table

Edit

(Optional) Click

Add Field

to add 1 or more fields. In the inspector panel for the field, configure the field attributes.

(Optional) Delete a field by clicking the trash can in the right-most column of a field in the list.

(Optional) Change the field attributes of an existing field.

Select a field in the list, and view the field details in the inspector panel on the right side.

In the inspector panel for the field, change the field attributes. You can't change the API name.

Click

(Optional) Change the

Table Display Name

(Optional) Select

Enable for Analysis

to create a Prism data source using the data in this table.

Workday recommends enabling a table for analysis after:

You apply the appropriate data source security to the table.

The table contains the data that you want and receives new and updated data from a data change task.

(Optional) Create or edit 1 or more