Table: PAY_US_COUNTIES

Product:	PAY - Payroll
Description:	US counties and their VERTEX geocodes, used to validate US addresses.
Implementation/DBA Data:	HR.PAY_US_COUNTIES

Primary Key: PAY_US_COUNTIES_PK

1. STATE_CODE
2. COUNTY_CODE

Primary Key: PAY_US_COUNTIES_UK2

1. COUNTY_NAME
2. STATE_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_US_COUNTIES		PAY_US_STATES	PAY_US_COUNTIES.STATE_CODE
PAY_US_CITY_GEOCODES		PAY_US_COUNTIES	PAY_US_CITY_GEOCODES.STATE_CODE PAY_US_CITY_GEOCODES.COUNTY_CODE
PAY_US_COUNTY_SCHOOL_DSTS		PAY_US_COUNTIES	PAY_US_COUNTY_SCHOOL_DSTS.STATE_CODE PAY_US_COUNTY_SCHOOL_DSTS.COUNTY_CODE
PAY_US_EMP_COUNTY_TAX_RULES_F		PAY_US_COUNTIES	PAY_US_EMP_COUNTY_TAX_RULES_F.STATE_CODE PAY_US_EMP_COUNTY_TAX_RULES_F.COUNTY_CODE