job_custom_fields_v1
Job custom fields are used to create additional fields which are not present by default on Job.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the job custom field. |
| label | VARCHAR(200) | The name of the custom field. |
| value | VARCHAR(524288) | The value of the custom field. |
| is_default_value | VARCHAR(3) | Indicates if the field value is default or input by the user. |
| type | VARCHAR(50) | Type of the custom field. Possible values: 'Yes/No', 'Whole Number', 'Decimal', 'Text', 'List', 'Statement', 'Date', 'Long Text', 'Time', 'System List'. |
| is_mandatory | VARCHAR(3) | Determines if the field value is mandatory. |
| field_order | NUMBER(38,0) | The integer value marking order of the field in UI. |
| _job_id | NUMBER(38,0) | The identifier of the job. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the custom field value was last refreshed. |