person_custom_fields_v1
Person custom fields are used to create additional fields which are not present by default on a person.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(32) | The unique identifier of the custom field. |
| label | VARCHAR(200) | The name of the custom field. |
| value | VARCHAR(16384) | The value of the custom field. |
| is_default_value | VARCHAR(3) | Indicates if the value of the custom field was set by 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. |
| _person_id | VARCHAR(256) | The identifier of the person. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the custom field value was last refreshed. |