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_GEOCODES

Product:	PAY - Payroll
Description:	Holds all distinct combinations of state code, county code and city code.
Implementation/DBA Data:	HR.PAY_US_CITY_GEOCODES

Primary Key: PAY_US_CITY_GEOCODES_PK

STATE_CODE
COUNTY_CODE
CITY_CODE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_US_CITY_GEOCODES	PAY_US_COUNTIES	PAY_US_CITY_GEOCODES.STATE_CODE PAY_US_CITY_GEOCODES.COUNTY_CODE
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
PAY_US_CITY_SCHOOL_DSTS	PAY_US_CITY_GEOCODES	PAY_US_CITY_SCHOOL_DSTS.STATE_CODE PAY_US_CITY_SCHOOL_DSTS.COUNTY_CODE PAY_US_CITY_SCHOOL_DSTS.CITY_CODE
PAY_US_EMP_CITY_TAX_RULES_F	PAY_US_CITY_GEOCODES	PAY_US_EMP_CITY_TAX_RULES_F.STATE_CODE PAY_US_EMP_CITY_TAX_RULES_F.COUNTY_CODE PAY_US_EMP_CITY_TAX_RULES_F.CITY_CODE
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