...
- 1 = NOT SUBMITTED
- 4 = INITIAL REPORT SUBMITTED
- 8 = FINAL REPORT SUBMITTED
- 16 = REPORT DELETED -- NOTE: Reports are marked as deleted but retained in the database for a historic record. Some users refer to this as "voiding" the report.
If a landing report is saved with a ReportStatus = 1 (NOT SUBMITTED), the data is stored in a clob in the database. This allows users to save unsubmitted reports in an incomplete or incorrect state. All other report status will trigger the report to be saved in the traditional report tables and columns.
When the submitInitialLandingReport() is called, the landing report is validated against final submission business rules. If the report was previously saved in the NOT SUBMITTED as a clob, that data is now deleted. The landing report status is changed to ReportStatus = 4 (INITIAL REPORT SUBMITTED). Finally the data is stored in the database tables.
...