Guide: Workday / Prism report naming

Objective

  • To provide information about the adopted best practices for naming Prism objects in Workday

Scope

  • Recommended naming standards and guidelines

User

  • Prism Developers

Environment

  • 1191721: Workday Prism

Prism Naming Guidelines

Tables

General Naming Guidelines

Development

Start with a standard abbreviation for the data source found below, followed by a space, then the Title, then the dataset or table type abbreviation found below.
<SRC><Title><Type>

  • Be Specific - More detailed names are useful in communicating the purpose of the dataset
  • Undersocres - Don’t use underscores in table / dataset names
  • Ampersand(&) – Spell out the word ‘and’ instead of using an ampersand (&)
  • Fields - Follow a standardized naming convention when adding fields to your tables and datasets

*Note: The Prism team will add abbreviations as new sources of data are identified.
Recommended abbreviations for the source of data

Source Abbreviation
Date Warehouse DW
Workday WD

 

Datasets

General Naming Guidelines

Development

Begin with a descriptive title then the dataset type abbreviation found below.
<Title<Type>

  • Be Specific - More detailed names are useful in communicating the purpose of the dataset
  • Undersocres - Don’t use underscores in table / dataset names
  • Ampersand(&) – Spell out the word ‘and’ instead of using an ampersand (&)
  • Fields - Follow a standardized naming convention when adding fields to your tables and datasets

Recommended abbreviations for dataset and table types:

Type Abbreviation
Table TBL
Base Dataset BDS
Derived Dataset DDS
Published Dataset PDS

 

Data Source

General Naming Guidelines

Published

Begin with the abbreviation for the general area found below, followed by a space, then a descriptive title, then PDS.
<GA><Title><PDS>

  • Be Specific - More detailed names are useful in communicating the purpose of the dataset
  • Undersocres - Don’t use underscores in table / dataset names
  • Ampersand(&) – Spell out the word ‘and’ instead of using an ampersand (&)
  • Fields - Follow a standardized naming convention when adding fields to your tables and datasets
General Area Abbreviation
Human Capital Management HCM
Payroll PAY
Finance FIN
Student STU
Compliance COM

 

Tagging

Leverage tagging to organize the objects in the Data Catalog.

 

Concept: Data Catalog

Custom Reports

See the following for guidelines: Custom Report Naming Guidelines

 

Print Article

Details

Article ID: 155140
Created
Wed 10/25/23 8:57 AM
Modified
Tue 1/30/24 1:24 PM
Can you resolve this issue yourself?
Yes! This is self-service with a smile.
Supported Office or Community
University Community of Students, Staff, and Faculty