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 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