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_ZIP_CODES

Product:	PAY - Payroll
Description:	Valid zip code ranges for VERTEX cities, used to validate US addresses.
Implementation/DBA Data:	HR.PAY_US_ZIP_CODES

Primary Key: PAY_US_ZIP_CODES_PK

ZIP_START
ZIP_END
STATE_CODE
COUNTY_CODE
CITY_CODE

Foreign Keys

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