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