Instrument Security Master Schemas

Instrument Description Reference and Shares Outstanding

OQD_SEC

Database includes the following Tables:

• DES - Static data, e.g. ISIN, description, security type

• SHO - Shares Outstanding

OQD_SEC - DES

Static data, e.g. ISIN, description, security type

OQD_SEC - DES Table Schema

Field	Data Type	Description
SYMBOL_NAME	string	Symbol Name (Exchange Symbol for Equities & ETFs, and Starting with Exchange Product Code for Derivative Markets followed by expiry and strike as appropriate)
TIMESTAMP	nsectime	Event Timestamp (typically at a nano-second resolution)
OID	string[14]	OneMarketData ID
END_DATE	msectime	Calendar Event End Date, or Last Valid Date
COUNTRY	string[3]	ISO Country Code
EXCH	string[10]	Exchange from which the update originates (Country Code + [MIC or PRIM for Primary, or COMP for Composite])
NAME	string[30]	Description of the instrument
ISSUE_DESC	string[30]	Security Description
ISSUE_CLASS	string[30]	Broadest Security Classification
ISSUE_TYPE	string[30]	Detailed Security Type Code
ISSUE_STATUS	string[30]	Security Status
SIC_CODE	string[4]	Standard Industrial Classfication Code
IDSYM	string[10]	Standard Identifier (CUSIP for US/Canada, otherwise SEDOL)
TICKER	string[30]	Ticker symbol, as specified by the data source
CALENDAR	string[30]	Associated Calendar
DELETED_TIME	msectime	Internal OneTick field. Usually null unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS).
TICK_STATUS	int	Internal OneTick field. Always 0 unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS).
OMDSEQ	uint	Sequence number allowing ticks of different types at the same timestamp to be sorted into the correct chronological order. e.g. if a trade and a quote have the same timestamp, the one with the lower value of OMDSEQ arrived first.

OQD_SEC - SHO

Shares Outstanding

OQD_SEC - SHO Table Schema

Field	Data Type	Description
SYMBOL_NAME	string	Symbol Name (Exchange Symbol for Equities & ETFs, and Starting with Exchange Product Code for Derivative Markets followed by expiry and strike as appropriate)
TIMESTAMP	nsectime	Event Timestamp (typically at a nano-second resolution)
OID	string[14]	OneMarketData ID
END_DATE	msectime	Calendar Event End Date, or Last Valid Date
REPORT_MONTH	string[6]	The reporting month for shares outstanding
SHARES	double	Shares / quantity outstanding
DELETED_TIME	msectime	Internal OneTick field. Usually null unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS).
TICK_STATUS	int	Internal OneTick field. Always 0 unless hidden ticks are requested (e.g. SHOW_HIDDEN_TICKS).
OMDSEQ	uint	Sequence number allowing ticks of different types at the same timestamp to be sorted into the correct chronological order. e.g. if a trade and a quote have the same timestamp, the one with the lower value of OMDSEQ arrived first.