Récupérer le matricule d'un salarié "Fantôme" pour le recréer

Identification du salarié concerné 

 Requête pour récupérer le code interne 

 Remplacer 'matricule du salarié' par le matricule réel : 

 

 

 

 

 

 

 

 

 

 

 SELECT SA_CompteurNumero FROM T_SAL WHERE MatriculeSalarie = 'matricule du salarié' 

 

 

 

 

 

 

 

 

 

 

 

 

 

 🔎 Noter le SA_CompteurNumero récupéré (code interne salarié). 

 Exemple : 

 

 

 Matricule 202508001 → Code interne 1589 

 

 

 Matricule 202508002 → Code interne 1585 

 

 

 

 Suppression complète des données liées au salarié 

 ⚠️ ATTENTION 

 

 

 Faire une sauvegarde de la base avant intervention. 

 

 

 Vérifier que le salarié peut être supprimé (pas d’historique à conserver). 

 

 

 Requêtes de suppression 

 Remplacer 2403 par le code interne du salarié . 

 

 

 

 

 

 

 

 

 

 

 Delete From T_infoBanque Where NumSalarie in ( 2403 ) Delete From T_InfosParMois Where NumSalarie in ( 2403 ) Delete From T_CUMSAL Where NumSalarie in ( 2403 ) Delete From T_Declaratif Where NumSalarie in ( 2403 ) Delete From T_Langue_Salarie Where NumSalarie in ( 2403 ) Delete From T_BNSSAL Where NumSalarie in ( 2403 ) Delete From T_COTSAL Where NumSalarie in ( 2403 ) Delete From T_FlagInterne Where NumSalarie in ( 2403 ) Delete From T_ZonesLibres Where NumSalarie in ( 2403 ) Delete From T_IRCA Where NumSalarie in ( 2403 ) Delete From T_ENF Where NumSalarie in ( 2403 ) Delete From T_PER Where NumSalarie in ( 2403 ) Delete From T_MUL Where NumSalarie in ( 2403 ) Delete From T_PrevoyanceSalarie Where NumSalarie in ( 2403 ) Delete From T_HAFF Where NumSalarie in ( 2403 ) Delete From T_HBNS Where NumSalarie in ( 2403 ) Delete From T_HCOT Where NumSalarie in ( 2403 ) Delete From T_HCUM Where NumSalarie in ( 2403 ) Delete From T_CUM2SAL Where NumSalarie in ( 2403 ) Delete From T_Duplicata Where NumSalarie in ( 2403 ) Delete From T_BilCum Where NumSalarie in ( 2403 ) Delete From T_BilSal Where NumSalarie in ( 2403 ) Delete From T_PJ_SALARIE Where NumSalarie in ( 2403 ) Delete From T_Compacquise Where NumSalarie in ( 2403 ) Delete From T_Contact Where NumSalarie in ( 2403 ) Delete From T_CumCompteurSal Where NumSalarie in ( 2403 ) Delete From T_CumPartSal Where NumSalarie in ( 2403 ) Delete From T_CumPlanAnalytiqueSal Where NumSalarie in ( 2403 ) Delete From T_EntrEval Where NumSalarie in ( 2403 ) Delete From T_EvtPos Where NumSalarie in ( 2403 ) Delete From T_GHRCal_Pas Where NumSalarie in ( 2403 ) Delete From T_GHRCal_Salarie Where NumSalarie in ( 2403 ) Delete From T_Participant Where NumSalarie in ( 2403 ) Delete From T_PJ_salarie Where NumSalarie in ( 2403 ) Delete From T_Pret Where NumSalarie in ( 2403 ) Delete From T_Reponse Where NumSalarie in ( 2403 ) Delete From T_Saliv_A Where NumSalarie in ( 2403 ) Delete From T_Saliv_B Where NumSalarie in ( 2403 ) Delete From T_Saliv_D Where NumSalarie in ( 2403 ) Delete From T_Saliv_E Where NumSalarie in ( 2403 ) Delete From T_Saliv_F Where NumSalarie in ( 2403 ) Delete From T_Souhait Where NumSalarie in ( 2403 ) Delete From T_GHRSal Where NumSalarie in ( 2403 ) Delete From T_ValeursGHRSal Where NumSalarie in ( 2403 ) Delete From TWf_Compteurs Where NumSalarie in ( 2403 ) Delete From TWf_Conge Where NumSalarie in ( 2403 ) Delete From T_SAL Where SA_CompteurNumero in ( 2403 ) 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 Vérification finale 

 

 

 Relancer l’application. 

 

 

 Recréer le salarié si nécessaire. 

 

 

 Relancer le traitement de la paie. 

 

 

 Vérifier l’absence d’erreur. 

 

 

 

 Bonnes pratiques 

 

 

 Toujours faire une sauvegarde avant suppression massive . 

 

 

 Vérifier qu’il ne s’agit pas d’un simple problème de compteur bloqué. 

 

 

 Si plusieurs salariés concernés, traiter un par un. 

 

 

 Documenter le matricule + code interne supprimé. 

 

 

 Informer la cliente de la nécessité éventuelle de ressaisir certaines données.