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 :
FROM T_SAL
WHERE MatriculeSalarie = 'matricule du salarié'
🔎 Noter le SA_CompteurNumero récupéré (code interne salarié).
Exemple :
-
Matricule
202508001→ Code interne1589 -
Matricule
202508002→ Code interne1585
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_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.