Using mySQL

Find list of files by submission id:

SELECT * FROM epageweb.files where submission_id = 1159;

Find submission id (in submission_id column) by trackingno (locator ID/coc#):

SELECT * FROM epageweb.submission where trackingno = 'coc5239a78eb0634';

Find a file by the file id (different than submission id. each file has its own id):

SELECT * FROM epageweb.files where id = '373540';

Change a file status:

UPDATE `epageweb`.`files` SET `current_status`='WIP' WHERE `id`='427553';

Search for files by submission id and change status of all files in the submission:

SELECT * FROM epageweb.files where submission_id = 60966;

Update epageweb.files set current_status='WIP' where submission_id=60966;

Delete file from additional info table (necessary in order to then delete from files table)

DELETE FROM epageweb.additional_info where file_id = 482721;

Delete file from files table

DELETE FROM epageweb.files where id = 482721;

Delete reference to fild id in external_files (recently receveived an error requiring this in order to delete from files table)

DELETE FROM epageweb.external_files where files_id = 745907;

To grab JSON code directly from database. Then scroll over to JSON code field:

select * from epageweb.external_package where ms_nm = '2015-20346'