NPDES Tracker - Overall Steps to Completion

[talllguy]

• [x] Make sure that the current S123 forms are updated. #432
• [x] All pending inspections (anything that is not yet submitted) must have their INSP_LIFECYCLE field set to ‘NEW’. All inspections going forward must populate this field, or else the updated ETL will not work for sync/submit. [Elliott] #434
• [x] Update the BMP inspections ETL to: [John] a. No longer use META_STATE. b. Query INSP_LIFECYCLE instead of FIRM_NAME when syncing, submitting, and deleting inspections. c. Update INSP_LIFECYCLE/INSP_LIFECYCLE_DATE during a submit/delete operation.
• [ ] Batch update the existing S123 AGOL data with submitted/deleted INSP_LIFECYCLE for various FIRM_NAME values, while restoring the FIRM_NAME to the original. This can be done last, as the data is just archived in AGOL and does not affect the existing inspections sync. [Elliott/John]
• [ ] Do all updates in #435

[johnshiu]

@talllguy, the inspections ETL has been updated and will now keep FIRM_NAME static, only changing INSP_LIFECYCLE during submission/deletion. Also, we are currently ignoring the READY_TO_SUBMIT field during sync.