All time sensitive data will be stored according to the base Time Zone defined on the installation record. The time zone table is used to define other time zones necessary for the application. When data being entered into the system is related to a time zone other than that defined on the installation record, the time zone information may be used by integration/interface logic to convert the data into the base time zone for storage on the database.
Open
to define the time zones and their relation to the base time.Description of Page
Enter a unique Time Zone and Description for the time zone.
Select the Time Zone Name from the list of Olson time zone values.
Indicate the Shift in Minutes that this time zone differs from the base time zone defined on the Installation Options (for Customer Care and Billing - Interval Billing applications only).
Indicate the Seasonal Time Shift applicable for this time zone (for Customer Care and Billing - Interval Billing applications only).
Default Time Zone Label is used to identify displayed and input times for non-shifted time. For example, the US/Central label would be CST. If specified, this label must be different from the Default Time Zone Label.
Shifted Time Zone Label is used to identify displayed and input times when time is shifted (typically by daylight savings time). For example, the US/Central label would be CDT.
Where Used
Follow this link to open the data dictionary where you can view the tables that reference CI_TIME_ZONE.
Copyright © 2011, Oracle and/or its affiliates. All rights reserved.