CartaX

Tables related to functionality specific to a CCMX transactions.

Auction →

For CCMX transactions (Carta Cross, Tender, RSU Settlement), the Auction table is used to hold and manage details for each transaction. Each Auction record must correspond to one (and only one) InstrumentMarket record - the Auction is effectively an extension of an InstrumentMarket with CCMX-specific fields.

AuctionAccount →

The AuctionAccount table is used to assign Accounts to Auctions, i.e., to allow one or more Accounts to participate in an Auction. The table stores the specific Auction-related parameters for each Account on the Auction along with data about each Account's participation.

AuctionAccount_children →

Working scratch for allocation to child AuctionAccounts from a parent.

AuctionAccountAllocation →

This table maintains the seller allocations for a CCMX Tender transactions. The seller allocations are calculated at the end of the initial phase of the Tender. They may be subsequently adjusted according to instructions from the Issuer to derive a final set of allocations for the Tender. Each record is an allocation for a particular AuctionAccount for a particlar SettlementClass. The allocations in this table and any subsequent adjustments flow into the AuctionAccount and AuctionAccountDetail tables.

AuctionAccountDetail →

For (multiclass) Tender transactions, this table tracks the breakdown of an AuctionAccount's order and trade quantities and values by SettlementClass. Each record has details for one AuctionAccount + SettlementClass combination.

AuctionAccountRelationship →

The AuctionAccountRelationship table is used to allow various parameters for an Auction to be set per AccountRelationship.

AuctionSession →

The AuctionSession table is used to define and set up the parameters for the Sessions for an Auction. An AuctionSession corresponds to two SessionTime records, one for the entry to the AuctionSession and for the exit from the AuctionSession.

AuctionSettlementClass →

This table enumerates the Settlement Classes that are available for trading on a particular Auction. The Settlement Classes must all be associated with the same Issuer as the Auction's Issuer (Instrument).

EquityClass →

This table enumerates valid Equity Clases supported by Carta. Each Equity Class belongs to an Issuer and is associated with the Issuer via its IssuerAccount. This table is not required for MarketGrid processing, it is informational only and passed through for reporting.

MarketEligibleEquityClass →

This table holds settlement class information for each Auction + SettlementClass + EquityClass combination. It is not used for processing in MarketGrid, just pass-through for reporting.

OptionExercise →

This table holds settlement information for each trade-option combo. It is used for reporting and not for MarketGrid processing.

SecuritySold →

This table holds securities sold information for each trade-option combo. It is used for reporting and not for MarketGrid processing.

SettlementClass →

This table enumerates the available Settlement Classes for each Instrument (Issuer).

VirtualReferenceNumber →

This table holds Virtual Reference Numbers (VRN) for JPMorgan linked accounts. VRN information is a list of all acquired VRN and what accounts they're associated with. If a VRN association is removed (eg. account is assigned a new one), the old one is put in 'Suspended' status.