Note that this table contains data about agents as well as users.
| Field Name |
Data Type |
| can_admin |
boolean |
| can_agent |
boolean |
| can_billing |
boolean |
| can_reports |
boolean |
| creation_system |
string |
| date_created |
datetime |
| date_last_login |
datetime |
| date_picture_check |
datetime |
| disable_autoresponses |
boolean |
| first_name |
string |
| gravatar_url |
string |
| id |
number |
| importance |
number |
| is_agent |
boolean |
| is_agent_confirmed |
boolean |
| is_confirmed |
boolean |
| is_contact |
boolean |
| is_deleted |
boolean |
| is_disabled |
boolean |
| is_user |
boolean |
| is_vacation_mode |
boolean |
| language_id |
number |
| last_name |
string |
| name |
string |
| organization_id |
number |
| organization_manager |
boolean |
| organization_position |
string |
| override_display_name |
string |
| picture_blob_id |
number |
| primary_email_id |
number |
| summary |
string |
| timezone |
string |
| title_prefix |
string |
| was_agent |
boolean |
| contact_data |
Person Contact Data |
| custom_data |
Custom Data Person |
| custom_data[#] |
Custom Data Person(data for person field with ID #) |
| emails |
Person Email |
| labels |
Label Person |
| language |
Language |
| organization |
Organization |
| picture_blob |
Blob |
| preferences |
Person Pref |
| primary_email |
Person Email |
| usersource_assoc |
Person Usersource Assoc |
| Field Name |
Data Type |
| data |
string |
| date_created |
datetime |
| id |
number |
| identity |
string |
| identity_friendly |
string |
| person_id |
number |
| usersource_id |
number |
| person |
Person |
| usersource |
Usersource |
| Field Name |
Data Type |
| auth |
string |
| date_created |
datetime |
| email |
string |
| id |
number |
| person_id |
number |
| validating_content |
string |
| person |
Person |
| Field Name |
Data Type |
| comment |
string |
| contact_type |
string |
| field_1 |
string |
| field_2 |
string |
| field_3 |
string |
| field_4 |
string |
| field_5 |
string |
| field_6 |
string |
| field_7 |
string |
| field_8 |
string |
| field_9 |
string |
| field_10 |
string |
| id |
number |
| person_id |
number |
| person |
Person |
| Field Name |
Data Type |
| comment |
string |
| date_created |
datetime |
| date_validated |
datetime |
| email |
string |
| email_domain |
string |
| id |
number |
| is_validated |
boolean |
| person_id |
number |
| person |
Person |
| Field Name |
Data Type |
| date_expire |
datetime |
| name |
string |
| person_id |
number |
| value_array |
string |
| value_str |
string |
| person |
Person |
Please log in or register to submit a comment.