Purpose
The Person CDP contains the human identities DataBee has identified within an organization, such as employees and contractors. It is the subset of the User CDP whose user type is Person, and is the best starting point for questions about the workforce, such as headcount, managers, and organizational hierarchy.
Entity Correlation
The Entity Correlator identifies and differentiates persons using these fields, in order of priority: Employee UID, then Email Address. Each person receives its own DataBee user ID, separate from the IDs of the accounts that belong to them.
For more on how persons and accounts are resolved, see Asset and Entity Resolution.
Schema
Caption | Name | Requirement | Type | Description |
|---|---|---|---|---|
Active | active | optional | boolean_t | Indicates whether this row is the current record for the person. Only the most recent row for each ID that has no end_time is TRUE; when an attribute changes, a new row is added and earlier rows are set to FALSE. |
Created Time | created_time | optional | timestamp_t | User.created_time: The timestamp when the user was created in the system. Useful for tracking user lifecycle and onboarding events. Synonyms: creation date, onboarding time. |
LDAP Person Email Addresses | email_addrs | optional | string_t Array | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.email_addrs: A list of additional email addresses for the user. |
LDAP Person Employee ID | employee_uid | optional | string_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.employee_uid: The unique identifier for an employee, often used for linking and integration with HR systems. This is often different and distinct from the user's email address and user principal name (UPN). For example: E12345. |
End Time | end_time | optional | timestamp_t | User.end_time: The end time of when a particular entity state was valid. Using start_time and end_time together bounds the time when a particular entity state was valid. If there is no end_time, this is the current state of the entity as DataBee understands it. |
Full Name | full_name | optional | string_t | User.full_name: The full name of the user, as reported by the product. |
LDAP Person Given Name | given_name | optional | string_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.given_name: The given or first name of the user. |
Group Names | group_names | optional | string_t Array | User.groups: The administrative groups to which the user belongs. Group.name: The group name. |
History ID | hid | optional | integer_t | User.hid: The unique DataBee ID to identify a particular history entry or row in an entity table (i.e., user, device or product table). This field is the primary key and should not be mapped manually as the DataBee product populates this field itself. |
LDAP Person Hire Time | hire_time | optional | timestamp_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.hire_time: The timestamp when the user was or will be hired by the organization. |
ID | id | required | integer_t | User.id: The unique identifier used by DataBee for a specific person. This is the primary key for the Person table and is referenced as user_id in activity and event tables to link to this person. Synonyms: user_id. |
LDAP Person Job Title | job_title | optional | string_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.job_title: The user's job title. |
LDAP Person Leave Time | leave_time | optional | timestamp_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.leave_time: The timestamp when the user left or will be leaving the organization. |
LDAP Person Geo Location City | location_city | optional | string_t | User.ldap_person.location: The geographical location associated with a user, typically the user's usual work location. Location.city: The name of the city. For example: San Diego. |
LDAP Person Geo Location Country | location_country | optional | string_t | User.ldap_person.location: The geographical location associated with a user, typically the user's usual work location. Location.country: The ISO 3166-1 Alpha-2 country code. For example: US. |
LDAP Person Geo Location Postal Code | location_postal_code | optional | string_t | User.ldap_person.location: The geographical location associated with a user, typically the user's usual work location. Location.postal_code: The postal code of the location. For example: 12345. |
LDAP Person Geo Location Region | location_region | optional | string_t | User.ldap_person.location: The geographical location associated with a user, typically the user's usual work location. Location.region: The ISO 3166-2 code for the principal subdivision of the country, such as a state or province. For example: CA. |
LDAP Person Geo Location Latitude | location_latitude | optional | float_t | User.ldap_person.location: The geographical location associated with a user, typically the user's usual work location. Location.lat: The latitude coordinate in decimal degrees. For example: 42.361145. |
LDAP Person Geo Location Longitude | location_longitude | optional | float_t | User.ldap_person.location: The geographical location associated with a user, typically the user's usual work location. Location.long: The longitude coordinate in decimal degrees. For example: -71.057083. |
LDAP Person Manager | manager_id | optional | integer_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.manager: The DataBee user ID of the person's manager. Joins to id in this table and helps in understanding the org hierarchy. |
Modified Time | modified_time | optional | timestamp_t | User.modified_time: The timestamp when the user entry was last modified. Useful for tracking changes to user attributes or status. Synonyms: last modified, update time. |
LDAP Person Office Location | office_location | optional | string_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.office_location: The primary office location associated with the user. This could be any string and isn't a specific address. For example, |
Organization Name | org_name | optional | string_t | User.org: Organization and org unit related to the user. Organization.name: The name of the organization, Oracle Cloud Tenancy, Google Cloud Organization, or AWS Organization. For example, |
Organization Org Unit Name | org_ou_name | optional | string_t | User.org: Organization and org unit related to the user. Organization.ou_name: The name of an organizational unit, Google Cloud Folder, or AWS Org Unit. For example, the |
Record Created At | record_created_at | required | timestamp_t | CDPs generated timestamp when record was created. |
Record Updated At | record_updated_at | required | timestamp_t | CDPs generated timestamp when record was last updated. |
Data Sources | sources | recommended | string_t Array | User.backtrace: This object is a key value set that relates each field in the user to the earliest raw event that gave DataBee that particular value in the correlation. For example, |
Start Time | start_time | optional | timestamp_t | User.start_time: The start time when a particular state of the user became valid |
LDAP Person Surname | surname | optional | string_t | User.ldap_person: The additional LDAP attributes that describe a person. LdapPerson.surname: The last or family name for the user. |
Type | type | optional | string_t | User.type: The type of the user. In this table, always Person. |
Type ID | type_id | recommended | integer_t | User.type_id: The user type identifier. In this table, always 98 (Person). |