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

TABLE: AR.HZ_TIMEZONES

Object Details
Object Name: HZ_TIMEZONES
Object Type: TABLE
Owner: AR
FND Design Data: TableAR.HZ_TIMEZONES
Subobject Name:
Status: VALID


The HZ_TIMEZONES table stores information about time zones and daylight-saving time with reference to Greenwich Mean Time (GMT). For example, the Pacific Standard time zone on the western coast of the United States is eight hours behind GMT.
.
The primary key for this table is TIMEZONE_ID.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
HZ_TIMEZONES_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnTIMEZONE_ID
Columns
Name Datatype Length Mandatory Comments
TIMEZONE_ID NUMBER (15) Yes Timezone identifier
GLOBAL_TIMEZONE_NAME VARCHAR2 (50) Yes Name of a time zone associated with a specific deviation or difference in hours from Greenwich Mean Time.
GMT_DEVIATION_HOURS NUMBER
Yes Deviation or difference in hours from Greenwich Mean Time
DAYLIGHT_SAVINGS_TIME_FLAG VARCHAR2 (1) Yes Indicates if this is time zone uses daylight-saving time (DST). Y for a time zone using DST, N for a time zone that does not use DST.
BEGIN_DST_MONTH VARCHAR2 (3)
Month when daylight-saving begins
BEGIN_DST_DAY NUMBER

Day of the month when daylight-saving time begins
BEGIN_DST_WEEK_OF_MONTH NUMBER

Week of the month when daylight-saving time begins
BEGIN_DST_DAY_OF_WEEK NUMBER

Day of the week when daylight-saving time begins
BEGIN_DST_HOUR NUMBER

Hour of the day when daylight-saving time begins
END_DST_MONTH VARCHAR2 (3)
Month that daylight-saving time ends
END_DST_DAY NUMBER

Day of the month that daylight-saving time ends
END_DST_WEEK_OF_MONTH NUMBER

Week of the month that daylight-saving time ends
END_DST_DAY_OF_WEEK NUMBER

Day of the week that daylight-saving time ends
END_DST_HOUR NUMBER

Hour of the day that daylight-savings time ends
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).
STANDARD_TIME_SHORT_CODE VARCHAR2 (5)
Code for this time zone when not in daylight savings time, such as PST for Pacific Standard Time
DAYLIGHT_SAVINGS_SHORT_CODE VARCHAR2 (5)
Code for this time zone when in daylight savings time, such as PDT for Pacific Daylight Time
PRIMARY_ZONE_FLAG VARCHAR2 (1)
Y or N indicates whether or not this time zone is used in determining time zone based on GMT offset and daylight savings rule. Only one primary zone for each combination of GMT offset and daylight savings rule
Query Text

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


SELECT TIMEZONE_ID
,      GLOBAL_TIMEZONE_NAME
,      GMT_DEVIATION_HOURS
,      DAYLIGHT_SAVINGS_TIME_FLAG
,      BEGIN_DST_MONTH
,      BEGIN_DST_DAY
,      BEGIN_DST_WEEK_OF_MONTH
,      BEGIN_DST_DAY_OF_WEEK
,      BEGIN_DST_HOUR
,      END_DST_MONTH
,      END_DST_DAY
,      END_DST_WEEK_OF_MONTH
,      END_DST_DAY_OF_WEEK
,      END_DST_HOUR
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      STANDARD_TIME_SHORT_CODE
,      DAYLIGHT_SAVINGS_SHORT_CODE
,      PRIMARY_ZONE_FLAG
FROM AR.HZ_TIMEZONES;

Dependencies

[top of page]

AR.HZ_TIMEZONES does not reference any database object

AR.HZ_TIMEZONES is referenced by following:

SchemaAPPS
SynonymHZ_TIMEZONES