Body
Objective
- To provide information about the adopted best practices for naming Prism objects in Workday
Scope
- Recommended naming standards and guidelines
User
Environment
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