If an attachment that is being deleted is associated with another record in the J1 database (an online submission, for example), the row in the ATTACHMENT table will not be deleted but the corresponding CANDIDACY_ATTACHMENT row(s) will be deleted.
This window allows you to delete attachments associated with CANDIDACY rows that meet the desired criteria. This utility can be used to delete attachments that are no longer necessary or useful.
The default d_delete_cand_attach_list query selects ID Numbers that have attachments that are older than five years. After identifying the ID Numbers, the process deletes all rows from the CANDIDACY_ATTACHMENT table for each ID Number and their corresponding attachment(s) from the ATTACHMENT table.
|
|
If an attachment that is being deleted is associated with another record in the J1 database (an online submission, for example), the row in the ATTACHMENT table will not be deleted but the corresponding CANDIDACY_ATTACHMENT row(s) will be deleted. |
You can change the query by clicking the Customize button.