TIMEZONEENTRYADJUSTMENTRULE (4.0SP17)

Contains daylight savings time rule information for time zones

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

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

Fields
Field	Field Type	Null	Notes	Description
STARTRULEDATE	datetime	false		Stores the date this rule starts
ENDRULEDATE	datetime	false		Stores the date this rule ends
ISFIXEDSTARTDATE	bit	false	0	Stores whether or not this is a fixed date rule for transition start
ISFIXEDENDDATE	bit	false	0	Stores whether or not this is a fixed date rule for transition end
STARTDAYOFWEEKCODE	tinyint	false	1	Stores day of week daylight savings time transition begins when rule is not fixed date
STARTDAYOFWEEK	nvarchar(9) (Computed)	true		Provides a translation for the 'STARTDAYOFWEEKCODE' field.
ENDDAYOFWEEKCODE	tinyint	false	1	Stores day of week daylight savings time transition ends when rule is not fixed date
ENDDAYOFWEEK	nvarchar(9) (Computed)	true		Provides a translation for the 'ENDDAYOFWEEKCODE' field.
STARTMONTHCODE	tinyint	false	1	Stores month daylight savings time transition begins when rule is not fixed date
STARTMONTH	nvarchar(9) (Computed)	true		Provides a translation for the 'STARTMONTHCODE' field.
ENDMONTHCODE	tinyint	false	1	Stores month daylight savings time transition ends when rule is not fixed date
ENDMONTH	nvarchar(9) (Computed)	true		Provides a translation for the 'ENDMONTHCODE' field.
STARTTIMEOFDAY	UDT_HOURMINUTE	false	''	Stores time daylight savings time transition begins when rule is not fixed date
ENDTIMEOFDAY	UDT_HOURMINUTE	false	''	Stores time daylight savings time transition ends when rule is not fixed date
STARTWEEKOFMONTHCODE	tinyint	false	1	Stores week of month daylight savings time transition begins when rule is not fixed date
STARTWEEKOFMONTH	nvarchar(6) (Computed)	true		Provides a translation for the 'STARTWEEKOFMONTHCODE' field.
ENDWEEKOFMONTHCODE	tinyint	false	1	Stores week of month daylight savings time transition ends when rule is not fixed date
ENDWEEKOFMONTH	nvarchar(6) (Computed)	true		Provides a translation for the 'ENDWEEKOFMONTHCODE' field.
STARTFIXEDDATE	datetime	true		Stores date (with 0001 year) daylight savings time transition starts when rule is fixed date
ENDFIXEDDATE	datetime	true		Stores date (with 0001 year) daylight savings time transition ends when rule is fixed date
DAYLIGHTSAVINGSDELTA	smallint	false	((0))	Stores the number of minutes difference between standard and daylight savings time
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.

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

Triggers
Trigger Name	Description
TR_TIMEZONEENTRYADJUSTMENTRULE_AUDIT_UPDATE
TR_TIMEZONEENTRYADJUSTMENTRULE_AUDIT_DELETE