Cap tables

SUMMARY_CAP_TABLE

Summary cap table for each portfolio company sourced from Carta's data warehouse. Contains 1 row per security class per day, with outstanding quantity, fully diluted quantity, authorized shares, cash raised, and ownership percentages. This table updates daily and contains historical cap table records as well.

Column Name	Data Type	Description
`corporation_id`	`varchar`	Unique identifier of the corporation
`as_of_date`	`timestamp`	Date when cap table info was last loaded from Carta's data warehouse
`legal_name`	`varchar`	Legal name of the company
`security_class_id`	`varchar`	Unique ID prefixed with SC- (share classes), WC- (warrants), OP- (option pools), NB- (note blocks)
`_pk`	`varchar`	Surrogate key of corporation_uuid, as_of_date, security_class_id
`security_class_type`	`varchar`	Type: warrant_block, option_plan, note_block, share_class
`security_class_type_detailed`	`varchar`	Detailed type: Common warrant, Option plan, Convertible debt, Common, Preferred, SAFE, etc.
`security_class_name`	`varchar`	Name of the shareclass, note block, warrant block, or option pool
`as_converted_shareclass_id`	`number`	Share class security converts to upon exercise/settlement
`as_converted_shareclass_name`	`varchar`	Name of the as-converted share class
`as_converted_sharclass_stock_type`	`varchar`	Stock type of as-converted share class (Preferred or Common)
`conversion_ratio`	`float`	How many common shares each security converts into
`outstanding_shares`	`number`	Outstanding shares (non-zero for share classes only)
`outstanding_warrants`	`number`	Outstanding warrants (non-zero for warrant blocks only)
`outstanding_equity_award_derivatives`	`number`	Outstanding equity awards (non-zero for option pools only)
`outstanding_committed_rsas`	`number`	RSAs approved by board but not yet purchased
`plan_size`	`number`	Total shares available under the plan (option pools only)
`shares_available_under_plan`	`number`	Shares available under plan (option pools only)
`first_board_approval_date`	`date`	Date board first approved option plan (option_plan types only)
`termination_date`	`date`	Date option plan was terminated (option_plan types only)
`fully_diluted_quantity`	`number`	Total securities on fully diluted basis (all shares, warrants, options, convertibles)
`authorized_shares`	`number`	Shares authorized by board (non-zero for share classes and option plans)
`fully_diluted_ownership`	`float`	Ownership % on fully diluted basis
`cash_raised`	`object`	Cash raised by security class (currency codes as keys, amounts as values)
`principal`	`object`	Principal amount in noteblock (currency codes as keys, amounts as values)
`interest`	`object`	Interest amount in noteblock (currency codes as keys, amounts as values)
`original_issue_price`	`number`	OIP. Price paid by investor in round; liquidation preference amount
`conversion_price`	`number`	Used to calc conversion to common: OIP / conversion_price = common shares received
`preference_cap`	`number`	Liquidation preference participation cap (OIP * preference_cap)
`participating_preferred`	`boolean`	If true, receives OIP * Multiplier + participation alongside common
`multiplier`	`number`	Liquidation preference multiplier (OIP * Multiplier for preferred stock)
`seniority`	`number`	Payout order for preferred shareclasses (1 = paid first by default)
`dividend_type`	`varchar`	Cumulative or Non-Cumulative
`dividend_coupon`	`number`	Annual dividend % (7.00 = 7%); multiplied with OIP for dollar value
`dividend_accrual`	`varchar`	Accrual period (daily, annually, etc.)
`is_compounding`	`boolean`	If true, uses OIP + cumulative accrued dividends for interest calc
`interest_compounding_period`	`varchar`	How often dividend is compounded
`note_block_prefix`	`varchar`	Prefix identifier for note blocks
`warrant_block_prefix`	`varchar`	Prefix identifier for warrant blocks
`last_refreshed_at`	`timestamp`	When data was last refreshed during dbt execution