Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 STARTRULEDATE datetime   Stores the date this rule starts
 ENDRULEDATE datetime   Stores the date this rule ends
 ISFIXEDSTARTDATE bit   Default = 0 Stores whether or not this is a fixed date rule for transition start
 ISFIXEDENDDATE bit   Default = 0 Stores whether or not this is a fixed date rule for transition end
 STARTDAYOFWEEKCODE tinyint   Default = 1 Stores day of week daylight savings time transition begins when rule is not fixed date
 STARTDAYOFWEEK nvarchar(9) (Computed) CASE [STARTDAYOFWEEKCODE] WHEN 1 THEN N'Sunday' WHEN 2 THEN N'Monday' WHEN 3 THEN N'Tuesday' WHEN 4 THEN N'Wednesday' WHEN 5 THEN N'Thursday' WHEN 6 THEN N'Friday' WHEN 7 THEN N'Saturday' END Provides a translation for the 'STARTDAYOFWEEKCODE' field.
 ENDDAYOFWEEKCODE tinyint   Default = 1 Stores day of week daylight savings time transition ends when rule is not fixed date
 ENDDAYOFWEEK nvarchar(9) (Computed) CASE [ENDDAYOFWEEKCODE] WHEN 1 THEN N'Sunday' WHEN 2 THEN N'Monday' WHEN 3 THEN N'Tuesday' WHEN 4 THEN N'Wednesday' WHEN 5 THEN N'Thursday' WHEN 6 THEN N'Friday' WHEN 7 THEN N'Saturday' END Provides a translation for the 'ENDDAYOFWEEKCODE' field.
 STARTMONTHCODE tinyint   Default = 1 Stores month daylight savings time transition begins when rule is not fixed date
 STARTMONTH nvarchar(9) (Computed) CASE [STARTMONTHCODE] WHEN 1 THEN N'January' WHEN 2 THEN N'February' WHEN 3 THEN N'March' WHEN 4 THEN N'April' WHEN 5 THEN N'May' WHEN 6 THEN N'June' WHEN 7 THEN N'July' WHEN 8 THEN N'August' WHEN 9 THEN N'September' WHEN 10 THEN N'October' WHEN 11 THEN N'November' WHEN 12 THEN N'December' END Provides a translation for the 'STARTMONTHCODE' field.
 ENDMONTHCODE tinyint   Default = 1 Stores month daylight savings time transition ends when rule is not fixed date
 ENDMONTH nvarchar(9) (Computed) CASE [ENDMONTHCODE] WHEN 1 THEN N'January' WHEN 2 THEN N'February' WHEN 3 THEN N'March' WHEN 4 THEN N'April' WHEN 5 THEN N'May' WHEN 6 THEN N'June' WHEN 7 THEN N'July' WHEN 8 THEN N'August' WHEN 9 THEN N'September' WHEN 10 THEN N'October' WHEN 11 THEN N'November' WHEN 12 THEN N'December' END Provides a translation for the 'ENDMONTHCODE' field.
 STARTTIMEOFDAY UDT_HOURMINUTE   Default = '' Stores time daylight savings time transition begins when rule is not fixed date
 ENDTIMEOFDAY UDT_HOURMINUTE   Default = '' Stores time daylight savings time transition ends when rule is not fixed date
 STARTWEEKOFMONTHCODE tinyint   Default = 1 Stores week of month daylight savings time transition begins when rule is not fixed date
 STARTWEEKOFMONTH nvarchar(6) (Computed) CASE [STARTWEEKOFMONTHCODE] WHEN 1 THEN N'First' WHEN 2 THEN N'Second' WHEN 3 THEN N'Third' WHEN 4 THEN N'Fourth' WHEN 5 THEN N'Fifth' END Provides a translation for the 'STARTWEEKOFMONTHCODE' field.
 ENDWEEKOFMONTHCODE tinyint   Default = 1 Stores week of month daylight savings time transition ends when rule is not fixed date
 ENDWEEKOFMONTH nvarchar(6) (Computed) CASE [ENDWEEKOFMONTHCODE] WHEN 1 THEN N'First' WHEN 2 THEN N'Second' WHEN 3 THEN N'Third' WHEN 4 THEN N'Fourth' WHEN 5 THEN N'Fifth' END Provides a translation for the 'ENDWEEKOFMONTHCODE' field.
 STARTFIXEDDATE datetime Stores date (with 0001 year) daylight savings time transition starts when rule is fixed date
 ENDFIXEDDATE datetime Stores date (with 0001 year) daylight savings time transition ends when rule is fixed date
 DAYLIGHTSAVINGSDELTA smallint   Default = ((0)) Stores the number of minutes difference between standard and daylight savings time
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.

Foreign Key Field Type Null Notes Description
 TIMEZONEENTRYID uniqueidentifier   TIMEZONEENTRY.ID Stores the time zone entry id for this rule.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_TIMEZONEENTRYADJUSTMENTRULE_DATEADDED DATEADDED    
 IX_TIMEZONEENTRYADJUSTMENTRULE_DATECHANGED DATECHANGED      
 PK_TIMEZONEENTRYADJUSTMENTRULE ID  

Trigger Name Description
 TR_TIMEZONEENTRYADJUSTMENTRULE_AUDIT_UPDATE
 TR_TIMEZONEENTRYADJUSTMENTRULE_AUDIT_DELETE

Entity-Relationship diagram of this table