Sept 2021 : NOTE - all required code for this process is found at :
simply copy and place into your preferred SQL tool
...
/*
If the data just uploaded is deemed to be corrupt or just very incorrect (example: incorrect SDR numbering) and we need to recode in some way, we might want to remove the data from WSDRS and make adjustments to M70 – or possibly purge m70 and return to the insert statements in DATA.TXT, recode and reprocess the data batch.
Note : we do not purge M70_SDR_Transit , until we’re ready to do the next data upload. This gives us some extra lag time, if someone reports unfixable anomalies in the Production data. Provided these FAA SDR’s have not been attached to any projects in the CAWIS PTS subsystem, we can usually delete the last batch, make our code corrections, and incorporate our last upload with the newest one.
...