settlement

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

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/settlement.parquet', Lineage.fiboModule = 'FBC', Lineage.fiboConcept = 'Settlement', Lineage.datasetTitle = 'Settlements'}
// Records of trade settlement — exchange of cash and securities on the contractual settlement date.
Class fibo::fbc::Settlement
{
    // SettlementIdentifier: Internal surrogate key for a settlement record.
    settlementId : Integer[1];
    // TradeIdentifier: Internal surrogate key for a booked trade.
    tradeId : Integer[1];
    // SettlementDate: Date on which cash and securities exchange hands to complete a trade (commonly T+1 or T+2 for equities).
    settlementDate : StrictDate[1];
    // SettlementStatus: Lifecycle state of a settlement (pending, settled, failed, cancelled).
    status : String[1];
    // Custodian: A bank or financial institution that holds client securities and cash for safekeeping and settles trades on the client\'s behalf.
    custodianLei : String[0..1];
    // Quantity: Number of units (shares, contracts, face value) held or traded.
    settledQuantity : Decimal[0..1];
    // NetAmount: Gross amount adjusted for commissions and fees — the cash that actually moves between accounts.
    settledAmount : Decimal[0..1];
    // ISO4217CurrencyCode: Three-letter code (e.g., USD, EUR, JPY) that uniquely identifies a currency under ISO 4217.
    settledCurrency : String[0..1];
}

    // parquet: out/parquet/settlement.parquet
    Table settlement (settlement_id INT PRIMARY KEY, trade_id INT, settlement_date DATE, status VARCHAR(255), custodian_lei VARCHAR(255), settled_quantity DECIMAL(20,6), settled_amount DECIMAL(20,4), settled_currency VARCHAR(255))

    fibo::fbc::Settlement : Relational
    {
        ~mainTable [FiboParquet]settlement
        settlementId : [FiboParquet]settlement.settlement_id,
        tradeId : [FiboParquet]settlement.trade_id,
        settlementDate : [FiboParquet]settlement.settlement_date,
        status : [FiboParquet]settlement.status,
        custodianLei : [FiboParquet]settlement.custodian_lei,
        settledQuantity : [FiboParquet]settlement.settled_quantity,
        settledAmount : [FiboParquet]settlement.settled_amount,
        settledCurrency : [FiboParquet]settlement.settled_currency
    }

// 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'
)