删除某员工考勤业务数据的参考脚本

[适用版本]

通用

[解决方案]

--备份数据

select * into attendancefile0526 from t_hr_ats_attendancefile

select * into attendancefilehis0526 from t_hr_ats_attendancefilehis

select * into holidaylimit0526 from t_hr_ats_holidaylimit

select * into holidaylimitdetail0526 from t_hr_ats_holidaylimitdetail

select * into overtimebillentry0526 from t_hr_ats_overtimebillentry

select * into overtimebill0526 from t_hr_ats_overtimebill

select * into punchcardrecord0526 from t_hr_ats_punchcardrecord

--删除数据

delete from t_hr_ats_holidaylimit where fproposerid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0='

delete from t_hr_ats_holidaylimitdetail where fproposerid='3ZPLMWP7RVW6EnlHElwGi4Dvfe0='

delete from t_hr_ats_overtimebill w