[Home] [Help] [Dependency Information]

TABLE: HR.PAY_US_CITY_GEOCODES

Object Details

Object Name:	PAY_US_CITY_GEOCODES
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_US_CITY_GEOCODES
Subobject Name:
Status:	VALID

PAY_US_CITY_GEOCODES holds all distinct combinations of state
code, county code and city code.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Primary Key: PAY_US_CITY_GEOCODES_PK

1. STATE_CODE
2. COUNTY_CODE
3. CITY_CODE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_US_CITY_GEOCODES_PK	NORMAL	UNIQUE	APPS_TS_SEED	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

Columns

Query Text

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

SELECT STATE_CODE
,      COUNTY_CODE
,      CITY_CODE
FROM HR.PAY_US_CITY_GEOCODES;

Dependencies

[top of page]

HR.PAY_US_CITY_GEOCODES does not reference any database object

HR.PAY_US_CITY_GEOCODES is referenced by following:

APPS

PAY_US_CITY_GEOCODES

PUBLIC

PAY_US_CITY_GEOCODES