Q: Finding Job Codes instead of Job Name?

Question

I am looking for a listing of all the Job Codes that are used in the data warehouse, as I find it is easier to access data by Job Code rather than by Job Title.

Answer

You have access to a table called HR_JOBS, a master data table containing a list of jobs, job titles, pay grade, salary ranges and other job related data. You can query this table to get a list of Job Codes and Job Titles. You can also join it with the Appointment Tables.