1 2 3 4
| SELECT RUB_0.R_IJSS, RUB_0.R_1902, RUB_0.R_1900, RUB_0.R_1979, RUB_0.R_5979, RUB_0.R_5107_prec, RUB_0.R_5107_act, RUB_0.R_5031_act, [001F_EFF_PAIE_EN_COURS].Mois_paie, [001F_EFF_PAIE_EN_COURS].Gest_Adm, [001F_EFF_PAIE_EN_COURS].direction, [001F_EFF_PAIE_EN_COURS].libelle, [001F_EFF_PAIE_EN_COURS].Matricule_paie, [001F_EFF_PAIE_EN_COURS].Nom_prenom, [001F_EFF_PAIE_EN_COURS].[Nature_ contrat], [001F_EFF_PAIE_EN_COURS].statut_Paie, [001F_EFF_PAIE_EN_COURS].Prive_Public, [001F_EFF_PAIE_EN_COURS].Date_fin, [001F_EFF_PAIE_EN_COURS].motif_sortie_lib, [001F_EFF_PAIE_EN_COURS].date_anc_paie, [001F_EFF_PAIE_EN_COURS].[12_medaille_trav_total], [001F_EFF_PAIE_EN_COURS].[13_Mobilite_total], [001F_EFF_PAIE_EN_COURS].[0513_cal], [001F_EFF_PAIE_EN_COURS].[1372_cal], [001F_EFF_PAIE_EN_COURS].CAL3, [14d_total_mutex].SommeDe14d_mt_presta_paye, [001F_EFF_PAIE_EN_COURS].[0225_cal], [001F_EFF_PAIE_EN_COURS].[1447_cal], [001F_EFF_PAIE_EN_COURS].[18_Ind_depart], Nz([0378_cal],0)+Nz([0379_cal],0)+Nz([5048_cal],0)+Nz([0380_cal],0)+Nz([0381_cal],0)+Nz([0382_cal],0)+Nz([0383_cal],0)+Nz([0359_cal],0) AS HS_total, [16_total2_prime_conferencier].SommeDe0510, [6b_total2_abs_non_paye].[6b_cal_montant], [5_total4_regul].SommeDe5cal_total, [R_5107_prec]-[R_5031_act] AS [5107_prec-5031_act], [R_5107_act]-[R_5107_prec] AS diff_5107, Nz([R_5031_act],0)-Nz([R_1902],0)+Nz([R_IJSS],0)-Nz([Total_Ind_csg],0)-Nz([R_5979],0)-Nz([1372_cal],0)-Nz([18_ind_depart],0)-Nz([0378_cal],0)-Nz([0379_cal],0)-Nz([5048_cal],0)-Nz([0380_cal],0)-Nz([0381_cal],0)-Nz([0382_cal],0)-Nz([0383_cal],0)-Nz([0359_cal],0)-Nz([SommeDe14d_mt_presta_paye],0)-Nz([0225_cal],0)+Nz([1447_cal],0)-Nz([SommeDe0510],0)+Nz([6b_cal_montant],0)-Nz([SommeDe5cal_total],0)-Nz([13_mobilite_total],0)-Nz([12_medaille_trav_total],0)-Nz([diff_anc],0)-Nz([IDCA_cal2],0)-Nz([1968],0)-Nz([0520],0)-Nz([diff_SM_promo],0)-Nz([CAL3],0)-Nz([1900],0) AS 5107_retabli, Nz([R_5031_act],0)-Nz([R_5107_prec],0)+(Nz([R_IJSS],0)-Nz([CAL3],0)-Nz([R_1900],0)-Nz([Total_Ind_csg],0)-Nz([R_5979],0)-Nz([0825],0)-Nz([1372_cal],0)-Nz([18_ind_depart],0)-Nz([0378_cal],0)-Nz([0379_cal],0)-Nz([5048_cal],0)-Nz([0380_cal],0)-Nz([0381_cal],0)-Nz([0382_cal],0)-Nz([0383_cal],0)-Nz([0359_cal],0)-Nz([1902],0)-Nz([SommeDe14d_mt_presta_paye],0)-Nz([0225_cal],0)+Nz([1447_cal],0)-Nz([SommeDe0510],0)+Nz([6b_cal_montant],0)-Nz([SommeDe5cal_total],0)-Nz([13_mobilite_total],0)-Nz([12_medaille_trav_total],0)-[0240_cal]+[prec_0240_cal]-Nz([IDCA_cal2],0)-Nz([1968],0)-Nz([0520],0)-(IIf(([sal_mens_prive]-[prec_SM_prive])<>0,([sal_mens_prive]-[prec_SM_prive]-([0240_cal]-[prec_0240_cal])),([sal_mens_prive]-[prec_SM_prive])))) AS diff, Nz([R_5031_act],0)-Nz([R_5107_prec],0)+(Nz([R_IJSS],0)-Nz([CAL3],0)-Nz([R_1900],0)-Nz([Total_Ind_csg],0)-Nz([R_5979],0)-Nz([1372_cal],0)-Nz([18_ind_depart],0)-Nz([0378_cal],0)-Nz([0379_cal],0)-Nz([5048_cal],0)-Nz([0380_cal],0)-Nz([0381_cal],0)-Nz([0382_cal],0)-Nz([0383_cal],0)-Nz([0359_cal],0)-Nz([1902],0)-Nz([SommeDe14d_mt_presta_paye],0)-Nz([0225_cal],0)+Nz([1447_cal],0)-Nz([SommeDe0510],0)+Nz([6b_cal_montant],0)-Nz([SommeDe5cal_total],0)-Nz([13_mobilite_total],0)-Nz([12_medaille_trav_total],0)-[0240_cal]+[prec_0240_cal]-Nz([IDCA_cal2],0)-Nz([1968],0)-Nz([0520],0)-(IIf(([sal_mens_prive]-[prec_SM_prive])<>0,([sal_mens_prive]-[prec_SM_prive]-([0240_cal]-[prec_0240_cal])),([sal_mens_prive]-[prec_SM_prive]))))-Nz([diff_salaire_justif],0) AS new_diff, [01B2_EFF_ANC_MOIS_PREC_SM].prec_SM_prive, [001F_EFF_PAIE_EN_COURS].diff_salaire_justif, [001F_EFF_PAIE_EN_COURS].commentaire_eff_paie, [001F_EFF_PAIE_EN_COURS].mois_anc_paie, [001F_EFF_PAIE_EN_COURS].mois_mois_paie, [0240_cal]-[prec_0240_cal] AS diff_anc, [001F_EFF_PAIE_EN_COURS].[0240_cal], [001F_EFF_PAIE_EN_COURS].anc, [001F_EFF_PAIE_EN_COURS].IDCA_cal2, [sal_mens_prive]-[prec_SM_prive] AS diff_SM_promo, RUB_0.Total_Ind_csg
FROM ((((((RUB_0 INNER JOIN 001F_EFF_PAIE_EN_COURS ON (RUB_0.RUB_mois_paie = [001F_EFF_PAIE_EN_COURS].Mois_paie) AND (RUB_0.RUB_mat = [001F_EFF_PAIE_EN_COURS].Matricule_paie)) LEFT JOIN 16_total2_prime_conferencier ON ([001F_EFF_PAIE_EN_COURS].Matricule_GA = [16_total2_prime_conferencier].[16_mat_GA]) AND ([001F_EFF_PAIE_EN_COURS].Mois_paie = [16_total2_prime_conferencier].[16_mois_paie])) LEFT JOIN 11_liste_heures_sup ON ([001F_EFF_PAIE_EN_COURS].Mois_paie = [11_liste_heures_sup].Mois_paie) AND ([001F_EFF_PAIE_EN_COURS].Matricule_GA = [11_liste_heures_sup].Matricule_GA)) LEFT JOIN 14d_total_mutex ON ([001F_EFF_PAIE_EN_COURS].Matricule_GA = [14d_total_mutex].Matricule_GA) AND ([001F_EFF_PAIE_EN_COURS].Mois_paie = [14d_total_mutex].[14d_mois_paie])) LEFT JOIN 6b_total2_abs_non_paye ON ([001F_EFF_PAIE_EN_COURS].Matricule_GA = [6b_total2_abs_non_paye].[6b_matGA]) AND ([001F_EFF_PAIE_EN_COURS].Mois_paie = [6b_total2_abs_non_paye].[6b_mois_paie])) LEFT JOIN 5_total4_regul ON ([001F_EFF_PAIE_EN_COURS].Matricule_GA = [5_total4_regul].[5_matGA]) AND ([001F_EFF_PAIE_EN_COURS].Mois_paie = [5_total4_regul].[5_mois_regul])) LEFT JOIN 01B2_EFF_ANC_MOIS_PREC_SM ON [001F_EFF_PAIE_EN_COURS].Matricule_paie = [01B2_EFF_ANC_MOIS_PREC_SM].Prec_Mat_paie
WHERE ((([001F_EFF_PAIE_EN_COURS].Gest_Adm) Like "*" & [Saisir le nom du gestionnaire] & "*" Or ([001F_EFF_PAIE_EN_COURS].Gest_Adm) Is Null) AND (([001F_EFF_PAIE_EN_COURS].Prive_Public)="privé") AND ((Nz([R_5031_act],0)-Nz([R_5107_prec],0)+(Nz([R_IJSS],0)-Nz([CAL3],0)-Nz([R_1900],0)-Nz([Total_Ind_csg],0)-Nz([R_5979],0)-Nz([1372_cal],0)-Nz([18_ind_depart],0)-Nz([0378_cal],0)-Nz([0379_cal],0)-Nz([5048_cal],0)-Nz([0380_cal],0)-Nz([0381_cal],0)-Nz([0382_cal],0)-Nz([0383_cal],0)-Nz([0359_cal],0)-Nz([1902],0)-Nz([SommeDe14d_mt_presta_paye],0)-Nz([0225_cal],0)+Nz([1447_cal],0)-Nz([SommeDe0510],0)+Nz([6b_cal_montant],0)-Nz([SommeDe5cal_total],0)-Nz([13_mobilite_total],0)-Nz([12_medaille_trav_total],0)-[0240_cal]+[prec_0240_cal]-Nz([IDCA_cal2],0)-Nz([1968],0)-Nz([0520],0)-(IIf(([sal_mens_prive]-[prec_SM_prive])<>0,([sal_mens_prive]-[prec_SM_prive]-([0240_cal]-[prec_0240_cal])),([sal_mens_prive]-[prec_SM_prive]))))-Nz([diff_salaire_justif],0))>-1 Or (Nz([R_5031_act],0)-Nz([R_5107_prec],0)+(Nz([R_IJSS],0)-Nz([CAL3],0)-Nz([R_1900],0)-Nz([Total_Ind_csg],0)-Nz([R_5979],0)-Nz([1372_cal],0)-Nz([18_ind_depart],0)-Nz([0378_cal],0)-Nz([0379_cal],0)-Nz([5048_cal],0)-Nz([0380_cal],0)-Nz([0381_cal],0)-Nz([0382_cal],0)-Nz([0383_cal],0)-Nz([0359_cal],0)-Nz([1902],0)-Nz([SommeDe14d_mt_presta_paye],0)-Nz([0225_cal],0)+Nz([1447_cal],0)-Nz([SommeDe0510],0)+Nz([6b_cal_montant],0)-Nz([SommeDe5cal_total],0)-Nz([13_mobilite_total],0)-Nz([12_medaille_trav_total],0)-[0240_cal]+[prec_0240_cal]-Nz([IDCA_cal2],0)-Nz([1968],0)-Nz([0520],0)-(IIf(([sal_mens_prive]-[prec_SM_prive])<>0,([sal_mens_prive]-[prec_SM_prive]-([0240_cal]-[prec_0240_cal])),([sal_mens_prive]-[prec_SM_prive]))))-Nz([diff_salaire_justif],0))>1))
ORDER BY RUB_0.RUB_nom, [001F_EFF_PAIE_EN_COURS].Nom_prenom; |
Partager