Announcement Role Title Category

announcement role title category this 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 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