order

S3 / causeway-data / dev / main / fibo / order

Auto-generated from fibo-data-gen/pure/ — column-level lineage from the FIBO-grounded class to its physical store. Structured mappings point at parquet columns; Object mappings point at object-storage paths for audio, video, documents, and transcripts.

// AUTO-GENERATED by generators/pure_export.py — do not edit by hand.
// Source: metadata/datasets/*.json

###Pure

Profile fibo::Lineage
{
    stereotypes: [parquetBacked, objectBacked];
    tags: [parquetPath, fiboModule, fiboConcept, datasetTitle, glossaryTerm, objectPath, mediaTypes];
}

<<Lineage.parquetBacked>>
{Lineage.parquetPath = 'out/parquet/order/**/*.parquet', Lineage.fiboModule = 'FBC', Lineage.fiboConcept = 'Order', Lineage.datasetTitle = 'Orders'}
// Investment instructions submitted to brokers or venues — buy/sell side, quantity, price terms, time in force, status.
Class fibo::fbc::Order
{
    // OrderIdentifier: Internal surrogate key for an order.
    orderId : Integer[1];
    // ParentOrder: An aggregate order from which child orders are split for execution (e.g., to slice a large block over time).
    parentOrderId : Integer[0..1];
    // FundIdentifier: Internal surrogate key uniquely identifying a fund within this system.
    fundId : Integer[1];
    // InstrumentSurrogateID: Internal surrogate key uniquely identifying a financial instrument within this system. External identifiers (ISIN, CUSIP, FIGI) live in instrument_identifier.
    instrumentId : Integer[1];
    // OrderSide: Direction of the order (buy, sell, short sell, cover).
    side : String[1];
    // OrderType: How an order is to be matched: market (immediate at best price), limit (at or better than a specified price), stop, stop-limit.
    orderType : String[1];
    // Quantity: Number of units (shares, contracts, face value) held or traded.
    quantity : Decimal[1];
    // Strike: The price at which an option holder can exercise the right to buy or sell the underlying.
    limitPrice : Decimal[0..1];
    // TimeInForce: How long an order remains active before cancellation (DAY, GTC = good-till-cancelled, IOC = immediate-or-cancel, FOK = fill-or-kill).
    timeInForce : String[1];
    // AsOfDate: The business date as of which a snapshot was taken (positions, prices, NAV, etc.).
    orderDate : StrictDate[1];
    // AsOfDate: The business date as of which a snapshot was taken (positions, prices, NAV, etc.).
    orderTimestamp : DateTime[1];
    // OrderStatus: Lifecycle state of an order (new, partially filled, filled, cancelled, rejected).
    status : String[1];
    // PortfolioManager: Person who decides which orders to place to implement a strategy.
    pmId : String[0..1];
    // Trader: Person responsible for executing orders on behalf of a portfolio manager.
    traderId : String[0..1];
}

    // parquet: out/parquet/order/**/*.parquet
    Table order (order_id INT PRIMARY KEY, parent_order_id INT, fund_id INT, instrument_id INT, side VARCHAR(255), order_type VARCHAR(255), quantity DECIMAL(20,6), limit_price DECIMAL(28,10), time_in_force VARCHAR(255), order_date DATE, order_timestamp TIMESTAMP, status VARCHAR(255), pm_id VARCHAR(255), trader_id VARCHAR(255))

    fibo::fbc::Order : Relational
    {
        ~mainTable [FiboParquet]order
        orderId : [FiboParquet]order.order_id,
        parentOrderId : [FiboParquet]order.parent_order_id,
        fundId : [FiboParquet]order.fund_id,
        instrumentId : [FiboParquet]order.instrument_id,
        side : [FiboParquet]order.side,
        orderType : [FiboParquet]order.order_type,
        quantity : [FiboParquet]order.quantity,
        limitPrice : [FiboParquet]order.limit_price,
        timeInForce : [FiboParquet]order.time_in_force,
        orderDate : [FiboParquet]order.order_date,
        orderTimestamp : [FiboParquet]order.order_timestamp,
        status : [FiboParquet]order.status,
        pmId : [FiboParquet]order.pm_id,
        traderId : [FiboParquet]order.trader_id
    }

// AUTO-GENERATED by generators/pure_export.py — do not edit by hand.

Store store::object::CausewayObjectStore
(
  backend: S3
  bucket:  'causeway-data'
  region:  'us-east-1'
)