{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sponsored Entity Data","Validation Errors","Country Jurisdiction List","Classification List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sponsored Entity Data","index":0,"n_rows":12,"n_cols":5,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"               FATCA Registration Sponsored Entity Data Preparation Tool"]
[null,"                           Version 1.4 (12/08/2016)"]
[null,"                           View instructions"]
[]
[]
[]
[null,"FATCA ID of Sponsoring Entity"]
[]
[]
[]
[]
["Validation Errors","Sponsored Entity Legal Name","Sponsored Entity Country/Jurisdiction","Sponsored Entity Classification","Sponsored Subsidiary Branch Country/Jurisdiction"]

{"sheet":"Validation Errors","index":1,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[null,"Error List"]
[]
["The data could not be validated due to the following errors.  Please correct the errors and try again."]
[]
["Row Number","Error Description"]

{"sheet":"Country Jurisdiction List","index":2,"n_rows":255,"n_cols":3,"rows_kept":255,"cut":false,"hidden":false,"merged":[]}
["          FATCA Online Registration System Country/Jurisdiction Listing"]
[]
[]
["Country/Jurisdiction Name","2-character alpha code","3-digit numeric code \n(for reference only)"]
["AFGHANISTAN","AF","004"]
["ALAND ISLANDS","AX",248]
["ALBANIA","AL","008"]
["ALGERIA","DZ","012"]
["AMERICAN SAMOA","AS","016"]
["ANDORRA","AD","020"]
["ANGOLA","AO","024"]
["ANGUILLA","AI",660]
["ANTARCTICA","AQ","010"]
["ANTIGUA AND BARBUDA","AG","028"]
["ARGENTINA","AR","032"]
["ARMENIA","AM","051"]
["ARUBA","AW",533]
["AUSTRALIA","AU","036"]
["AUSTRIA","AT","040"]
["AZERBAIJAN","AZ","031"]
["BAHAMAS","BS","044"]
["BAHRAIN","BH","048"]
["BANGLADESH","BD","050"]
["BARBADOS","BB","052"]
["BELARUS","BY",112]
["BELGIUM","BE","056"]
["BELIZE","BZ","084"]
["BENIN","BJ",204]
["BERMUDA","BM","060"]
["BHUTAN","BT","064"]
["BOLIVIA, PLURINATIONAL STATE OF","BO","068"]
["BONAIRE, SINT EUSTATIUS AND SABA","BQ",535]
["BOSNIA AND HERZEGOVINA","BA","070"]
["BOTSWANA","BW","072"]
["BOUVET ISLAND","BV","074"]
["BRAZIL","BR","076"]
["BRITISH INDIAN OCEAN TERRITORY","IO","086"]
["BRUNEI DARUSSALAM","BN","096"]
["BULGARIA","BG",100]
["BURKINA FASO","BF",854]
["BURUNDI","BI",108]
["CAMBODIA","KH",116]
["CAMEROON","CM",120]
["CANADA","CA",124]
["CAPE VERDE","CV",132]
["CAYMAN ISLANDS","KY",136]
["CENTRAL AFRICAN REPUBLIC","CF",140]
["CHAD","TD",148]
["CHILE","CL",152]
["CHINA","CN",156]
["CHRISTMAS ISLAND","CX",162]
["COCOS (KEELING) ISLANDS","CC",166]
["COLOMBIA","CO",170]
["COMOROS","KM",174]
["CONGO","CG",178]
["CONGO, DEMOCRATIC REPUBLIC OF THE","CD",180]
["COOK ISLANDS","CK",184]
["COSTA RICA","CR",188]
["COTE D'IVOIRE","CI",384]
["CROATIA","HR",191]
["CUBA","CU",192]
["CURACAO","CW",531]
["CYPRUS","CY",196]
["CZECH REPUBLIC","CZ",203]
["DENMARK","DK",208]
["DJIBOUTI","DJ",262]
["DOMINICA","DM",212]
["DOMINICAN REPUBLIC","DO",214]
["ECUADOR","EC",218]
["EGYPT","EG",818]
["EL SALVADOR","SV",222]
["EQUATORIAL GUINEA","GQ",226]
["ERITREA","ER",232]
["ESTONIA","EE",233]
["ETHIOPIA","ET",231]
["FALKLAND ISLANDS (MALVINAS)","FK",238]
["FAROE ISLANDS","FO",234]
["FIJI","FJ",242]
["FINLAND","FI",246]
["FRANCE","FR",250]
["FRENCH GUIANA","GF",254]
["FRENCH POLYNESIA","PF",258]
["FRENCH SOUTHERN TERRITORIES","TF",260]
["GABON","GA",266]
["GAMBIA","GM",270]
["GEORGIA","GE",268]
["GERMANY","DE",276]
["GHANA","GH",288]
["GIBRALTAR","GI",292]
["GREECE","GR",300]
["GREENLAND","GL",304]
["GRENADA","GD",308]
["GUADELOUPE","GP",312]
["GUAM","GU",316]
["GUATEMALA","GT",320]
["GUERNSEY","GG",831]
["GUINEA","GN",324]
["GUINEA-BISSAU","GW",624]
["GUYANA","GY",328]
["HAITI","HT",332]
["HEARD ISLAND AND MCDONALD ISLANDS","HM",334]
["HOLY SEE (VATICAN CITY STATE)","VA",336]
["HONDURAS","HN",340]
["HONG KONG","HK",344]
["HUNGARY","HU",348]
["ICELAND","IS",352]
["INDIA","IN",356]
["INDONESIA","ID",360]
["IRAN, ISLAMIC REPUBLIC OF","IR",364]
["IRAQ","IQ",368]
["IRELAND","IE",372]
["ISLE OF MAN","IM",833]
["ISRAEL","IL",376]
["ITALY","IT",380]
["JAMAICA","JM",388]
["JAPAN","JP",392]
["JERSEY","JE",832]
["JORDAN","JO",400]
["KAZAKHSTAN","KZ",398]
["KENYA","KE",404]
["KIRIBATI","KI",296]
["KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF","KP",408]
["KOREA, REPUBLIC OF","KR",410]
["KOSOVO","XK",901]
["KUWAIT","KW",414]
["KYRGYZSTAN","KG",417]
["LAO PEOPLE'S DEMOCRATIC REPUBLIC","LA",418]
["LATVIA","LV",428]
["LEBANON","LB",422]
["LESOTHO","LS",426]
["LIBERIA","LR",430]
["LIBYA","LY",434]
["LIECHTENSTEIN","LI",438]
["LITHUANIA","LT",440]
["LUXEMBOURG","LU",442]
["MACAO","MO",446]
["MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF","MK",807]
["MADAGASCAR","MG",450]
["MALAWI","MW",454]
["MALAYSIA","MY",458]
["MALDIVES","MV",462]
["MALI","ML",466]
["MALTA","MT",470]
["MARSHALL ISLANDS","MH",584]
["MARTINIQUE","MQ",474]
["MAURITANIA","MR",478]
["MAURITIUS","MU",480]
["MAYOTTE","YT",175]
["MEXICO","MX",484]
["MICRONESIA, FEDERATED STATES OF","FM",583]
["MOLDOVA, REPUBLIC OF","MD",498]
["MONACO","MC",492]
["MONGOLIA","MN",496]
["MONTENEGRO","ME",499]
["MONTSERRAT","MS",500]
["MOROCCO","MA",504]
["MOZAMBIQUE","MZ",508]
["MYANMAR","MM",104]
["NAMIBIA","NA",516]
["NAURU","NR",520]
["NEPAL","NP",524]
["NETHERLANDS","NL",528]
["NEW CALEDONIA","NC",540]
["NEW ZEALAND","NZ",554]
["NICARAGUA","NI",558]
["NIGER","NE",562]
["NIGERIA","NG",566]
["NIUE","NU",570]
["NORFOLK ISLAND","NF",574]
["NORTHERN MARIANA ISLANDS","MP",580]
["NORWAY","NO",578]
["OMAN","OM",512]
["PAKISTAN","PK",586]
["PALAU","PW",585]
["PANAMA","PA",591]
["PAPUA NEW GUINEA","PG",598]
["PARAGUAY","PY",600]
["PERU","PE",604]
["PHILIPPINES","PH",608]
["PITCAIRN","PN",612]
["POLAND","PL",616]
["PORTUGAL","PT",620]
["PUERTO RICO","PR",630]
["QATAR","QA",634]
["REUNION","RE",638]
["ROMANIA","RO",642]
["RUSSIAN FEDERATION","RU",643]
["RWANDA","RW",646]
["SAINT BARTHÉLEMY","BL",652]
["SAINT HELENA, ASCENSION AND TRISTAN DA CUNHA","SH",654]
["SAINT KITTS AND NEVIS","KN",659]
["SAINT LUCIA","LC",662]
["SAINT MARTIN (FRENCH PART)","MF",663]
["SAINT PIERRE AND MIQUELON","PM",666]
["SAINT VINCENT AND THE GRENADINES","VC",670]
["SAMOA","WS",882]
["SAN MARINO","SM",674]
["SAO TOME AND PRINCIPE","ST",678]
["SAUDI ARABIA","SA",682]
["SENEGAL","SN",686]
["SERBIA","RS",688]
["SEYCHELLES","SC",690]
["SIERRA LEONE","SL",694]
["SINGAPORE","SG",702]
["SINT MAARTEN (DUTCH PART)","SX",534]
["SLOVAKIA","SK",703]
["SLOVENIA","SI",705]
["SOLOMON ISLANDS","SB","090"]
["SOMALIA","SO","706"]
["SOUTH AFRICA","ZA",710]
["SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS","GS",239]
["SOUTH SUDAN","SS",728]
["SPAIN","ES",724]
["SRI LANKA","LK",144]
["SUDAN","SD",729]
["SURINAME","SR",740]
["SVALBARD AND JAN MAYEN","SJ","744"]
["SWAZILAND","SZ",748]
["SWEDEN","SE",752]
["SWITZERLAND","CH",756]
["SYRIAN ARAB REPUBLIC","SY",760]
["TAIWAN","TW",158]
["TAJIKISTAN","TJ",762]
["TANZANIA, UNITED REPUBLIC OF","TZ",834]
["THAILAND","TH",764]
["TIMOR-LESTE","TL",626]
["TOGO","TG",768]
["TOKELAU","TK",772]
["TONGA","TO",776]
["TRINIDAD AND TOBAGO","TT",780]
["TUNISIA","TN",788]
["TURKEY","TR",792]
["TURKMENISTAN","TM",795]
["TURKS AND CAICOS ISLANDS","TC",796]
["TUVALU","TV",798]
["UGANDA","UG",800]
["UKRAINE","UA",804]
["UNITED ARAB EMIRATES","AE",784]
["UNITED KINGDOM","GB",826]
["UNITED STATES","US",840]
["UNITED STATES MINOR OUTLYING ISLANDS","UM",581]
["URUGUAY","UY",858]
["UZBEKISTAN","UZ",860]
["VANUATU","VU",548]
["VENEZUELA, BOLIVARIAN REPUBLIC OF","VE",862]
["VIET NAM","VN",704]
["VIRGIN ISLANDS (BRITISH)","VG","092"]
["VIRGIN ISLANDS (U.S.)","VI",850]
["WALLIS AND FUTUNA","WF",876]
["WEST BANK AND GAZA","PS",275]
["WESTERN SAHARA","EH",732]
["YEMEN","YE",887]
["ZAMBIA","ZM",894]
["ZIMBABWE","ZW",716]
["OTHER COUNTRY","XX",999]

{"sheet":"Classification List","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["FATCA Online Registration System Sponsored Entity Classifications"]
["View instructions for using this tool"]
[]
["Classification","2-character alpha code"]
["Sponsored Direct Reporting NFFE ","SD",null,null,null,null,null," "]
["Sponsored Fund","SF"]
["Sponsored Subsidiary","SS"]