> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# TZLocation table

> Time zone location

## TZLocation Table (245)

Time zone location

## Fields

| Name                      | Description                                                                                                                                                        | Type                            | Nullable |
| ------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------ | ------------------------------- | :------: |
| TZLocation\_id            | Primary key                                                                                                                                                        | PK                              |    No    |
| countryId                 | Country that this timezone location is defined for                                                                                                                 | FK [country](./country.mdx)     |    No    |
| locationCode              | Code, such as CA-NT, identifying the timezone location in the imported data. Unique, NOT equal to the culture codes of Windows                                     | String(29)                      |    No    |
| groupName                 | Group (heading) name for timezone locations that do not have a country (such as the EU zones)                                                                      | String(254)                     |    Yes   |
| regionName                | Name of region, such as Northwest Territories. Future localization via localeText resource type 31                                                                 | String(254)                     |    No    |
| cities                    | Cities, comma-separated list. Future localization via localeText resource type 32                                                                                  | String(2047)                    |    No    |
| shortName                 | Short name, such as CET (Central European Time); future localization via localeText resource type 33                                                               | String(254)                     |    No    |
| description               | Dcescription, only visible in Admin contexts                                                                                                                       | String(254)                     |    Yes   |
| isBuiltIn                 | Is this row part of SuperOffice priming data                                                                                                                       | Bool                            |    Yes   |
| isActive                  | Is this field visible in the standard drop-down list in the GUI? If no, it can still be used and searched for, but won't be visible directly in the dropdown list. | Bool                            |    Yes   |
| isDeleted                 | Is this row 'deleted' (invisible in lists)                                                                                                                         | Bool                            |    Yes   |
| registered                | Registered when                                                                                                                                                    | UtcDateTime                     |    No    |
| registered\_associate\_id | Registered by whom                                                                                                                                                 | FK [associate](./associate.mdx) |    No    |
| updated                   | Last updated when                                                                                                                                                  | UtcDateTime                     |    No    |
| updated\_associate\_id    | Last updated by whom                                                                                                                                               | FK [associate](./associate.mdx) |    No    |
| updatedCount              | Number of updates made to this record                                                                                                                              | UShort                          |    No    |

<img src="https://mintcdn.com/superofficeas/3ZhivzBeXAvFeVZx/media/loc/en/database/tables/TZLocation.png?fit=max&auto=format&n=3ZhivzBeXAvFeVZx&q=85&s=899bc9571ff9b53320beac82d3a9da32" alt="TZLocation table relationship diagram" width="612" height="59" data-path="media/loc/en/database/tables/TZLocation.png" />

## Indexes

| Fields       | Types      | Description |
| ------------ | ---------- | ----------- |
| locationCode | String(29) | Unique      |

## Relationships

| Table                              | Description                                                                                                                                                                 |
| ---------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| [appointment](./appointment)       | Tasks, appointments, followups, phone calls; and documents (document\_id != 0). An appointment always has a corresponding record in VisibleFor specifying who may see this. |
| [associate](./associate)           | Employees, resources and other users - except for External persons                                                                                                          |
| [BaseTZLocation](./basetzlocation) | Time zone location for the database (how tz-related datetimes should be stored in the database)                                                                             |
| [chat\_topic](./chat-topic)        | This table contains chat topics.                                                                                                                                            |
| [contact](./contact)               | Companies and Organizations.                                                                                                                                                |
| [country](./country)               | Country information                                                                                                                                                         |
| [DiaryView](./diaryview)           | Configuration of a multi-user diary view                                                                                                                                    |
| [person](./person)                 | Persons                                                                                                                                                                     |
| [project](./project)               | Projects                                                                                                                                                                    |
| [TZDstRule](./tzdstrule)           | Time zone rule for daylight saving time                                                                                                                                     |
| [TZStdRule](./tzstdrule)           | Time zone rule for standard time                                                                                                                                            |
| [workflow](./workflow)             | SuperOffice specific info about a workflow                                                                                                                                  |

## 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.


## Related topics

- [SuperOffice.WebApi.Agents.ITimeZoneAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.ITimeZoneAgent.md)
- [SuperOffice.WebApi.Agents.TimeZoneAgent](/en/api/reference/webapi/SuperOffice.WebApi.Agents.TimeZoneAgent.md)
- [NSTimeZoneAgent](/en/automation/crmscript/reference/CRMScript.NetServer.NSTimeZoneAgent.md)
- [Toggle Active Time Zone Row](/en/api/reference/restful/agent/timezone_agent/toggle-active-time-zone-row.md)
- [Set Active Time Zone Row](/en/api/reference/restful/agent/timezone_agent/set-active-time-zone-row.md)
- [Set Active Time Zones By Filter](/en/api/reference/restful/agent/timezone_agent/set-active-time-zones-by-filter.md)