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.
Custom Reports
See the following: Custom Report Naming Guidelines