Role

role table provides data attributes associated with employment, board and committee roles held by people within the altrata data universe data field key type data field type recommended character limit role id primary key string person id foreign key string organization id foreign key string role title string role start date date 10 role end date date 10 role current prior status string role type string role email primary string months in role bigint months with org bigint role field descriptions role id (pk) unique id given to each role in the database these ids can be mapped to other entity ids within altrata example 1 rol 21546034 person id (fk) 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 organization id (fk) unique id assigned to the altrata organization these ids enable consistent mapping to other entity ids within altrata example 1 org 14994 – sun microsystems, inc role title the employment title associated to the person’s employment or board role as reported from our source example vice president sales & marketing wood products role start date start date year, month, and day example 1992 01 02 role end date end date year, month, and day example 1992 01 02 role current prior status indicates if the role is current or prior (historic) role type denotes type of role function; board function, committee function, job function, government function example job function role email primary primary and current professional email address months in role this refers to the calculated duration, in months, that an individual has spent in a specific role months with org this refers to the calculated the total duration, in months, that an individual has been associated with an organization this includes all roles and appointments, such as board level, executive, management, and advisory positions