Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
How do I pull US school district codes and their meanings for US states such as Ohio and PA?
Summary:
I need to pull the school district names and numeric codes from Oracle to help users map numeric codes to meaningful names.
Content (required):
I need to pull the US school district codes and their meanings from Oracle, but I have not been able to find the table that tracks this information. For example, Oracle's seeded Tax Withholding Card Audit Report shows the numeric code of "15200" for the Resident School District/Work School District for an employee, but the Tax Withholding screen in Oracle shows "Downingtown ASD". Our users need to see the names of the school districts and not the numerical codes. Can someone let me know the name of the table that stores this information or, better yet, provide a SQL query?
Tagged:
0