Announcement

the announcement 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)