à partir du script SELECT day as Cle_Jour, 
employeeSid as Cle_Employe, 
--registrationNumber as Matricule,
isCorrectEmployeeCode as Top_Code_Employe_Correct,
age           as Age,
sexe as sexe,
ageRange as Tranche_Age,
seniority as Anciennete_Societe,
seniorityRange as Tranche_Anciennete_Societe, 
functionSeniority as Anciennete_Fonction, 
functionSeniorityRange as Tranche_Anciennete_Fonction, 
siteSeniority as Anciennete_Site,
siteSiteRange as Tranche_Anciennete_Site, 
weeklyScheduleRange as Tranche_Temps_Travail, 
theoreticalHoursOfPresence as Heure_Presence_Theorique, 
weeklyScheduleFTE as Equivalent_Temps_Plein,

employeeWorkForce as Effectif_Salarie, 
employeeWorkForceFTE as Effectif_Salarie_Equivalent_Temps_Plein, 
traineeWorkForce as Effectif_Stagiaire, 
traineeWorkForceFTE as Effectif_Stagiaire_Equivalent_Temps_Plein,

entryTypeSid as Cle_Type_Entree,
leavingTypeSid as Cle_Type_Sortie, 
leavingReasonSid as Cle_Motif_Sortie, 
typeContractSid as Cle_Type_Contrat, 
natureContractSid as Cle_Nature_Contrat, 
reasonFixedTermContractSid as Cle_Motif_CDD, 
isWorkStudyContract as Top_Alternant, 

conventionSid as Cle_Convention,
statusLevel1 as Niveau1_Status,
statusLevel2 as Niveau2_Status,
qualif as Qualification,
qualifLevel as Niveau_Qualification,
qualifStep as Echelon_Qualification,
annex as Code_Annexe,
annexLabel as Nom_annexe,




diplomaLevel as  Niveau_Diplome, 
establishementId as Code_Etablissement,

establishmentCseCode as Code_CSE_Etablissement,
establishmentCseLabel as Nom_CSE_Etablissement,

establishmentSIRETCode as Code_SIRET_Etablissement,
societySIRENCode as Code_SIREN_Societe,
societyAPE2003Code as Code_APE2003_Societe,
societyAPE2008Code as Code_APE2008_Societe,




expertiseLevelSid as Cle_Tenue_Fonction, 
FamilySituationSid as Cle_Situation_Familliale, 
jobSid as Cle_Metier, 
--caseSid as Cle_Dossier,
organizationalUnitSid as Cle_Unite_Organisation,

lvl1_Id as Code_Unite_Organisation_lvl1,
organizationalUnitShortLabel_lvl1 as Nom_Unite_Organisation_lvl1,
organizationalUnitLongLabel_lvl1 as Nom_Long_Unite_Organisation_lvl1,
organizationalUnitCrossParentId_lvl1 as Code_Unite_Organisation_Transverse_lvl1,
organizationalUnitCrossParentShortLabel_lvl1 as Nom_Unite_Organisation_Transverse_lvl1,
organizationalUnitCrossParentLongLabel_lvl1 as Nom_Long_Unite_Organisation_Transverse_lvl1,

lvl2_Id as Code_Unite_Organisation_lvl2,
organizationalUnitShortLabel_lvl2 as Nom_Unite_Organisation_lvl2,
organizationalUnitLongLabel_lvl2 as Nom_Long_Unite_Organisation_lvl2,
organizationalUnitCrossParentId_lvl2 as Code_Unite_Organisation_Transverse_lvl2,
organizationalUnitCrossParentShortLabel_lvl2 as Nom_Unite_Organisation_Transverse_lvl2,
organizationalUnitCrossParentLongLabel_lvl2 as Nom_Long_Unite_Organisation_Transverse_lvl2,

lvl3_Id as Code_Unite_Organisation_lvl3,
organizationalUnitShortLabel_lvl3 as Nom_Unite_Organisation_lvl3,
organizationalUnitLongLabel_lvl3 as Nom_Long_Unite_Organisation_lvl3,
organizationalUnitCrossParentId_lvl3 as Code_Unite_Organisation_Transverse_lvl3,
organizationalUnitCrossParentShortLabel_lvl3 as Nom_Unite_Organisation_Transverse_lvl3,
organizationalUnitCrossParentLongLabel_lvl3 as Nom_Long_Unite_Organisation_Transverse_lvl3,

lvl4_Id as Code_Unite_Organisation_lvl4,
organizationalUnitShortLabel_lvl4 as Nom_Unite_Organisation_lvl4,
organizationalUnitLongLabel_lvl4 as Nom_Long_Unite_Organisation_lvl4,
organizationalUnitCrossParentId_lvl4 as Code_Unite_Organisation_Transverse_lvl4,
organizationalUnitCrossParentShortLabel_lvl4 as Nom_Unite_Organisation_Transverse_lvl4,
organizationalUnitCrossParentLongLabel_lvl4 as Nom_Long_Unite_Organisation_Transverse_lvl4,

lvl5_Id as Code_Unite_Organisation_lvl5,
organizationalUnitShortLabel_lvl5 as Nom_Unite_Organisation_lvl5,
organizationalUnitLongLabel_lvl5 as Nom_Long_Unite_Organisation_lvl5,
organizationalUnitCrossParentId_lvl5 as Code_Unite_Organisation_Transverse_lvl5,
organizationalUnitCrossParentShortLabel_lvl5 as Nom_Unite_Organisation_Transverse_lvl5,
organizationalUnitCrossParentLongLabel_lvl5 as Nom_Long_Unite_Organisation_Transverse_lvl5,

lvl6_Id as Code_Unite_Organisation_lvl6,
organizationalUnitShortLabel_lvl6 as Nom_Unite_Organisation_lvl6,
organizationalUnitLongLabel_lvl6 as Nom_Long_Unite_Organisation_lvl6,
organizationalUnitCrossParentId_lvl6 as Code_Unite_Organisation_Transverse_lvl6,
organizationalUnitCrossParentShortLabel_lvl6 as Nom_Unite_Organisation_Transverse_lvl6,
organizationalUnitCrossParentLongLabel_lvl6 as Nom_Long_Unite_Organisation_Transverse_lvl6,

lvl7_Id as Code_Unite_Organisation_lvl7,
organizationalUnitShortLabel_lvl7 as Nom_Unite_Organisation_lvl7,
organizationalUnitLongLabel_lvl7 as Nom_Long_Unite_Organisation_lvl7,
organizationalUnitCrossParentId_lvl7 as Code_Unite_Organisation_Transverse_lvl7,
organizationalUnitCrossParentShortLabel_lvl7 as Nom_Unite_Organisation_Transverse_lvl7,
organizationalUnitCrossParentLongLabel_lvl7 as Nom_Long_Unite_Organisation_Transverse_lvl7,

lvl8_Id as Code_Unite_Organisation_lvl8,
organizationalUnitShortLabel_lvl8 as Nom_Unite_Organisation_lvl8,
organizationalUnitLongLabel_lvl8 as Nom_Long_Unite_Organisation_lvl8,
organizationalUnitCrossParentId_lvl8 as Code_Unite_Organisation_Transverse_lvl8,
organizationalUnitCrossParentShortLabel_lvl8 as Nom_Unite_Organisation_Transverse_lvl8,
organizationalUnitCrossParentLongLabel_lvl8 as Nom_Long_Unite_Organisation_Transverse_lvl8,

lvl9_Id as Code_Unite_Organisation_lvl9,
organizationalUnitShortLabel_lvl9 as Nom_Unite_Organisation_lvl9,
organizationalUnitLongLabel_lvl9 as Nom_Long_Unite_Organisation_lvl9,
organizationalUnitCrossParentId_lvl9 as Code_Unite_Organisation_Transverse_lvl9,
organizationalUnitCrossParentShortLabel_lvl9 as Nom_Unite_Organisation_Transverse_lvl9,
organizationalUnitCrossParentLongLabel_lvl9 as Nom_Long_Unite_Organisation_Transverse_lvl9,



 
--percentAssignment as Pourcentage_Affectation,  ne sert pas car on ne garde que l'affectation principal
flagNightWorker as Top_Travailleur_Nuit, 
--siteHrSid as Cle_SiteHR,
siteHrCode as Code_SiteHR, 
--employeeSitePercent as Pourcentage_Site,  ne sert pas car on ne garde que l'affectation principal
isstudent as Top_Etudiant, 
timeModeId as Cle_Type_Horaire,
timeOrganizationId as Cle_Organisation_Horaire,
weeklySchedule as Horaire_Hebdo, 
isFullTimeWorker as Top_TempsPlein, 
contractDays as Nb_Jour_Contrat, 



jobId as Code_Metier,
jobUnitShortLabel as Nom_Metier,
jobUnitLongLabel as Nom_Long_Metier,
functionId as Code_Fonction,
functionShortLabel as Nom_Fonction,
functionLongLabel as Nom_Long_Fonction,


natureContractId as Code_Nature_Contrat,
natureContractabel as Nom_Nature_Contrat,
natureContractLabelLong as Nom_Long_Nature_Contrat,

reasonFixedTermContractId as Code_Motif_CDD,
reasonFixedTermContractLabel as Nom_Motif_CDD,
reasonFixedTermContractLabelLong as Nom_Long_Motif_CDD,

entryTypeId as Code_Type_Entree,
entryTypeLabel as Nom_Type_Entree,
entryTypetLabelLong as Nom_Long_Type_Entree,

leavingTypeId as Code_Motif_Sortie,
leavingTypeLabel as Nom_Motif_Sortie,
leavingTypetLabelLong as Nom_Long_Motif_Sortie,


siteShortLabel as Nom_Court_SiteHR, 
siteLongLabel as Nom_Long_SiteHR, 
normalizedLabel  as Nom_Normalise_SiteHR, 
siteTypeCode as Code_Type_SiteHR, 
siteTypeShortLabel as Nom_Court_Type_SiteHR, 
siteTypeLongLabel as Nom_Long_Type_SiteHR, 
siteFormat as Format_ARF, 
siteFormatCode as Code_Format_SiteHR, 


establishementSid as Cle_Etablissement,
establishmentLabel as Nom_Etablissement,
establishmentLabelLong as Nom_Long_Etablissement,

establishmentNormalizedLabel as Nom_Normalise_SiteHR_Etablissement,
establishmentFormat as Format_Groupe,

conventionId as Code_Convention,
conventionLabel as Nom_Convention,
conventionLabelLong as Nom_Long_Convention,

typeContractId as Code_Type_Contrat,
typeContractLabel as Nom_Type_Contrat,
typeContractLabelLong as Nom_Long_Type_Contrat,


FamilySituationId as Code_Situation_Familliale,
FamilySituationLabel as Nom_Situation_Familliale,
FamilySituationLabelLong as Nom_Long_Situation_Familliale,

expertiseLevelId as Code_Tenue_Fonction,
expertiseLevelLabel as Nom_Tenue_Fonction,
expertiseLevelLabelLong as Nom_Long_Tenue_Fonction,


timeModeLabel as Nom_Type_Horaire,
timeModeLabelLong as Nom_Long_Type_Horaire,

timeOrganizationLabel as Nom_Organisation_Horaire,
timeOrganizationLabelLong as Nom_Long_Organisation_Horaire,

territoryHrId as Code_Territoire,
territoryHrLabel as Nom_Territoire,
livingAreaHrId as Code_Zone_De_Vie,
livingAreaHrLabel as Nom_Zone_De_Vie,
 je voudrais que tu remplacer le nouveau nom par l'ancien nom suivit du suffixe _prevSituation