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

Colleen Lowe
Tera Contributor

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 ValueValueActiveHR ServiceDepends OnOrderIntegration ValueUpdatedElementDomain
BenefitsbenefitstrueGeneral Inquiry 100????
VisionvisiontrueGeneral InquiryBenefits100????


Not sure these values (or headers) are correct...  Any help/guidance would help!!
 Category: u_category = Benefits
Subcategory: u_subcategory = Vision

@MadisonP @keithlyon 

0 REPLIES 0