Role

The role table provides data attributes associated with employment, board and committee roles held by people within the Altrata data universe.



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.

role_city

The component of an address (a specific locality, town, or village), where the role of a person is based.

role_state

The component of an address (a state, or province), where the role of a person is based.

role_country

The component of an address, the country, where the role of a person is based.

role_latitude

The geographic latitude coordinate of the specific location where the person performs this role

role_longitude

The geographic longitude coordinate of the specific location where the person performs this role