How to create a Lookup Table in NetSuite?

I'm hoping for guidance to help optimize a workflow. It's a simple lookup, but I'm having trouble finding the best method in NetSuite.

Our goal is to determine a RATE on the Employee record based on selected criteria/fields on the Employee record.

For example:

An employee record is created and has the following values:

-Job Code: Technical Consultant

-Solution Family: Chemical Management

This would calculate a $200 rate.

We want to avoid scripting. We can figure this out with a workflow, but it's tedious as we have many different job codes and solution families. Ideally, we'd like a solution that can look up in a table (possible a custom record?) where the Finance team can maintain the rates or add new job codes in case they change.