Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
Steps: Create a Table Manually

Steps: Create a Table Manually

Security:
Prism: Tables Create
 domain in the Prism Analytics functional area.
You can create a table by manually defining each field in the table schema. When you create a table manually, the table is empty. You can create a data change task to load data into the table.
  1. Access the
    Data Catalog
     report.
  2. Select
    Create
    Table
    .
  3. Enter the
    Table Name
    . You can change the table name when you edit the table.
  4. (Optional) Change the
    Table API Name
    .
    Workday automatically selects an API name based on the table name that you enter, modifying it to make it meet the name requirements. Click
    Change
     to change the API name. You can’t change this name after you finish creating the table.
  5. (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.
  6. (Optional) Create or edit 1 or more
    Tags
     to organize the table in the Data Catalog.
  7. (Optional) Add a
    Description
     to help others understand what data this table contains.
  8. On the
    Select Schema Source
     step, select
    Manual Input
    .
    The
    Edit Schema
     step displays where you can define each field in the table schema.
  9. Click
    Add Field
     to add 1 or more fields.
  10. In the inspector panel for the field, configure the field attributes.
Create a data change task to load data into the table.

This content is not part of the Workday Administrator Guide.