Organization Index

the organization index table provides information about organization indices the term "organization index" here refers to the stock market index that measures the performance of a specific collection of major, publicly traded companies data field key type data field type recommended character limit organization index id primary key string organization id string index name string index abbreviated name string index status string index start date date 10 index end date date 10 index country string organization index field descriptions organization index id (pk) this is the primary key for the table, i e , it uniquely identifies each record in the table organization id 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 index name this attribute provides the name of the stock index the organization is part of a stock index is a statistical measure that tracks the performance of a group of selected stocks within a stock exchange for example, the nasdaq is a stock exchange (home to over 2500 stocks), while the nasdaq 100 is a specific index within it, tracking the performance of the 100 largest non financial companies list on that exchange, heavily skewed towards technology and growth stocks like apple, microsoft, and amazon index abbreviated name this attribute provides the abbreviated name of the stock index the organization is part of this abbreviated name is usually referred to as a ticker symbol index status this describes the status of the organization being part of the stock index as current or prior index start date this is the date for when the organization became part of the index index end date this is the date for when the organization stopped being part of the index index country this attribute provides the name of the country the index is in