Data Dictionaries
...
Core Data
Role
2 min
role table provides data attributes associated with employment, board and committee roles held by people within the altrata data universe true 225,126 00189574276493,131 41358464388506,179 58451961335004left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type left 1 1 unhandled content type 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

