This table contains the Timezones used in CA SDM applications.
|
Field |
Data Type |
Reference |
Remarks |
|---|---|---|---|
|
code |
nvarchar(12) |
|
Primary key of this table. |
|
del |
INTEGER |
Active_Boolean_ |
Specifies the Deleted flag, as follows: |
|
description |
nvarchar(500) |
|
Identifies the text description of the timezone. |
|
dst_delta |
INTEGER |
|
Specifies the delta seconds for daylight saving time. |
|
end_abs |
LOCAL_TIME |
|
Identifies the absolute start date. |
|
end_day |
INTEGER |
|
Represents the end day of the week, such as 0-6. |
|
end_mon |
INTEGER |
|
Represents the ending month, such as 0-11 for the month of the year. |
|
end_pos |
INTEGER |
|
Represents the ending position, such as 0 for "First" or 1 for "Last". |
|
gmt_delta |
INTEGER |
|
Represents the delta seconds from GMT. |
|
id |
INTEGER |
|
Identifies the numeric ID, which is unique to the table. |
|
last_mod_by |
byte(16) |
ca_contact::uuid |
Specifies the UUID of the contact who last modified this record. |
|
last_mod_dt |
INTEGER |
|
Identifies the timestamp for when this record was last modified. |
|
persid |
nvarchar(30) |
|
Persistent ID (SystemObjectName:id). |
|
start_abs |
INTEGER |
|
Identifies the absolute start date. |
|
start_day |
INTEGER |
|
Represents the Start day used to calculate DST, for example, 0-6 day of the week. |
|
start_mon |
INTEGER |
|
Represents the starting month for the timezone, such as 0-11 for the month of the year. |
|
start_pos |
INTEGER |
|
Represents the starting position, such as 0 for "First" or 1 for "Last". |
|
sym |
nvarchar(30) |
|
Specifies the name of the service type. |
|
Copyright © 2013 CA.
All rights reserved.
|
|