Trade Identifier of the trade that originally created the holding row. This PK+ HH_H_T_ID TRADE_T Not Null is a Foreign Key to the TRADE table FK (T_) rather than the HOLDING table because the HOLDING row could be deleted. Identifier of the current trade (the PK+ HH_T_ID TRADE_T Not Null one that last inserted, updated or deleted FK (T_) the holding identified by HH_H_T_ID). Quantity of this security held before the HH_ BEFORE_QTY S_QTY_T Not Null modifying On initial insertion, HH_BEFORE_QTY is 0. Quantity of this security held after the modifying trade. If the HOLDING row HH_ AFTER_QTY S_QTY_T Not Null gets deleted by the modifying trade, then HH_AFTER_QTY is 0. HOLDING_SUMMARY The table contains aggregate information about the customer account’s security holdings. Table Prefix: HS_ Column Name Data Type Constraints Relations Description PK+ HS_CA_ID IDENT_T Not Null Customer account identifier. FK (CA_) PK+ HS_S_SYMB CHAR(15) Not Null Symbol for the security held. FK (S_) HS_ QTY S_QTY_T Not Null Total quantity of this security held. Comment: HOLDING_SUMMARY may be implemented as a view on HOLDING, in case the HOLDING Foreign Key references to HOLDING_SUMMARY are automatically met. However, the HOLDING_SUMMARY Foreign Key references to CA_ and S_ must then be adopted and met by HOLDING. WATCH_ITEM The table contains list of securities to watch for a watch list. Prefix: WI_ Column Name Data Type Constraints Relations Description PK+ WI_WL_ID IDENT_T Not Null list identifier. FK (WL_) PK+ WI_S_SYMB CHAR(15) Not Null Symbol of the security to FK (S_) WATCH_LIST The table contains information about the customer who created this watch list. Table Prefix: WL_
HH_H_T_ID TRADE_T Not Null PK+ FK (T_) Trade Identifier of the trade that originally created the holding row. This is a Foreign Key to the TRADE table rather than the HOLDING table because the HOLDING row could be deleted. HH_T_ID TRADE_T Not Null PK+ FK (T_) Identifier of the current trade (the one that last inserted, updated or deleted the holding identified by HH_H_T_ID). HH_ BEFORE_QTY S_QTY_T Not Null Quantity of this security held before the modifying On initial insertion, HH_BEFORE_QTY is 0. HH_ AFTER_QTY S_QTY_T Not Null Quantity of this security held after the modifying trade. If the HOLDING row gets deleted by the modifying trade, then HH_AFTER_QTY is 0. HOLDING_SUMMARY The table contains aggregate information about the customer account’s security holdings. Table Prefix: HS_ Column Name Data Type Constraints Relations Description HS_CA_ID IDENT_T Not Null PK+ FK (CA_) Customer account identifier. HS_S_SYMB CHAR(15) Not Null PK+ FK (S_) Symbol for the security held. HS_ QTY S_QTY_T Not Null Total quantity of this security held. Comment: HOLDING_SUMMARY may be implemented as a view on HOLDING, in case the HOLDING Foreign Key references to HOLDING_SUMMARY are automatically met. However, the HOLDING_SUMMARY Foreign Key references to CA_ and S_ must then be adopted and met by HOLDING. WATCH_ITEM The table contains list of securities to watch for a watch list. Prefix: WI_ Column Name Data Type Constraints Relations Description WI_WL_ID IDENT_T Not Null PK+ FK (WL_) list identifier. WI_S_SYMB CHAR(15) Not Null PK+ FK (S_) Symbol of the security to WATCH_LIST The table contains information about the customer who created this watch list. Table Prefix: WL_
tpcx-v_v2.1.0.docx