运维类 - 档案系统维护日志

档案信息（DA_PERSON_ARCHIVE）

查询档案信息

select * from da_person_archive where pa_archive_serial = '档案号'

---

 

档案接收表 （DL_ARCHIVE_RECEIVE）

查询档案接收信息

select * from dl_archive_receive where AR_ARCHIVE_FK = '8ac790b3037b5ca501037b6228170003'

删除档案接收信息

update dl_archive_receive set AR_DELETE_FLAG_TF = 'T' 
where AR_ARCHIVE_FK = '8ac790b3037b5ca501037b6228170003'

---

商调函

删除商调函

select * from DL_APPLICATION_LETTER where AL_NAME = '姓名'
update DL_APPLICATION_LETTER set DELETEFLAG = 'T' where  AL_NAME = '姓名'

---

删除日结

update BI_DAY_END set DE_DELETE_FLAG_TF = 'T' where de_day_END_SERIAL = '日结号';

 

其他操作

SQL执行完默认没有提交，必须要提交一下

commit;