{"text_format":"2","workbook":"xls","n_sheets":2,"sheets":["champs statut","correspondances"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"champs statut","index":0,"n_rows":44,"n_cols":5,"rows_kept":44,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Numero colonne","code du champ","contenu","format","commentaires"]
[1,"id_salarie_ming","n° du salarié dans ming","alphanumérique","obligatoire"]
[2,"id_salarie_import","n° du salarié dans le logiciel initial","alphanumérique","facultatif"]
[3,"civilite","civilité","code","M / Mme / Mlle"]
[4,"nom","nom du salarié","alphanumérique","obligatoire. "]
[5,"nom_jeune_fille","nom de jeune fille de la salarié","alphanumérique","facultatif"]
[6,"prenom","prénom du salarié","alphanumérique","obligatoire"]
[7,"date_naissance","date de naissance","date","AAAA/MM/JJ"]
[8,"code_postal","code postal","alphanumérique","Sur 5 lettres 01200 par exemple"]
[9,"ville_residence","ville de résidence","alphanumérique","Libellé de la ville de résidence"]
[10,"ANRU","type quartier ANRU ","booleen","Oui/Non / colonne name de district_type à renseigner dans personnaldetail_districttype ?"]
[11,"ZRU","type quartier ZRU","booleen","Oui/Non / colonne name de district_type à renseigner dans personnaldetail_districttype ?"]
[12,"ZUS","type quartier ZUS","booleen","Oui/Non / colonne name de district_type à renseigner dans personnaldetail_districttype ?"]
[13,"AAH","Allocataire de l'AAH ","booleen","Oui/Non / colonne is_allocataire_aah dans HiringStatus"]
[14,"ARE","Allocataire de l'ARE ","booleen","Oui/Non / colonne is_allocataire_are dans HiringStatus"]
[15,"ASS","Allocataire de l'ASS ","booleen","Oui/Non / colonne is_allocataire_ass dans HiringStatus"]
[16,"ATA","Allocataire de l'ATA ","booleen","Oui/Non / colonne is_allocataire_ata dans HiringStatus"]
[17,"RSA","Allocataire du RSA ","booleen","Oui/Non / colonne is_allocataire_rsa dans HiringStatus"]
[18,"RSADROIT","Ayant droit RSA ","booleen","Oui/Non / colonne is_ayantdroit_rsa dans HiringStatus"]
[19,"RSANUM","Numéro d'allocataire RSA ","alphanumérique","colonne rsa_numero dans HiringStatus"]
[20,"RSAREFERENTCODE","1, 2, 3...","code","colonne id de la table Partenaire (nom de la table correct ?)"]
[21,"RSAREFERENTNOM","nom organisme référent","alphanumérique","colonne libelle de la table Partenaire (nom de la table correct ?)"]
[22,"RSACONTACT","contact RSA","alphanumérique","?"]
[23,"AS","Bénéficiaire d'aide sociale ","booleen","Oui/Non / colonne is_beneficiaire_as dans HiringStatus"]
[24,"ASNATURE","Nature de l'aide sociale ","alphanumérique","multiligne ?"]
[25,"ASI","Beneficiaire d'une mesure ASI ","booleen","Oui/Non / colonne is_beneficiaire_asi dans HiringStatus"]
[26,"ASIREFERENTCODE","1, 2, 3...","code","colonne id de la table Partenaire (nom de la table correct ?)"]
[27,"ASIREFERENTNOM","nom organisme référent","alphanumérique","colonne libelle de la table Partenaire (nom de la table correct ?)"]
[28,"ASICONTACT","ASICONTACT","alphanumérique"]
[29,"JGD","Jeune en grandes difficultés ","booleen","Oui/Non / colonne is_jeune_difficulte dans HiringStatus"]
[30,"CIVIS","CIVIS","date","AAAA/MM/JJ / colonne civis dans HiringStatus ?"]
[31,"DATEML","DATEML","date","AAAA/MM/JJ / colonne jd_date_inscription dans HiringStatus ?"]
[32,"JGDMLCODE","1, 2, 3...","code","colonne id de la table Partenaire (nom de la table correct ?)"]
[33,"JGDMLNOM","nom organisme mission locale","alphanumérique","colonne libelle de la table Partenaire (nom de la table correct ?)"]
[34,"SIAE","Personne en emploi dans une autre SIAE ","booleen","Oui/Non / colonne is_employe_autre_siae dans HiringStatus"]
[35,"SIAENOM","Nom de la SIAE d'origine ","alphanumérique","colonne  \teas_siae_name dans HiringStatus"]
[36,"PJJ","Personne relevant de la PJJ ","booleen","Oui/Non / Colonne is_relevant_pjj dans HiringStatus"]
[37,"PJJREFERENTCODE","1, 2, 3...","code","colonne id de la table Partenaire (nom de la table correct ?)"]
[38,"PJJREFERENTNOM","nom organisme référent","alphanumérique","colonne libelle de la table Partenaire (nom de la table correct ?)"]
[39,"PJJCONTACT","contact PJJ","alphanumérique"]
[40,"SR","Personne sans ressources propres ","booleen","Oui/Non / colonne is_sans_ressources dans HiringStatus"]
[41,"HANDICAPE","Travailleur Handicapé ","booleen","Oui/Non / colonne is_handicape dans HiringStatus"]
[42,"HANDIDATE","RQTH valable jusqu'au ","date","AAAA/MM/JJ / colonne handicape_date_validite dans HiringStatus"]
[43,"HANDICOM","Précautions particulières à mettre en oeuvre ","alphanumérique","commentaires multilignes / colonne  \thandicape_precaution dans HiringStatus"]

{"sheet":"correspondances","index":1,"n_rows":28,"n_cols":4,"rows_kept":28,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["code","contenu","type","dans ming"]
["ANRU","Type quartier ANRU : 0 / 1","booleen","colonne name de district_type à renseigner dans personnaldetail_districttype ?"]
["ZRU","Type quartier ZRU : 0 / 1","booleen","colonne name de district_type à renseigner dans personnaldetail_districttype ?"]
["ZUS","Type quartier ZUS : 0 / 1","booleen","colonne name de district_type à renseigner dans personnaldetail_districttype ?"]
["AAH","Allocation adulte hnadicapé 0 / 1","booleen","colonne is_allocataire_aah dans HiringSituation"]
["ARE","Allocation retour emploi 0 / 1","booleen","colonne is_allocataire_are dans HiringSituation"]
["ASS","Allocation sociale solidarité 0 / 1","booleen","colonne is_allocataire_ass dans HiringSituation"]
["ATA","Allocation temporaire attente 0 / 1","booleen","colonne is_allocataire_ata dans HiringSituation"]
["RSA","Revenu solidarité active 0 / 1","booleen","colonne is_allocataire_rsa dans HiringSituation"]
["RSADROIT","Ayant droit rsa 0 / 1","booleen","colonne is_ayantdroit_rsa dans HiringSituation"]
["RSANUM","numéro RSA","alphanumérique","colonne rsa_numero dans HiringSituation"]
["RSACONTACT","contact rsa","alphanumérique","colonne rsa_contact_referent dans HiringSituation"]
["AS","Aide sociale 0 / 1","booleen","colonne is_beneficiaire_as dans HiringSituation"]
["ASI","Allocation supplementaire invalidité 0 / 1","booleen","colonne is_beneficiaire_asi dans HiringSituation"]
["ASICONTACT","contact ASI","alphanumérique","colonne asi_contact_referent dans HiringSituation"]
["JGD","Jeune en grande difficulté 0 / 1","booleen","colonne is_jeune_difficulte dans HiringSituation"]
["CIVIS","date de fin contrat civis","date","colonne civis dans HiringSituation"]
["DATEML","date inscription mission locale","date","colonne  \tjd_date_inscription dans HiringSituation"]
["SIAE","Travaille autre siae 0 / 1","booleen","colonne  \tis_employe_autre_siae dans HiringSituation"]
["SIAENOM","nom de la SIAE","alphanumérique","colonne  \teas_siae_name dans HiringSituation"]
["PJJ","Protection judiciaire jeunesse 0 / 1","booleen","Colonne is_relevant_pjj dans HiringSituation"]
["PJJCONTACT","contact PJJ","alphanumérique","colonne  \tpjj_referent_contact dans HiringSituation"]
["SR","sans ressource 0/1","booleen","colonne is_sans_ressources dans HiringSituation"]
["HANDICAPE","Handicape 0/1","booleen","colonne is_handicape dans HiringSituation"]
["HANDIDATE","date validité handicap","date","colonne handicape_date_validite dans HiringSituation"]
["HANDICOM","commentaires sur le handicap","alphanumérique","colonne  \thandicape_precaution dans HiringSituation"]
[]
["Si le code n'est pas reconnu, une alerte l'affiche, on  ne fait rien pour cette ligne mais on continue"]