[Home] [Help] [Dependency Information]
Object Name: | HZ_TIMEZONE_MAPPING |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.HZ_TIMEZONE_MAPPING |
Subobject Name: | |
Status: | VALID |
The HZ_TIMEZONE_MAPPING table stores information about mapping a city, postal code, telephone area code, province, state, and country to a time zone. For example, Redwood City in California, USA could be mapped to the Pacific Standard time zone.
.
The primary key for this table is MAPPING_ID.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HZ_TIMEZONE_MAPPING_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
MAPPING_ID
ZD_EDITION_NAME |
HZ_TIMEZONE_MAPPING_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | COUNTRY |
HZ_TIMEZONE_MAPPING_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | TIMEZONE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MAPPING_ID | NUMBER | (15) | Yes | Address to timezone mapping identifier |
AREA_CODE | VARCHAR2 | (10) | Telephone area code | |
POSTAL_CODE | VARCHAR2 | (60) | Postal code | |
CITY | VARCHAR2 | (60) | Name of the city | |
STATE | VARCHAR2 | (60) | Name of the state | |
COUNTRY | VARCHAR2 | (60) | Yes | Name of the country |
PROVINCE | VARCHAR2 | (60) | Name of the province | |
TIMEZONE_ID | NUMBER | (15) | Yes | Timezone identifier. Foreign key to the HZ_TIMEZONES table. |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT MAPPING_ID
, AREA_CODE
, POSTAL_CODE
, CITY
, STATE
, COUNTRY
, PROVINCE
, TIMEZONE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM AR.HZ_TIMEZONE_MAPPING;
AR.HZ_TIMEZONE_MAPPING does not reference any database object
AR.HZ_TIMEZONE_MAPPING is referenced by following:
|
|
|