Field: Timezone Id

From Catglobe Wiki
Revision as of 09:38, 14 December 2011 by Cg huyphong (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search



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


Retrieved from "http://wiki.catglobe.com/index.php?title=Field:_Timezone_Id&oldid=20759"