The Data Dictionary provides a centralized view of all data fields available across the YäRKEN application. It serves as a reference for understanding data structures and downloading standardized templates for data loading.
Use the Data Dictionary to:
-
Download data templates for supported datasets
-
Review field names, descriptions, and data types
-
Identify mandatory and optional fields for data uploads
-
Understand the impact and severity (high or low) of missing data in each field
How to use the Data Dictionary
Procedure
To download a template file,
-
Navigate to Admin > Data Dictionary.
-
Use the search box or browse the list in the left pane.
-
Select a data table, for example, Actual Spend.
-
Once selected, the system displays all fields associated with that data table.
-
In the upper-right corner, click DOWNLOAD.
-
(Optional) Enable Include Field Descriptions to include detailed field descriptions in the downloaded files.
The system downloads a ZIP file containing:
-
A .csv file — the data template to be used for uploads
-
A .xlsx file — the data dictionary with field definitions, data types, mandatory flags, and impact severity
When to use the Data Dictionary
Use the Data Dictionary when you:
-
Prepare files for data uploads
-
Validate field requirements before loading data
-
Troubleshoot upload errors caused by missing or incorrect fields
-
Understand the business impact of incomplete data