job_note_workflow_answers_v1
'Job note workflow answers' refer to the responses or data collected through the digital questionnaires associated with a job note.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The identifier of the workflow answer. |
| workflow_name | VARCHAR(100) | The name of the workflow. |
| workflow_group_name | VARCHAR(92) | The name of the workflow group. |
| question_text | VARCHAR(2000) | Textual representation of the workflow question. |
| answer_text | VARCHAR(4000) | Textual representation of the workflow answer. |
| is_default | VARCHAR(3) | Indicates if the answer is the default value provided for the question. |
| notes | VARCHAR(8144) | Additional textual notes provided for the workflow answer. |
| quantity | NUMBER(38,0) | Quantity value associated with the cost type workflow question. |
| net_amount | NUMBER(38,0) | Net amount value associated with the cost type workflow question. |
| tax_amount | NUMBER(38,0) | Tax amount value associated the cost type workflow question. |
| gross_amount | NUMBER(38,0) | Gross amount value associated the cost type workflow question. |
| currency | VARCHAR(6) | Currency code associated with the cost type workflow question. |
| answered_at | TIMESTAMP_TZ(9) | The timestamp with the timezone offset of when the workflow question was answered. |
| question_type | VARCHAR(58) | The type of the workflow question. Possible values: 'Yes/No', 'Whole number', 'Decimal', 'Text', 'Multi-select List', 'Single-select List', 'Cost', 'Date', 'Time', 'List', 'Barcode', 'Multi-select Icons list', 'Single-select Icons list', 'Optical character recognition'. |
| is_answer_mandatory | VARCHAR(3) | Indicates if the answer to the workflow question is mandatory. |
| is_on_job_card | VARCHAR(3) | Indicates if the workflow question appears on the job card. |
| question_order | NUMBER(38,0) | The integer value marking order of the question in the workflow. |
| is_deleted | VARCHAR(3) | Indicates if the answer was deleted from JobWatch. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the answer was deleted. |
| _resource_id | NUMBER(38,0) | Identifier of the resource associated with the workflow question. |
| _job_note_id | NUMBER(38,0) | Identifier of the job note associated with the workflow answer. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the workflow answer data was last refreshed. |