You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started with Redwood for Oracle Cloud HCM   Begin Now

What table(s) store US cities and counties?

Accepted answer
533
Views
2
Comments
in Payroll and Global Payroll Interface (GPI) 2 comments

Summary:

In order to show the names of the counties/cities that correspond to the numeric codes that are are stored in various Oracle tables, I need to know the name(s) of the table(s) that store this information. Better yet, if someone could provide me with SQL queries to pull this information (City/County codes and meaningful names), I would appreciate it.

Content (required):

For example, when running the below query for a particular person id, it returns numeric codes in CONTEXT_VALUE1 and CONTEXT_VALUE2. I know that CONTEXT_VALUE1 of 23 equates to US state MI (Michigan). However, I am trying to find the table that stores county codes and their meanings, as well as city codes and their meanings. In the below snip-it, I believe that CONTEXT_VALUE2 of 145 equates to "Saginaw", but I need to find the table that stores this information.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!