eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: PAY_US_CITY_NAMES

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

Primary Key: PAY_US_CITY_NAMES_PK

CITY_NAME
STATE_CODE
COUNTY_CODE
CITY_CODE

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_US_CITY_NAMES		PAY_US_CITY_GEOCODES	PAY_US_CITY_NAMES.STATE_CODE PAY_US_CITY_NAMES.COUNTY_CODE PAY_US_CITY_NAMES.CITY_CODE