subscription

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

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/subscription.parquet', Lineage.fiboModule = 'FBC', Lineage.fiboConcept = 'FundSubscription', Lineage.datasetTitle = 'Fund Subscriptions and Redemptions'}
// Investor capital movements into or out of a fund, recording amount, units, and NAV per unit.
Class fibo::fbc::FundSubscription
{
    // SubscriptionIdentifier: Internal surrogate key for a fund subscription or redemption record.
    subscriptionId : Integer[1];
    // InvestorIdentifier: Internal surrogate key uniquely identifying an investor within this system.
    investorId : Integer[1];
    // FundIdentifier: Internal surrogate key uniquely identifying a fund within this system.
    fundId : Integer[1];
    // TradeDate: Date on which a trade was executed.
    tradeDate : StrictDate[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];
    // TransactionType: Kind of ledger entry (TRADE_BUY, TRADE_SELL, DIVIDEND, INTEREST, FEE_BROKER, FEE_MGMT, FX, SUBSCRIPTION, REDEMPTION, CORPORATE_ACTION).
    transactionType : String[1];
    // GrossAmount: Trade quantity × price, before commissions and fees.
    amount : Decimal[1];
    // ISO4217CurrencyCode: Three-letter code (e.g., USD, EUR, JPY) that uniquely identifies a currency under ISO 4217.
    currencyCode : String[1];
    // Units: The shares or units of ownership a fund issues to its investors. NAV per unit is the value of one unit.
    units : Decimal[1];
    // NAVPerUnit: Net Asset Value divided by units outstanding — the value attributable to each fund unit.
    navPerUnit : Decimal[1];
}

    // parquet: out/parquet/subscription.parquet
    Table subscription (subscription_id INT PRIMARY KEY, investor_id INT, fund_id INT, trade_date DATE, settlement_date DATE, transaction_type VARCHAR(255), amount DECIMAL(20,4), currency_code VARCHAR(255), units DECIMAL(20,6), nav_per_unit DECIMAL(20,6))

    fibo::fbc::FundSubscription : Relational
    {
        ~mainTable [FiboParquet]subscription
        subscriptionId : [FiboParquet]subscription.subscription_id,
        investorId : [FiboParquet]subscription.investor_id,
        fundId : [FiboParquet]subscription.fund_id,
        tradeDate : [FiboParquet]subscription.trade_date,
        settlementDate : [FiboParquet]subscription.settlement_date,
        transactionType : [FiboParquet]subscription.transaction_type,
        amount : [FiboParquet]subscription.amount,
        currencyCode : [FiboParquet]subscription.currency_code,
        units : [FiboParquet]subscription.units,
        navPerUnit : [FiboParquet]subscription.nav_per_unit
    }

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