New Tz_Offset Table (in FI_Data_2)
- Last UpdatedDec 18, 2018
- 1 minute read
This table maintains a list of regions and their time zone rules for a period of several years in the past and future. It is maintained by the Middleware Host Service.
|
Field |
Datatype |
PK |
Nulls? |
Description |
|---|---|---|---|---|
|
region_id |
string80 |
N |
N |
The name of the timezone region to which this row of data belongs. Each row represents a period of time |
|
year |
int32 |
N |
N |
The year this time period starts in |
|
dst |
logical |
N |
N |
Specifies if this period is a DST period or not |
|
default_region |
logical |
N |
N |
Specifies if this is the system’s default region. Only one region should have this set to 1. This is enforced by the middleware |
|
start_utc |
tdatetime |
N |
N |
The UTC time that is the start of this period |
|
start_local |
tdatetime |
N |
N |
The local time that is the start of this period |
|
end_utc |
tdatetime |
N |
N |
The UTC time that is the end of this period |
|
end_local |
tdatetime |
N |
N |
The local time that is the end of this period |
|
offset |
int32 |
N |
N |
The offset from UTC in minutes for this period |
|
row_id |
ID 0 |
Y |
N |
Unique row identifier |