Organization

organization table incudes key attributes for companies within the altrata universe see below for a visual representation of the attributes data field key type data field type recommended character limit organization id primary key string date extinct date 10 date founded date 10 email domain string website string organization name string organization alternate name string ticker primary string head office address string head office country string head office zip string head office state string head office city string organization type string sector primary string industry primary string ultimate parent id foreign key string ultimate parent name string political party string organization charitable cause primary string organization field descriptions organization id (pk) unique id assigned to the altrata organization these ids enable consistent mapping to other entity ids within altrata example 1 org 14994 – sun microsystems, inc date extinct date year, month, and day when the organization ceases to exist example 2009 04 01 – sun microsystems, inc date founded date year, month, and day when the organization was established example 2009 04 01 – sun microsystems, inc email domain the email domain that is associated with the organization example @microsoft com website the website associated with the organization example http //www idealab com organization name the full organization display name example meta organization alternate name alternate name of the organization, a name used by an organization instead of or in addition to the organization's legal name example meta platforms inc ticker primary stock ticker symbols associated to official stock exchange listings of the organization example meta head office address business address, the primary office address of an organization or company example 130 west union street, pasadena, ca, 91103 head office country the country where the head office of a company is located example 130 west union street, pasadena, ca, 91103 head office zip the zip code of the organization’s head office example 91103 head office state the state of the organization’s head office example california head office city the city of the organization’s head office example pasadena organization type denotes the nature or type of business example public, private, charity sector primary company sector information associated to the organization example investment banking & brokerage, it consulting & services, computer software industry primary a more granular industry vertical associated to the organization example banking & finance, business & consumer services, technology ultimate parent id (fk) the unique id of ultimate parent company the topmost company within the hierarchy of the organization example 1203740 – kkr & co , inc ultimate parent name the name of ultimate parent company the topmost company within the hierarchy of the organization example elbit systems ltd political party the name of a political party a donation is given to organization charitable cause primary