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.

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.

Â