Person
The person table incudes key biographic attributes for people within the Altrata universe.
Data Field | Key Type | Data Field Type | 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) 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 In order the year, month, and day that person was born. Example: 1981-06-15 (Lindsay Lawrence)
date_of_death In order the year, month, and day that person died. Example: 2011-10-05 (Steve Jobs)
is_deceased 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 Value is provided as Male or Female, when available. Example: Female
person_name A person’s disclosed full name is displayed. Example: Satya Nadella
first_name A person’s disclosed first name is displayed. Example: Satya
last_name A person’s disclosed last name is displayed. Example: Nadella
middle_name A person’s disclosed middle name is placed between the first and last names, were available. Example: Satya Narayana Nadella
salutation Title before a person’s name. Example: Mrs.
suffix Follows a person’s full name and provides additional information about the person. Example: Jr, Jr
linked_in_primary The LinkedIn URL of the person.
person_primary_role_id Most notable role within a person’s profile, based on seniority and recency.
age Persons current age
person_executive_summary Brief description of persons employment and education history
earning_indicator_description Profile ranking based on person’s career progression and associated earning potential categorised by four tiers. Developing - Early Career Professionals Established - Senior Associates, Middle Management High Achiever - Upper Management, Experienced Elite - Top tier & industry experts, C- Suite.
personal_email_primary Primary and current personal email address.
birthplace_city Filters by a city that a person is born in.
birthplace_state Filters by a state that a person is born in.
birthplace_country Filters by a country that a person is born in.
relationship_status Filters 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.