Field: Timezone Id



Field: Timezone_Id

Field: Timezone_Id
Type	String
General Description	Integer (System enumeration)
Import Group	Timezone_Id specifies the time zone of a user and is used in connection with CATI calls, to avoid calling people during the night!
Business Rules	The column name should be ‘Work_Setting_Id’ in order to be mapped automatically when checking the ‘Auto Map’ function. Work setting can be imported using only number. Numbers are unique ID predefined for Catglobe. Please look at the notes below to see how these id relate to existing time zones. To update this field for existing users, you must map the import using the Work_Setting_Id column to show which users to update for. If you are updating existing users’ time zones you are forced to update all of the users in your excel. The system will recognize NULL as an acceptable value and update any mapped user to be null in this case. I.e. null does not mean that users existing time zone values will be kept but rather that they will be removed!
Validation	The number imported to work setting must be null or from 1 to 75, else an error will occur!
Notes	ID = 0. Timezone_UTC (UTC) ID = 1. Timezone_Azerbaijan_Standard_Time (GMT+04:00) Baku ID = 2. Timezone_Middle_East_Standard_Time (GMT+02:00) Beirut ID = 3. Timezone_Jordan_Standard_Time (GMT+02:00) Amman ID = 4. Timezone_Central_Standard_Time_Mexico (GMT-06:00) Guadalajara, Mexico City, Monterrey - New ID = 5. Timezone_Mountain_Standard_Time_Mexico (GMT-07:00) Chihuahua, La Paz, Mazatlan - New ID = 6. Timezone_Pacific_Standard_Time_Mexico (GMT-08:00) Tijuana, Baja California ID = 7. Timezone_Namibia_Standard_Time (GMT+02:00) Windhoek ID = 8. Timezone_Georgian_Standard_Time (GMT+03:00) Tbilisi ID = 9. Timezone_Central_Brazilian_Standard_Time (GMT-04:00) Manaus ID = 10. Timezone_Montevideo_Standard_Time (GMT-03:00) Montevideo ID = 11. Timezone_Dateline_Standard_Time (GMT-12:00) International Date Line West ID = 12. Timezone_Samoa_Standard_Time (GMT-11:00) Midway Island, Samoa ID = 13. Timezone_Hawaiian_Standard_Time (GMT-10:00) Hawaii ID = 14. Timezone_Alaskan_Standard_Time (GMT-09:00) Alaska ID = 15. Timezone_Pacific_Standard_Time (GMT-08:00) Pacific Time (US & Canada) ID = 16. Timezone_Mountain_Standard_Time (GMT-07:00) Mountain Time (US & Canada) ID = 17. Timezone_Mexico_Standard_Time_2 (GMT-07:00) Chihuahua, La Paz, Mazatlan - Old ID = 18. Timezone_US_Mountain_Standard_Time (GMT-07:00) Arizona ID = 19. Timezone_Central_Standard_Time (GMT-06:00) Central Time (US & Canada) ID = 20. Timezone_Canada_Central_Standard_Time (GMT-06:00) Saskatchewan ID = 21. Timezone_Mexico_Standard_Time (GMT-06:00) Guadalajara, Mexico City, Monterrey - Old ID = 22. Timezone_Central_America_Standard_Time (GMT-06:00) Central America ID = 23. Timezone_Eastern_Standard_Time (GMT-05:00) Eastern Time (US & Canada) ID = 24. Timezone_US_Eastern_Standard_Time (GMT-05:00) Indiana (East) ID = 25. Timezone_SA_Pacific_Standard_Time (GMT-05:00) Bogota, Lima, Quito, Rio Branco ID = 26. Timezone_Atlantic_Standard_Time (GMT-04:00) Atlantic Time (Canada) ID = 27. Timezone_SA_Western_Standard_Time (GMT-04:00) La Paz ID = 28. Timezone_Pacific_SA_Standard_Time (GMT-04:00) Santiago ID = 29. Timezone_Newfoundland_Standard_Time (GMT-03:30) Newfoundland ID = 30. Timezone_E_South_America_Standard_Time (GMT-03:00) Brasilia ID = 31. Timezone_SA_Eastern_Standard_Time (GMT-03:00) Buenos Aires, Georgetown ID = 32. Timezone_Greenland_Standard_Time (GMT-03:00) Greenland ID = 33. Timezone_Mid_Atlantic_Standard_Time (GMT-02:00) Mid-Atlantic ID = 34. Timezone_Azores_Standard_Time (GMT-01:00) Azores ID = 35. Timezone_Cape_Verde_Standard_Time (GMT-01:00) Cape Verde Is. ID = 36. Timezone_GMT_Standard_Time (GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London ID = 37. Timezone_Greenwich_Standard_Time (GMT) Casablanca, Monrovia, Reykjavik ID = 38. Timezone_Central_Europe_Standard_Time (GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague ID = 39. Timezone_Central_European_Standard_Time (GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb ID = 40. Timezone_Romance_Standard_Time (GMT+01:00) Brussels, Copenhagen, Madrid, Paris ID = 41. Timezone_W_Europe_Standard_Time (GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna ID = 42. Timezone_W_Central_Africa_Standard_Time (GMT+01:00) West Central Africa ID = 43. Timezone_E_Europe_Standard_Time (GMT+02:00) Minsk ID = 44. Timezone_Egypt_Standard_Time (GMT+02:00) Cairo ID = 45. Timezone_FLE_Standard_Time (GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius ID = 46. Timezone_GTB_Standard_Time (GMT+02:00) Athens, Bucharest, Istanbul ID = 47. Timezone_Jerusalem_Standard_Time (GMT+02:00) Jerusalem ID = 48. Timezone_South_Africa_Standard_Time (GMT+02:00) Harare, Pretoria ID = 49. Timezone_Russian_Standard_Time (GMT+03:00) Moscow, St. Petersburg, Volgograd ID = 50. Timezone_Arab_Standard_Time (GMT+03:00) Kuwait, Riyadh ID = 51. Timezone_E_Africa_Standard_Time (GMT+03:00) Nairobi ID = 52. Timezone_Arabic_Standard_Time (GMT+03:00) Baghdad ID = 53. Timezone_Iran_Standard_Time (GMT+03:30) Tehran ID = 54. Timezone_Arabian_Standard_Time (GMT+04:00) Abu Dhabi, Muscat ID = 55. Timezone_Caucasus_Standard_Time (GMT+04:00) Caucasus Standard Time ID = 56. Timezone_Afghanistan_Standard_Time (GMT+04:30) Kabul ID = 57. Timezone_Ekaterinburg_Standard_Time (GMT+05:00) Ekaterinburg ID = 58. Timezone_West_Asia_Standard_Time (GMT+05:00) Islamabad, Karachi, Tashkent ID = 59. Timezone_India_Standard_Time (GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi ID = 60. Timezone_Nepal_Standard_Time (GMT+05:45) Kathmandu ID = 61. Timezone_Central_Asia_Standard_Time (GMT+06:00) Astana, Dhaka ID = 62. Timezone_Sri_Lanka_Standard_Time (GMT+05:30) Sri Jayawardenepura ID = 63. Timezone_N_Central_Asia_Standard_Time (GMT+06:00) Almaty, Novosibirsk ID = 64. Timezone_Myanmar_Standard_Time (GMT+06:30) Yangon (Rangoon) ID = 65. Timezone_SE_Asia_Standard_Time (GMT+07:00) Bangkok, Hanoi, Jakarta ID = 66. Timezone_North_Asia_Standard_Time (GMT+07:00) Krasnoyarsk ID = 67. Timezone_China_Standard_Time (GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi ID = 68. Timezone_Malay_Peninsula_Standard_Time (GMT+08:00) Kuala Lumpur, Singapore ID = 69. Timezone_Taipei_Standard_Time (GMT+08:00) Taipei ID = 70. Timezone_W_Australia_Standard_Time (GMT+08:00) Perth ID = 71. Timezone_North_Asia_East_Standard_Time (GMT+08:00) Irkutsk, Ulaan Bataar ID = 72. Timezone_Korea_Standard_Time (GMT+09:00) Seoul ID = 73. Timezone_Tokyo_Standard_Time (GMT+09:00) Osaka, Sapporo, Tokyo ID = 74. Timezone_Yakutsk_Standard_Time (GMT+09:00) Yakutsk ID = 75. Timezone_AUS_Central_Standard_Time (GMT+09:30) Darwin ID = 76. Timezone_Cen_Australia_Standard_Time (GMT+09:30) Adelaide ID = 77. Timezone_AUS_Eastern_Standard_Time (GMT+10:00) Canberra, Melbourne, Sydney ID = 78. Timezone_E_Australia_Standard_Time (GMT+10:00) Brisbane ID = 79. Timezone_Tasmania_Standard_Time (GMT+10:00) Hobart ID = 80. Timezone_Vladivostok_Standard_Time (GMT+10:00) Vladivostok ID = 81. Timezone_West_Pacific_Standard_Time (GMT+10:00) Guam, Port Moresby ID = 82. Timezone_Central_Pacific_Standard_Time (GMT+11:00) Magadan, Solomon Is., New Caledonia ID = 83. Timezone_Fiji_Standard_Time (GMT+12:00) Fiji, Kamchatka, Marshall Is. ID = 84. Timezone_New_Zealand_Standard_Time (GMT+12:00) Auckland, Wellington ID = 85. Timezone_Tonga_Standard_Time (GMT+13:00) Nuku'alofa