Data Dictionary
Data Dictionary
This data dictionary provides detailed definitions for every table and column in the data warehouse. Tables are listed alphabetically below — use the table of contents to jump to the one you need.
Tables
- Aggregate Fund Metrics
- Aggregate Investments
- Aggregate Investments History
- Allocations
- Capital Activities
- Capital Activity Partner Rows
- Capital Activity Row Journal Entries
- Company Financials
- Corporation Basic Info
- Corporation Basic Info V2
- Corporation Entity Links
- Corporation Entity Links V2
- Document Ai Document
- Document Ai Extraction
- Document Ai Spa
- Document Ai Spa Issuer
- Document Ai Spa Purchaser
- Document Ai Spa Series
- Financing History
- Fund Cohort Deployment Velocity
- Fund Corporation Ownership
- Fund Holdings Value
- Fund Ops Benchmarks V2
- Funds
- Holdings Value
- Irc409a Value
- Journal Entries
- Loan
- Monthly Nav Calculations
- Partner Data
- Partner Monthly Nav Calculations
- Portfolio Events
- Portfolio Notes
- Portfolio Valuations History
- Statement Of Ops
- Summary Cap Table
- Temporal Deal Irr
- Temporal Fund Cohort Benchmarks
- Waterfall Modeling History
Primary table containing fund-level metrics and characteristics. One row per fund with comprehensive performance, capital structure, and operational metrics. Pagination sort: fund_name, month_end_date DESC
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
vintage_date | DATE | Date of first capital call. Used to determine vintage year and age-based metrics |
vintage_year | NUMBER | Calendar year of first capital call, used for cohort analysis and benchmarking |
month_end_date | DATE | The last day of the month when NAV, Value, RVPI, and TVPI were calculated |
entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV, ...). |
firm_name | VARCHAR | Name of the investment firm. |
fund_size | NUMBER | Total committed capital across all LPs and GPs. Used for fund size cohort classification and as denominator for various metrics. |
fund_aum_bucket | VARCHAR | Size category for peer comparison based on fund_size (e.g., '100M-250M') |
fund_reporting_currency | VARCHAR | Currency denomination of the fund |
partner_transaction_source | VARCHAR | System of record identifier for partner transaction data (e.g., carta_gl, cats, partner_records) |
total_cost_of_investments | NUMBER | Aggregate cost basis of all investments made by the fund, including both active and exited positions |
total_investments_at_fair_value | NUMBER | Current fair market value of all remaining investments held by the fund, based on latest valuation marks |
total_unrealized_gain_loss | NUMBER | Aggregate unrealized gains or losses on current investment holdings (total_investments_at_fair_value - total_cost_of_investments) |
total_opx | NUMBER | Total operating expenses excluding management fees (legal, fund administration, etc.) |
total_mgmt_fees | NUMBER | Total management fees paid by all partners (total_gp_mgmt_fees + total_lp_mgmt_fees) |
cost_tax_prep_fees | NUMBER | Total tax preparation fees paid by the fund |
cash | NUMBER | Cash balance including (1000 - Bank, 1001 - outstanding checks, 1002 - Stablecoins, 1003 - Overnight Swap, 1004 - Money Market Funds, 1005 - Money Market Funds unrealized/gain loss, 1006 - Cash Margin, 1099 - Bank 1099able) |
cost_fa_fees | NUMBER | Total fees paid to the fund administrator |
cost_legal_fees | NUMBER | Total legal fees paid by the fund |
cost_filing_fees | NUMBER | Total filing fees paid by the fund |
cost_other_professional_fees | NUMBER | All other professional fees not associated with audit, tax prep, and legal. |
cost_organization_costs | NUMBER | All fees associated with organizing and creating the fund |
cost_insurance_expense | NUMBER | Costs associated with Directors and Officers (D&O) insurance |
cost_travel | NUMBER | Costs associated with travel expenses |
cost_syndication_costs | NUMBER | Syndications costs related to fundraising and placement agent |
cost_software_and_technology | NUMBER | Costs related to software, technology, and IT |
cost_dues_and_subscriptions | NUMBER | Costs associated with membership dues or subscriptions |
cost_meal | NUMBER | Costs associated with meal and entertainment expenses |
cost_market_expenses | NUMBER | Costs associated with marketing expenses |
cost_accounting_expense | NUMBER | Costs associated with accounting expenses |
cost_payroll_salary | NUMBER | Costs associated with payroll and salary expenses |
cost_events | NUMBER | Costs associated with events |
ending_total_nav | NUMBER | Ending Net Asset Value (NAV) for both GPs and LPs |
ending_lp_nav | NUMBER | Ending Net Asset Value (NAV) for LPs |
ending_gp_nav | NUMBER | Ending Net Asset Value (NAV) for GPs |
total_value | NUMBER | Total value of the fund including GPs and LPs |
lp_value | NUMBER | Total value attributable to limited partners (LP NAV plus cumulative distributions to LPs). |
gp_value | NUMBER | Total value attributable to general partners (GP NAV plus cumulative distributions to GPs). |
total_rvpi | NUMBER | Residual Value to Paid-In Capital for both LPs and GPs |
lp_rvpi | NUMBER | Residual Value to Paid-In Capital for LPs |
total_tvpi | NUMBER | Total Value to Paid-In Capital for both LPs and GPs |
lp_tvpi | NUMBER | Total Value to Paid-In Capital for LPs |
total_moic | NUMBER | Multiple of Invested Capital for both LPs and GPs |
lp_moic | NUMBER | Multiple of Invested Capital for LPs |
lp_dpi | NUMBER | LP-only distributions to paid-in capital ratio (most recent month-end value) |
deal_irr | FLOAT | Gross deal-level IRR for the fund expressed as a percentage, sourced from the most recent as_of_date. NULL when IRR cannot be computed. |
net_lp_irr | FLOAT | Net LP internal rate of return expressed as a percentage, sourced from the most recent as_of_date. NULL when IRR cannot be computed. |
count_gps | NUMBER | Total number of general partners in the fund |
count_lps | NUMBER | Total number of limited partners in the fund |
total_gp_cap_contribution | NUMBER | Aggregate capital contributions from general partners to date |
total_lp_cap_contribution | NUMBER | Aggregate capital contributions from limited partners to date |
total_cap_contribution | NUMBER | Total capital contributed to fund from all partners (total_gp_cap_contribution + total_lp_cap_contribution) |
total_gp_mgmt_fees | NUMBER | Cumulative management fees paid by general partners |
total_lp_mgmt_fees | NUMBER | Cumulative management fees paid by limited partners |
total_gp_capital_call_receivable | NUMBER | Total capital call receivable from general partners |
total_lp_capital_call_receivable | NUMBER | Total capital call receivable from limited partners |
total_capital_call_receivable | NUMBER | Total capital call receivable from all partners |
total_gp_distribution | NUMBER | Cumulative distributions paid to general partners, including return of capital and profits |
total_lp_distribution | NUMBER | Cumulative distributions paid to limited partners, including return of capital and profits |
total_distribution | NUMBER | Total distributions paid to all partners (total_gp_distribution + total_lp_distribution) |
total_net_realized | NUMBER | Net realized gains or losses from exited investments (total proceeds - cost basis of exited investments) |
total_net_unrealized | NUMBER | Net unrealized gains or losses on current holdings (current fair value - cost basis of current holdings) |
total_distribution_payable | NUMBER | Distributions approved but not yet paid to partners |
total_deferred_cap_call | NUMBER | Capital calls that have been deferred or scheduled for future dates |
total_carried_interest_accrued | NUMBER | Carried interest earned but not yet distributed, based on waterfall calculations |
total_contributions_outside_commitment | NUMBER | Capital contributions exceeding original commitment amounts (e.g., for follow-on investments) |
dry_powder | NUMBER | Remaining capital available for investments and expenses (fund_size - total_cost_of_investments - total_opx - total_mgmt_fees) |
perc_capital_remaining | NUMBER | Percentage of fund size not yet deployed (dry_powder / fund_size * 100) |
perc_mgmt_fees_to_fundsize | NUMBER | Management fees as percentage of fund size (total_mgmt_fees / fund_size * 100) |
perc_mgmt_fees_to_contributions | NUMBER | Management fees as percentage of total contributions (total_mgmt_fees / total_cap_contribution * 100) |
perc_cost_tax_prep_fees_to_contributions | NUMBER | Tax preparation fees as percentage of total contributions (cost_tax_prep_fees / total_cap_contribution * 100) |
perc_cost_travel_to_contributions | NUMBER | Travel expenses as percentage of total contributions (cost_travel / total_cap_contribution * 100) |
perc_cost_software_and_technology_to_contributions | NUMBER | Software and technology expenses as percentage of total contributions (cost_software_and_technology / total_cap_contribution * 100) |
perc_cost_dues_and_subscriptions_to_contributions | NUMBER | Dues and subscriptions as percentage of total contributions (cost_dues_and_subscriptions / total_cap_contribution * 100) |
perc_cost_payroll_salary_to_contributions | NUMBER | Payroll and salary expenses as percentage of total contributions (cost_payroll_salary / total_cap_contribution * 100) |
perc_cost_accounting_expenses_to_contributions | NUMBER | Accounting expenses as percentage of total contributions (cost_accounting_expense / total_cap_contribution * 100) |
perc_cost_events_to_contributions | NUMBER | Events expenses as percentage of total contributions (cost_events / total_cap_contribution * 100) |
perc_cost_legal_fees_to_contributions | NUMBER | Legal fees as percentage of total contributions (cost_legal_fees / total_cap_contribution * 100) |
perc_opx_to_fundsize | NUMBER | Operating expenses as percentage of fund size (total_opx / fund_size * 100) |
perc_opx_to_contributions | NUMBER | Operating expenses as percentage of total contributions (total_opx / total_cap_contribution * 100) |
is_eligible_fund | BOOLEAN | Flag indicating if fund meets criteria for inclusion in benchmark calculations (e.g., has a "go live date", isn't onboarding, etc.) |
is_administered_by_carta | BOOLEAN | True if the fund has full or investment only access |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Investment-level details for all investments made by funds, tracking cost basis, current value, and investment characteristics Pagination sort: fund_name, issuer_name, asset_name
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
issuer_name | VARCHAR | Name of the issuer from the general ledger (GL). |
asset_name | VARCHAR | Specific name or description of the investment asset (e.g., SAFE, Series Seed, Series A Preferred, etc.). Potential aliases include share class(es), holdings, investments (i.e. "my preferred series A investments"), etc. |
investment_date | DATE | Date when the initial investment was made |
latest_update_effective_date | DATE | Date of most recent update to investment information |
latest_fmv_effective_date | DATE | Date of most recent fair market value assessment |
fund_entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV, ...). |
firm_name | VARCHAR | Name of the investment firm. |
asset_class_type | VARCHAR | Classification of the investment (e.g., PREFERRED_EQUITY, CONVERTIBLE_DEBT, COMMON_EQUITY, FUND_INVESTMENT, WARRANTS, OTHER, TOKEN, ALTERNATIVE_ASSETS/OTHER, etc...) |
currency_code | VARCHAR | Currency denomination of the investment |
most_recent_journal_entry_type | VARCHAR | Type of the most recent transaction affecting the investment (e.g., NEW_INVESTMENT, MIGRATION, CONVERSION, VALUATION, ...) |
issuer_entity_type | VARCHAR | Legal structure of the issuing entity in the (somewhat uncommon) case that the issuer is a Fund / SPV / GP / Mgt Company entity |
issuer_domicile_country | VARCHAR | Country where the issuing entity is domiciled |
tags | VARCHAR | Comma delimited list of tags assigned to the issuer by the firm |
tags_json | OBJECT | JSON object of category and tag key-value pairs assigned to the issuer |
count_remaining_shares | NUMBER | Current number of shares or units held |
total_cost_basis | NUMBER | Remaining cost basis of the investment |
total_unrealized_gain_loss | NUMBER | Current unrealized gain/loss (remaining_value - total_cost_basis) |
total_proceeds | NUMBER | Total cash or equivalent received from partial or full exits |
remaining_value | NUMBER | Current fair market value of remaining holdings |
remaining_value_per_share | NUMBER | Current fair market value per share (remaining_value / count_remaining_shares) |
total_value | NUMBER | Total value including both realized and unrealized components |
total_cost | NUMBER | The total cost basis of the investment in the portfolio company. This is the aggregate amount of capital invested. |
total_interest_capitalized | NUMBER | Total amount of capitalized interest on the investment. This represents interest that has been added to the principal balance rather than paid out as cash. |
residual_gain_loss | NUMBER | Adjustment for reconciling cost basis with actual gains/losses |
is_investment_in_fund | BOOLEAN | Flag indicating if investment is in another fund / SPV / ... (fund-of-funds structure) |
is_crypto_asset | BOOLEAN | Flag indicating if investment is in cryptocurrency or digital assets |
is_option_or_warrant_asset | BOOLEAN | Flag indicating if investment is an option or warrant |
is_public_asset | BOOLEAN | Flag indicating if investment is in a publicly traded security |
is_ownership_interest_asset | BOOLEAN | Flag indicating if investment represents an ownership stake |
is_alternative_or_other_asset | BOOLEAN | Flag indicating if investment is classified as alternative investment |
is_investment_in_carta_fund_entity | BOOLEAN | Flag indicating if investment is in a Carta-administered fund |
is_international_issuer | BOOLEAN | Flag indicating if issuer is based outside the fund's domicile |
is_carta_customer | BOOLEAN | Indicates if the corporation is a Carta customer. Non-Carta companies are sometimes referred to as "paper companies" and are used to manually track investments for fund accounting purposes. |
is_foreign_currency_investment | BOOLEAN | Flag indicating if investment is denominated in foreign currency |
has_realization | BOOLEAN | Flag indicating if investment has had any realizations |
is_active_investment | BOOLEAN | Flag indicating if investment is currently held |
fund_investment_key | VARCHAR | Unique identifier for each fund-investment combination |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
general_ledger_issuer_id | VARCHAR | Unique identifier of the issuer from the general ledger (GL). Used as both a primary key and a foreign key. |
general_ledger_asset_id | VARCHAR | Unique identifier for the asset in the general ledger. Used as both a primary key and a foreign key. |
general_ledger_asset_class_id | VARCHAR | Classification identifier for the investment asset type |
most_recent_general_ledger_fund_journal_entry_id | VARCHAR | Identifier for the most recent journal entry affecting this investment |
most_recent_journal_entry_uuid | VARCHAR | UUID of the most recent journal entry for tracking updates |
most_recent_event_key | VARCHAR | Identifier for the most recent event affecting the investment |
entity_link_id | VARCHAR | Reference ID linking to related entity information |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Time series table with several rows per investments made by funds. It has an effective_date and next_effective_date dictating the range of dates the status was effective. Useful for tracking cost basis, current value, and investment characteristics over time. Pagination sort: fund_name, issuer_name, asset_name, effective_date DESC
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
issuer_name | VARCHAR | Name of the investment issuer in the general ledger |
asset_name | VARCHAR | Specific name or description of the investment asset |
effective_date | DATE | Effective date of the investment's status. Used in conjunction with next_effective_date to get the investment's status at a given point in time. For example, effective_date <= <some_date> and (next_effective_date is NULL or next_effective_date > <some_date>) |
next_effective_date | DATE | Next effective date of the investment's status. Used in conjunction with effective_date to get the investment's status at a given point in time. For example, effective_date <= <some_date> and (next_effective_date is NULL or next_effective_date > <some_date>) |
is_current_state | BOOLEAN | Flag indicating if the investment's status is the last in the time series. Used to quickly get the current status of an investment. |
fund_entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV, ...). |
firm_name | VARCHAR | Name of the investment firm. |
asset_class_type | VARCHAR | Classification of the investment (e.g., PREFERRED_EQUITY, CONVERTIBLE_DEBT, COMMON_EQUITY, FUND_INVESTMENT, WARRANTS, OTHER, TOKEN, ALTERNATIVE_ASSETS/OTHER, etc...) |
currency_code | VARCHAR | Currency denomination of the investment |
issuer_entity_type | VARCHAR | Legal structure of the issuing entity in the (somewhat uncommon) case that the issuer is a Fund / SPV / GP / Mgt Company entity |
issuer_domicile_country | VARCHAR | Country of domicile for the issuer |
event_types | VARCHAR | A comma-separated list of accounting event types that changed the asset on the effective date. e.g., "VALUATION", "NEW_INVESTMENT", "MIGRATION", "CONVERSION", ... |
count_remaining_shares | NUMBER | Number of remaining shares of the investment |
total_cost_basis | NUMBER | Remaining cost basis of the investment |
total_unrealized_gain_loss | NUMBER | (remaining_value - total_cost_basis) |
total_proceeds | NUMBER | Total cash or equivalent received from partial or full exits |
total_value | NUMBER | Total value including both realized and unrealized components |
total_cost | NUMBER | The total cost basis of the investment in the portfolio company. This is the aggregate amount of capital invested. |
total_interest_capitalized | NUMBER | Cumulative amount of capitalized interest on the investment as of the effective_date. This represents interest that has been added to the principal balance rather than paid out as cash. |
residual_gain_loss | NUMBER | Adjustment for reconciling cost basis with actual gains/losses |
count_records_on_date | NUMBER | Number of accounting records on the effective date |
remaining_value | NUMBER | Current fair market value of remaining holdings (equivalent to remaining cost basis + unrealized gain/loss). |
remaining_value_per_share | NUMBER | (remaining_value / count_remaining_shares) |
is_investment_in_fund | BOOLEAN | Flag indicating if investment is in another fund, SPV, etc. in a fund-of-funds structure |
is_crypto_asset | BOOLEAN | Flag indicating if investment is in cryptocurrency or digital assets |
is_option_or_warrant_asset | BOOLEAN | Flag indicating if investment is an option or warrant |
is_public_asset | BOOLEAN | Flag indicating if investment is in a publicly traded security |
is_ownership_interest_asset | BOOLEAN | Flag indicating if investment represents an ownership stake |
is_alternative_or_other_asset | BOOLEAN | Flag indicating if investment is classified as alternative investment |
is_investment_in_carta_fund_entity | BOOLEAN | Flag indicating if investment is in a Carta-administered fund |
is_international_issuer | BOOLEAN | Flag indicating if issuer is domiciled in a different country |
is_carta_customer | BOOLEAN | Indicates if the corporation is a Carta customer. Non-Carta companies are sometimes referred to as "paper companies" and are used to manually track investments for fund accounting purposes. |
_pk | VARCHAR | Primary key for investment history table |
fund_investment_key | VARCHAR | Unique identifier for each fund-investment combination |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
general_ledger_issuer_id | VARCHAR | Unique identifier of the issuer from the general ledger (GL). Used as both a primary key and a foreign key. |
general_ledger_asset_id | VARCHAR | Unique identifier for the asset in the general ledger. Used as both a primary key and a foreign key. |
general_ledger_asset_class_id | VARCHAR | Classification identifier for the investment asset type |
entity_link_id | VARCHAR | Reference identifier linking to related entity information |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
This model aggregates allocations data, including fund and partner details, allocation amounts, and related metadata. Pagination sort: fund_name, partner_name, effective_date DESC
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
partner_name | VARCHAR | Legal or registered name of the partner entity |
allocation_bucket_name | VARCHAR | The name of the bucket to which the allocation belongs. Also known as an allocation category or allocation type, each allocation bucket represents a line item on a partner's capital account statement. When a general ledger journal line's amount is allocated to a list of partners, it is funneled into an allocation bucket. |
effective_date | DATE | The date upon which the allocation is effective. |
entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV, ...). |
firm_name | VARCHAR | Name of the management firm. |
partner_class_name | VARCHAR | Name of the partner class this partner belongs to (e.g., Class A, Class B), representing different tiers or categories of investment terms |
firm_partner_group_name | VARCHAR | Name of the partner group, coalesced with partner name if no group is assigned |
actual_amount | NUMBER | The actual amount allocated for this allocation bucket. |
partner_type | VARCHAR | Type of partner relationship to the fund. Possible values include: "general_partner", "limited_partner", "managing_member", "member". |
gp_entity_name | VARCHAR | Name of the general partner entity associated with the allocation. |
allocation_notes | VARCHAR | Notes about the allocation providing additional context. |
general_ledger_account_name | VARCHAR | Name of the general ledger account associated with the allocation |
general_ledger_account_type | VARCHAR | Four-digit account type classification code for the general ledger account |
general_ledger_account_normal_balance | VARCHAR | Whether the general ledger account has a normal balance of either CREDIT or DEBIT |
is_limited_partner | BOOLEAN | True if the partner is a limited partner; otherwise, false. This will be true if partner_type = 'limited_partner' |
is_general_partner | BOOLEAN | True if the partner is a general partner; otherwise, false. This will be true if partner_type = 'general_partner' |
general_ledger_partner_record_id | VARCHAR | Unique identifier pk for general ledger partner records |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
fund_id | NUMBER | Unique identifier for the fund. Used as both a primary key and a foreign key. |
partner_id | NUMBER | Unique identifier for the partner. Used as both a primary key and a foreign key. |
external_partner_id | VARCHAR | External identifier for the partner, used for integrations with external systems and cross-referencing partner records |
firm_partner_group_id | NUMBER | Identifier of the partner group this partner belongs to within the firm |
partner_entity_id | VARCHAR | Unique identifier for the partner's legal entity. |
asset_id | VARCHAR | the asset_id associated with the allocation if any |
journal_entry_line_id | VARCHAR | The journal entry line id associated with the allocation |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
One row per capital activity (capital call, distribution, or return of excess) per fund. Mirrors the Fund Capital Activity list view in the Carta investor portal. Includes pre-aggregated dollar totals by bucket activity type, partner row counts by payment status, and lifecycle metadata. The firm_id and fund_uuid columns are foreign keys to funds and are used for row-level access policies. Pagination sort: fundname, due_date DESC, pk
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund that issued this capital activity. |
activity_type | VARCHAR | Type of capital activity: capital_call, distribution, return_of_excess, mixed (when multiple bucket types contribute non-zero amounts), or NULL when no amounts have been recorded yet. |
due_date | DATE | Date the capital activity is due (or to be paid out, for distributions). |
notice_date | DATE | Date the notice for this capital activity was issued. |
issue_at | TIMESTAMP_NTZ | Timestamp when this capital activity was issued. |
status | VARCHAR | Lifecycle status of the capital activity (e.g., active, completed, draft). |
source | VARCHAR | Source system or workflow that originated the capital activity. |
gross_call_amount | NUMBER | Sum of all amounts associated with capital_call buckets on this activity. |
gross_distribution_amount | NUMBER | Sum of all amounts associated with distribution buckets on this activity. |
gross_return_of_excess_amount | NUMBER | Sum of all amounts associated with return_of_excess buckets on this activity. |
net_activity_amount | NUMBER | Net dollar value of the activity, signed by each bucket's impact_on_activity (increase = +, decrease = -, none = 0). This is the headline number shown in the UI. |
total_amount_owed | NUMBER | Net dollar value owed across all partner rows on this activity, signed by each bucket's impact_on_owed. |
partner_row_count | NUMBER | Number of partner line items on this capital activity. |
paid_partner_row_count | NUMBER | Number of partner line items with payment_status = 'paid'. |
partially_paid_partner_row_count | NUMBER | Number of partner line items with payment_status = 'partially_paid'. |
unpaid_partner_row_count | NUMBER | Number of partner line items with payment_status = 'unpaid'. |
created_at | TIMESTAMP_NTZ | Timestamp when the capital activity record was created. |
updated_at | TIMESTAMP_NTZ | Timestamp when the capital activity record was last updated. |
is_stale | BOOLEAN | Whether the capital activity is stale (downstream data has changed since issuance). |
is_unlocked | BOOLEAN | Whether the capital activity is unlocked for editing. |
is_fully_paid | BOOLEAN | True when all partner line items are paid (no unpaid or partially-paid rows). |
is_partially_paid | BOOLEAN | True when at least one partner row is paid and at least one is unpaid or partial. |
_pk | VARCHAR | Generated surrogate primary key derived from capital_activity_id. |
firm_id | VARCHAR | Foreign key to the management firm (used for row-level access policies). |
fund_uuid | VARCHAR | Foreign key to the fund (used for row-level access policies). |
capital_activity_id | VARCHAR | Unique identifier for the capital activity. |
supersedes_capital_activity_id | NUMBER | When this activity replaces a prior one, the id of the prior capital activity. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
One row per (capital_activity, partner) — the per-partner line items for every capital call, distribution, or return of excess. Mirrors the per-activity detail view in the Carta investor portal. Includes paid_date, days_late, and bucket-typed dollar amounts. This is the table that consumers should use to monitor capital call payment timeliness. The firm_id and fund_uuid columns are foreign keys to funds and are used for row-level access policies. Pagination sort: fundname, due_date DESC, partner_name, pk
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund that issued this capital activity. |
activity_type | VARCHAR | Type of capital activity: capital_call, distribution, return_of_excess, mixed, or NULL when no amounts have been recorded yet. Inherited from the parent capital activity. |
due_date | DATE | Date the capital activity is due (or to be paid out, for distributions). |
partner_name | VARCHAR | Legal or registered name of the partner this line item belongs to. |
notice_date | DATE | Date the notice for this capital activity was issued. |
issue_at | TIMESTAMP_NTZ | Timestamp when this capital activity was issued. |
activity_status | VARCHAR | Lifecycle status of the parent capital activity (e.g., active, completed). |
amount_owed | NUMBER | Net dollar amount owed by this partner for this activity, signed by each bucket's impact_on_owed. Positive for capital calls, negative for distributions. |
capital_call_amount | NUMBER | Sum of amounts on this partner row tied to capital_call buckets (always non-negative). |
distribution_amount | NUMBER | Sum of amounts on this partner row tied to distribution buckets (always non-negative). |
return_of_excess_amount | NUMBER | Sum of amounts on this partner row tied to return_of_excess buckets. |
net_activity_amount | NUMBER | Net dollar value of this partner's line item, signed by each bucket's impact_on_activity. |
paid_date | DATE | Date the partner's wire was received (capital calls) or distribution paid out. GP-entered. Null when unpaid. |
in_kind_paid_date | DATE | Date the in-kind portion of the activity was settled, when applicable. |
days_late | NUMBER | Days between due_date and paid_date. Computed as DATEDIFF('day', due_date, COALESCE(paid_date, CURRENT_DATE)). Negative values mean paid before due date. For unpaid rows, this is days elapsed since due date. |
payment_status | VARCHAR | Cash payment status (paid, partially_paid, unpaid). |
in_kind_payment_status | VARCHAR | In-kind payment status. |
notes | VARCHAR | GP-entered notes on this partner's line item. |
created_at | TIMESTAMP_NTZ | Timestamp when this row was created. |
updated_at | TIMESTAMP_NTZ | Timestamp when this row was last updated. |
is_email_notice_enabled | BOOLEAN | Whether the partner is configured to receive the notice via email. |
is_pdf_notice_enabled | BOOLEAN | Whether the partner is configured to receive the notice as a PDF document. |
is_paid | BOOLEAN | True when payment_status = 'paid'. |
is_partially_paid | BOOLEAN | True when payment_status = 'partially_paid'. |
is_unpaid | BOOLEAN | True when payment_status = 'unpaid'. |
_pk | VARCHAR | Generated surrogate primary key derived from capital_activity_row_id. |
firm_id | VARCHAR | Foreign key to the management firm (used for row-level access policies). |
fund_uuid | VARCHAR | Foreign key to the fund (used for row-level access policies). |
capital_activity_id | VARCHAR | Foreign key to the parent capital activity. |
capital_activity_row_id | VARCHAR | Unique identifier for this partner line item. |
partner_id | NUMBER | Foreign key to the partner. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
Many-to-many junction between capital activity partner rows and journal entries. One row per (capital_activity_row_id, journal_entry_id) link. Use to navigate between capital_activity_partner_rows and journal_entries. Approximately 98% of rows link to exactly one journal entry on each side; the remaining ~2% genuinely link to multiple, so this is exposed as a junction rather than a scalar FK on either parent table. The firm_id and fund_uuid columns are used for row-level access policies. Pagination sort: fundname, pk
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund both records belong to. |
link_id | NUMBER | Surrogate identifier of the link record from the source junction table. |
_pk | VARCHAR | Generated surrogate primary key from [capital_activity_row_id, journal_entry_id]. |
firm_id | VARCHAR | Foreign key to the management firm (used for row-level access policies). |
fund_uuid | VARCHAR | Foreign key to the fund (used for row-level access policies). |
capital_activity_row_id | VARCHAR | Foreign key to capital_activity_partner_rows.capital_activity_row_id. |
journal_entry_id | VARCHAR | Foreign key to journal_entries.journal_entry_id. |
capital_activity_id | VARCHAR | Convenience FK to the parent capital activity (inherited from the partner row). |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
Contains portfolio company financial and KPI data Pagination sort: legal_name, as_of_date DESC, mnemonic
| Column | Type | Description |
|---|---|---|
legal_name | VARCHAR | The legal name of the portfolio company |
as_of_date | DATE | The date the data was collected |
period_start | DATE | The start date of the period the data point was collected for |
period_end | DATE | The end date of the period the data point was collected for |
mnemonic | VARCHAR | A short code for the metric name |
entity_type | VARCHAR | The type of entity the financial data belongs to (CORP for corporations, LLC for LLCs) |
is_latest | BOOLEAN | A flag indicating if this is the latest (by as_of_date) data point for a given metric during a given period |
instance_type | VARCHAR | Whether the data point is an Estimate or Actual |
report_type | VARCHAR | Indicates if the data point is a Profit and Loss, Cash Flow, Balance Sheet, or KPI |
name | VARCHAR | The name of the metric |
frequency | VARCHAR | The frequency of the period the data point was collected for, e.g. ANN, MON, QTR, SA |
float_value | FLOAT | The float value of the metric |
string_value | VARCHAR | The string value of the metric if the metric could not be represented as a float |
currency | VARCHAR | The currency of the metric |
unit_type | VARCHAR | The unit type of the metric e.g. Dollar, Percentage, Ratio, Number |
source_type | VARCHAR | The source type of the metric e.g. Direct Import, Xero, Excel Import, Codat Import |
agg_method | VARCHAR | The aggregation method of the metric e.g. Sum, Average, Max, Min |
data_type_description | VARCHAR | The description of the metric |
firm_name | VARCHAR | Name of the management firm |
corporation_id | VARCHAR | The Carta Corporation UUID of the portfolio company. NULL for LLC rows. |
llc_entity_id | VARCHAR | The LLC entity UUID. NULL for CORP rows. |
_pk | VARCHAR | Primary key for the company financials |
instance_id | NUMBER | An instance represents a collection of data representing a given period data can be collected for the same period multiple times. |
firm_id | VARCHAR | Unique identifier for the management firm |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Deprecated — Use Corporation Basic Info V2 instead. This model will be removed in a future release.
Corporation basic information including legal name, description, complete address details, website, logo, and CEO name. Consolidates data from legal entity, legal entity profile, and organization tables with fallback logic for logo and website. Firm-level overrides take precedence over Carta values when present for: corporation name, description, address, website, CEO, and foundation year. Grain: one row per corporation. CEO information matches the Carta application but may be overridden by firm-level overrides. Filters applied: pro forma corporations are excluded; corporations hidden from portfolio are excluded; voided corporations are excluded. Pagination sort: corporationname, pk
| Column | Type | Description |
|---|---|---|
corporation_name | VARCHAR | Official legal name of the corporation. Uses firm issuer override name when available, otherwise falls back to legal entity record. |
corporation_description | VARCHAR | Business description or summary of the corporation's activities and purpose. Uses firm issuer override description when available, otherwise falls back to legal entity record. |
street_address | VARCHAR | Street address of the corporation's primary business location. When a firm issuer override address is present, this contains the full address string (e.g. "100 Webster, Oakland, California 94607, United States") and city, state, postal_code, country will be NULL. |
city | VARCHAR | City where the corporation is located. NULL when a override address is present (see street_address). |
state | VARCHAR | State or province where the corporation is located. NULL when a override address is present (see street_address). |
postal_code | VARCHAR | Postal/ZIP code of the corporation's address. NULL when a override address is present (see street_address). |
country | VARCHAR | Country code in ISO 3166-1 alpha-3 format (e.g., USA, CAN, GBR). Converted from full country names in the base model. NULL when a override address is present (see street_address). |
website_url | VARCHAR | Corporation website URL. Uses firm issuer override website when available, then LegalEntityProfile website, then falls back to Organization website. |
logo_id | VARCHAR | Logo image identifier reference. Uses LegalEntityProfile logo_id first, falls back to Organization logo_id if LegalEntityProfile is null. This ID can be used to construct full logo URLs in application layer. |
ceo_name | VARCHAR | Full name of the corporation's CEO. Uses firm-level override when available, otherwise derived from the most recent active user with a CEO-level title (titles matching 'chief executive' or 'ceo', case-insensitive). May be null if no CEO data exists. |
foundation_year | NUMBER | Year the corporation was incorporated. Uses firm issuer override date of incorporation when available, otherwise extracted from the Carta Web incorporation_date. May be null if no incorporation date is available from either source. |
is_carta_customer | BOOLEAN | Boolean flag indicating whether the corporation is currently a Carta customer actively managing their cap table. TRUE when the corporation is on the Carta platform and has not churned. FALSE when the corporation has never been a Carta customer or has stopped using Carta services. Churn status is determined from the most recent churn record. |
_pk | VARCHAR | Surrogate primary key generated from corporation_id |
corporation_id | NUMBER | Unique identifier for the corporation |
corporation_uuid | VARCHAR | Universal unique identifier for the corporation in UUID format |
_loaded_at | TIMESTAMP_NTZ | Timestamp indicating when the most recent source data was loaded into Snowflake. Calculated as the maximum _loaded_at from all source tables used in this model, including the firm issuer override table. Useful for tracking data freshness and identifying stale records. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Entity basic information including legal name, description, complete address details, website, logo, and CEO name. Grain is one row per (firmid, entity_link_id), covering both Carta corporations and paper companies (non-Carta entities) that exist only as entity links within a firm. Consolidates data from legal entity, legal entity profile, and organization tables with fallback logic for logo, website, and corporation name. For paper companies, corporation_id and corporation_uuid may be NULL and all corporation fields are sourced exclusively from firm-level overrides. Firm-level overrides take precedence over Carta values when present for: corporation name, description, address, website, CEO, and foundation year. CEO information matches the Carta application but may be overridden by firm-level overrides. Filters applied: pro forma corporations are excluded; corporations hidden from portfolio are excluded; voided corporations are excluded. Pagination sort: corporation_name, pk
| Column | Type | Description |
|---|---|---|
corporation_name | VARCHAR | Official legal name of the corporation. Priority: (1) firm issuer override name, (2) Carta Web legal entity record, (3) legal_name from the corporation links view (covers paper companies that have no Carta Web profile). |
corporation_description | VARCHAR | Business description or summary of the corporation's activities and purpose. Uses firm issuer override description when available, otherwise falls back to legal entity record. |
street_address | VARCHAR | Street address of the corporation's primary business location. When a firm issuer override address is present, this contains the full address string (e.g. "100 Webster, Oakland, California 94607, United States") and city, state, postal_code, country will be NULL. |
city | VARCHAR | City where the corporation is located. NULL when a override address is present (see street_address). |
state | VARCHAR | State or province where the corporation is located. NULL when a override address is present (see street_address). |
postal_code | VARCHAR | Postal/ZIP code of the corporation's address. NULL when a override address is present (see street_address). |
country | VARCHAR | Country code in ISO 3166-1 alpha-3 format (e.g., USA, CAN, GBR). Converted from full country names in the base model. NULL when a override address is present (see street_address). |
website_url | VARCHAR | Corporation website URL. Uses firm issuer override website when available, then LegalEntityProfile website, then falls back to Organization website. |
logo_id | VARCHAR | Logo image identifier reference. Uses LegalEntityProfile logo_id first, falls back to Organization logo_id if LegalEntityProfile is null. This ID can be used to construct full logo URLs in application layer. |
ceo_name | VARCHAR | Full name of the corporation's CEO. Uses firm-level override when available, otherwise derived from the most recent active user with a CEO-level title (titles matching 'chief executive' or 'ceo', case-insensitive). May be null if no CEO data exists. |
foundation_year | NUMBER | Year the corporation was incorporated. Uses firm issuer override date of incorporation when available, otherwise extracted from the Carta Web incorporation_date. May be null if no incorporation date is available from either source. |
is_carta_customer | BOOLEAN | Boolean flag indicating whether the corporation is currently a Carta customer actively managing their cap table. TRUE when the corporation is on the Carta platform and has not churned. FALSE when the corporation has never been a Carta customer or has stopped using Carta services. Churn status is determined from the most recent churn record. |
_pk | VARCHAR | Surrogate primary key generated from firm_id and entity_link_id |
firm_id | VARCHAR | UUID of the firm that holds this portco via an entity link. |
entity_link_id | VARCHAR | Entity link identifier that uniquely identifies the portco relationship within a firm. Together with firm_id, forms the grain of this table. Used as the join key for firm-level override data. |
corporation_id | NUMBER | Integer identifier for the Carta Web corporation. NULL for paper companies that have no Carta Web corporation record. |
corporation_uuid | VARCHAR | UUID of the Carta Web corporation. NULL for paper companies that have no Carta Web corporation record. |
_loaded_at | TIMESTAMP_NTZ | Timestamp indicating when the most recent source data was loaded into Snowflake. Calculated as the maximum _loaded_at from all source tables used in this model, including the firm issuer override table and the corporation links view. Useful for tracking data freshness and identifying stale records. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Deprecated — Use Corporation Entity Links V2 instead. This model will be removed in a future release.
Links between general ledger issuers and their corresponding corporation entities, indicating whether the corporation is a Carta customer and providing key identifiers for cross-referencing between and corporation data systems. Pagination sort: firm_id, corporation_id
| Column | Type | Description |
|---|---|---|
general_ledger_issuer_id | VARCHAR | Unique identifier for the issuer found in the general ledger. Used for issuer-level aggregations and hierarchies. |
corporation_id | VARCHAR | Unique identifier for the corporation. Used as both a primary key and a foreign key. |
is_carta_customer | BOOLEAN | Indicates if the corporation is a Carta customer. Non-Carta companies are sometimes referred to as "paper companies" and are used to manually track investments for fund accounting purposes. |
_pk | VARCHAR | Surrogate primary key generated from firm_id, general_ledger_issuer_id, and corporation_id |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Simplified version of corporation entity links using the data_warehouse_corporation_links_view base model. This model provides mappings between Carta corporations and external entities including general ledger issuers and firm identifiers. This v2 version sources directly from the CartaWeb data warehouse materialized view for improved performance and data consistency. For each unique combination of (user_id, entity_link_id, firm_id, general_ledger_issuer_id, corporation_id), only the most recent as_of_date record is included. Pagination sort: firm_id, corporation_id, as_of_date DESC
| Column | Type | Description |
|---|---|---|
general_ledger_issuer_id | VARCHAR | Unique identifier for the issuer found in the general ledger. Used for issuer-level aggregations and hierarchies. |
corporation_id | VARCHAR | Unique identifier for the corporation (UUID format). Used as both a primary key and a foreign key. May be null for firm-level entity links that are not associated with a specific corporation. |
as_of_date | DATE | The date this link record is effective as of. For each unique key combination, only the record with the most recent as_of_date is included. |
is_carta_customer | BOOLEAN | Indicates if the corporation is a Carta customer. Non-Carta companies are sometimes referred to as "paper companies" and are used to manually track investments for fund accounting purposes. |
legal_name | VARCHAR | Legal name of the corporation as registered in official records. This is the formal, registered name of the entity. |
pro_forma_of_corporation_id | NUMBER | Pro forma corporation ID referencing the original corporation that this record is a copy of. Pro forma corporations are copies of real corporations on the platform used for financial modeling and scenario planning. When present, this indicates the source corporation that was copied. Null for actual corporations (not pro forma copies). |
user_id | NUMBER | User ID associated with this corporation entity link. May be null if no user is associated. |
entity_link_id | VARCHAR | External entity link identifier that connects the corporation to systems. May be null if no external entity link exists. |
corporation_entity_link_key | VARCHAR | Surrogate key generated from user_id, entity_link_id, firm_id, general_ledger_issuer_id, and corporation_id. Provides a stable, unique identifier for each corporation entity link. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Universal document registry across all document types. One row per extraction per document, filtered to current extraction. This model bridges the document domain and document_ai domain: join from document models on document_id, then use extraction_id to reach type-specific tables (e.g., document_ai_spa). Pagination sort: firm_id, document_id
| Column | Type | Description |
|---|---|---|
document_type | VARCHAR | Type of the document. Current values: 'Stock Purchase Agreement (SPA)'. New document types will be added as extraction support expands. |
page_count | NUMBER | Number of pages in the document |
extraction_id | VARCHAR | Unique identifier for the current extraction of this document |
_pk | VARCHAR | Surrogate primary key generated from document_id and extraction_id |
document_id | VARCHAR | Unique identifier for the document |
firm_id | VARCHAR | Unique identifier of the management firm that owns the document |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Raw extraction payload for each document. One row per current extraction, keyed by extraction_id. Contains the full extracted JSON for debugging and audit. Prefer the type-specific tables (e.g., document_aispa*) for structured queries. Pagination sort: firm_id, extracted_at DESC, document_id
| Column | Type | Description |
|---|---|---|
extracted_at | TIMESTAMP_NTZ | Timestamp when the document was extracted |
enriched_at | TIMESTAMP_NTZ | Timestamp when the document was enriched |
raw_json | VARIANT | VARIANT containing the full extracted JSON payload. Top-level keys include parties (company, purchasers), deal_terms (closing_dates, price_per_share_by_series), and capitalization (preferred_designations). Structure varies by document_type. |
_pk | VARCHAR | Surrogate primary key generated from extraction_id |
extraction_id | VARCHAR | Unique identifier for the extraction |
document_id | VARCHAR | Unique identifier for the document |
firm_id | VARCHAR | Unique identifier of the management firm that owns the document |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
One row per SPA extraction. Contains scalar deal-level attributes for Stock Purchase Agreements. Related tables: document_ai_spa_issuer (company party), document_ai_spa_purchaser (investor parties), document_ai_spa_series (preferred stock designations). All joinable on extraction_id. Pagination sort: firm_id, closing_date DESC, document_id
| Column | Type | Description |
|---|---|---|
extraction_id | VARCHAR | Unique identifier for the SPA extraction |
closing_date | DATE | First closing date from the deal terms |
_pk | VARCHAR | Surrogate primary key generated from extraction_id |
document_id | VARCHAR | Unique identifier for the SPA document |
firm_id | VARCHAR | Unique identifier of the management firm that owns the document |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
One row per SPA extraction. The company/issuer party extracted from the Stock Purchase Agreement. Join to document_ai_spa on extraction_id for deal terms. Pagination sort: issuer_name, firm_id, document_id
| Column | Type | Description |
|---|---|---|
issuer_name | VARCHAR | Name of the issuing company |
address | VARCHAR | Address of the issuing company |
jurisdiction | VARCHAR | Jurisdiction of incorporation of the issuing company |
ceo_or_key_officer | VARCHAR | CEO or key officer named in the SPA |
executed_by_issuer | BOOLEAN | Whether the SPA was executed by the issuer |
_pk | VARCHAR | Surrogate primary key generated from extraction_id |
extraction_id | VARCHAR | Unique identifier for the SPA extraction |
document_id | VARCHAR | Unique identifier for the SPA document |
firm_id | VARCHAR | Unique identifier of the management firm that owns the document |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
One row per purchaser per SPA extraction. Flattened from the purchasers array in the Stock Purchase Agreement extraction. Multiple rows per extraction_id. Join to document_ai_spa on extraction_id for deal terms. Pagination sort: purchaser_name, firm_id, document_id
| Column | Type | Description |
|---|---|---|
purchaser_name | VARCHAR | Name of the purchasing entity |
entity_type | VARCHAR | Legal entity type of the purchaser (e.g., L.P., LLC) |
share_class_name | VARCHAR | Name of the share class purchased |
shares_purchased | NUMBER | Number of shares purchased by cash |
total_amount_paid | NUMBER | Total amount paid for the shares |
price_per_share | NUMBER | Price per share paid by the purchaser |
_pk | VARCHAR | Surrogate primary key generated from extraction_id and purchaser index |
extraction_id | VARCHAR | Unique identifier for the SPA extraction |
document_id | VARCHAR | Unique identifier for the SPA document |
firm_id | VARCHAR | Unique identifier of the management firm that owns the document |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
One row per preferred series per SPA extraction. Flattened from the capitalization preferred designations array in the Stock Purchase Agreement extraction. Multiple rows per extraction_id. Join to document_ai_spa on extraction_id for deal terms. Pagination sort: series_name, firm_id, document_id
| Column | Type | Description |
|---|---|---|
series_name | VARCHAR | Name of the preferred stock series |
designated_shares | NUMBER | Number of shares designated for this series |
outstanding_pre_closing | NUMBER | Number of shares outstanding before closing |
price_per_share | NUMBER | Price per share for this series from deal terms. May be null for older records. |
shares_issued | NUMBER | Shares issued by series after all closings from deal terms. May be null for older records. |
_pk | VARCHAR | Surrogate primary key generated from extraction_id and series index |
extraction_id | VARCHAR | Unique identifier for the SPA extraction |
document_id | VARCHAR | Unique identifier for the SPA document |
firm_id | VARCHAR | Unique identifier of the management firm that owns the document |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Provides information on various financing rounds for different companies/corporations ("portcos") in a fund/firm's portfolio, including specifics about share classes, amounts raised, and company valuations. Each row represents a unique investment event, outlining key terms such as issue prices, types of shares issued, and investor rights. Pagination sort: raised_date DESC, investment_name, shareclass_name
| Column | Type | Description |
|---|---|---|
investment_name | VARCHAR | The legal name of the portfolio company. |
shareclass_name | VARCHAR | Shareclass name. No strict format for the values in this column. Examples include: "Series D-1 Preferred", "Preferred", "Seed-1", "SERIES A-2", "Non-Voting Series A Preferred (PANV) Stock", "Investment", ... |
raised_date | DATE | The date the first certificate was issued from a share class. |
closing_date | DATE | The date the last original issuance was issued from a share class. |
round | VARCHAR | The series/round name from the shareclass_name. Contains the string "seed" or one of: "a", "b", ..., "h" |
calculated_cash_raised | NUMBER(38,5) | shares_issued (aka "total_quantity") times original_issue_price (OIP). Can use this when (estimated) cash raised has not been entered in the Carta platform |
estimated_cash_raised | NUMBER(38,12) | The total funds raised during this funding round. This figure is independent of share prices or valuations. |
shares_issued | NUMBER | The total outstanding quantity of shares in this share class. AKA: "the share class's total quantity" |
original_issue_price | NUMBER | The price per share set at the time of issuance for this funding round. Note: This calculation does not account for post-conversion prices and uses the original issue price for consistency. |
fully_diluted_shares | NUMBER(38,12) | The total number of shares outstanding as of the closing date, including shares that could exist in the future if all options, warrants, and convertible securities are exercised. Conversion ratios are already reflected in this number. |
post_money_valuation | NUMBER(38,12) | Calculated using the original_issue_price and fully_diluted_shares. Does not account for post-conversion prices, which may lead to variations from adjusted valuations based on specific conversion scenarios. |
pre_money_valuation | NUMBER(28,12) | Calculated as post_money_valuation - cash_raised for the round. Does not account for post-conversion prices, which may lead to variations from adjusted valuations based on specific conversion scenarios. |
conversion_price | NUMBER | Conversion Price. OIP (original issue price) / conversion price = number of common shares the shareholder would receive if the stock converted to common. For example if OIP = 1 and conversion_price = .5, the shareholder would receive 2 shares of common. This calculation also affects the fully diluted shares of a company. This is overridden by conversion ratio if it is present. |
calculated_conversion_ratio | FLOAT | Conversion ratio for the security, calculated from the round terms. Used to convert preferred shares to common-equivalent shares. |
multiplier | VARCHAR | Shareclass Multiplier. This is a waterfall input and only used on preferred stock_types. In the event of a liquidation, the holder of the stock will receive OIP * Multiplier based on the seniority before common starts to participate. If the shareholder would receive more money converting preferred into common stock, then it will. A larger multiplier is better for investors but worse for the company. |
dividend_coupon | NUMBER(10,6) | Annual dividend percentage of the dividend rights (7.00 = 7%). The percentage is multiplied with the OIP to arrive at a dollar value. |
dividend_type | VARCHAR | Dividend Type. Can either be "Cumulative" or "Non-Cumulative". If a dividend is cumulative it means that dividends accrue over time. In the event of a liquidation, the unpaid dividends are added to the investor's liquidation preference before paying out common. Non-cumulative dividends don't accrue and just protect the investors from the company trying to declare a dividend on just the common shareclass. Cumulative dividends are good for investors and bad for companies. Non-cumulative dividends have little to no effect. |
preference_cap | NUMBER(10,6) | Shareclass Preference Cap. Waterfall input. OIP * preference_cap is the amount of liquidation preference the shareholder will participate along side common after the OIP * Multiplier has been paid out and before converting into common. Good for investors, bad for companies. |
is_carta_customer | BOOLEAN | Indicates if the corporation is a Carta customer. Non-Carta companies are sometimes referred to as "paper companies" and are used to manually track investments for fund accounting purposes. |
participating_preferred | BOOLEAN | Shareclass Participating Preferred. Waterfall input. If true, the shareholder will receive the OIP * Multiplier and participating_preferred along side common after the preferences have been paid. The participation is limited by preference_cap. Good for investors, bad for companies. |
_pk | VARCHAR | Surrogate primary key generated from corporation_id and share_class_id |
corporation_id | VARCHAR | Unique identifier for the corporation. Used as both a primary key and a foreign key. |
share_class_id | NUMBER | Unique identifier for the share class. The set of share classes differs for each corporation. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Tracks fund deployment speed relative to peer funds, providing percentile benchmarks for capital deployment over time Pagination sort: fund_uuid, months_since_vintage
| Column | Type | Description |
|---|---|---|
vintage_year | NUMBER | Fund's vintage year for cohort grouping |
fund_aum_bucket | VARCHAR | Fund size category for peer comparison. Possible values are: "<1m", "1m-10m", "10m-25m", "25m-100m", "100m-250m", "250m+" |
months_since_vintage | NUMBER | Number of months elapsed since first capital call |
cumulative_invested_through_month | FLOAT | Total amount invested as of each month since vintage |
percentage_invested_through_month | FLOAT | Percentage of fund size deployed as of each month (cumulative_invested_through_month / fund_size) |
ct_companies_in_bucket | NUMBER | Number of funds in the same cohort for comparison |
p1 | FLOAT | 1st percentile of deployment rate in cohort at this time point |
p5 | FLOAT | 5th percentile of deployment rate in cohort at this time point |
p10 | FLOAT | 10th percentile of deployment rate in cohort at this time point |
p25 | FLOAT | 25th percentile of deployment rate in cohort at this time point |
p50 | FLOAT | Median deployment rate in cohort at this time point |
p75 | FLOAT | 75th percentile of deployment rate in cohort at this time point |
p90 | FLOAT | 90th percentile of deployment rate in cohort at this time point |
p99 | FLOAT | 99th percentile of deployment rate in cohort at this time point |
_pk | VARCHAR | Surrogate primary key generated from fund_uuid and months_since_vintage |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Fund corporation ownership data showing the percentage and quantity of ownership that funds have in portfolio companies (corporations). Uses UUID identifiers for corporation and fund. Pagination sort: corporation_id, fund_id, as_of_date DESC
| Column | Type | Description |
|---|---|---|
as_of_date | TIMESTAMP_NTZ | The date for which the ownership snapshot is calculated |
corporation_id | VARCHAR | UUID of the portfolio company (corporation) |
fund_id | VARCHAR | UUID of the fund |
firm_id | VARCHAR | ID of the firm that owns the fund |
percentage | NUMBER | Ownership percentage (0-100) |
fully_diluted | NUMBER | Fully diluted ownership percentage |
ownership_quantity | NUMBER | Number of shares or units owned |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
_pk | VARCHAR | Surrogate primary key derived from source table id |
Per-fund holdings value (normalized layer). One row per (valuation/waterfall × fund), sourced from two places: (1) PORTFOLIO_VALUATION — finalized Portfolio Valuations; (2) SCENARIO_MODELING — saved Waterfall Modeling marks (including LLC_ACCOUNT multi-entity waterfalls). Four target_type variants are handled (CORPORATION, CORPORATION_ENTITY_GROUP, LLC_ISSUER, LLC_ACCOUNT). Pagination sort: fund_name, target_name, valuation_date DESC
| Column | Type | Description |
|---|---|---|
valuation_date | DATE | Valuation date for PORTFOLIO_VALUATION rows; effective date of the waterfall mark for SCENARIO_MODELING rows. |
target_type | VARCHAR | Carta cap table platform used by the portfolio company. One of CORPORATION, CORPORATION_ENTITY_GROUP, LLC_ISSUER, or LLC_ACCOUNT (the latter for multi-entity LLC waterfalls). |
target_name | VARCHAR | Legal name of the portfolio company being valued. Resolved by target_type — CORPORATION from corporation legal name; CORPORATION_ENTITY_GROUP from entity group name; LLC_ISSUER from LLC entity legal name; LLC_ACCOUNT from LLC account name (may include a firm-specific suffix). NULL only when no matching record exists. |
fund_name | VARCHAR | Fund name. Holder name for PORTFOLIO_VALUATION; corporation legal name for SCENARIO_MODELING. |
source | VARCHAR | PORTFOLIO_VALUATION (finalized portfolio valuation) or SCENARIO_MODELING (saved waterfall mark, including LLC_ACCOUNT multi-entity waterfalls). |
allocation_methodology | VARCHAR | Allocation method used to calculate holdings value. From the underlying Allocation for PORTFOLIO_VALUATION; literal NIAGARA_WATERFALL for SCENARIO_MODELING. Accepted values: WATERFALL, OPTION_PRICING_MODEL, NIAGARA_WATERFALL, COMMON_STOCK_EQUIVALENT, NIAGARA_OPM. |
target_value | NUMBER | Total portfolio company value after discounts, or exit value from waterfall modeling. |
fund_holdings_value | NUMBER | Holdings value attributable to this fund. 0 when the fund has participated in another waterfall for the same portfolio company but receives no allocation in this specific scenario (e.g. exit value below the liquidation preference stack). |
fund_proceeds_percentage | NUMBER | Fund's share of exit value, computed as fund_proceeds / target_value (matches the Niagara canonical definition). Populated for SCENARIO_MODELING; NULL for PORTFOLIO_VALUATION. |
fund_invested_capital | NUMBER | Total invested capital across all interests this fund holds in the target. For zero-padded rows (fund participated in a sibling waterfall but receives no allocation in this scenario — e.g. exit value below the LP stack), carries the fund's invested capital from the most-recent sibling waterfall for the same target+firm+fund. Populated for SCENARIO_MODELING; NULL for PORTFOLIO_VALUATION (the upstream holding model doesn't track invested capital). |
fund_moic | NUMBER | Multiple on invested capital: fund_holdings_value / fund_invested_capital. 0 when the fund receives no allocation in the scenario (zero-padded row). NULL when fund_invested_capital is NULL or zero. |
total_holdings_value | NUMBER | Total firm holdings value across all funds for this valuation/waterfall. |
_pk | VARCHAR | Surrogate primary key generated from (source, valuation_id or portfolio_valuation_mark_id, fund_id). |
firm_id | VARCHAR | Firm UUID. Used to enforce row access policy. |
target_id | VARCHAR | Identifier of the portfolio company. Corporation UUID when target_type = CORPORATION; otherwise the upstream UUID (entity group, LLC interest issuer, or LLC account). Used to enforce row access policy. |
fund_id | VARCHAR | Fund corporation UUID. |
valuation_id | NUMBER | Valuation identifier. Populated for PORTFOLIO_VALUATION rows; NULL for SCENARIO_MODELING. |
waterfall_id | VARCHAR | Waterfall mark source identifier. Populated for SCENARIO_MODELING rows; NULL for PORTFOLIO_VALUATION. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this row was last refreshed during dbt execution. |
Operational benchmarks for funds based on size cohorts and vintage years joined back to fund-level tables Pagination sort: fund_name, vintage_year
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
vintage_year | NUMBER | Year of first capital call, used for cohort analysis |
fund_aum_bucket | VARCHAR | Fund size category used for peer grouping |
entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Limited Partnership, LLC) |
total_opx | NUMBER | Total operating expenses excluding management fees (legal, fund administration, etc.) |
perc_opx_to_fundsize | NUMBER | Operating expenses as percentage of fund size (total_opx / fund_size * 100) |
total_mgmt_fees | NUMBER | Total management fees paid by all partners (total_gp_mgmt_fees + total_lp_mgmt_fees) |
perc_mgmt_fees_to_fundsize | NUMBER | Management fees as percentage of fund size (total_mgmt_fees / fund_size * 100) |
dry_powder | NUMBER | Remaining capital available for investments and expenses (fund_size - total_cost_of_investments - total_opx - total_mgmt_fees) |
perc_capital_remaining | NUMBER | Percentage of fund size not yet deployed (dry_powder / fund_size * 100) |
cost_legal_fees | NUMBER | Total legal fees paid by the fund |
perc_cost_legal_fees_to_contributions | NUMBER | Legal fees as percentage of total contributions (cost_legal_fees / total_cap_contribution * 100) |
cost_software_and_technology | NUMBER | Costs related to software, technology, and IT |
perc_cost_software_and_technology_to_contributions | NUMBER | Software and technology expenses as percentage of total contributions (cost_software_and_technology / total_cap_contribution * 100) |
net_perc_capital_remaining_5th | NUMBER | 5th percentile of capital remaining percentage in cohort |
net_perc_capital_remaining_10th | NUMBER | 10th percentile of capital remaining percentage in cohort |
net_perc_capital_remaining_25th | NUMBER | 25th percentile of capital remaining percentage in cohort |
net_perc_capital_remaining_50th | NUMBER | Median capital remaining percentage in cohort |
net_perc_capital_remaining_75th | NUMBER | 75th percentile of capital remaining percentage in cohort |
net_perc_capital_remaining_90th | NUMBER | 90th percentile of capital remaining percentage in cohort |
ct_companies_capital_remaining | NUMBER | Number of funds in cohort for capital remaining analysis |
net_perc_mgmt_fees_to_fundsize_5th | NUMBER | 5th percentile of management fees as percentage of fund size |
net_perc_mgmt_fees_to_fundsize_10th | NUMBER | 10th percentile of management fees as percentage of fund size |
net_perc_mgmt_fees_to_fundsize_25th | NUMBER | 25th percentile of management fees as percentage of fund size |
net_perc_mgmt_fees_to_fundsize_50th | NUMBER | Median management fees as percentage of fund size |
net_perc_mgmt_fees_to_fundsize_75th | NUMBER | 75th percentile of management fees as percentage of fund size |
net_perc_mgmt_fees_to_fundsize_90th | NUMBER | 90th percentile of management fees as percentage of fund size |
ct_companies_mgmt_fees | NUMBER | Number of funds in cohort for management fee analysis |
net_count_gps_5th | NUMBER | 5th percentile of GP count in cohort |
net_count_gps_10th | NUMBER | 10th percentile of GP count in cohort |
net_count_gps_25th | NUMBER | 25th percentile of GP count in cohort |
net_count_gps_50th | NUMBER | Median GP count in cohort |
net_count_gps_75th | NUMBER | 75th percentile of GP count in cohort |
net_count_gps_90th | NUMBER | 90th percentile of GP count in cohort |
ct_companies_gps | NUMBER | Number of funds in cohort for GP count analysis |
net_count_lps_5th | NUMBER | 5th percentile of LP count in cohort |
net_count_lps_10th | NUMBER | 10th percentile of LP count in cohort |
net_count_lps_25th | NUMBER | 25th percentile of LP count in cohort |
net_count_lps_50th | NUMBER | Median LP count in cohort |
net_count_lps_75th | NUMBER | 75th percentile of LP count in cohort |
net_count_lps_90th | NUMBER | 90th percentile of LP count in cohort |
ct_companies_lps | NUMBER | Number of funds in cohort for LP count analysis |
net_perc_opex_to_fundsize_5th | NUMBER | 5th percentile of operating expenses as percentage of fund size |
net_perc_opex_to_fundsize_10th | NUMBER | 10th percentile of operating expenses as percentage of fund size |
net_perc_opex_to_fundsize_25th | NUMBER | 25th percentile of operating expenses as percentage of fund size |
net_perc_opex_to_fundsize_50th | NUMBER | Median operating expenses as percentage of fund size |
net_perc_opex_to_fundsize_75th | NUMBER | 75th percentile of operating expenses as percentage of fund size |
net_perc_opex_to_fundsize_90th | NUMBER | 90th percentile of operating expenses as percentage of fund size |
ct_companies_opex | NUMBER | Number of funds in cohort for operating expense analysis |
net_perc_cost_legal_fees_to_contributions_5th | NUMBER | 5th percentile of legal fees as percentage of contributions |
net_perc_cost_legal_fees_to_contributions_10th | NUMBER | 10th percentile of legal fees as percentage of contributions |
net_perc_cost_legal_fees_to_contributions_25th | NUMBER | 25th percentile of legal fees as percentage of contributions |
net_perc_cost_legal_fees_to_contributions_50th | NUMBER | Median legal fees as percentage of contributions |
net_perc_cost_legal_fees_to_contributions_75th | NUMBER | 75th percentile of legal fees as percentage of contributions |
net_perc_cost_legal_fees_to_contributions_90th | NUMBER | 90th percentile of legal fees as percentage of contributions |
ct_companies_legal | NUMBER | Number of funds in cohort for legal cost analysis |
net_perc_cost_tech_to_contributions_5th | NUMBER | 5th percentile of technology costs as percentage of contributions |
net_perc_cost_tech_to_contributions_10th | NUMBER | 10th percentile of technology costs as percentage of contributions |
net_perc_cost_tech_to_contributions_25th | NUMBER | 25th percentile of technology costs as percentage of contributions |
net_perc_cost_tech_to_contributions_50th | NUMBER | Median technology costs as percentage of contributions |
net_perc_cost_tech_to_contributions_75th | NUMBER | 75th percentile of technology costs as percentage of contributions |
net_perc_cost_tech_to_contributions_90th | NUMBER | 90th percentile of technology costs as percentage of contributions |
ct_companies_tech_cost | NUMBER | Number of funds in cohort for technology cost analysis |
net_perc_payroll_to_contributions_5th | NUMBER | 5th percentile of payroll as percentage of contributions |
net_perc_payroll_to_contributions_10th | NUMBER | 10th percentile of payroll as percentage of contributions |
net_perc_payroll_to_contributions_25th | NUMBER | 25th percentile of payroll as percentage of contributions |
net_perc_payroll_to_contributions_50th | NUMBER | Median payroll as percentage of contributions |
net_perc_payroll_to_contributions_75th | NUMBER | 75th percentile of payroll as percentage of contributions |
net_perc_payroll_to_contributions_90th | NUMBER | 90th percentile of payroll as percentage of contributions |
ct_companies_payroll | NUMBER | Number of funds in cohort for payroll analysis |
fund_id | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
fund | VARCHAR | Foreign key to the funds table (fund_uuid). The fund this benchmark record applies to. |
cr_fund_aum_bucket | VARCHAR | Fund size bucket for capital remaining analysis |
cr_vintage_year | NUMBER | Vintage year for capital remaining analysis |
cr_entity_type_name | VARCHAR | Capital remaining entity type for analysis |
mf_fund_aum_bucket | VARCHAR | Fund size bucket for management fee analysis |
mf_vintage_year | NUMBER | Vintage year for management fee analysis |
mf_entity_type_name | VARCHAR | Management fee entity type for analysis |
gps_fund_aum_bucket | VARCHAR | Fund size bucket for GP count analysis |
gps_vintage_year | NUMBER | Vintage year for GP count analysis |
gps_entity_type_name | VARCHAR | General partner entity type for GP count analysis |
lps_fund_aum_bucket | VARCHAR | Fund size bucket for LP count analysis |
lps_vintage_year | NUMBER | Vintage year for LP count analysis |
lps_entity_type_name | VARCHAR | LP entity type for LP count analysis |
opex_fund_aum_bucket | VARCHAR | Fund size bucket for operating expense analysis |
opex_vintage_year | NUMBER | Vintage year for operating expense analysis |
opex_entity_type_name | VARCHAR | Operating expense entity type for analysis |
legal_fund_aum_bucket | VARCHAR | Fund size bucket for legal cost analysis |
legal_vintage_year | NUMBER | Vintage year for legal cost analysis |
legal_entity_type_name | VARCHAR | Legal entity type for legal cost analysis |
tech_cost_fund_aum_bucket | VARCHAR | Fund size bucket for technology cost analysis |
tech_cost_vintage_year | NUMBER | Vintage year for technology cost analysis |
tech_cost_entity_type_name | VARCHAR | Legal entity type for technology cost analysis |
payroll_fund_aum_bucket | VARCHAR | Fund size bucket for payroll analysis |
payroll_vintage_year | NUMBER | Vintage year for payroll analysis |
payroll_entity_type_name | VARCHAR | Legal entity type for payroll analysis |
perc_mgmt_fees_to_contributions | NUMBER | Management fees as percentage of total contributions (total_mgmt_fees / total_cap_contribution * 100) |
Core fund dimension table containing fund-level properties and attributes. One row per fund. Designed as a normalized dimension to support PK/FK relationships and automatic join inference with other warehouse tables via fund_uuid. Pagination sort: fund_name, fund_uuid
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
vintage_date | DATE | Date of first capital call (GL-based). Used to determine vintage year and age-based metrics. |
vintage_year | NUMBER | Calendar year of first capital call, used for cohort analysis and benchmarking. |
entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV). |
firm_name | VARCHAR | Name of the management firm that operates the fund. |
fund_family_name | VARCHAR | Name of the fund family grouping related funds. |
reporting_currency | VARCHAR | Currency denomination of the fund (e.g., USD, EUR). |
investment_strategy_code | VARCHAR | Raw investment strategy code from fund properties (e.g., DIRECT_VENTURE, FUND_OF_FUNDS). |
partner_transaction_source | VARCHAR | System of record for partner transaction data (e.g., carta_gl, cats, partner_records). |
legal_structure | VARCHAR | Legal structure of the fund entity (e.g., LP, LLC). |
fund_size | NUMBER | Total committed capital across all LPs and GPs. Used for fund size cohort classification. |
fund_aum_bucket | VARCHAR | Size category for peer comparison based on fund_size. Buckets differ by entity type (Fund vs SPV). |
created_at | TIMESTAMP_NTZ | Timestamp when the fund entity was created in the system. |
updated_at | TIMESTAMP_NTZ | Timestamp when the fund entity was last updated. |
service_stop_date | DATE | Date when Carta services were stopped for this fund (if applicable). |
last_reporting_period | VARCHAR | The most recent reporting period for the fund from fund properties general properties. |
last_reporting_period_year | NUMBER | The year of the most recent reporting period for the fund. |
is_onboarding | BOOLEAN | Flag indicating if the fund is currently in the onboarding process. |
is_parallel_entity | BOOLEAN | Flag indicating if this is a parallel fund entity (e.g., parallel vehicle). |
is_using_investran | BOOLEAN | Flag indicating if the fund uses Investran as a secondary system. |
is_administered_by_carta | BOOLEAN | Flag indicating if the fund has an active full fund administration or investments-only product access. |
is_churned_fund_properties | BOOLEAN | Flag indicating if the fund is marked as churned in Carta's system. |
_pk | VARCHAR | Surrogate primary key generated from fund_uuid. |
fund_uuid | VARCHAR | Unique identifier for the fund. Foreign key to other dataset models. |
fund_id | NUMBER | Integer identifier for the fund in the system. |
carta_id | NUMBER | Identifier linking this fund to its corresponding corporation entity. |
firm_id | VARCHAR | Unique identifier for the management firm. Foreign key to firm-level tables. |
portfolio_id | NUMBER | Identifier for the portfolio this fund belongs to. |
fund_family_id | VARCHAR | Identifier for the fund family grouping related funds. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
Per-fund breakdown of holdings value sourced from finalized Portfolio Valuations and saved Waterfall Modeling marks (including LLC_ACCOUNT multi-entity waterfalls). One row per (valuation/waterfall × fund). Pagination sort: fund_name, target_name, valuation_date DESC
| Column | Type | Description |
|---|---|---|
valuation_date | DATE | Valuation date (project valuation_date for PORTFOLIO_VALUATION; mark effective_date for SCENARIO_MODELING). |
target_type | VARCHAR | Carta cap table platform used by the portfolio company. One of CORPORATION, CORPORATION_ENTITY_GROUP, LLC_ISSUER, or LLC_ACCOUNT (the latter for multi-entity LLC waterfalls). |
target_name | VARCHAR | Legal name of the portfolio company being valued. Resolved by target_type — CORPORATION from corporation legal name; CORPORATION_ENTITY_GROUP from entity group name; LLC_ISSUER from LLC entity legal name; LLC_ACCOUNT from LLC account name (may include a firm-specific suffix). NULL only when no matching record exists. |
fund_name | VARCHAR | Fund name. |
source | VARCHAR | PORTFOLIO_VALUATION (finalized portfolio valuation) or SCENARIO_MODELING (saved waterfall mark, including LLC_ACCOUNT multi-entity waterfalls). |
allocation_methodology | VARCHAR | Allocation method used to calculate holdings value. Accepted values: WATERFALL, OPTION_PRICING_MODEL, NIAGARA_WATERFALL, COMMON_STOCK_EQUIVALENT, NIAGARA_OPM. Literal NIAGARA_WATERFALL for SCENARIO_MODELING. |
target_value | NUMBER | Total portfolio company value after discounts (or waterfall exit value). |
fund_holdings_value | NUMBER | Holdings value attributable to this fund. 0 when the fund has participated in another waterfall for the same portfolio company but receives no allocation in this specific scenario (e.g. exit value below the liquidation preference stack). |
fund_proceeds_percentage | NUMBER | Fund's share of exit value, computed as fund_proceeds / target_value (matches the Niagara canonical definition). Populated for SCENARIO_MODELING; NULL for PORTFOLIO_VALUATION. |
fund_invested_capital | NUMBER | Total invested capital across all interests this fund holds in the target. For zero-padded rows (fund participated in a sibling waterfall but receives no allocation in this scenario — e.g. exit value below the LP stack), carries the fund's invested capital from the most-recent sibling waterfall for the same target+firm+fund. Populated for SCENARIO_MODELING; NULL for PORTFOLIO_VALUATION (the upstream holding model doesn't track invested capital). |
fund_moic | NUMBER | Multiple on invested capital: fund_holdings_value / fund_invested_capital. 0 when the fund receives no allocation in the scenario. NULL when invested capital is NULL or zero. |
total_holdings_value | NUMBER | Total firm holdings value across all funds for this valuation/waterfall. |
_pk | VARCHAR | Surrogate primary key. |
firm_id | VARCHAR | Firm UUID. Used to enforce row access policy. |
target_id | VARCHAR | Identifier of the portfolio company. Corporation UUID when target_type = CORPORATION; otherwise the upstream UUID (entity group, LLC interest issuer, or LLC account). Used to enforce row access policy. |
fund_id | VARCHAR | Fund corporation UUID. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
This model provides IRC 409A fair market valuation data for portfolio companies, including valuation reports, effective dates, and pricing information for share classes. Excludes churned corporations based on the most recent non-voided churn record. Pagination sort: legal_name, effective_date DESC
| Column | Type | Description |
|---|---|---|
legal_name | VARCHAR | Legal name of the corporation |
effective_date | DATE | Date when the 409A valuation becomes effective |
price | NUMBER | Fair market value price per share |
currency_code | VARCHAR | Currency code for the price (e.g., USD, EUR) |
expiration_date | DATE | Date when the 409A valuation expires |
stale_date | DATE | Date when the 409A valuation becomes stale |
is_common | BOOLEAN | Boolean indicating if this valuation applies to common stock |
source | VARCHAR | Source of the valuation report |
_pk | VARCHAR | Surrogate primary key generated from fmv_id and corporation_uuid |
corporation_id | NUMBER | Unique identifier for the corporation |
corporation_uuid | VARCHAR | UUID identifier for the corporation |
fmv_id | NUMBER | Unique identifier for the 409A fair market value record |
report_id | NUMBER | Unique identifier for the valuation report |
share_class_id | NUMBER | Unique identifier for the share class |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
All journal entries in the general ledger. This table has a primary key of "journal_entry_id". The "firm_id" and "fund_uuid" columns are foreign keys that can be used to join with other tables. Pagination sort: fund_name, effective_date DESC, journal_entry_line_id
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
account_name | VARCHAR | The name of the account related to the journal entry. |
effective_date | DATE | The date at which the journal entry is effective. |
posted_date | TIMESTAMP_NTZ | The date at which the journal entry was posted. |
firm_name | VARCHAR | Name of the investment firm. |
journal_entry_id | VARCHAR | Unique identifier for each journal entry in the general ledger |
amount | NUMBER | Amount of the journal entry. |
base_currency_amount | NUMBER | Amount of the journal entry in the base currency. |
base_currency_code | VARCHAR | Currency code for the base currency of the journal entry. |
account_type | NUMBER | The code used to identify the type of the account related to the journal entry. |
normal_balance | VARCHAR | The normal balance of the account related to the journal entry, indicating whether it is a debit or credit account. |
account_description | VARCHAR | A description of the account related to the journal entry. |
journal_entry_description | VARCHAR | A description of the journal entry that may capture additional context about the journal entry. |
event_type | VARCHAR | The type of event that triggered the journal entry. |
reporting_tags | VARCHAR | Comma-separated list of all reporting tags associated with this journal entry line. |
reporting_tags_json | OBJECT | JSON object containing reporting tags grouped by category name, with each category containing an array of tag names. |
partner_name | VARCHAR | Name of the partner associated with this journal entry line |
partner_entity_type | VARCHAR | Entity type of the partner (e.g., individual, corporation, LLC) |
partner_organization_name | VARCHAR | LP organization name associated with the partner |
vendor_name | VARCHAR | Name of the vendor associated with this journal entry line |
vendor_type | VARCHAR | Type classification of the vendor |
expense_type | VARCHAR | Expense classification for the vendor |
asset_name | VARCHAR | Name of the asset associated with this journal entry line |
issuer_name | VARCHAR | Name of the issuer (company) associated with the asset |
bank_transaction_reference | VARCHAR | Reference identifier for the bank transaction |
bank_name | VARCHAR | Name of the bank associated with the transaction |
bank_account_name | VARCHAR | Name of the bank account associated with the transaction |
bank_account_type | VARCHAR | Type of the bank account (e.g., checking, savings) |
journal_entry_line_id | VARCHAR | Unique identifier for each journal entry line in the general ledger |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
partner_id | NUMBER | Foreign key to the capital account partner associated with this journal entry line |
vendor_id | VARCHAR | Foreign key to the vendor associated with this journal entry line |
asset_id | VARCHAR | Foreign key to the asset associated with this journal entry line |
bank_txn_id | VARCHAR | Foreign key to the bank transaction associated with this journal entry line |
related_entity_id | NUMBER | Foreign key to a related entity (from lp_crm_crmentity) associated with this journal entry line |
issuer_id | VARCHAR | Unique identifier for the issuer |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
fund_id | NUMBER | Unique identifier for the fund. Used as both a primary key and a foreign key. |
Loan-level data for credit and lending products. One row per loan with cached counterparty names, key dates, committed and outstanding principal balances, and an is_active flag. total_committed_amount sums all tranche contributions across the loan. outstanding_principal reflects the current borrower-level principal balance across the loan's advances; when a loan is in default, default-type balances supersede regular interest-type balances on the same principal base. Pagination sort: loanname, closing_date DESC, pk
| Column | Type | Description |
|---|---|---|
loan_name | VARCHAR | Loan name. |
borrower_name | VARCHAR | Cached borrower company name. |
lending_firm_name | VARCHAR | Cached lending firm name. |
closing_date | DATE | Loan closing date. |
total_committed_amount | NUMBER | Sum of contribution amounts across all tranches in the loan. 0 for loans with no tranche contributions yet. |
outstanding_principal | NUMBER | Current borrower-level outstanding principal balance, summed across the loan's advances (default-type balances supersede interest-type when both exist for the same period). NULL for loans with no recorded payment obligations yet. |
currency_code | VARCHAR | Unified currency code across the loan's tranche contributions. NULL when contributions span multiple currencies (mixed-currency loan) or when the loan has no tranche contributions yet. |
tranche_count | NUMBER | Number of tranches in the loan. |
lender_count | NUMBER | Number of unique lenders contributing to the loan. |
lead_lender_name | VARCHAR | Cached lead lender name. |
agent_name | VARCHAR | Cached agent name. |
created_at | TIMESTAMP_NTZ | Timestamp when the loan record was created. |
updated_at | TIMESTAMP_NTZ | Timestamp of the most recent update to the loan record. |
is_active | BOOLEAN | Indicates whether the loan is currently active (no advances yet, draw period active, maturity not passed, or cash/PIK outstanding > 0). |
_pk | VARCHAR | Surrogate primary key generated from loan_id. |
lending_firm_id | VARCHAR | Lending firm UUID. Used to enforce row access policy. |
loan_id | VARCHAR | Unique identifier for the loan. |
borrower_id | VARCHAR | Borrower company UUID. |
lead_lender_id | VARCHAR | Lead lender company UUID. |
agent_id | VARCHAR | Agent company UUID. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
This model calculates the monthly Net Asset Value (NAV) for each fund, including contributions, distributions, commitments, and various NAV metrics. It aggregates data from fund allocations and journal entries to provide a comprehensive view of fund performance over time. The model includes metrics such as total NAV, LP and GP NAV, contributions, distributions, DPI, RVPI, TVPI, and MOIC. It also tracks cumulative contributions, distributions, and commitments for both LPs and GPs, providing insights into fund performance and partner contributions. Pagination sort: fund_name, month_end_date DESC
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
firm_name | VARCHAR | Name of the investment firm. |
month_start_date | DATE | The start date of the month for which NAV is calculated |
month_end_date | DATE | The end date of the month for which NAV is calculated |
entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV, ...). |
beginning_total_nav | NUMBER | The NAV at the beginning of the month |
total_contributions | NUMBER | Capital contributions made during the month |
total_distributions | NUMBER | Capital distributions made during the month |
ending_total_nav | NUMBER | The NAV at the end of the month |
beginning_lp_nav | NUMBER | The NAV of LPs at the beginning of the month |
lp_contributions | NUMBER | The LP contributions made during the month |
lp_distributions | NUMBER | The LP distributions made during the month |
ending_lp_nav | NUMBER | The NAV of LPs at the end of the month |
beginning_gp_nav | NUMBER | The NAV of GPs at the beginning of the month |
gp_contributions | NUMBER | The GP contributions made during the month |
gp_distributions | NUMBER | The GP distributions made during the month |
ending_gp_nav | NUMBER | The NAV of GPs at the end of the month |
cumulative_total_contributions | NUMBER | The cumulative contributions made to the fund since fund inception |
cumulative_total_distributions | NUMBER | The cumulative distributions made to the fund since fund inception |
cumulative_lp_contributions | NUMBER | The cumulative contributions made to LPs since fund inception |
cumulative_lp_distributions | NUMBER | The cumulative distributions made to LPs since fund inception |
cumulative_gp_contributions | NUMBER | The cumulative contributions made to GPs since fund inception |
cumulative_gp_distributions | NUMBER | The cumulative distributions made to GPs since fund inception |
month_commitment_amount | NUMBER | Total dollar amount of new commitment transactions recorded during this specific month. This represents new or adjusted commitments from partners in the given month. Includes all commitment transactions from active partners (is_active = 1), non-deleted transactions only (is_deleted = 0), transactions with valid dates falling within this month, and both positive commitments and negative adjustments. Note: Months with no commitment activity will show 0. This differs from contributions (capital calls), which represent actual cash movements. |
cumulative_commitment_amount | NUMBER | Running total of all commitment transaction amounts for active partners from fund inception through the end of this month. This represents the total committed capital at this point in time. Calculated as the sum of all month_commitment_amount values from fund inception through the current month using a window function with PARTITION BY fund_id. Includes all commitment transactions from active partners (is_active = 1), non-deleted transactions only (is_deleted = 0), and transactions with valid dates (transaction_date IS NOT NULL). Use cases include tracking growth of fund commitments over time, calculating capital call percentages (cumulative_contributions / cumulative_commitment_amount), and understanding remaining capital available for deployment. Note: For the most recent month, this should closely match the fund_size field in aggregate_fund_metrics. Small differences may occur if some commitment transactions lack transaction dates. |
total_value | NUMBER | The total value of the fund at the end of the month, including contributions and distributions |
lp_value | NUMBER | Month-end value attributable to limited partners (LP NAV plus cumulative distributions to LPs). |
gp_value | NUMBER | Month-end value attributable to general partners (GP NAV plus cumulative distributions to GPs). |
total_dpi | NUMBER | The Distributions to Paid-In (DPI) ratio for the fund, calculated as total distributions divided by total contributions |
lp_dpi | NUMBER | The Distributions to Paid-In (DPI) ratio for LPs, calculated as LP distributions divided by LP contributions |
total_rvpi | NUMBER | The Residual Value to Paid-In (RVPI) ratio for the fund, calculated as total NAV divided by total contributions |
lp_rvpi | NUMBER | The Residual Value to Paid-In (RVPI) ratio for LPs, calculated as LP NAV divided by LP contributions |
total_tvpi | NUMBER | The Total Value to Paid-In (TVPI) ratio for the fund, calculated as total value divided by total contributions |
lp_tvpi | NUMBER | The Total Value to Paid-In (TVPI) ratio for LPs, calculated as LP value divided by LP contributions |
total_moic | NUMBER | The Multiple on Invested Capital (MOIC) for the fund, calculated as total investment value divided by total investment cost using data from aggregate_investments_history. This differs from TVPI in that it uses investment-level cost basis rather than partner contributions. |
lp_moic | NUMBER | The Multiple on Invested Capital (MOIC) for LPs, calculated as LP value divided by LP contributions |
gp_moic | NUMBER | The Multiple on Invested Capital (MOIC) for GPs, calculated as GP value divided by GP contributions |
is_firm_rollup | BOOLEAN | Indicates if a given row is a rollup for the firm |
nav_pk | VARCHAR | Unique identifier for date and fund combination |
fund_id | NUMBER | Unique identifier for the fund. Used as both a primary key and a foreign key. |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Partner-level metrics and characteristics for both LPs and GPs, including commitments, contributions, and distributions. Pagination sort: fund_name, partner_name
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund the partner is associated with |
partner_name | VARCHAR | Legal name of the partner |
partner_created_at | TIMESTAMP_NTZ | Timestamp in UTC when partner record was created in Carta |
earliest_commitment_date | DATE | The date of the partner's first commitment transaction |
latest_commitment_transaction_date | DATE | The date of the partner's latest commitment transaction |
firm_name | VARCHAR | Name of the management firm |
firm_partner_group_name | VARCHAR | Name of the partner group, coalesced with partner name if no group is assigned |
commitment_size | NUMBER | Total capital committed by the partner to the fund |
partner_entity_type | VARCHAR | The legal entity type of the partner (e.g. corporation_c, corporation_s, estate, individual, etc.) |
count_active_lp_accounts | NUMBER | Number of active LP partner commitments associated with the partner |
organization_name | VARCHAR | Name of the organization the partner is associated with |
partner_class_name | VARCHAR | The fund's partner class the partner has a commitment in |
partner_class_description | VARCHAR | Description of the partner class |
partner_street_address | VARCHAR | Partner street address |
partner_city | VARCHAR | Partner address city |
partner_state | VARCHAR | Partner address state |
partner_country | VARCHAR | Partner address country |
wire_instructions_status | VARCHAR | Status of the wire instructions uploaded by the partner |
total_capital_commitment_amount_current | NUMBER | The partners current capital commitment to the fund. Partners that backed out would show up as 0, see total_capital_commitment_amount_max for the maximum commitment a partner had to the fund. |
total_capital_commitment_amount_max | NUMBER | The maximum capital commitment a partner had to the fund. |
primary_contact_email | VARCHAR | The primary contact email of the partner |
total_cap_contribution | NUMBER | Total capital contributed by partner to date |
total_mgmt_fees | NUMBER | Total management fees paid by partner to date |
total_capital_call_receivable | NUMBER | A partners capital call receivable balance |
total_distribution | NUMBER | Total distributions paid to partner to date |
total_opx | NUMBER | Total operating expenses allocated to partner |
total_net_realized | FLOAT | Net realized gains/losses allocated to partner |
total_net_unrealized | NUMBER | Net unrealized gains/losses allocated to partner |
total_distribution_payable | NUMBER | Distributions approved but not yet paid to partner |
total_deferred_cap_call | NUMBER | Capital calls approved but deferred for this partner |
total_carried_interest_accrued | NUMBER | Carried interest allocated to partner (typically for GPs) |
total_contributions_outside_commitment | NUMBER | Additional contributions beyond original commitment amount |
total_net_asset_balance | NUMBER | The net asset balance allocated to the partner |
total_net_operating_income_llc_interest | NUMBER | Total net operating income allocated to the partner's LLC interest. |
total_distribution_llc_interest | NUMBER | Total distributions allocated to the partner's LLC interest. |
total_in_kind_distribution_llc_interest | NUMBER | Total in-kind distributions allocated to the partner's LLC interest. |
total_syndication_costs_llc_interest | NUMBER | Total syndication costs allocated to the partner's LLC interest. |
sent_date | TIMESTAMP_NTZ | Timestamp in UTC of when the commitment was sent to the partner for acceptance into their portfolio |
wire_confirmation_date | TIMESTAMP_NTZ | Timestamp in UTC when the wire information was confirmed by the partner. This is typically the date the partner signed off on their wire instructions. |
wire_instructions_added_date | TIMESTAMP_NTZ | Timestamp in UTC when the wire information was added by the partner. |
latest_w8_w9 | DATE | Date of the most recently received W-8 or W-9 tax form for the partner. |
send_capital_calls_notices | BOOLEAN | Flag indicating if partner should receive capital call notices |
is_active | BOOLEAN | Flag indicating if partner is currently active in the fund |
is_limited_partner | BOOLEAN | Flag indicating if partner is a limited partner (LP) |
is_general_partner | BOOLEAN | Flag indicating if partner is a general partner (GP) |
has_confirmed_wire_instructions | BOOLEAN | Flag indicating if the partner has confirmed wire instructions |
has_wire_setup | BOOLEAN | Flag indicating if the partner has setup wire information |
has_w8_w9 | BOOLEAN | Has a W8/W9 on file |
partner_id | NUMBER | Unique identifier for each partner, used as primary key |
external_partner_id | VARCHAR | ID added by firm as an external identifier to join 3rd party data |
firm_partner_group_id | NUMBER | Identifier of the partner group this partner belongs to within the firm |
partner_entity_id | VARCHAR | Unique identifier for partner's portfolio |
fund_uuid | VARCHAR | Unique identifier of the fund the partner is associated with |
organization_id | VARCHAR | Unique identifier of the organization the partner is associated with |
tax_id_type | VARCHAR | Type of tax identifier on file for the partner. |
firm_id | VARCHAR | Unique identifier of the management firm |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
has_wire_instruction_reference | BOOLEAN | Flag indicating if the partner has a wire instruction reference |
This model calculates the monthly Net Asset Value (NAV) at the partner level for each fund. It provides a detailed breakdown of NAV, contributions, distributions, commitments, and performance metrics (DPI, RVPI, TVPI, MOIC) for each individual partner. When aggregated by fund, the results should match the fund-level calculations in monthly_nav_calculations (excluding firm rollup records). This model enables partner-level analysis and is particularly useful for fund-of-funds reporting and custom partner-level analytics. Pagination sort: fund_name, partner_name, month_end_date DESC
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund |
partner_name | VARCHAR | Name of the partner |
month_start_date | DATE | First day of the month for this NAV calculation |
month_end_date | DATE | Last day of the month for this NAV calculation |
entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV) |
firm_name | VARCHAR | Name of the management firm |
is_limited_partner | BOOLEAN | True if the partner is a limited partner, otherwise false |
is_general_partner | BOOLEAN | True if the partner is a general partner, otherwise false |
partner_class_name | VARCHAR | Partner class name for classification (e.g., "Class A", "Founder Class") |
partner_class_description | VARCHAR | Detailed description of the partner class |
firm_partner_group_name | VARCHAR | Name of the partner group (defaults to partner name if no group assigned) |
is_active | BOOLEAN | True if the partner is currently active, otherwise false |
beginning_total_nav | NUMBER | Partner's NAV at the beginning of the month |
total_contributions | NUMBER | Partner's total contributions during the month |
total_commitment | NUMBER | Partner's commitment amount for the month |
total_distributions | NUMBER | Partner's total distributions during the month |
ending_total_nav | NUMBER | Partner's NAV at the end of the month |
cumulative_total_contributions | NUMBER | Partner's cumulative contributions from inception through the end of the month |
cumulative_total_commitment | NUMBER | Partner's cumulative commitment amount through the end of the month |
cumulative_total_distributions | NUMBER | Partner's cumulative distributions from inception through the end of the month |
total_value | NUMBER | Partner's total value (ending NAV + cumulative distributions) |
total_dpi | NUMBER | Partner's Distributions to Paid-In capital ratio (cumulative distributions / cumulative contributions) |
total_rvpi | NUMBER | Partner's Residual Value to Paid-In capital ratio (ending NAV / cumulative contributions) |
total_tvpi | NUMBER | Partner's Total Value to Paid-In capital ratio (total value / cumulative contributions) |
total_moic | NUMBER | Partner's Multiple on Invested Capital (total value / cumulative contributions) |
partner_nav_pk | VARCHAR | Unique identifier for partner, fund, firm, and date combination (surrogate key on partner_id, fund_uuid, firm_id, month_end_date) |
fund_id | VARCHAR | Unique identifier (UUID) for the fund |
partner_id | NUMBER | Unique identifier for the partner |
partner_entity_id | VARCHAR | Unique identifier for the partner's legal entity |
firm_partner_group_id | NUMBER | Unique identifier for the partner group within the firm |
firm_id | VARCHAR | Unique identifier for the management firm |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Events relating to a firm's portfolio of investments Pagination sort: event_date DESC, fund_name, corporation_name
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the fund. |
corporation_name | VARCHAR | The name of the Carta cap table customer related to the portfolio event. |
event_date | TIMESTAMP_NTZ | The date of the portfolio event. |
event_type | VARCHAR | The type of the portfolio event. Possible values include: "New priced round", "New share class", "Company name changed", "Stock split", "Valuation finalized", "Valuation amended", "Valuation deleted", "Certificate issuance", "Convertible conversion", "Warrant exercise", "Share class conversion", "Certificate transfer". |
description | VARCHAR | A description of the portfolio event that is relevant to the event type. |
security_label | VARCHAR | The label of the security related to the portfolio event in instances of security-related events. |
security_kind | VARCHAR | The kind of security related to the portfolio event in instances of security-related events. |
firm_name | VARCHAR | Name of the investment firm. |
additional_details | VARIANT | Structured data about the portfolio event that is relevant to the event type. This data is provided as a JSON string. |
event_uuid | VARCHAR | Unique identifier for each newsfeed event |
fund_id | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
corporation_id | VARCHAR | Unique identifier of the associated corporation (company / portfolio). Primary key for corporations. Might be the same as core_legal_entities.entity_id, but is not guaranteed to be the same. The keys match if the corporation was imported into the legal entity framework as a part of the initial bulk import. It will be different if the corporation was created or updated after the initial import. |
issuer_uuid | VARCHAR | Unique identifier of the issuer from the general ledger (GL). Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Portfolio notes created by investment firm users about their portfolio companies. Includes both general notes and review notes with optional ratings. Grain: one row per note. Notes are scoped to organizations (investment firms) and their portfolio corporations. Filters applied: voided notes are excluded, deleted notes are excluded, and only notes with Organization-level sharing permission are included. Pagination sort: createdat DESC, corporation_name, pk
| Column | Type | Description |
|---|---|---|
organization_name | VARCHAR | Name of the investment firm/organization that owns the note |
corporation_name | VARCHAR | Name of the portfolio company the note is about. Uses fallback logic: portfolio corporation name → corporations table legal name. |
note_type_name | VARCHAR | Type of note - either "General Note" for regular notes or "Review Note" for periodic review notes with ratings |
sharing_permission_name | VARCHAR | Visibility level of the note. In this table, all rows have the value "Organization" (only organization-wide notes are included). Possible values in the source system: "Personal" (author only), "Investment Team", "Organization" (all organization members). |
note_body | VARCHAR | Plain text content of the note |
note_rich_body | VARIANT | Rich text content of the note in JSON format |
note_rich_body_text | VARCHAR | Plain text extracted from the note_rich_body JSON. Concatenates all text blocks from the JSON structure with newlines. Null when note_rich_body is null. |
rating | NUMBER | Optional rating from 1-5 for review notes. Null for general notes or review notes without a rating. |
author_name | VARCHAR | Full name of the user who created the note |
author_email | VARCHAR | Email address of the note author |
created_at | TIMESTAMP_NTZ | Timestamp when the note was created |
modified_at | TIMESTAMP_NTZ | Timestamp when the note was last modified |
_pk | VARCHAR | Surrogate primary key generated from note_id |
note_id | NUMBER | Original note ID from insights_note table |
firm_id | VARCHAR | UUID of the investment firm/organization (aliased as firm_id per product standard) |
corporation_id | VARCHAR | UUID of the portfolio corporation (aliased as corporation_id per product standard) |
entity_link_id | VARCHAR | External entity link identifier linking this corporation to entities. Used for joining with other data. May be null if the corporation is not linked to an entity. |
general_ledger_issuer_id | VARCHAR | General ledger issuer identifier for accounting system integration. Used for joining with investment and financial data. May be null if the corporation is not linked to a general ledger issuer. |
author_id | NUMBER | User ID of the note author |
time_period_id | NUMBER | Reference to time period for review notes. Null for general notes. |
_loaded_at | TIMESTAMP_NTZ | Most recent source data load timestamp. Calculated as maximum of note and portfolio corporation load times. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp of dbt model execution |
One row per finalized Portfolio Valuation (valuation candidate with status = 'FINAL'). Captures the full enterprise-value snapshot at finalization: methodologies, financials, allocation method, and total firm holdings value. Pagination sort: targetname, valuation_date DESC, pk
| Column | Type | Description |
|---|---|---|
valuation_date | DATE | Valuation date (internal valuation project's valuation_date). |
target_type | VARCHAR | Carta cap table platform used by the portfolio company. One of CORPORATION or LLC_ISSUER. |
target_name | VARCHAR | Legal name of the portfolio company being valued. Populated for CORPORATION (via corporation legal name), CORPORATION_ENTITY_GROUP (via entity group name), and LLC_ISSUER (via LLC entity legal name). NULL only when no matching record exists. |
name | VARCHAR | Valuation name (e.g., "Q1 2026 Valuations") — the valuation candidate's name. |
target_value | NUMBER | Total portfolio company value after discounts. |
selected_methodologies | VARCHAR | Comma-separated list of enterprise value calculation methods used (Backsolve, DCF, GPC, M&A, Post Money, Other Indication of Value). |
dlom_method | VARCHAR | Discount rate calculation method. One of: FINNERTY, CUSTOM_DLOM, CHAFFE. |
ltm_revenue | NUMBER | Last twelve months of revenue. |
ltm_ebitda | NUMBER | Last twelve months of EBITDA. |
ntm_revenue | NUMBER | Next twelve months of revenue. |
ntm_ebitda | NUMBER | Next twelve months of EBITDA. |
cash_and_cash_equivalents | NUMBER | Last twelve months total cash and cash equivalents on the valuation financials. |
non_convertible_debt | NUMBER | Last twelve months total non-convertible debt on the valuation financials. |
allocation_methodology | VARCHAR | Allocation method used to calculate holdings value. Accepted values: WATERFALL, OPTION_PRICING_MODEL, COMMON_STOCK_EQUIVALENT, NIAGARA_WATERFALL, NIAGARA_OPM. |
total_holdings_value | NUMBER | Total firm holdings value after discounts. |
finalized_at | DATE | Date when the valuation was finalized. |
_pk | VARCHAR | Surrogate primary key. |
firm_id | VARCHAR | Firm UUID. Used to enforce row access policy. |
target_id | VARCHAR | Identifier of the portfolio company. Corporation UUID when target_type = CORPORATION; otherwise the upstream UUID (entity group or LLC interest issuer). Used to enforce row access policy. |
valuation_id | NUMBER | Unique identifier of the valuation project. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
Row access policy currently resolves onlytarget_type = 'CORPORATION'. Rows wheretarget_type = 'LLC_ISSUER'or'CORPORATION_ENTITY_GROUP'carry non-corporation UUIDs intarget_idand are not yet visible to PE-firm users; coverage for these target types is planned.
This model aggregates statement of operations data, including fund and partner details, cost breakdowns, capital contributions, and unrealized gains/losses. Pagination sort: fund_name
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the investment fund |
cash | NUMBER | Cash balance across all bank and cash-equivalent accounts for the fund as of the reporting period. |
cost_management_fees | NUMBER | Fees paid to the fund manager for managing the investment fund. |
cost_all_other_expenses | NUMBER | Aggregated amount of miscellaneous fund-related expenses not categorized elsewhere. |
cost_tax_prep_fees | NUMBER | Fees related to preparing and filing fund-related tax returns. |
cost_fa_fees | NUMBER | Fees paid to the fund administrator for operational services. |
cost_legal_fees | NUMBER | Fees related to fund operations, compliance, and documentation. |
cost_filing_fees | NUMBER | Fees related to submitting regulatory or legal filings. |
cost_other_professional_fees | NUMBER | Fees paid to other professional services, including consultants and third-party advisors. |
cost_organization_costs | NUMBER | Expenses related to the initial formation and setup of the fund. |
cost_insurance_expense | NUMBER | Premiums paid for insurance policies covering fund assets or operations. |
cost_travel | NUMBER | Business travel expenses incurred by fund staff or management. |
cost_syndication_costs | NUMBER | Costs related to presenting investment opportunities to co-investors or limited partners. |
cost_software_and_technology | NUMBER | Costs related to technology tools and software used in fund operations. |
cost_dues_and_subscriptions | NUMBER | Membership dues or subscriptions relevant to fund management. |
cost_meal | NUMBER | Meal and entertainment expenses related to business activities. |
cost_market_expenses | NUMBER | Expenses associated with marketing, investor relations, and promotional activities. |
cost_accounting_expense | NUMBER | Professional accounting or bookkeeping service fees. |
cost_payroll_salary | NUMBER | Wages and compensation paid to fund employees or contractors. |
cost_events | NUMBER | Costs for hosting or attending business-related events or conferences. |
cost_audit | NUMBER | Audit-related fees paid to accounting firms for financial statement reviews. |
capital_contributed | NUMBER | Total capital that has been contributed by investors to the fund. |
capital_receivable | NUMBER | Committed capital from investors not yet received by the fund. |
capital_distributed | NUMBER | Capital that has been returned or distributed back to investors. |
unrealized_gain_loss | NUMBER | Change in fair value of investments that have not yet been sold or realized. |
fund_id | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Contains a summary cap table for each portco sourced from Carta's data warehouse materialized views. A summary cap table has 1 row per security class and contains the outstanding quantity, fully diluted quantity, authorized shares, cash raised, and ownership percentages. As of date is the date when the information was last updated by Carta in the data warehouse. Pagination sort: legal_name, security_class_name
| Column | Type | Description |
|---|---|---|
legal_name | VARCHAR | Legal name of the company |
security_class_name | VARCHAR | Name of the shareclass, note block, warrant block, or option pool |
as_of_date | TIMESTAMP_NTZ | The date when the cap table information was last loaded from Carta's data warehouse |
security_class_type | VARCHAR | Type of security class, e.g. warrant_block, option_plan, note_block, share_class |
security_class_type_detailed | VARCHAR | Detailed type of security class, e.g. Common warrant, Option plan, Convertible debt, Common, Preferred, SAFE, Preferred warrant, Convertible security |
as_converted_shareclass_name | VARCHAR | The name of the share class that the security will ultimately convert into upon exercise/settlement |
as_converted_sharclass_stock_type | VARCHAR | The stock type of the share class that the security will ultimately convert into upon exercise/settlement. e.g. Preferred or Common |
outstanding_shares | NUMBER | The number of shares that are outstanding. Will only be non-zero for share classes |
outstanding_warrants | NUMBER | The number of warrants that are outstanding. Will only be non-zero for warrant blocks |
outstanding_equity_award_derivatives | NUMBER | The number of equity award derivatives that are outstanding. Will only be non-zero for option pools |
outstanding_committed_rsas | NUMBER | The number of RSAs approved by the board but not yet purchased by the recipient |
plan_size | NUMBER | The total number of shares available under the plan. Will only be non-zero for option pools |
shares_available_under_plan | NUMBER | The number of shares available under the plan. Will only be non-zero for option pools |
fully_diluted_quantity | NUMBER(24,10) | The total number of securities on a fully diluted basis including all outstanding shares, warrants, options, and convertible securities |
authorized_shares | NUMBER | The number of shares that have been authorized by the board of directors. Will only be non-zero for share classes and option plans |
fully_diluted_ownership | NUMBER | The ownership percentage on a fully diluted basis, calculated as the fully diluted quantity divided by the total fully diluted shares for the corporation |
principal | OBJECT | The total principal amount in a noteblock as an OBJECT type with currency codes as keys and amounts as values. Example format - USD key with numeric value |
interest | OBJECT | The total interest amount in a noteblock as an OBJECT type with currency codes as keys and amounts as values. Example format - USD key with numeric value |
cash_raised | OBJECT | The total amount of cash raised by the security class as an OBJECT type with currency codes as keys and amounts as values. Example format - USD key with numeric value |
note_block_prefix | VARCHAR | Prefix identifier for note blocks |
warrant_block_prefix | VARCHAR | Prefix identifier for warrant blocks |
conversion_ratio | NUMBER | The conversion ratio of a shareclass, warrant, or option plan showing how many common shares each security converts into |
original_issue_price | NUMBER | Original Issue Price (OIP). Generally, this is the price paid by an investor when participating in a round. Without any other liquidation preferences, this is the amount that the investor would receive before common. If the preferred shareclass would convert into common if it would receive more money doing so. For warrants, this applies to the OIP of the as converted share class. |
conversion_price | NUMBER | Conversion Price. OIP / conversion_price = number of common shares the shareholder would receive if the stock converted to common. For example if OIP = 1 and conversion_price = .5, the shareholder would receive 2 shares of common. This calculation also affects the fully diluted shares of a company. This is overridden by conversion_ratio if it is present. |
preference_cap | NUMBER | Shareclass Preference Cap. Waterfall input. OIP preference_cap is the amount of liquidation preference the shareholder will participate alongside common after the OIP Multiplier has been paid out and before converting into common. |
multiplier | NUMBER | Shareclass Multiplier. This is a waterfall input and only used on preferred stock types. In the event of a liquidation, the holder of the stock will receive OIP * Multiplier based on the seniority before common starts to participate. |
seniority | NUMBER | Seniority is the order in which the preferred shareclasses are paid out. By default (seniority_is_inverted = false), shareclasses with a seniority of 1 are paid out first. If seniority_is_inverted = true, shareclasses with a seniority of 1 are paid out last. |
dividend_type | VARCHAR | Dividend Type. Can either be Cumulative or Non-Cumulative. If a dividend is cumulative it means that dividends accrue over time. In the event of a liquidation, the unpaid dividends are added to the investor's liquidation preference before paying out common. Non-cumulative dividends don't accrue and just protect the investors from the company trying to declare a dividend on just the common shareclass. |
dividend_coupon | NUMBER | Annual dividend percentage of the dividend rights (7.00 = 7%). The percentage is multiplied with the OIP to arrive at a dollar value. |
dividend_accrual | VARCHAR | Dividend Accrual is a time period such as daily or annually which defines when dividends are accrued. This has no effect on the dividend_coupon which is annual. |
interest_compounding_period | VARCHAR | Interest Compounding Period is how often the dividend is compounded. |
first_board_approval_date | DATE | Date when the board first approved this option plan. Only populated for option_plan security class types |
termination_date | DATE | Date when this option plan was terminated. Only populated for option_plan security class types |
participating_preferred | BOOLEAN | Shareclass Participating Preferred. Waterfall input. If true, the shareholder will receive the OIP * Multiplier and participating_preferred alongside common after the preferences have been paid. The participation is limited by preference_cap. |
is_compounding | BOOLEAN | Is Compounding indicator. When true, dividend interest is calculated by using the OIP + cumulative accrued dividends to date. |
_pk | VARCHAR | Unique identifier which is a surrogate key of corporation_uuid, as_of_date, security_class_id |
corporation_id | VARCHAR | Unique identifier of the corporation |
security_class_id | VARCHAR | Unique identifier of the security class. Is prefixed with SC- for share classes, WC- for warrant blocks, OP- for option pools, and NB- for note blocks |
as_converted_shareclass_id | NUMBER | The share class that the security will ultimately convert into upon exercise/settlement |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
This model aggregates temporal deal IRR metrics for investments by fund. Looks at deal_irr on the asset level, not the portfolio company level. Pagination sort: fund_name, issuer_name, performance_quarter_end_date DESC
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | Name of the investment fund. |
issuer_name | VARCHAR | Name of the issuer |
performance_quarter_end_date | DATE | End date of the performance quarter |
firm_name | VARCHAR | Name of the investment firm. |
issuer_entity_type | VARCHAR | Entity type of the issuer |
issuer_domicile_country | VARCHAR | Domicile country of the issuer |
earliest_investment_date | DATE | Earliest investment date for the asset |
remaining_value | NUMBER | Remaining value of the investment |
cost_basis | NUMBER | Cost basis of the investment |
total_cost | NUMBER | Total cost of the investment |
deal_irr | FLOAT | Deal IRR value |
pk | VARCHAR | Unique identifier composed of fund_uuid, issuer_id, and performance_quarter_end_date |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
fund_id | VARCHAR | Unique identifier for the fund. Used as a foreign key. |
issuer_id | VARCHAR | Unique identifier of the issuer from the general ledger (GL). Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
Time-series benchmarks tracking fund performance metrics (DPI, TVPI, Net IRR, MOIC, LP DPI, LP TVPI, Net LP IRR) by cohort over time. Fund-level metrics are sourced from fund_performance_metrics_history and benchmark percentiles come from the verified benchmark models (dpi, tvpi, net_irr, moic, lp_dpi, lp_tvpi, net_lp_irr). Pagination sort: fund_name, performance_quarter_start_date DESC
| Column | Type | Description |
|---|---|---|
fund_name | VARCHAR | The name of the fund |
performance_quarter_start_date | DATE | Quarter-start date for which metrics are calculated |
vintage_year | NUMBER | Fund's vintage year for cohort grouping |
fund_aum_bucket | VARCHAR | Fund size category for peer grouping |
entity_type_name | VARCHAR | Legal structure classification of the fund entity (e.g., Fund, SPV, ...). |
net_irr | FLOAT | Net internal rate of return (IRR) for the fund |
moic | FLOAT | Multiple on invested capital (MOIC). Calculated as total value / total cost |
tvpi | FLOAT | Total value to paid-in (TVPI) capital ratio |
dpi | FLOAT | Distributions to paid-in (DPI) capital ratio |
lp_dpi | FLOAT | LP-only distributions to paid-in (DPI) capital ratio |
lp_tvpi | FLOAT | LP-only total value to paid-in (TVPI) capital ratio |
net_lp_irr | FLOAT | Net internal rate of return (IRR) for the fund's LPs |
fund_count | NUMBER | Number of funds in the benchmark cohort |
dpi_5 | FLOAT | 5th percentile DPI in cohort |
dpi_10 | FLOAT | 10th percentile DPI in cohort |
dpi_25 | FLOAT | 25th percentile DPI in cohort |
dpi_50 | FLOAT | Median DPI in cohort |
dpi_75 | FLOAT | 75th percentile DPI in cohort |
dpi_90 | FLOAT | 90th percentile DPI in cohort |
dpi_95 | FLOAT | 95th percentile DPI in cohort |
tvpi_5 | FLOAT | 5th percentile TVPI in cohort |
tvpi_10 | FLOAT | 10th percentile TVPI in cohort |
tvpi_25 | FLOAT | 25th percentile TVPI in cohort |
tvpi_50 | FLOAT | Median TVPI in cohort |
tvpi_75 | FLOAT | 75th percentile TVPI in cohort |
tvpi_90 | FLOAT | 90th percentile TVPI in cohort |
tvpi_95 | FLOAT | 95th percentile TVPI in cohort |
net_irr_5th | FLOAT | 5th percentile net IRR in cohort |
net_irr_10th | FLOAT | 10th percentile net IRR in cohort |
net_irr_25th | FLOAT | 25th percentile net IRR in cohort |
net_irr_50th | FLOAT | Median net IRR in cohort |
net_irr_75th | FLOAT | 75th percentile net IRR in cohort |
net_irr_90th | FLOAT | 90th percentile net IRR in cohort |
net_irr_95th | FLOAT | 95th percentile net IRR in cohort |
moic_5 | FLOAT | 5th percentile MOIC in cohort |
moic_10 | FLOAT | 10th percentile MOIC in cohort |
moic_25 | FLOAT | 25th percentile MOIC in cohort |
moic_50 | FLOAT | Median MOIC in cohort |
moic_75 | FLOAT | 75th percentile MOIC in cohort |
moic_90 | FLOAT | 90th percentile MOIC in cohort |
moic_95 | FLOAT | 95th percentile MOIC in cohort |
lp_dpi_5 | FLOAT | 5th percentile LP DPI in cohort |
lp_dpi_10 | FLOAT | 10th percentile LP DPI in cohort |
lp_dpi_25 | FLOAT | 25th percentile LP DPI in cohort |
lp_dpi_50 | FLOAT | Median LP DPI in cohort |
lp_dpi_75 | FLOAT | 75th percentile LP DPI in cohort |
lp_dpi_90 | FLOAT | 90th percentile LP DPI in cohort |
lp_dpi_95 | FLOAT | 95th percentile LP DPI in cohort |
lp_tvpi_5 | FLOAT | 5th percentile LP TVPI in cohort |
lp_tvpi_10 | FLOAT | 10th percentile LP TVPI in cohort |
lp_tvpi_25 | FLOAT | 25th percentile LP TVPI in cohort |
lp_tvpi_50 | FLOAT | Median LP TVPI in cohort |
lp_tvpi_75 | FLOAT | 75th percentile LP TVPI in cohort |
lp_tvpi_90 | FLOAT | 90th percentile LP TVPI in cohort |
lp_tvpi_95 | FLOAT | 95th percentile LP TVPI in cohort |
net_lp_irr_5th | FLOAT | 5th percentile net LP IRR in cohort |
net_lp_irr_10th | FLOAT | 10th percentile net LP IRR in cohort |
net_lp_irr_25th | FLOAT | 25th percentile net LP IRR in cohort |
net_lp_irr_50th | FLOAT | Median net LP IRR in cohort |
net_lp_irr_75th | FLOAT | 75th percentile net LP IRR in cohort |
net_lp_irr_90th | FLOAT | 90th percentile net LP IRR in cohort |
net_lp_irr_95th | FLOAT | 95th percentile net LP IRR in cohort |
_perf_pk | VARCHAR | Primary key for performance metrics table |
fund_uuid | VARCHAR | Unique identifier for the fund. Used as both a primary key and a foreign key. |
firm_id | VARCHAR | Unique identifier for the management firm. Used as both a primary key and a foreign key. |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution |
One row per saved Waterfall Modeling mark (PortfolioValuationMark). Captures the exit-scenario snapshot at the time the waterfall was saved: target, exit value, and total firm holdings value attached to the mark. Pagination sort: targetname, exit_date DESC, pk
| Column | Type | Description |
|---|---|---|
exit_date | DATE | Waterfall exit date (mark's effective_date). |
target_type | VARCHAR | Mark's target_kind. One of CORPORATION, CORPORATION_ENTITY_GROUP, LLC_ISSUER, or LLC_ACCOUNT (the latter for multi-entity LLC waterfalls). |
target_name | VARCHAR | Legal name of the portfolio company being valued. Resolved by target_type — CORPORATION from corporation legal name; CORPORATION_ENTITY_GROUP from entity group name; LLC_ISSUER from LLC entity legal name; LLC_ACCOUNT from LLC account name (may include a firm-specific suffix such as "(EQT Paper Company)"). NULL only when no matching record exists. |
exit_value | NUMBER | Waterfall exit value. |
total_holdings_value | NUMBER | Total firm holdings value attached to this mark. 0 when the firm's administered funds receive no allocation in this scenario (e.g. when the exit value is below the liquidation preference stack so subordinate funds get zeroed out). |
_pk | VARCHAR | Surrogate primary key. |
firm_id | VARCHAR | Firm UUID. Used to enforce row access policy. |
target_id | VARCHAR | Identifier of the portfolio company. Corporation UUID when target_type = CORPORATION; otherwise the upstream UUID (entity group, LLC interest issuer, or LLC account). Used to enforce row access policy. |
waterfall_id | VARCHAR | Mark's source_id (scenario waterfall execution id for legacy WATERFALL_EXECUTION marks; execution graph id for NIAGARA_V4_WATERFALL_EXECUTION marks). |
last_refreshed_at | TIMESTAMP_LTZ | Timestamp indicating when this data was last refreshed during dbt execution. |
Row access policy currently resolves onlytarget_type = 'CORPORATION'. Rows wheretarget_type = 'LLC_ISSUER','CORPORATION_ENTITY_GROUP', or'LLC_ACCOUNT'(multi-entity LLC waterfalls) carry non-corporation UUIDs intarget_idand are not yet visible to PE-firm users; coverage for these target types is planned.
Updated 8 days ago