HRSD - HR Generic Lookup Table - How developers populate, How to use in Record Producers

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2025 06:43 AM
Might I ask for some more detailed information on exactly HOW to populate the HR Generic Lookup Table with data? We have created fields "Category" and "Subcategory" in our HR Services. There are many, across several COEs and several HR Services.
We would like to populate the HR Generic Lookup Table with all of these choices and then reference them within the HR services. The plan is to have variables in the Record producer be "reference" and look at the Generic Lookup Table for values (with a reference qualifier?). AND these variable are conditional, based on user selection. (i.e. - user selects Benefits category and sees Vision subcategory to select)
Attached is the IMPORT table we have configured with (possible) fields to populate.
1) Help us understand what to populate in each field for appropriate update??
2) What (if any) reference qualifier to use with these (reference) variables in the Record Producer??
Display Value | Value | Active | HR Service | Depends On | Order | Integration Value | Updated | Element | Domain |
Benefits | benefits | true | General Inquiry | 100 | ? | ? | ? | ? | |
Vision | vision | true | General Inquiry | Benefits | 100 | ? | ? | ? | ? |
Not sure these values (or headers) are correct... Any help/guidance would help!!
Category: u_category = Benefits
Subcategory: u_subcategory = Vision
@MadisonP @keithlyon