job_worksheet_answers_v1
'Job worksheet answers' refer to the responses or data collected through the digital questionnaires associated with a job.
| Column | Data type | Description |
|---|---|---|
| id | NUMBER(38,0) | The identifier of the worksheet answer. |
| worksheet_name | VARCHAR(100) | The name of the worksheet. |
| worksheet_group_name | VARCHAR(92) | The name of the worksheet group. |
| question_text | VARCHAR(2000) | Textual representation of the worksheet question. |
| answer_text | VARCHAR(4000) | Textual representation of the worksheet 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 worksheet answer. |
| quantity | NUMBER(38,0) | Quantity value associated with the cost type worksheet question. |
| net_amount | NUMBER(38,0) | Net amount value associated with the cost type worksheet question. |
| tax_amount | NUMBER(38,0) | Tax amount value associated with the cost type worksheet question. |
| gross_amount | NUMBER(38,0) | Gross amount value associated with the cost type worksheet question. |
| currency | VARCHAR(6) | Currency code associated with the cost type worksheet question. |
| answered_at | TIMESTAMP_TZ(9) | The timestamp with the timezone offset of when the worksheet question was answered. |
| question_type | VARCHAR(58) | The type of the worksheet 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 worksheet question is mandatory. |
| is_on_job_card | VARCHAR(3) | Indicates if the worksheet question appears on the job card. |
| question_order | NUMBER(38,0) | The integer value marking order of the question in the worksheet. |
| 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 worksheet question. |
| _job_id | NUMBER(38,0) | Identifier of the job associated with the worksheet answer. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the worksheet answer data was last refreshed. |