persons_v1
Persons are members of staff at a Contact who can receive information related to new jobs, notes, financial documents, or sales opportunities. They serve as recipients for tasks and notifications within the system.
| Column | Data type | Description |
|---|---|---|
| id | VARCHAR(256) | The unique identifier of the person. |
| contact_name | VARCHAR(256) | Name of the contact the person belongs to. |
| title | VARCHAR(40) | The title or salutation used to address a person. |
| first_name | VARCHAR(100) | The first name of the person. |
| last_name | VARCHAR(100) | The last name of the person. |
| VARCHAR(200) | The email address of the person. | |
| position | VARCHAR(80) | The job title or role of a person within an organisation. |
| department | VARCHAR(80) | The specific department or division in which a person works. |
| phone | VARCHAR(40) | The mobile phone number of the person. |
| landline | VARCHAR(40) | The landline number of the person. |
| landline_extension | VARCHAR(40) | An additional number or extension used to reach a person on a landline phone. |
| last_consent_status | VARCHAR(16) | The most recent status of consent given by a person, indicating their agreement or permission for certain activities or data processing. Possible values: 'Awaiting', 'Refused', 'Granted'. |
| last_consent_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when last consent status was changed. |
| is_opted_out_marketing | VARCHAR(3) | A field indicating whether a person has opted out of receiving marketing communications. |
| is_receiving_financial_documents | VARCHAR(3) | Specifies whether the person is the designated recipient for invoices or billing-related documents. |
| is_anonymised | VARCHAR(3) | A flag indicating whether the person's data has been anonymised or made anonymous to protect their identity or privacy. |
| is_main_contact_person | VARCHAR(3) | Indicates whether the person is the main or primary contact associated with a particular organisation. |
| created_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when person record was created. |
| deleted_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset when person record was deleted. |
| _contact_id | NUMBER(38,0) | The identifier of the contact that the person record belongs to. |
| _last_sync_at | TIMESTAMP_TZ(9) | The timestamp with time zone offset of when the quote record was last refreshed. |