Role Title Category
The role title category table provides additional insight into the title of a person. This table allows users to identify, filter, and select the titles and functions that meet their unique requirements. For example, the role title category field allows similar titles (i.e. Chief Executive, CEO) to be grouped under an umbrella category of CEO.
Data Field | Key Type | Data Field Type | Recommended Character Limit |
|---|---|---|---|
role_title_category_id | Primary Key | String | |
role_id | Foreign Key | String | |
role_title_category_value |
| String | |
role_title_category_value_prefix | | String | |
role_department | | String | |
role_group | | String | |
role_type | | String | |
role_group_id | Foreign Key | String | |
Role Title Category Field Descriptions
role_title_category_id (PK) Unique ID associated to the role title categories within a person’s role. Example: 1-rtc-21546034
role_id (FK) Unique ID associated to the role held by the person. Example: 1-rol-21546034
role_title_category_value Categorizes a role title by its job or board function. Example: Chairman, CEO
role_title_category_value_prefix A title pre-fix appears in front of the title and indicates seniority. Example: Vice, Assistant, Deputy
role_department
The functional department or organizational area a role belongs to, based on its main responsibilities (including business lines and support functions). There are over 300 roles departments in Altrata.
role_group Categorization of the organization group or body that the person is associated to. Example: Board of Directors, Audit Committee
role_type
This describes the role type based on 6 categories: Board Function, Board/Committee Type, Committee Function, Government Function, Job Function, Membership.
role_group_id (FK) Unique ID associated to the role group. A role group is a categorization of the organization group or body that the person's role is associated to. This data comes to Altrata as is from its sources. Example: Board of Directors, Audit Committee.