Global Lookups
Applicable Product:
- Talent Management: Performance, Compensation
Applicable Release:
- V23.07+
Summary:
This feature adds a way to upload simple lookup tables as CSV files to speed up processing time when loading large amounts of data.
Detailed Information:
This update features a new Global Lookups feature that allows administrators to upload CSV files containing key/value pairs of data that will be used as simple (single axis, vertical only) lookup tables. This can save a lot of time over the classic lookups when a simple lookup table has many rows.
This feature is accessed by going to Menu > Talent Management Administration > Site Configuration > Data Tools > Global Lookups.
Clicking the Add button allows you to upload a CSV file containing key/value pairs. This can be used in formulas as a simple single axis lookup table that will process quickly, even when there are thousands of rows.
The CSV file will look something like this:
Global lookups cannot be viewed in the application; you can only download the CSV file and view it in a spreadsheet application such as Microsoft Excel or a text editor. To download the file, edit the record and click the Preview button.
The Global Lookups feature is also available to data processing scripts, and thus is usable anywhere that scripting is used in Talent Management.
A new method has been added to the Talent Management Pseudo Model under CommonUtil:
| Method | Description |
| getGlobalLookupValue | Returns a value from a Key/Value map based on the string parameters that are passed. The string parameters are "GlobalLookup Name" and "Key" and the return value is a string. When using this method in a formula or alert, the value will need to be converted. For example, if in a formula the output field used is an integer, then the value will need to be converted into an integer or there will be errors in the formula. |
Keywords: Lookup, 23.07 Enhancement
Created: Derrick Kwong
Reviewed: