DBA Data[Home] [Help] [Dependency Information]

TABLE: HR.PAY_US_ZIP_CODES

Object Details
Object Name: PAY_US_ZIP_CODES
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_US_ZIP_CODES
Subobject Name:
Status: VALID


PAY_US_ZIP_CODES holds a list of valid zip code ranges for US cities.
It is used to validate US addresses, only if US Payroll is installed.
Geocodes are used by the VERTEX tax module to uniquely identify
specific tax jurisdictions.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 20
PCT Used:
Primary Key: PAY_US_ZIP_CODES_PK
  1. ColumnZIP_START
  2. ColumnZIP_END
  3. ColumnSTATE_CODE
  4. ColumnCOUNTY_CODE
  5. ColumnCITY_CODE
Indexes
Index Type Uniqueness Tablespace Column
PAY_US_ZIP_CODES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnZIP_START
ColumnZIP_END
ColumnSTATE_CODE
ColumnCOUNTY_CODE
ColumnCITY_CODE
PAY_US_ZIP_CODES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnSTATE_CODE
ColumnCOUNTY_CODE
ColumnCITY_CODE
PAY_US_ZIP_CODES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnZIP_START
PAY_US_ZIP_CODES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnZIP_END
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_US_ZIP_CODES PAY_US_ZIP_CODES_FK1 TablePAY_US_CITY_GEOCODES PAY_US_ZIP_CODES STATE_CODE
PAY_US_ZIP_CODES COUNTY_CODE
PAY_US_ZIP_CODES CITY_CODE
Columns
Name Datatype Length Mandatory Comments
ZIP_START VARCHAR2 (10) Yes Start of zip code range.
ZIP_END VARCHAR2 (10) Yes End of zip code range.
STATE_CODE VARCHAR2 (2) Yes State geocode. Foreign key to PAY_US_COUNTIES.
COUNTY_CODE VARCHAR2 (3) Yes County geocode. Foreign key to PAY_US_COUNTIES.
CITY_CODE VARCHAR2 (4) Yes City geocode. Foreign key to PAY_US_CITY_GEOCODES.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ZIP_START
,      ZIP_END
,      STATE_CODE
,      COUNTY_CODE
,      CITY_CODE
FROM HR.PAY_US_ZIP_CODES;

Dependencies

[top of page]

HR.PAY_US_ZIP_CODES does not reference any database object

HR.PAY_US_ZIP_CODES is referenced by following:

SchemaAPPS
SynonymPAY_US_ZIP_CODES
SchemaPUBLIC
SynonymPAY_US_ZIP_CODES