HRSD - generic lookup table

[Colleen]

I have a requirement for a custom multi-select field to be added to a table that extends HR case (sn_hr_core_case).  I can use the List data type but would need a table to store the choices.  I took a look at the tables that came with HRSD application and found Generic Lookup (sn_hr_core_generic_look_up) which appears to be suitable but I cannot find any information on how to use it.  The Generic Lookup table contains no data and has no fields except for sys id, created on etc.

Is there any guidance on how to use the Generic Lookup table in HRSD?  For clarity, sn_hr_core_generic_look_up DOES NOT extend dl_matcher.

[Colleen Lowe]

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	?	?	?	?

Does this look correct?

Category: u_category is Benefits
Subcategory: u_subcategory is Vision

[ChrisBurks]

Hi @Colleen Lowe ,

Let me see if I understand correctly what the ask is.

You have structured the generic look up table already with the columns shown in your last post. In your prior post you're asking how to get the required information into the generic look up table, such as populate the cells that contain the question marks displayed in your post. Is that correct?

If my assumption is correct a data source flat file (CSV, Excel, JSON, XML etc.) can be used to import and populate the table. It can also do a direct database connection to a third party database to grab the data needed. 

Here's the ServiceNow documentation on setting up a Data Source:

https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/import-sets/c...

There is also a feature known as Easy Import:

https://www.servicenow.com/docs/bundle/yokohama-integrate-applications/page/administer/import-sets/c...

As well as the "Load data" module that guides you on loading a flat file similar to the Easy Import feature:

Hopefully, I understood the question and this helps you.