[Home] [Help] [Dependency Information]
Object Name: | PAY_US_STATES |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_US_STATES |
Subobject Name: | |
Status: | VALID |
PAY_US_STATES holds the list of US states and the geocodes used by the
VERTEX tax module to identify tax jurisdictions. It is used to
validate US addresses and tax information only if US Payroll is
installed.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_US_STATES_PK | NORMAL | UNIQUE | APPS_TS_SEED |
STATE_CODE
ZD_EDITION_NAME |
PAY_US_STATES_UK2 | NORMAL | UNIQUE | APPS_TS_SEED |
STATE_ABBREV
ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STATE_CODE | VARCHAR2 | (2) | Yes | State geocode. |
STATE_ABBREV | VARCHAR2 | (2) | Yes | Abbreviation for state, eg. CA. |
STATE_NAME | VARCHAR2 | (25) | Yes | State name. |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT STATE_CODE
, STATE_ABBREV
, STATE_NAME
, ZD_EDITION_NAME
FROM HR.PAY_US_STATES;
HR.PAY_US_STATES does not reference any database object
HR.PAY_US_STATES is referenced by following:
|
|
|