---
title: Role
slug: role
createdAt: 2025-06-11T20:48:30.220Z
---

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\_city                     |                    | String              |                                 |
| role\_state                    |                    | String              |                                 |
| role\_country                  |                    | String              |                                 |
| role\_latitude                 |                    | Decimal             |                                 |
| role\_longitude                |                    | Decimal             |                                 |

### 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.

**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