---
title: Person
slug: person
docTags: 
createdAt: 2025-06-11T20:46:45.625Z
---

The **person** table incudes key biographic attributes for people within the Altrata universe.&#x20;

| **Data Field &#xD;**<br />      | **Key Type &#xD;**<br /> | **Data Field Type&#x20;** | **Recommended Character Limit** |
| ------------------------------- | ------------------------ | ------------------------- | ------------------------------- |
| person\_id                      | Primary Key              | String                    |                                 |
| date\_of\_birth                 |                          | Date                      | 10                              |
| death\_of\_death                |                          | Date                      | 10                              |
| is\_deceased                    |                          | Boolean                   | 5                               |
| gender                          |                          | String                    |                                 |
| person\_name                    |                          | String                    |                                 |
| first\_name                     |                          | String                    |                                 |
| last\_name                      |                          | String                    |                                 |
| middle\_name                    |                          | String                    |                                 |
| salutation                      |                          | String                    |                                 |
| suffix                          |                          | String                    |                                 |
| linked\_in\_primary             |                          | String                    |                                 |
| person\_primary\_role\_id       | Foreign Key              | String                    |                                 |
| age                             |                          | Int                       |                                 |
| person\_executive\_summary      |                          | String                    |                                 |
| earning\_indicator\_description |                          | String                    |                                 |
| personal\_email\_primary        |                          | String                    |                                 |
| birthplace\_city                |                          | String                    |                                 |
| birthplace\_state               |                          | String                    |                                 |
| birthplace\_country             |                          | String                    |                                 |
| relationship\_status            |                          | String                    |                                 |
| nationality                     |                          | String                    |                                 |

### Person Field Descriptions

**person\_id (PK)**&#x20;                                                                                                                     Unique ID assigned to the Altrata Person. These IDs enable consistent  mapping to other entity IDs within Altrata. Example: 1-per-8690 is the person\_id Lindsay Lawrence

**date\_of\_birth                                                                                                                                                       &#x20;**&#x49;n order the year, month, and day that person was born. Example: 1981-06-15 (Lindsay Lawrence)

**date\_of\_death**&#x20;                                                                                                                             In order the year, month, and day that person died. Example: 2011-10-05 (Steve Jobs)

**is\_deceased**&#x20;                                                                                                                                            We record whether a person is deceased via a TRUE or FALSE value. If they are deceased, the value will be TRUE. Example: true (Steve Jobs)

**gender**&#x20;                                                                                                                                                                          Value is provided as Male or Female, when available. Example: Female

**person\_name**&#x20;                                                                                                                                   A person’s disclosed full name is displayed. Example: Satya Nadella

**first\_name**&#x20;                                                                                                                                       A person’s disclosed first name is displayed. Example: Satya

**last\_name**&#x20;                                                                                                                                      A person’s disclosed last name is displayed. Example: Nadella

**middle\_name**&#x20;                                                                                                                               A person’s disclosed middle name is placed between the first and last names, were available. Example: Satya Narayana Nadella

**salutation**&#x20;                                                                                                                                 Title before a person’s name. Example: Mrs.

**suffix**&#x20;                                                                                                                                    Follows a person’s full name and provides additional information about the person. Example: Jr, Jr

**linked\_in\_primary**&#x20;                                                                                                                    The LinkedIn URL of the person.

**person\_primary\_role\_id**&#x20;&#x20;                                                                                                        Most notable role within a person’s profile, based on seniority and recency.

**age**&#x20;                                                                                                                                            Persons current age

**person\_executive\_summary**&#x20;                                                                                                Brief description of persons employment and education history

**earning\_indicator\_description**&#x20;                                                                                          Profile ranking based on person’s career progression and associated earning potential categorised by four tiers.
&#x20;      Developing - Early Career Professionals
&#x20;      Established - Senior Associates, Middle Management
&#x20;      High Achiever - Upper Management, Experienced
&#x20;      Elite - Top tier & industry experts, C- Suite.

**personal\_email\_primary**&#x20;                                                                                                   Primary and current personal email address.

**birthplace\_city                                                                                                                                                 &#x20;**&#x46;ilters by a city that a person is born in.

**birthplace\_state                                                                                                                                                 &#x20;**&#x46;ilters by a state that a person is born in.

**birthplace\_country                                                                                                                                                 &#x20;**&#x46;ilters by a country that a person is born in.

**relationship\_status                                                                                                                                                 &#x20;**&#x46;ilters by the romantic relationship that a person has, such as married, single, windowed, etc..

**nationality**

The state of being a national of a certain political nation (country). This also includes citizenship.
