TZDstRule Table (247)

•
Environment: onsite, online
• 2 minutes to read
 • 2 minutes to read

Time zone rule for daylight saving time

Fields

Name Description Type Null
TZDstRule_id Primary key PK
TZLocationId Location that this rule is valid for - one location may have one or more rules; multiple rules are discerned by their validFrom dates FK TZLocation
validFrom Date this rule is valid from DateTime
bias number of minutes bias relative to UTC time Short
startRule DST start rule, such as 0200 1ST-SUN-APR; limited to rules that we have parse code for; use dayOfMonth etc for custom rules String(254) ●
endRule DST end rule, such as 2300 LST-SAT-OCT; limited to rules that we have parse code for; use dayOfMonth etc for custom rules String(254) ●
startDayOfMonth Custom DST start day, if 0 then parse startRule UShort ●
startMonth Custom DST start month, if 0 then parse startRule UShort
endDayOfMonth Custom DST end day, if 0 then parse endRule UShort
endMonth Custom DST end month, if 0 then parse endRule UShort
description Description, for identifying the rule in SoAdmin String(2047) ●
isBuiltIn Is this row part of SuperOffice priming data Bool ●
registered Registered when UtcDateTime
registered_associate_id Registered by whom FK associate
updated Last updated when UtcDateTime
updated_associate_id Last updated by whom FK associate
updatedCount Number of updates made to this record UShort

TZDstRule table relationship diagram

Indexes

Fields Types Description
TZDstRule_id PK Clustered, Unique
TZLocationId FK Index

Relationships

Table Description
associate Employees, resources and other users - except for External persons
TZLocation Time zone location

Replication Flags

  • Replicate changes DOWN from central to satellites and travellers.
  • Replicate changes UP from satellites and travellers back to central.
  • Copy to satellite and travel prototypes.

Security Flags

  • No access control via user's Role.