{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Glossaire Glossary Glosario","Ref_Country_Codes","Ref_Domaines_Areas"],"not_rendered":{"charts":0,"images":8,"macros":1,"external_links":0,"defined_names":2,"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":"Glossaire Glossary Glosario","index":0,"n_rows":7,"n_cols":9,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"Ref_Country_Codes!B76","v":"FR"},null,{"$f":"Ref_Domaines_Areas!A2","v":"Domaines"},{"$f":"Ref_Country_Codes!B78","v":"GB"},null,{"$f":"Ref_Domaines_Areas!B2","v":"Areas"},{"$f":"Ref_Country_Codes!B69","v":"ES"},null,{"$f":"Ref_Domaines_Areas!C2","v":"Áreas"}]
["Agent général d’assurance","Personne physique ou morale qui :\n- représente une ou plusieurs compagnies d’assurances dont elle est mandataire\n- met à disposition du public sa compétence pour la recherche et la souscription de contrats d’assurance auprès de la ou des sociétés qu’il représente\nSa fonction est de développer un portefeuille d’assurance.\nL'agent général a la qualité juridique de profession libérale.\n","Production - IARD","General insurance agent","Agent who helps clients choose insurance policies that suit their needs",null,"Agente de seguros"]
["Agent souscripteur","Professionnel qui :\n- est le mandataire de la ou des compagnies qu’il représente\n- propose aux courtiers et agents d’utiliser les contrats qu’il a négociés avec les compagnies d’assurances et ne s’adresse pas directement à un candidat à l’assurance\n- tarifie les risques pour le compte de la compagnie\nL’agent souscripteur est jugé sur ses résultats et est rémunéré par commissionnement.","Production - IARD","Underwriting agent","An underwriting agent is defined as a professional with the right to underwrite on behalf of an insurer",null,"Agente de suscripción"]
["Apériteur","Chef de fil d’un contrat dont l’importance des capitaux assurés justifie l’intervention de plusieurs assureurs ayant la qualité de coassureurs.\nL’apériteur émet et gère le contrat dans le cadre et dans les limites d’un mandat limité à la gestion qui lui est donné par les coassureurs.\nIl n’a pas le pouvoir d’engager les coassureurs par une prise de garantie ou à l’occasion d’un règlement de sinistre.\n","Production - IARD","Lead insurer","co-insurance pools means groups set up by insurance undertakings either directly or through brokers or authorized agents, with the exception of ad-hoc co-insurance agreements on the subscription market, whereby a certain part of a given risk is covered by a lead insurer and the remaining part of the risk is covered by follow insurers who are invited to cover that remainder",null,"Entidad abridora","Entidad aseguradora que cubre inicialmente un riesgo que después se distribuirá entre varias entidades aseguradoras en forma de coaseguro.  "]
["Apporteur d’affaires","Démarcheur apportant des contrats moyennant une rémunération convenue à l’avance.\nLa qualification d’apporteur ou de démarcheur, peu habituelle pour les intermédiaires d’assurance est retenue par la Cour de Cassation par opposition à celle d’agent ou de courtier.\n","Production - IARD","Business getter",null,null,"Corredor","Persona que se dedica (y está habilitada para ello) a la gestión de pólizas y contratos de seguros. Habitualmente ejerce de mediador entre el asegurado y la empresa aseguradora, impulsa la concertación de nuevos contratos y asesora a las dos partes implicadas"]
["Avenant","Document complémentaire au contrat d’assurance constatant les modifications apportées à un risque.\n\nExemple de modification à l’origine d’un avenant :\n- l’assuré change d’adresse\n- l’assuré demande une extension de garantie\n- l’assuré demande une modification des sommes fixées dans le contrat d’assurance\nDifférents types d’avenant existent : avenant de renouvellement, avenant de résiliation avec ou sans ristourne, avenant d'incorporation, avenant de retrait ou de régularisation avec ou sans ristourne.\nDans plusieurs transactions permettent d’effectuer ces avenants.\n","Production - IARD","Endorsement","Written document attached to an insurance policy that modifies the policy by changing the coverage afforded under the policy. An endorsement can add coverage for acts or things that are not covered as a part of the original policy and can be added at the inception of the policy or later during the term of the policy.",null,"Adenda","Documento formal, adjunto a una póliza de seguros, que modifica o añade cláusulas al texto principal."]

{"sheet":"Ref_Country_Codes","index":1,"n_rows":250,"n_cols":4,"rows_kept":250,"cut":false,"hidden":false,"merged":[]}
["Pays","Code","Source","http://www.iso.org/iso/fr/country_codes/iso_3166_code_lists.htm"]
["ANDORRE","AD"]
["ÉMIRATS ARABES UNIS","AE"]
["AFGHANISTAN","AF"]
["ANTIGUA-ET-BARBUDA","AG"]
["ANGUILLA","AI"]
["ALBANIE","AL"]
["ARMÉNIE","AM"]
["ANGOLA","AO"]
["ANTARCTIQUE","AQ"]
["ARGENTINE","AR"]
["SAMOA AMÉRICAINES","AS"]
["AUTRICHE","AT"]
["AUSTRALIE","AU"]
["ARUBA","AW"]
["ÅLAND, ÎLES","AX"]
["AZERBAÏDJAN","AZ"]
["BOSNIE-HERZÉGOVINE","BA"]
["BARBADE","BB"]
["BANGLADESH","BD"]
["BELGIQUE","BE"]
["BURKINA FASO","BF"]
["BULGARIE","BG"]
["BAHREÏN","BH"]
["BURUNDI","BI"]
["BÉNIN","BJ"]
["SAINT-BARTHÉLEMY","BL"]
["BERMUDES","BM"]
["BRUNEI DARUSSALAM","BN"]
["BOLIVIE, l'ÉTAT PLURINATIONAL DE","BO"]
["BONAIRE, SAINT-EUSTACHE ET SABA","BQ"]
["BRÉSIL","BR"]
["BAHAMAS","BS"]
["BHOUTAN","BT"]
["BOUVET, ÎLE","BV"]
["BOTSWANA","BW"]
["BÉLARUS","BY"]
["BELIZE","BZ"]
["CANADA","CA"]
["COCOS (KEELING), ÎLES","CC"]
["CONGO, LA RÉPUBLIQUE DÉMOCRATIQUE DU","CD"]
["CENTRAFRICAINE, RÉPUBLIQUE","CF"]
["CONGO","CG"]
["SUISSE","CH"]
["CÔTE D'IVOIRE","CI"]
["COOK, ÎLES","CK"]
["CHILI","CL"]
["CAMEROUN","CM"]
["CHINE","CN"]
["COLOMBIE","CO"]
["COSTA RICA","CR"]
["CUBA","CU"]
["CAP-VERT","CV"]
["CURAÇAO","CW"]
["CHRISTMAS, ÎLE","CX"]
["CHYPRE","CY"]
["TCHÈQUE, RÉPUBLIQUE","CZ"]
["ALLEMAGNE","DE"]
["DJIBOUTI","DJ"]
["DANEMARK","DK"]
["DOMINIQUE","DM"]
["DOMINICAINE, RÉPUBLIQUE","DO"]
["ALGÉRIE","DZ"]
["ÉQUATEUR","EC"]
["ESTONIE","EE"]
["ÉGYPTE","EG"]
["SAHARA OCCIDENTAL","EH"]
["ÉRYTHRÉE","ER"]
["ESPAGNE","ES"]
["ÉTHIOPIE","ET"]
["FINLANDE","FI"]
["FIDJI","FJ"]
["FALKLAND, ÎLES (MALVINAS)","FK"]
["MICRONÉSIE, ÉTATS FÉDÉRÉS DE","FM"]
["FÉROÉ, ÎLES","FO"]
["FRANCE","FR"]
["GABON","GA"]
["ROYAUME-UNI","GB"]
["GRENADE","GD"]
["GÉORGIE","GE"]
["GUYANE FRANÇAISE","GF"]
["GUERNESEY","GG"]
["GHANA","GH"]
["GIBRALTAR","GI"]
["GROENLAND","GL"]
["GAMBIE","GM"]
["GUINÉE","GN"]
["GUADELOUPE","GP"]
["GUINÉE ÉQUATORIALE","GQ"]
["GRÈCE","GR"]
["GÉORGIE DU SUD-ET-LES ÎLES SANDWICH DU SUD","GS"]
["GUATEMALA","GT"]
["GUAM","GU"]
["GUINÉE-BISSAU","GW"]
["GUYANA","GY"]
["HONG KONG","HK"]
["HEARD-ET-ÎLES MACDONALD, ÎLE","HM"]
["HONDURAS","HN"]
["CROATIE","HR"]
["HAÏTI","HT"]
["HONGRIE","HU"]
["INDONÉSIE","ID"]
["IRLANDE","IE"]
["ISRAËL","IL"]
["ÎLE DE MAN","IM"]
["INDE","IN"]
["OCÉAN INDIEN, TERRITOIRE BRITANNIQUE DE L'","IO"]
["IRAQ","IQ"]
["IRAN, RÉPUBLIQUE ISLAMIQUE D'","IR"]
["ISLANDE","IS"]
["ITALIE","IT"]
["JERSEY","JE"]
["JAMAÏQUE","JM"]
["JORDANIE","JO"]
["JAPON","JP"]
["KENYA","KE"]
["KIRGHIZISTAN","KG"]
["CAMBODGE","KH"]
["KIRIBATI","KI"]
["COMORES","KM"]
["SAINT-KITTS-ET-NEVIS","KN"]
["CORÉE, RÉPUBLIQUE POPULAIRE DÉMOCRATIQUE DE","KP"]
["CORÉE, RÉPUBLIQUE DE","KR"]
["KOWEÏT","KW"]
["CAÏMANS, ÎLES","KY"]
["KAZAKHSTAN","KZ"]
["LAO, RÉPUBLIQUE DÉMOCRATIQUE POPULAIRE","LA"]
["LIBAN","LB"]
["SAINTE-LUCIE","LC"]
["LIECHTENSTEIN","LI"]
["SRI LANKA","LK"]
["LIBÉRIA","LR"]
["LESOTHO","LS"]
["LITUANIE","LT"]
["LUXEMBOURG","LU"]
["LETTONIE","LV"]
["LIBYE","LY"]
["MAROC","MA"]
["MONACO","MC"]
["MOLDOVA, RÉPUBLIQUE DE","MD"]
["MONTÉNÉGRO","ME"]
["SAINT-MARTIN(PARTIE FRANÇAISE)","MF"]
["MADAGASCAR","MG"]
["MARSHALL, ÎLES","MH"]
["MACÉDOINE, L'EX-RÉPUBLIQUE YOUGOSLAVE DE","MK"]
["MALI","ML"]
["MYANMAR","MM"]
["MONGOLIE","MN"]
["MACAO","MO"]
["MARIANNES DU NORD, ÎLES","MP"]
["MARTINIQUE","MQ"]
["MAURITANIE","MR"]
["MONTSERRAT","MS"]
["MALTE","MT"]
["MAURICE","MU"]
["MALDIVES","MV"]
["MALAWI","MW"]
["MEXIQUE","MX"]
["MALAISIE","MY"]
["MOZAMBIQUE","MZ"]
["NAMIBIE","NA"]
["NOUVELLE-CALÉDONIE","NC"]
["NIGER","NE"]
["NORFOLK, ÎLE","NF"]
["NIGÉRIA","NG"]
["NICARAGUA","NI"]
["PAYS-BAS","NL"]
["NORVÈGE","NO"]
["NÉPAL","NP"]
["NAURU","NR"]
["NIUÉ","NU"]
["NOUVELLE-ZÉLANDE","NZ"]
["OMAN","OM"]
["PANAMA","PA"]
["PÉROU","PE"]
["POLYNÉSIE FRANÇAISE","PF"]
["PAPOUASIE-NOUVELLE-GUINÉE","PG"]
["PHILIPPINES","PH"]
["PAKISTAN","PK"]
["POLOGNE","PL"]
["SAINT-PIERRE-ET-MIQUELON","PM"]
["PITCAIRN","PN"]
["PORTO RICO","PR"]
["PALESTINIEN OCCUPÉ, TERRITOIRE","PS"]
["PORTUGAL","PT"]
["PALAOS","PW"]
["PARAGUAY","PY"]
["QATAR","QA"]
["RÉUNION","RE"]
["ROUMANIE","RO"]
["SERBIE","RS"]
["RUSSIE, FÉDÉRATION DE","RU"]
["RWANDA","RW"]
["ARABIE SAOUDITE","SA"]
["SALOMON, ÎLES","SB"]
["SEYCHELLES","SC"]
["SOUDAN","SD"]
["SUÈDE","SE"]
["SINGAPOUR","SG"]
["SAINTE-HÉLÈNE, ASCENSION ET TRISTAN DA CUNHA","SH"]
["SLOVÉNIE","SI"]
["SVALBARD ET ÎLE JAN MAYEN","SJ"]
["SLOVAQUIE","SK"]
["SIERRA LEONE","SL"]
["SAINT-MARIN","SM"]
["SÉNÉGAL","SN"]
["SOMALIE","SO"]
["SURINAME","SR"]
["SOUDAN DU SUD","SS"]
["SAO TOMÉ-ET-PRINCIPE","ST"]
["EL SALVADOR","SV"]
["SAINT-MARTIN (PARTIE NÉERLANDAISE)","SX"]
["SYRIENNE, RÉPUBLIQUE ARABE","SY"]
["SWAZILAND","SZ"]
["TURKS-ET-CAÏCOS, ÎLES","TC"]
["TCHAD","TD"]
["TERRES AUSTRALES FRANÇAISES","TF"]
["TOGO","TG"]
["THAÏLANDE","TH"]
["TADJIKISTAN","TJ"]
["TOKELAU","TK"]
["TIMOR-LESTE","TL"]
["TURKMÉNISTAN","TM"]
["TUNISIE","TN"]
["TONGA","TO"]
["TURQUIE","TR"]
["TRINITÉ-ET-TOBAGO","TT"]
["TUVALU","TV"]
["TAÏWAN, PROVINCE DE CHINE","TW"]
["TANZANIE, RÉPUBLIQUE-UNIE DE","TZ"]
["UKRAINE","UA"]
["OUGANDA","UG"]
["ÎLES MINEURES ÉLOIGNÉES DES ÉTATS-UNIS","UM"]
["ÉTATS-UNIS","US"]
["URUGUAY","UY"]
["OUZBÉKISTAN","UZ"]
["SAINT-SIÈGE (ÉTAT DE LA CITÉ DU VATICAN)","VA"]
["SAINT-VINCENT-ET-LES GRENADINES","VC"]
["VENEZUELA, RÉPUBLIQUE BOLIVARIENNE DU","VE"]
["ÎLES VIERGES BRITANNIQUES","VG"]
["ÎLES VIERGES DES ÉTATS-UNIS","VI"]
["VIET NAM","VN"]
["VANUATU","VU"]
["WALLIS ET FUTUNA","WF"]
["SAMOA","WS"]
["YÉMEN","YE"]
["MAYOTTE","YT"]
["AFRIQUE DU SUD","ZA"]
["ZAMBIE","ZM"]
["ZIMBABWE","ZW"]

{"sheet":"Ref_Domaines_Areas","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[{"$f":"Ref_Country_Codes!B76","v":"FR"},{"$f":"Ref_Country_Codes!B78","v":"GB"},{"$f":"Ref_Country_Codes!B69","v":"ES"}]
["Domaines","Areas","Áreas"]
["Socle métier"]
["Personne"]
["Production - Socle commun"]
["Production - IARD"]
["Production - ADP"]
["Sinistre - IARD"]
["Sinistre - Prestations"]
["Sinistre - Prévoyance"]
["Comptabilité technique"]
["Comptabilité générale"]
["Socle transverse"]
["Socle technique"]