# 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 1. Relancer l’application. 2. Recréer le salarié si nécessaire. 3. Relancer le traitement de la paie. 4. 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.