SEC Holding Filing Attributes

Snowflake table name : CYBERSYN.SEC_HOLDING_FILING_ATTRIBUTES

View data sources, attributes, and sample queries here.

Name	Description	Type	Example
ADSH	Unique accession number for the filing. Can be used to join to the sec_holding_filing_index table.	VARCHAR	0001415889-20-002491
HOLDER_CIK	Central Index Key (CIK) of the holding manager.	VARCHAR	0000932974
SECURITY_NAME	Name of the security or of the issuer of the security.	VARCHAR	JUNIPER NETWORKS INC
TOP_LEVEL_OPENFIGI_ID	OpenFIGI ID of the highest, most widely encompassing level for a particular security. The hierarchy follows the order "share class FIGI" (global) > "composite FIGI" (country-level) > "FIGI" (exchange-level).	VARCHAR	BBG001SCTT05
TOP_LEVEL_OPENFIGI_ID_TYPE	The highest level of the OpenFIGI ID in the hierarchy for the security held. The hierarchy follows the order "share class FIGI" (global) > "composite FIGI" (country-level) > "FIGI" (exchange-level). For example, if the highest level of ID (recorded in TOP_LEVEL_OPENFIGI_ID) is the composite FIGI, then this will be equal to 'openfigi_composite_id'.	VARCHAR	openfigi_share_class_id
PRIMARY_TICKER	The ticker for the primary trading venue of a security. If a security trades on multiple exchanges or has numerous tickers, an attempt is made to select the ticker from the home market.	VARCHAR	MUB
ASSET_CLASS	Broad-based class of the asset, such as 'Equity', 'Muni', etc.	VARCHAR	Equity
SECURITY_TYPE	The type of security, such as "Common Stock" for equities. Securities can fall into multiple categories such as when a company has both tradable shares of Common Stock and an ADR.	VARCHAR	ETP
MARKET_VALUE	Market value of the security held in USD.	NUMBER	13102000
NUMBER_OF_SHARES	Number of shares held. When NULL, the principal amount was disclosed instead, and can be found in the principal_amount column.	NUMBER	20382
PRINCIPAL_AMOUNT	The principal amount held. When NULL, the number of shares was disclosed instead, and can be found in the number_of_shares column.	NUMBER	121000
PUTCALL	One of Put, Call, or NULL. When disclosed as Put or Call, the security is held as a put option or call option, respectively.	VARCHAR	Put
INVESTMENT_DISCRETION	One of shared-defined, sole, or shared-other. Denotes the nature of the investment discretion for this holding by the filing manager.	VARCHAR	Shared-Defined
OPENFIGI_SHARE_CLASS_ID	The global share class FIGI ID(s) for the security. This is meant to be the most broad classification in the FIGI classification hierarchy.	ARRAY	[ "BBG00441QMK5" ]
OPENFIGI_COMPOSITE_ID	Array of the country-level composite FIGI ID(s) for the security. In cases where there is a share class FIGI (global ID) and the security is tradable in more than one country there may be multiple composite IDs associated with a single security.	ARRAY	[ "BBG007KC7PB0", "BBG00CW7Q726", "BBG00D0R72Y2", "BBG00...
OPENFIGI_FIGI_ID	Array of the FIGI (Financial Instrument Global Identifier) ID(s) for the security. In cases where there is a share class FIGI (global ID) or composite FIGI (country-level ID) becase a security trades across multiple countries or exchanges, there may be multiple FIGI IDs associated with a single security.	ARRAY	[ "BBG000BWCNN7", "BBG000BWCNT1", "BBG000BWCPT6", "BBG00...
PERMID_SECURITY_ID	PermID for the security.	VARCHAR	21609251256