{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["champs contrats"],"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 contrats","index":0,"n_rows":29,"n_cols":6,"rows_kept":29,"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,"id_contrat_ming","n° du contrat dans Ming","alphanumérique","obligatoire"]
[11,"id_contrat","n° du contrat dans le logiciel initial","alphanumérique","facultatif"]
[12,"contrat_date_debut","date début contrat","date","AAAA/MM/JJ"]
[13,"Code contrat_type","1,2,3...","code","Colonne id de la table forme_contrat "]
[14,"Libellé contrat_type","type contrat","alphanumérique","Colonne nom de la table forme_contrat "]
[15,"Code metier","1,2,3...","code","Colonne id de la table metier"]
[16,"Libellé métier","métier","alphanumérique","Colonne nom de la table metier"]
[17,"code_site_travail","1,2,3...","code","Colonne id de la table secteur_activite site travail","v2"]
[18,"Libellé _site_travail","secteur activité  site de travail pour ce contrat ","alphanumérique","Colonne nom de la table  secteur_activite site travail","v2"]
[19,"nb_heures_hebdo","nombre d'heures hebdomadaire","alphanumérique","hh:mm"]
[20,"salaire_brut_mensuel","salaire brut mensuel","alphanumérique","abcd.xy"]
[21,"date_fin_prevue","date de fin prévue","date","AAAA/MM/JJ"]
[22,"date_fin_reelle","date de fin réelle","date","AAAA/MM/JJ"]
[23,"Code motif_fin","1,2,3...","code","Colonne id de la table MotifFinContrat "]
[24,"Libellé motif_fin","motif de fin (démission, ...)","alphanumérique","Colonne nom de la table MotifFinContrat "]
[25,"code_rome","code  rome","alphanumérique","Axxxx lettre suivi de 4 chiffres"]
[26,"type_contrat_asp","NPT ou I ou R1 R2 etc..","alphanumérique","Colonne code la table type_contrat_asp "]
[27,"salarie_id_asp","identifiant ASP salarié","alphanumérique","code ASP du salarié"]
[28,"contrat_id_asp","identifiant ASP contrat","alphanumérique","code ASP du contrat du salarié"]