Role

the 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 is executive director boolean is non executive director boolean is part of leadership team boolean is other employee boolean 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 is executive director a company employee who is also on the board of directors and is responsible for the company's day to day management they hold both an executive role, often managing a specific department or division, and a directorial one, contributing to strategic decisions and reporting to the board is non executive director a company employee who is also on the board of directors but is not responsible for any of the company's day to day management they only hold a directorial role, contributing to strategic decisions and reporting to the board is part of leadership team a company employee who is part of a group of top level executives and managers—such as c suite officers (executive directors) and vps—responsible for directing company strategy, making major decisions, and driving business success is other employee a category used to classify roles that do not fall under specific executive, directorial, or leadership titles