Use Calculated IDs for Transactions

The following three identifiers were created for reporting, but are not persisted in the database:

calcTransactionId. Universal ID for transaction record. Occurs once in a database.
calcCancelTransactionId. ID on a cancel trade that will link back to the calcTransactionId. Occurs once in a database.
calcMasterTransactionId. ID that links the transaction record together including during rollback and replay. Can occur many times in a database.

When you extract data from the database, the system constructs these fields dynamically using a combination of fields.

On this page

1 About the EnhanceCalcTransactionId Parameter
2 Available Extracts
3 Elements Included in Calculated IDs

About the EnhanceCalcTransactionId Parameter

You can set an optional parameter, EnhanceCalcTransactionId, to Y in available extracts to create uniqueness for transactions with these calculated IDs. The system uses this parameter in tandem with the IncludeExtendedDetails parameter setting to create calculated IDs. The IncludeExtendedDetails parameter setting must be equal to Y or ALL.

<taskParameter>
<name>EnhanceCalcTransactionId</name>
<value>Y</value>
</taskParameter>
<taskParameter>
<name>IncludeExtendedDetails</name>
<value>ALL</value>
</taskParameter>

For more information about the EnhanceCalcTransactionId parameter, see Control Message Required and Optional Parameters.

Available Extracts

The following table describes the extracts where you can use the EnhanceCalcTransactionId parameter, and identifies which calculated IDs the system can create for that extract.

	calcTransactionId	calcCancelTransactionId	calcMasterTransactionId
Definition	Universal ID for transaction record	ID on a cancel trade that will link back to the calcTransactionId	ID that links the transaction record together including during rollback and replay
Frequency	Occurs once in a database	Occurs once in a database	Can occur many times in a database
Feed Type:
WRHSTRADEEXTRACT	X	X	X
WRHSOPENLOTEXTRACT	NO	NO	X
WRHSCLOSELOTEXTRACT	NO	NO	X
TRADEDCAEXTRACT	X	X	X
SETTLEDCAEXTRACT	X	X	X

For more information about the data maps associated with these extracts, see Warehouse Trade Data Map Table, Warehouse Open Lot Data Map Table, Warehouse Close Lot Data Map Table, Traded Cash Activity Data Map Table, and Settled Cash Activity Data Map Table.

Elements Included in Calculated IDs

In the following pages of this section, additional information is available about the calculated IDs created for each of the following types of transactions:

For each calculated ID, you can view information about the individual fields utilized to calculate the identifier, along with the order of the elements included in the calculated ID and the character length of each element. This information varies based on how you set up the EnhanceCalcTransactionId parameter and how you set up the IncludeExtendedDetails parameter.