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.

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

TABLE: HR.PAY_CA_DISPLAY_CITIES

Object Details

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

PAY_CA_DISPLAY_CITIES holds a list of Canadian city names
and their geocodes mapped on to their correct Canadian French
spelling.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_CA_DISPLAY_CITIES_UI	NORMAL	UNIQUE	APPS_TS_SEED	CITY_NAME STATE_CODE COUNTY_CODE CITY_CODE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
CITY_NAME	VARCHAR2	(30)	Yes	City name.
STATE_CODE	VARCHAR2	(2)	Yes	Foreign key to PAY_US_COUNTIES.
COUNTY_CODE	VARCHAR2	(3)	Yes	Foreign key to PAY_US_COUNTIES.
CITY_CODE	VARCHAR2	(4)	Yes	Foreign key to PAY_US_CITY_GEOCODES.
DISPLAY_CITY_NAME	VARCHAR2	(90)	Yes	Represents correct Canadian French spelling of city name
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT CITY_NAME
,      STATE_CODE
,      COUNTY_CODE
,      CITY_CODE
,      DISPLAY_CITY_NAME
,      ZD_EDITION_NAME
FROM HR.PAY_CA_DISPLAY_CITIES;

Dependencies

[top of page]

HR.PAY_CA_DISPLAY_CITIES does not reference any database object

HR.PAY_CA_DISPLAY_CITIES is referenced by following:

HR: PAY_CA_DISPLAY_CITIES#