| Name | R_Timezone |
|---|---|
| Entity Type | Table |
| Description | A reference table for time zones. A time zone is a region of the Earth that uses the same standard time (the "local" time) throughout. Moving west, adjacent time zones increment by one hour. Local time is computed as an offset, in hours and minutes, from UTC (also known as Greenwich Mean Time (GMT)). |
| Submodel | Spatial |
| Entity Scope | Reference |
| Primary Key | Code |
| Natural Key | Code |
| Generalizations | Reference_Entity , Reference_Entity_Parent |
| Specializations |
| Name | Value Domain | Property / Storage Unit | Description | Required / Default | Type |
|---|---|---|---|---|---|
| Active_Flag | boolean | NA |
1 = use without restriction. 0 = avoid use - the value has been deprecated and may be removed in a later release. | Yes 1 |
NUMBER(1) |
| Code | CODE | NA |
A standard abbreviation, mnemonic, or short code that represents the reference value. | Yes |
VARCHAR2(64) |
| Daylight_Time_Full_Name | STRING255 | NA |
Full name of the time zone when in daylight saving (summer) time. | No |
VARCHAR2(255) |
| Daylight_Time_Offset | NUMBER | No_Unit |
The hours to be added to the local time to convert to daylight saving (summer) time. The same number is subtracted to convert from daylight time to standard time. The month, day, and time of day that the conversions occur are defined in the two attributes: To_Daylight_Time_Rule and To_Standard_Time_Rule. | No |
NUMBER |
| Daylight_Time_Short_Name | STRING255 | NA |
Abbreviation of the time zone name when in daylight saving (summer) time. For example, the abbreviation for Central Daylight Time is CDT. | No |
VARCHAR2(255) |
| Description | STRING2000 | NA |
A textual definition of the reference value. | No |
VARCHAR2(2000) |
| Insert_Date | DATE | NA |
Date the entity was created in the repository | No |
DATE |
| Insert_User | STRING64 | NA |
The name of the user responsible for the creation of this entity in the repository. | No |
VARCHAR2(64) |
| Name | STRING255 | NA |
The spelled-out name of the reference value. | No |
VARCHAR2(255) |
| Source | CODE | NA |
The person, company or application that defined or specified the data (content) for this instance and is considered to be responsible for it. For example, POSC, EPSG, API, ISO, etc.. | No |
VARCHAR2(64) |
| Standard_Time_Full_Name | STRING255 | NA |
Full name of the time zone when in standard time. | No |
VARCHAR2(255) |
| Standard_Time_Short_Name | STRING255 | NA |
Abbreviation of the time zone name when in standard time. For example, the abbreviation for Central Standard Time is CST. | No |
VARCHAR2(255) |
| To_Daylight_Time_Rule | STRING255 | NA |
A rule that defines when the time zone shifts from standard time to daylight saving (summer) time. | No |
VARCHAR2(255) |
| To_Standard_Time_Rule | STRING255 | NA |
A rule that defines when the time zone shifts from daylight saving (summer) time to standard time. | No |
VARCHAR2(255) |
| UTC_Offset | NUMBER | No_Unit |
The hours to be added to the time at the zero meridian of Greenwich (UTC - Coordinated Universal Time) to get the local time. | No |
NUMBER |
| Update_Date | DATE | NA |
Date of the most-recent modification to the entity. | No |
DATE |
| Update_User | STRING64 | NA |
The name of the user responsible for the last modification to this entity. | No |
VARCHAR2(64) |
| From Entity | Link | Description | Implementation Technique | Required |
|---|---|---|---|---|
| Alternate_Position | Timezone | The Universal Coordinated Time (UTC) Code for the time zone in which the position resides. | Restrict | No |
| Geopolitical_Position | Timezone | The Universal Coordinated Time (UTC) Code for the time zone of this position. | Restrict | No |