Reference Data Management

Settings à Administration à Reference Data

The reference data area contains settings for the content of every “drop down list box” in the entire Gnosis system.

Virtually all drop-down lists may be customized using reference data.  The system may prevent you from deleting some entries which means that the entry is required. You may change the wording in these cases you may change the wording but should not change the general meaning of the entry to avoid confusion.

 

Special Definition Types

Certain categories in Reference Data require additional definitions in addition to the Display name.  These additional definitions determine how the reference data item behaves in the Gnosis system.

Age Ranges

When defining age ranges in the system, use the Bound From and to fields to specify the lower and upper age ranges that you have described in the Display Name field.

Calendar Cities

When specifying calendar cities, you must specify the Time Zone ID in which the city resides.  Cities may be cascaded inside regions and countries and the correct time zone should be specified for all entries in this category. The "Bound From" field should be used to hold the Time Zone ID.  Use the following table of Time Zone ID's when entering Calendar Cities:

Time Zone ID

Time Zone Name

90

(GMT) Casablanca, Monrovia

85

(GMT) Greenwich Mean Time : Dublin, Edinburgh, Lisbon, London

110

(GMT+01:00) Amsterdam, Berlin, Bern, Rome, Stockholm, Vienna

95

(GMT+01:00) Belgrade, Bratislava, Budapest, Ljubljana, Prague

105

(GMT+01:00) Brussels, Copenhagen, Madrid, Paris

100

(GMT+01:00) Sarajevo, Skopje, Warsaw, Zagreb

113

(GMT+01:00) West Central Africa

130

(GMT+02:00) Athens, Beirut, Istanbul, Minsk

115

(GMT+02:00) Bucharest

120

(GMT+02:00) Cairo

140

(GMT+02:00) Harare, Pretoria

125

(GMT+02:00) Helsinki, Kyiv, Riga, Sofia, Tallinn, Vilnius

135

(GMT+02:00) Jerusalem

158

(GMT+03:00) Baghdad

150

(GMT+03:00) Kuwait, Riyadh

145

(GMT+03:00) Moscow, St. Petersburg, Volgograd

155

(GMT+03:00) Nairobi

160

(GMT+03:30) Tehran

165

(GMT+04:00) Abu Dhabi, Muscat

170

(GMT+04:00) Baku, Tbilisi, Yerevan

175

(GMT+04:30) Kabul

180

(GMT+05:00) Ekaterinburg

185

(GMT+05:00) Islamabad, Karachi, Tashkent

190

(GMT+05:30) Chennai, Kolkata, Mumbai, New Delhi

193

(GMT+05:45) Kathmandu

201

(GMT+06:00) Almaty, Novosibirsk

195

(GMT+06:00) Astana, Dhaka

200

(GMT+06:00) Sri Jayawardenepura

203

(GMT+06:30) Rangoon

205

(GMT+07:00) Bangkok, Hanoi, Jakarta

207

(GMT+07:00) Krasnoyarsk

210

(GMT+08:00) Beijing, Chongqing, Hong Kong, Urumqi

227

(GMT+08:00) Irkutsk, Ulaan Bataar

215

(GMT+08:00) Kuala Lumpur, Singapore

225

(GMT+08:00) Perth

220

(GMT+08:00) Taipei

235

(GMT+09:00) Osaka, Sapporo, Tokyo

230

(GMT+09:00) Seoul

240

(GMT+09:00) Yakutsk

250

(GMT+09:30) Adelaide

245

(GMT+09:30) Darwin

260

(GMT+10:00) Brisbane

255

(GMT+10:00) Canberra, Melbourne, Sydney

275

(GMT+10:00) Guam, Port Moresby

265

(GMT+10:00) Hobart

270

(GMT+10:00) Vladivostok

280

(GMT+11:00) Magadan, Solomon Is., New Caledonia

290

(GMT+12:00) Auckland, Wellington

285

(GMT+12:00) Fiji, Kamchatka, Marshall Is.

300

(GMT+13:00) Nuku'alofa

80

(GMT-01:00) Azores

83

(GMT-01:00) Cape Verde Is.

75

(GMT-02:00) Mid-Atlantic

65

(GMT-03:00) Brasilia

70

(GMT-03:00) Buenos Aires, Georgetown

73

(GMT-03:00) Greenland

60

(GMT-03:30) Newfoundland

50

(GMT-04:00) Atlantic Time (Canada)

55

(GMT-04:00) Caracas, La Paz

56

(GMT-04:00) Santiago

45

(GMT-05:00) Bogota, Lima, Quito

35

(GMT-05:00) Eastern Time (US & Canada)

40

(GMT-05:00) Indiana (East)

33

(GMT-06:00) Central America

20

(GMT-06:00) Central Time (US & Canada)

30

(GMT-06:00) Guadalajara, Mexico City, Monterrey

25

(GMT-06:00) Saskatchewan

15

(GMT-07:00) Arizona

13

(GMT-07:00) Chihuahua, La Paz, Mazatlan

10

(GMT-07:00) Mountain Time (US & Canada)

4

(GMT-08:00) Pacific Time (US & Canada); Tijuana

3

(GMT-09:00) Alaska

2

(GMT-10:00) Hawaii

1

(GMT-11:00) Midway Island, Samoa

0

(GMT-12:00) International Date Line West