Announcement Role Title Category
The announcement role title category table provides a structured mapping of role titles for each announcement, similar to how the role and role title category relationship works.
The announcement table contains role titles in an unstructured format. By joining it with this mapping table, users can translate those titles into structured role title categories.
A single announcement can correspond to multiple role title categories. For example, if an announcement states that someone is starting as CEO and President in 2026, this mapping table will capture two separate structured entities - one for CEO and one for President.
Purpose of this table: If a user wants to identify how many CEOs are starting in 2026, they must join the announcement table with this mapping table and filter on the role title category 'CEO'. The same logic applies for finding how many Presidents are starting that year. This mirrors the use case of joining the role table with the role title category table for structured analysis.
Data Field | Key Type | Data Field Type | Recommended Character Limit |
|---|---|---|---|
announcement_role_title_category_id | Primary Key | String | |
announcement_id | Primary Key | String |
|
announcement_role_title_category_value | | String |
|
announcement_role_title_category_value_prefix | | String |
|
announcement_role_group | | String | |
announcement_role_type | | String | |
announcement_role_group_id | Foreign Key | String | |
Announcement Role Title Category Field Descriptions
announcement_role_title_category_id (PK) A Unique key that links the role title category to a specific announcement.
The Role Title Category table offers structured insights into an individual's title by grouping similar or equivalent titles under standardized categories. This enables users to identify, filter, and select titles and functions that align with their specific criteria.
For example, the role title category 'CEO' may encompass various title variations such as 'Chief Executive' and 'CEO', grouping them under a single, unified category for easier analysis and reporting.
announcement_id (PK) A Unique key that links each role title category entry to its corresponding announcement.
A single announcement_id can be associated with multiple announcement_role_title_category_id valys, reflecting the presence of multiple role title categories within one announcement.
This key serves as the join between the announcement table and announcement role title category table.
announcement_role_title_category_value Categorizes a role title based on its function, such as job-related or board-related roles. For example: Chairman, CEO.
announcement_role_title_category_value_prefix A title prefix that appears before the main title to indicate seniority. Examples: Vice, Assistant, Deputy.
announcement_role_group Categorizes the group or committee within the organization that the individual is associated with. Examples: Board of Directors, Audit Committee.
announcement_role_type
This is the type of the new announced role. The role type consists of 6 categories: Board Function, Board/Committee Type, Committee Function, Government Function, Job Function, Membership.
announcement_role_group_id
Unique ID associated to the role group of the role title category. A role group is a categorization of the organization group or body that the person's role is associated to. Role group data comes to Altrata as is from its sources. Example: Board of Directors, Audit Committee.