Investments

AGGREGATE_INVESTMENTS

Details for all investments made by funds, tracking cost basis, current value, and investment characteristics.

Column Name	Data Type	Description
`FIRM_ID`	TEXT	Unique identifier for the management firm.
`FUND_NAME`	TEXT	Name of the fund.
`FUND_UUID`	TEXT	Unique identifier for the fund.
`FUND_ENTITY_TYPE_NAME`	TEXT	Legal structure classification of the fund entity (e.g., Fund, SPV, ...).
`FIRM_NAME`	TEXT	Name of the investment firm.
`FUND_INVESTMENT_KEY`	TEXT	Unique identifier for each fund-investment combination.
`GENERAL_LEDGER_ISSUER_ID`	TEXT	Unique identifier of the issuer from the general ledger (GL).
`GENERAL_LEDGER_ASSET_ID`	TEXT	Unique identifier for the asset in the general ledger.
`GENERAL_LEDGER_ASSET_CLASS_ID`	TEXT	Classification identifier for the investment asset type.
`MOST_RECENT_GENERAL_LEDGER_FUND_JOURNAL_ENTRY_ID`	TEXT	Identifier for the most recent journal entry affecting this investment.
`MOST_RECENT_JOURNAL_ENTRY_UUID`	TEXT	UUID of the most recent journal entry for tracking updates.
`MOST_RECENT_EVENT_KEY`	TEXT	Identifier for the most recent event affecting the investment.
`ENTITY_LINK_ID`	TEXT	Reference ID linking to related entity information.
`ISSUER_NAME`	TEXT	Name of the issuer from the general ledger (GL).
`ASSET_CLASS_TYPE`	TEXT	Classification of the investment (e.g., `PREFERRED_EQUITY`, `CONVERTIBLE_DEBT`, `COMMON_EQUITY`, etc.).
`ASSET_NAME`	TEXT	Specific name or description of the investment asset (e.g., `SAFE`, `Series Seed`).
`CURRENCY_CODE`	TEXT	Currency denomination of the investment.
`MOST_RECENT_JOURNAL_ENTRY_TYPE`	TEXT	Type of the most recent transaction affecting the investment (e.g., `NEW_INVESTMENT`, `VALUATION`).
`ISSUER_ENTITY_TYPE`	TEXT	Legal structure of the issuing entity.
`ISSUER_DOMICILE_COUNTRY`	TEXT	Country where the issuing entity is domiciled.
`IS_INVESTMENT_IN_FUND`	BOOLEAN	Flag indicating if investment is in another fund (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.
`TAGS`	TEXT	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.
`IS_CARTA_CUSTOMER`	BOOLEAN	Indicates if the corporation is a Carta customer. Non-Carta companies are sometimes referred to as "paper companies".
`IS_FOREIGN_CURRENCY_INVESTMENT`	BOOLEAN	Flag indicating if investment is denominated in foreign currency.
`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.
`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.
`RESIDUAL_GAIN_LOSS`	NUMBER	Adjustment for reconciling cost basis with actual gains/losses.
`HAS_REALIZATION`	BOOLEAN	Flag indicating if investment has had any realizations.
`LAST_REFRESHED_AT`	DATE	Timestamp (UTC) indicating when this data was last refreshed during data pipeline execution.

AGGREGATE_INVESTMENTS_HISTORY

This table provides a time series view of investments made by funds, tracking attributes like cost basis, current value, and investment characteristics over time. It has an effective_date and next_effective_date dictating the range of dates the status was effective.

FIELD NAME	DATA TYPE	DEFINITION
`_PK`	TEXT	Primary key for investment history table.
`FIRM_ID`	TEXT	Unique identifier for the management firm. Used as both a primary key and a foreign key.
`FUND_NAME`	TEXT	Name of the fund.
`FUND_UUID`	TEXT	Unique identifier for the fund. Used as both a primary key and a foreign key.
`FUND_ENTITY_TYPE_NAME`	TEXT	Legal structure classification of the fund entity (e.g., Fund, SPV, ...).
`FIRM_NAME`	TEXT	Name of the investment firm.
`FUND_INVESTMENT_KEY`	TEXT	Unique identifier for each fund-investment combination.
`EFFECTIVE_DATE`	DATE	Effective date of the investment's status. Used with `next_effective_date` to get the status within a date range.
`NEXT_EFFECTIVE_DATE`	DATE	Next effective date of the investment's status. Used with `effective_date` to get the status within a date range.
`IS_CURRENT_STATE`	BOOLEAN	Flag indicating if the investment's status is the last in the time series (i.e., the current status).
`GENERAL_LEDGER_ISSUER_ID`	TEXT	Unique identifier of the issuer from the general ledger (GL). Used as both a primary key and a foreign key.
`GENERAL_LEDGER_ASSET_ID`	TEXT	Unique identifier for the asset in the general ledger. Used as both a primary key and a foreign key.
`GENERAL_LEDGER_ASSET_CLASS_ID`	TEXT	Classification identifier for the investment asset type.
`ENTITY_LINK_ID`	TEXT	Reference identifier linking to related entity information.
`ISSUER_NAME`	TEXT	Name of the investment issuer in the general ledger.
`ASSET_CLASS_TYPE`	TEXT	Classification of the investment (e.g., PREFERRED_EQUITY, FUND_INVESTMENT, WARRANTS, etc.).
`ASSET_NAME`	TEXT	Specific name or description of the investment asset.
`CURRENCY_CODE`	TEXT	Currency denomination of the investment.
`ISSUER_ENTITY_TYPE`	TEXT	Legal structure of the issuing entity (in uncommon cases where the issuer is a Fund/SPV/etc.).
`ISSUER_DOMICILE_COUNTRY`	TEXT	Country of domicile for the issuer.
`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.
`EVENT_TYPES`	TEXT	A comma-separated list of accounting event types that changed the asset on the effective date (e.g., "VALUATION", "NEW_INVESTMENT").
`IS_CARTA_CUSTOMER`	BOOLEAN	Indicates if the corporation is a Carta customer.
`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	The unrealized gain/loss, calculated as `(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 aggregate amount of capital invested (total cost basis) in the portfolio company.
`TOTAL_INTEREST_CAPITALIZED`	NUMBER	Cumulative amount of capitalized interest on the investment as of the effective date.
`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	The value of the remaining investment, calculated as `Remaining cost basis + unrealized gain/loss`.
`REMAINING_VALUE_PER_SHARE`	NUMBER	Calculated as `(remaining_value / count_remaining_shares)`.
`LAST_REFERRED_AT`	TIMESTAMP_LTZ	Timestamp indicating when this data was last refreshed during dbt execution.

COMPANY_FINANCIALS

Portfolio company financial and KPI data, including metrics from profit & loss statements, balance sheets, and cash flow reports.

Column Name	Data Type	Description
`_PK`	TEXT	Primary key for the company financials.
`INSTANCE_ID`	NUMBER	An instance represents a collection of data representing a given period.
`CORPORATION_ID`	TEXT	The Carta Corporation ID of the portfolio company.
`LEGAL_NAME`	TEXT	The legal name of the portfolio company.
`AS_OF_DATE`	TIMESTAMP_NTZ	The date the data was collected.
`IS_LATEST`	BOOLEAN	A flag indicating if this is the latest data point for a given metric during a given period.
`INSTANCE_TYPE`	TEXT	Whether the data point is an Estimate or Actual.
`REPORT_TYPE`	TEXT	Indicates if the data point is a Profit and Loss, Cash Flow, Balance Sheet, or KPI.
`NAME`	TEXT	The name of the metric.
`MNEMONIC`	TEXT	A short code for the metric name.
`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.
`FREQUENCY`	TEXT	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`	TEXT	The string value of the metric if it could not be represented as a float.
`CURRENCY`	TEXT	The currency of the metric.
`UNIT_TYPE`	TEXT	The unit type of the metric e.g. Dollar, Percentage, Ratio, Number.
`SOURCE_TYPE`	TEXT	The source type of the metric e.g. Direct Import, Xero, Excel Import.
`AGG_METHOD`	TEXT	The aggregation method of the metric e.g. Sum, Average, Max, Min.
`DATA_TYPE_DESCRIPTION`	TEXT	The description of the metric.
`FIRM_ID`	TEXT	Unique identifier for the management firm.
`FIRM_NAME`	TEXT	Name of the management firm.
`LAST_REFRESHED_AT`	DATE	Timestamp (UTC) indicating when this data was last refreshed during data pipeline execution.

CORPORATION_ENTITY_LINKS

A key mapping table that links Carta's General Ledger issuer ID with the corresponding corporation ID.

Column Name	Data Type	Description
`FIRM_ID`	TEXT	Unique identifier for the management firm.
`GENERAL_LEDGER_ISSUER_ID`	TEXT	Unique identifier for the issuer found in the general ledger.
`CORPORATION_ID`	TEXT	Unique identifier for the corporation.
`IS_CARTA_CUSTOMER`	BOOLEAN	Indicates if the corporation is a Carta customer.
`LAST_REFRESHED_AT`	DATE	Timestamp (UTC) indicating when this data was last refreshed during data pipeline execution.

Key Relationships:

GENERAL_LEDGER_ISSUER_ID: Joins to AGGREGATE_INVESTMENTS to link financial data to a corporation.
CORPORATION_ID: Joins to FINANCING_HISTORY and COMPANY_FINANCIALS.

FINANCING_HISTORY

Information on various financing rounds for different companies 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.

Column Name	Data Type	Description
`CORPORATION_ID`	TEXT	Unique identifier for the corporation.
`INVESTMENT_NAME`	TEXT	The legal name of the portfolio company.
`IS_CARTA_CUSTOMER`	BOOLEAN	Indicates if the corporation is a Carta customer.
`SHARE_CLASS_ID`	NUMBER	Unique identifier for the share class.
`SHARECLASS_NAME`	TEXT	Shareclass name (e.g., "Series D-1 Preferred", "Seed-1").
`ROUND`	TEXT	The series/round name from the `shareclass_name`.
`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.
`CALCULATED_CASH_RAISED`	NUMBER	`shares_issued` times `original_issue_price`.
`ESTIMATED_CASH_RAISED`	NUMBER	The total funds raised during this funding round.
`SHARES_ISSUED`	NUMBER	The total outstanding quantity of shares in this share class.
`ORIGINAL_ISSUE_PRICE`	NUMBER	The price per share set at the time of issuance for this funding round.
`FULLY_DILUTED_SHARES`	NUMBER	The total number of shares outstanding as of the closing date.
`POST_MONEY_VALUATION`	NUMBER	Calculated using the `original_issue_price` and `fully_diluted_shares`.
`PRE_MONEY_VALUATION`	NUMBER	The valuation of the company before the investment.
`CONVERSION_PRICE`	NUMBER	The price at which preferred shares convert to common shares.
`MULTIPLIER`	NUMBER	Liquidation preference multiplier.
`DIVIDEND_COUPON`	NUMBER	Annual dividend percentage of the dividend rights.
`DIVIDEND_TYPE`	TEXT	Dividend Type, can either be "Cumulative" or "Non-Cumulative".
`PARTICIPATING_PREFERRED`	BOOLEAN	Flag indicating if the share class is participating preferred.
`PREFERENCE_CAP`	NUMBER	The cap on the liquidation preference.
`LAST_REFRESHED_AT`	DATE	Timestamp (UTC) indicating when this data was last refreshed during data pipeline execution

PORTFOLIO_EVENTS

A log of significant events relating to a firm's portfolio of investments, such as new priced rounds or stock splits.

Column Name	Data Type	Description
`EVENT_UUID`	TEXT	Unique identifier for each newsfeed event.
`EVENT_DATE`	TIMESTAMP_NTZ	The date of the portfolio event.
`EVENT_TYPE`	TEXT	The type of the portfolio event (e.g., "New priced round", "Stock split").
`DESCRIPTION`	TEXT	A description of the portfolio event.
`SECURITY_LABEL`	TEXT	The label of the security related to the portfolio event.
`SECURITY_KIND`	TEXT	The kind of security related to the portfolio event.
`FIRM_ID`	TEXT	Unique identifier for the management firm.
`FIRM_NAME`	TEXT	Name of the investment firm.
`FUND_ID`	TEXT	Unique identifier for the fund.
`FUND_NAME`	TEXT	Name of the fund.
`ISSUER_UUID`	TEXT	Unique identifier of the issuer from the general ledger (GL).
`CORPORATION_ID`	TEXT	Unique identifier of the associated corporation.
`CORPORATION_NAME`	TEXT	The name of the Carta cap table customer related to the portfolio event.
`ADDITIONAL_DETAILS`	TEXT	Structured data about the portfolio event as a JSON string.
`LAST_REFRESHED_AT`	DATE	Timestamp (UTC) indicating when this data was last refreshed during data pipeline execution

TEMPORAL_DEAL_IRR

Aggregates temporal deal IRR metrics for investments by fund at the asset level.

Column Name	Data Type	Description
`PK`	TEXT	Unique identifier composed of `fund_uuid`, `issuer_id`, and `performance_quarter_end_date`.
`FUND_ID`	NUMBER	Unique identifier for the fund.
`FUND_UUID`	TEXT	Unique identifier for the fund.
`FIRM_ID`	TEXT	Unique identifier for the management firm.
`FIRM_NAME`	TEXT	Name of the investment firm.
`ISSUER_ID`	TEXT	Unique identifier of the issuer from the general ledger (GL).
`REMAINING_VALUE`	FLOAT	Remaining value of the investment.
`COST_BASIS`	FLOAT	Cost basis of the investment.
`TOTAL_COST`	FLOAT	Total cost of the investment.
`PERFORMANCE_QUARTER_END_DATE`	DATE	End date of the performance quarter.
`DEAL_IRR`	FLOAT	Deal IRR value.
`ISSUER_NAME`	TEXT	Name of the issuer.
`ISSUER_ENTITY_TYPE`	TEXT	Entity type of the issuer.
`ISSUER_DOMICILE_COUNTRY`	TEXT	Domicile country of the issuer.
`EARLIEST_INVESTMENT_DATE`	DATE	Earliest investment date for the asset.
`LAST_REFRESHED_AT`	DATE	Timestamp (UTC) indicating when this data was last refreshed during data pipeline execution

TEMPORAL_DEAL_METRICS

Aggregates temporal metrics of specific investments by fund.

Column Name	Data Type	Description
`_PK`	TEXT	Primary key for temporal deal metrics table.
`FUND_ID`	NUMBER	Unique identifier for the fund.
`FUND_UUID`	TEXT	Unique identifier for the fund.
`FUND_NAME`	TEXT	Name of the fund.
`FIRM_ID`	TEXT	Unique identifier for the management firm.
`ASSET_ID`	TEXT	Unique identifier for the asset in the general ledger.
`PERFORMANCE_QUARTER_START_DATE`	DATE	The start date of the performance quarter.
`ISSUER_NAME`	TEXT	Name of the issuer from the general ledger (GL).
`INVESTMENT_DATE`	DATE	The date when the investment was made.
`ASSET_CLASS_TYPE`	TEXT	The type of asset class for the investment.
`CURRENCY_CODE`	TEXT	The currency code for the investment.
`ASSET_CLASS`	TEXT	The asset class of the investment.
`COST_BASIS`	FLOAT	The cost basis of the investment.
`TOTAL_COST`	FLOAT	The total cost of the investment.
`REMAINING_VALUE`	FLOAT	The remaining value of the investment.
`GROSS_IRR`	FLOAT	The gross internal rate of return for the investment.
`UNREALIZED_GAIN_LOSS`	FLOAT	The unrealized gain or loss for the investment.
`LAST_REFRESHED_AT`	DATE	Timestamp (UTC) indicating when this data was last refreshed during data pipeline execution