Announcement

announcement this table captures all future role announcements, such as role start, role end and role change events each announcement includes details like the announcement date, the effective start or end date of the role, and the associated role title the structure of this table is modeled similarly to the role table to facilitate easier joins with other tables data field key type data field type recommended character limit announcement id primary key string person id string organization id string announcement date date 10 announcement type string announcement description string announcement role title string announcement effective date date 10 announcement role type string announcement field descriptions announcement id (pk) primary key associated with each announcement future role announcements these are defined as announcements regarding roles that are scheduled to start, end, or change in the future they are treated as events, and therefore, the model associates them with event related attributes role start announcements these events detail individuals who are expected to begin a new role at a future date role end announcements these events provide information about individuals anticipated to conclude a role in the future role change announcements these events provide information about individuals who are expected to transition from their current role to a new one within the same organization, with both chnages occurring within a 3 day window person id the person id represents the individual associated with the announcement event (i e , the person who is expected to start a new role) this can be joined with the person table to retrieve all related attributes of the individual organization id the organization id refers to the organization associated with the announcement event (i e , the organization where the individual is expected to start a new role) this can be joined with the organization table to retrieve all related attributes of the organization announcement date the date when the announcement was published announcement type defines the type of announcement (i e role start or role end) announcement description a descriptive summary of the announcement event intended for client facing communication for example 'sam altman starting as ceo at open ai' announcement role title the title of the role referenced in the announcement announcement effective date this field is populated based on the anticipated start or end date of the role, enabling support for future role announcements announcement role type specifies the category of the role in the announcement (e g , job function, board function) 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 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 to role mapping this table serves as a mapping between announcements and actual role records it represents the transition from a role announcement to a correponding role lifecycle event for example, an announcement like 'sam altman is leaving open ai in 2026' is initially captured as a role end event in the announcement table when 2026 arrives, the role table will reflect this change by updating sam's role with an end date of 2026 this mapping table connects the announcement to the corresponding role record, enabling a view of the full journey from announcement to actual role status change primary use case to determine how many current ceos are expected to leave in 2026, you can query the role table for active ceo roles and join it with this mapping table to check for any associated end announcements dated 2026 data field key type data field type recommended character limit announcement id primary key string start role id string end role id string announcement to role mapping field descriptions announcement id (pk) unique identifier for each announcement, serving as the primary key this key is used to join with the announcement table to retrieve detailed information related to the announcement start role id the role id of the corresponding role that is created when a role start announcement becomes effective this can be joined with the role table to retrieve detailed information about the corresponding role end role id the role id of the corresponding role that is created when a role end announcement becomes effective this can be joined with the role table to retrieve detailed information about the corresponding role