Previous Topic: Timespan TableNext Topic: Transition_Points Table


Timezone Table

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_
Table::
enum

Specifies the Deleted flag, as follows:
0—Active
1—Inactive/marked as deleted

description

nvarchar(500)

 

Identifies the text description of the timezone.

dst_delta

INTEGER

 

Specifies the delta seconds for daylight saving time.

end_abs
_date

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
_date

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.