Submission Tracking Logs
Submission Tracking Logs
Updated on Dec 11, 2024
Published on Oct 10, 2024
1 minute(s) read
The submissions tracking functionality in the database and API records each stage that a page moves through as it is processed in Hyperscience. This information can help with debugging and stuck or incomplete submissions. To query the submission tracking logs, navigate to the database table reports_submissionlog.
Submission Tracking Log columns
The following information defines the column names in the Submissions Tracking Log, which correspond to the stages of the processing graph:
| Submission Activity Name | Submission Activity Subtype Name |
|---|---|
| Initial | W_SUBMISSION_START |
| Submission Deletion | W_SUBMISSIONS_DELETE |
| Resubmission | W_SUBMISSION_RETRY |
| Segmentation | SEGMENTATION |
| Page Classification | VPC |
| Layout Alignment | REGISTRATION |
| Form Aggregation | W_DISTRIBUTE_TO_FORMS |
| W_DISTRIBUTE_TO_FORMS_COMPLETE | |
| Field Identification | FIELD_LOCATOR |
| Transcription | OICR_FIELD |
| OICR_PAGE | |
| OICR_FLEX_PAGE | |
| Transcription completion | W_FORM_OICR_READY |
| Supervision - [Task Type] | CS_REQUEST |
| CS_RESPONSE | |
| Completion - [Page Status] | W_FORM_COMPLETE |
| W_SUBMISSION_COMPLETE | |
| Document State Changed | Complete |
| Submission State Changed | |
| Record QA | W_QA_READY |
| Notification | "NOTIFY" |
Submissions logged
The following information is recorded for every submitted page at each processing step:
| Column Name | Description |
|---|---|
| id | System-generated numeric ID for the processing step |
| activity_start | Date & time at which the processing step began |
| activity_end | Date & time at which the processing step completed |
| submission_metadata | Metadata provided at the time of submission, if any |
| submission_external_id | External ID provided at the time of submission, if any |
| submission_id | System-generated numeric ID for the submission of which the page is part |
| submission_page_id | System-generated numeric ID for the page |
| form_id | System-generated numeric ID for the document of which the page is part, if any |
| template_uuid | System-generated unique identifier of the layout to which the page has been matched |
| template_name | Name of the layout to which the page has been matched |
| operator | Whether the step was performed by the machine or manually - 1 corresponds to machine, 0 to manual |
| username | The username which performed the step, if manual |
| activity_name | Human-readable activity name - the full list above |
| activity_subtype_name | Processing graph step name - the full list above |
| activity_created | Date & time at which the processing step was created |
| transcribed_fields_count | Fields transcribed during the processing step, if any |
| details | Any additional information relevant to specific processing steps. |
Sample Submission Tracking Record
Here’s an example submission tracking record for a page undergoing manual transcription:
| Column Name | Value - Manual Transcription Step |
|---|---|
| id | 123456789 |
| activity_start | 2019-01-02 12:19:07.278863+00:00 |
| activity_end | 2019-01-02 15:38:27.192354+00:00 |
| submission_metadata | “{\ |