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_STATES

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

Primary Key: PAY_US_STATES_PK

STATE_CODE

Primary Key: PAY_US_STATES_UK2

STATE_ABBREV

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_US_COUNTIES	PAY_US_STATES	PAY_US_COUNTIES.STATE_CODE
PAY_US_EMP_CITY_TAX_RULES_F	PAY_US_STATES	PAY_US_EMP_CITY_TAX_RULES_F.STATE_CODE
PAY_US_EMP_COUNTY_TAX_RULES_F	PAY_US_STATES	PAY_US_EMP_COUNTY_TAX_RULES_F.STATE_CODE
PAY_US_EMP_FED_TAX_RULES_F	PAY_US_STATES	PAY_US_EMP_FED_TAX_RULES_F.SUI_STATE_CODE
PAY_US_EMP_STATE_TAX_RULES_F	PAY_US_STATES	PAY_US_EMP_STATE_TAX_RULES_F.STATE_CODE