Role Summary

role summary table provides a person's time in years by role type board, employment or government at a company it groups multiple role titles from the role table to provide a summary role with earliest and latest date among roles within role type data field key type data field type recommended character limit person id pk, fk string organization id pk,fk string role summary primary role id fk string role summary start date date 10 role summary end date date 10 role summary status string role summary years with org string role summary role type pk string role summary field descriptions 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 summary primary role id (fk) primary role for a person within a role type role summary start date start date year, month, and day example 1992 01 02 role summary end date end date year, month, and day example 1992 01 02 role summary status indicates if the role is current or prior (historic) role summary years with org indicates number of years at specific organization between same role type showing difference between earliest and latest date role summary role type (pk) denotes type of role function; board function (including committees), job function, government function example job function