tbl_ACTIVE
STATUS | Type | Details |
Blank OR NULL | CAD | Raw, unlinked CAD Record |
DELETED | CAD | The end user in Reporter has requested to be deleted. This must be approved in the Administrator before the report is deleted. |
STARTED | Report | Unfinished and not linked to a CAD Record |
STARTED-CAD | Report | Unfinished, Linked to a CAD Record, CADLinkedActiveKey field has the active_key of the CAD Record |
tbl_CLOSED
STATUS | Type | Details |
ADMINDELETE- | CAD | Deleted in the Administrator. No one requested the CAD Record be deleted |
ADMINDELETE-DELETED | CAD | Deleted in Administrator after a user requested the CAD record be deleted. This will also be the status of a CAD record created via Add-A-CAD and then deleted by the end user |
ADMINDELETE-STARTED | Report | Unfinished report that has not been CAD Linked deleted in the Administrator by an admin |
ADMINDELETE-STARTED-CAD | Report | Unfinished report that has been CAD Linked deleted in the Administrator by an admin |
CADLINKED | CAD | Linked to a report. A corresponding report should exist with this records active_key for its CADLinkedActiveKey field value |
CLOSED | Report | Closed, Imported report that may or not be linked, depending on whether they require a cad link to close or not. Report contents should be in tbl_incident_data |
EDITED | Report | Closed and Imported, then edited by either an administrator or through messaging. This report may or may not be CAD Linked the same as a CLOSED status |
USERDELETE | Report | Unfinished report that has not been cad linked that a user deleted without the help of an administrator |