Instrument Identifier

FIBO-grounded class definition for this concept: properties, multiplicities, and source-column annotations. Per-dataset Mapping and Table blocks live on each dataset's Pure Model tab.

<<Lineage.parquetBacked>>
{Lineage.parquetPath = 'out/parquet/instrument_identifier.parquet', Lineage.fiboModule = 'SEC', Lineage.fiboConcept = 'InstrumentIdentifier', Lineage.datasetTitle = 'Instrument Identifiers'}
// All external identifiers (ISIN, CUSIP, SEDOL, FIGI, ticker, OCC) assigned to each instrument, with point-in-time history.
Class fibo::sec::InstrumentIdentifier
{
    // InstrumentSurrogateID: Internal surrogate key uniquely identifying a financial instrument within this system. External identifiers (ISIN, CUSIP, FIGI) live in instrument_identifier.
    instrumentId : Integer[1];
    // IdentifierScheme: The naming system that defines how identifiers are formed and assigned (e.g., LEI, ISIN, CUSIP, FIGI).
    scheme : String[1];
    // InstrumentIdentifier: A code under a recognized scheme (ISIN, CUSIP, SEDOL, FIGI, ticker) that uniquely identifies a financial instrument.
    value : String[1];
    // ValidFromDate: The date a record\'s information became effective. Together with Valid To Date and Is Current, supports point-in-time history (slowly-changing dimension).
    validFrom : StrictDate[1];
    // ValidToDate: The date a record\'s information stopped being effective. NULL means still in force.
    validTo : StrictDate[0..1];
    // IsCurrent: Flag indicating whether a versioned record is the currently active version for its natural key.
    isCurrent : Boolean[1];
}