account

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

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/account.parquet', Lineage.fiboModule = 'FBC', Lineage.fiboConcept = 'FinancialAccount', Lineage.datasetTitle = 'Financial Accounts'}
// Custody and cash accounts opened at custodians for each fund, keyed by currency.
Class fibo::fbc::FinancialAccount
{
    // AccountIdentifier: Internal surrogate key uniquely identifying an account within this system.
    accountId : Integer[1];
    // FundIdentifier: Internal surrogate key uniquely identifying a fund within this system.
    fundId : Integer[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];
    // AccountType: Functional kind of account: custody (holds securities), cash (holds money), margin (supports leveraged positions), prime brokerage.
    accountType : String[1];
    // ISO4217CurrencyCode: Three-letter code (e.g., USD, EUR, JPY) that uniquely identifies a currency under ISO 4217.
    currencyCode : 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).
    openedOn : StrictDate[1];
    // ValidToDate: The date a record\'s information stopped being effective. NULL means still in force.
    closedOn : StrictDate[0..1];
    // ExternalAccountNumber: Account number assigned by the custodian or external system for reconciliation.
    externalAccountNumber : String[0..1];
}

    // parquet: out/parquet/account.parquet
    Table account (account_id INT PRIMARY KEY, fund_id INT, custodian_lei VARCHAR(255), account_type VARCHAR(255), currency_code VARCHAR(255), opened_on DATE, closed_on DATE, external_account_number VARCHAR(255))

    fibo::fbc::FinancialAccount : Relational
    {
        ~mainTable [FiboParquet]account
        accountId : [FiboParquet]account.account_id,
        fundId : [FiboParquet]account.fund_id,
        custodianLei : [FiboParquet]account.custodian_lei,
        accountType : [FiboParquet]account.account_type,
        currencyCode : [FiboParquet]account.currency_code,
        openedOn : [FiboParquet]account.opened_on,
        closedOn : [FiboParquet]account.closed_on,
        externalAccountNumber : [FiboParquet]account.external_account_number
    }

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