JSON-based import reference tables
Special keys and their values used for imports
platform_id key values represent platform codes currently supported by ScheduleInterpreter®
| Key | Value | Platform name |
| platform_id | 1 | Digium |
| platform_id | 2 | Oracle |
| platform_id | 3 | BoostLingo |
| platform_id | 4 | Lingo |
| platform_id | 5 | Abila |
| platform_id | 6 | Plunet |
| platform_id | 7 | ScheduleInterpreter VRI |
userType key values represent user profile, when not specifically set, profile 102 is used.
| Key | Value | Profile |
| userType | 100 | Administrator |
| userType | 101 | Manager |
| userType | 102 | User (default) |
| userType | 200 | Accounting manager |
| userType | 201 | Accounting user |
| userType | 301 | Scheduler |
timeZoneID key values represent time zones, when not specifically set, Central Time Zone is used.
| Key | Value | Time zone |
| timeZoneID | 1 | Eastern Time Zone |
| timeZoneID | 2 | Central Time Zone |
| timeZoneID | 3 | Mountain Time Zone |
| timeZoneID | 4 | Pacific Time Zone |
| timeZoneID | 5 | Alaska Time Zone |
| timeZoneID | 6 | Hawaii Time Zone |
| timeZoneID | 7 | UTC |
| timeZoneID | 8 | UTC +01:00 |
| timeZoneID | 9 | UTC +02:00 |
| timeZoneID | 10 | UTC +03:00 |
| timeZoneID | 11 | UTC +04:00 |
| timeZoneID | 12 | UTC +05:00 |
| timeZoneID | 13 | UTC +06:00 |
| timeZoneID | 14 | UTC +07:00 |
| timeZoneID | 15 | UTC +08:00 |
| timeZoneID | 16 | UTC +09:00 |
| timeZoneID | 17 | UTC +10:00 |
| timeZoneID | 18 | UTC +11:00 |
| timeZoneID | 19 | UTC +12:00 |
| timeZoneID | 20 | Atlantic Time Zone |
| timeZoneID | 21 | UTC -01:00 |
| timeZoneID | 22 | UTC -02:00 |
| timeZoneID | 23 | UTC -03:00 |
| timeZoneID | 24 | UTC -11:00 |
| timeZoneID | 25 | UTC -12:00 |
country_code key values represent platform codes currently supported by ScheduleInterpreter®
| Key | Value | Country name | Additional info |
| country_code | AD | Andorra | |
| country_code | AE | United Arab Emirates | |
| country_code | AF | Afghanistan | |
| country_code | AG | Antigua and Barbuda | |
| country_code | AI | Anguilla | |
| country_code | AL | Albania | |
| country_code | AM | Armenia | |
| country_code | AN | Netherlands Antilles | |
| country_code | AO | Angola | |
| country_code | AQ | Antarctica | |
| country_code | AR | Argentina | |
| country_code | AS | American Samoa | |
| country_code | AT | Austria | |
| country_code | AU | Australia | |
| country_code | AW | Aruba | |
| country_code | AX | Aland Islands | |
| country_code | AZ | Azerbaijan | |
| country_code | BA | Bosnia and Herzegovina | |
| country_code | BB | Barbados | |
| country_code | BD | Bangladesh | |
| country_code | BE | Belgium | |
| country_code | BF | Burkina Faso | |
| country_code | BG | Bulgaria | |
| country_code | BH | Bahrain | |
| country_code | BI | Burundi | |
| country_code | BJ | Benin | |
| country_code | BM | Bermuda | |
| country_code | BN | Brunei Darussalam | |
| country_code | BO | Bolivia | |
| country_code | BR | Brazil | |
| country_code | BS | Bahamas | |
| country_code | BT | Bhutan | |
| country_code | BV | Bouvet Island | |
| country_code | BW | Botswana | |
| country_code | BY | Belarus | |
| country_code | BZ | Belize | |
| country_code | CA | Canada | |
| country_code | CC | Cocos (Keeling) Islands | |
| country_code | CD | Congo | The Democratic Republic of the |
| country_code | CF | Central African Republic | |
| country_code | CG | Congo | |
| country_code | CH | Switzerland | |
| country_code | CI | Cote d'Ivoire | |
| country_code | CK | Cook Islands | |
| country_code | CL | Chile | |
| country_code | CM | Cameroon | |
| country_code | CN | China | |
| country_code | CO | Colombia | |
| country_code | CR | Costa Rica | |
| country_code | CU | Cuba | |
| country_code | CV | Cape Verde | |
| country_code | CX | Christmas Island | |
| country_code | CY | Cyprus | |
| country_code | CZ | Czech Republic | |
| country_code | DE | Germany | |
| country_code | DJ | Djibouti | |
| country_code | DK | Denmark | |
| country_code | DM | Dominica | |
| country_code | DO | Dominican Republic | |
| country_code | DZ | Algeria | |
| country_code | EC | Ecuador | |
| country_code | EE | Estonia | |
| country_code | EG | Egypt | |
| country_code | EH | Western Sahara | |
| country_code | ER | Eritrea | |
| country_code | ES | Spain | |
| country_code | ET | Ethiopia | |
| country_code | FI | Finland | |
| country_code | FJ | Fiji | |
| country_code | FK | Falkland Islands (Malvinas) | |
| country_code | FM | Micronesia | Federated States of |
| country_code | FO | Faroe Islands | |
| country_code | FR | France | |
| country_code | GA | Gabon | |
| country_code | GB | United Kingdom | |
| country_code | GD | Grenada | |
| country_code | GE | Georgia | |
| country_code | GF | French Guiana | |
| country_code | GG | Guernsey | |
| country_code | GH | Ghana | |
| country_code | GI | Gibraltar | |
| country_code | GL | Greenland | |
| country_code | GM | Gambia | |
| country_code | GN | Guinea | |
| country_code | GP | Guadeloupe | |
| country_code | GQ | Equatorial Guinea | |
| country_code | GR | Greece | |
| country_code | GS | South Georgia and the South Sandwich Islands | |
| country_code | GT | Guatemala | |
| country_code | GU | Guam | |
| country_code | GW | Guinea-Bissau | |
| country_code | GY | Guyana | |
| country_code | HK | Hong Kong | |
| country_code | HM | Heard Island and McDonald Islands | |
| country_code | HN | Honduras | |
| country_code | HR | Croatia | |
| country_code | HT | Haiti | |
| country_code | HU | Hungary | |
| country_code | ID | Indonesia | |
| country_code | IE | Ireland | |
| country_code | IL | Israel | |
| country_code | IM | Isle of Man | |
| country_code | IN | India | |
| country_code | IO | British Indian Ocean Territory | |
| country_code | IQ | Iraq | |
| country_code | IR | Iran | Islamic Republic of |
| country_code | IS | Iceland | |
| country_code | IT | Italy | |
| country_code | JE | Jersey | |
| country_code | JM | Jamaica | |
| country_code | JO | Jordan | |
| country_code | JP | Japan | |
| country_code | KE | Kenya | |
| country_code | KG | Kyrgyzstan | |
| country_code | KH | Cambodia | |
| country_code | KI | Kiribati | |
| country_code | KM | Comoros | |
| country_code | KN | Saint Kitts and Nevis | |
| country_code | KP | Korea | Democratic People's Republic of |
| country_code | KR | Korea | Republic of |
| country_code | KW | Kuwait | |
| country_code | KY | Cayman Islands | |
| country_code | KZ | Kazakhstan | |
| country_code | LA | Lao People's Democratic Republic | |
| country_code | LB | Lebanon | |
| country_code | LC | Saint Lucia | |
| country_code | LI | Liechtenstein | |
| country_code | LK | Sri Lanka | |
| country_code | LR | Liberia | |
| country_code | LS | Lesotho | |
| country_code | LT | Lithuania | |
| country_code | LU | Luxembourg | |
| country_code | LV | Latvia | |
| country_code | LY | Libyan Arab Jamahiriya | |
| country_code | MA | Morocco | |
| country_code | MC | Monaco | |
| country_code | MD | Moldova | Republic of |
| country_code | ME | Montenegro | |
| country_code | MG | Madagascar | |
| country_code | MH | Marshall Islands | |
| country_code | MK | Macedonia | |
| country_code | ML | Mali | |
| country_code | MM | Myanmar | |
| country_code | MN | Mongolia | |
| country_code | MO | Macao | |
| country_code | MP | Northern Mariana Islands | |
| country_code | MQ | Martinique | |
| country_code | MR | Mauritania | |
| country_code | MS | Montserrat | |
| country_code | MT | Malta | |
| country_code | MU | Mauritius | |
| country_code | MV | Maldives | |
| country_code | MW | Malawi | |
| country_code | MX | Mexico | |
| country_code | MY | Malaysia | |
| country_code | MZ | Mozambique | |
| country_code | NA | Namibia | |
| country_code | NC | New Caledonia | |
| country_code | NE | Niger | |
| country_code | NF | Norfolk Island | |
| country_code | NG | Nigeria | |
| country_code | NI | Nicaragua | |
| country_code | NL | Netherlands | |
| country_code | NO | Norway | |
| country_code | NP | Nepal | |
| country_code | NR | Nauru | |
| country_code | NU | Niue | |
| country_code | NZ | New Zealand | |
| country_code | OM | Oman | |
| country_code | PA | Panama | |
| country_code | PE | Peru | |
| country_code | PF | French Polynesia | |
| country_code | PG | Papua New Guinea | |
| country_code | PH | Philippines | |
| country_code | PK | Pakistan | |
| country_code | PL | Poland | |
| country_code | PM | Saint Pierre and Miquelon | |
| country_code | PN | Pitcairn | |
| country_code | PR | Puerto Rico | |
| country_code | PS | Palestinian Territory | |
| country_code | PT | Portugal | |
| country_code | PW | Palau | |
| country_code | PY | Paraguay | |
| country_code | QA | Qatar | |
| country_code | RE | Reunion | |
| country_code | RO | Romania | |
| country_code | RS | Serbia | |
| country_code | RU | Russian Federation | |
| country_code | RW | Rwanda | |
| country_code | SA | Saudi Arabia | |
| country_code | SB | Solomon Islands | |
| country_code | SC | Seychelles | |
| country_code | SD | Sudan | |
| country_code | SE | Sweden | |
| country_code | SG | Singapore | |
| country_code | SH | Saint Helena | |
| country_code | SI | Slovenia | |
| country_code | SJ | Svalbard and Jan Mayen | |
| country_code | SK | Slovakia | |
| country_code | SL | Sierra Leone | |
| country_code | SM | San Marino | |
| country_code | SN | Senegal | |
| country_code | SO | Somalia | |
| country_code | SR | Suriname | |
| country_code | ST | Sao Tome and Principe | |
| country_code | SV | El Salvador | |
| country_code | SY | Syrian Arab Republic | |
| country_code | SZ | Swaziland | |
| country_code | TC | Turks and Caicos Islands | |
| country_code | TD | Chad | |
| country_code | TF | French Southern Territories | |
| country_code | TG | Togo | |
| country_code | TH | Thailand | |
| country_code | TJ | Tajikistan | |
| country_code | TK | Tokelau | |
| country_code | TL | Timor-Leste | |
| country_code | TM | Turkmenistan | |
| country_code | TN | Tunisia | |
| country_code | TO | Tonga | |
| country_code | TR | Turkey | |
| country_code | TT | Trinidad and Tobago | |
| country_code | TV | Tuvalu | |
| country_code | TW | Taiwan | |
| country_code | TZ | Tanzania | United Republic of |
| country_code | UA | Ukraine | |
| country_code | UG | Uganda | |
| country_code | UM | United States Minor Outlying Islands | |
| country_code | US | United States | |
| country_code | UY | Uruguay | |
| country_code | UZ | Uzbekistan | |
| country_code | VA | Holy See (Vatican City State) | |
| country_code | VC | Saint Vincent and the Grenadines | |
| country_code | VE | Venezuela | |
| country_code | VG | Virgin Islands | British |
| country_code | VI | Virgin Islands | U.S. |
| country_code | VN | Vietnam | |
| country_code | VU | Vanuatu | |
| country_code | WF | Wallis and Futuna | |
| country_code | WS | Samoa | |
| country_code | YE | Yemen | |
| country_code | YT | Mayotte | |
| country_code | ZA | South Africa | |
| country_code | ZM | Zambia | |
| country_code | ZW | Zimbabwe |