Passer au contenu principal

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.

Pas de commentaires
Retour en haut