...
- Query Options
- Entity Information
- Security Information
| Option | Tag | Description |
|---|
| Anchor |
|---|
| _Toc422492251 |
|---|
| _Toc422492251 |
|---|
|
Query Options |
...
...
...
| Allows you to show/hide additional query filters. The system displays additional fields depending on your selection. Options include: |
...
...
- One Entity/All Securities
|
...
- All Entities/One Security
|
...
- All Entities/All Securities
|
| Message Type |
...
...
| Specifies the message type associated with the transaction. Options include: |
...
...
...
...
...
...
| for an MTOPEN event. See the About Event Types section for more information. This field appears if you specify a value for the Message Type field of MTOPEN. Options include: |
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| for an MTCLOSE event. See the About Event Types section for more information. This field appears if you specify a value for the Message Type field of MTCLOSE. Options include: |
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
| Specifies the transaction status of the pended transaction. You can select a value of Pending, Hold, or a custom status. Otherwise, you can leave the field blank to view pending transactions with all statuses, including Released and Failed. |
| Trade Ticket Number |
...
...
| Specifies the trade ticket identification number. |
| Query Data From |
...
...
| Specifies the table in the TRADES database associated with the transactions you want to view. If you modify any field in a transaction in the PENDING_TRADES table, the system adds a row to the PENDING_TRADES_HIST table. The PENDING_TRADES_HIST table stores the full transaction rather than just the changed fields. Options include: |
...
...
- Pending Trade History Table
|
| Anchor |
|---|
| _Toc422492252 |
|---|
| _Toc422492252 |
|---|
|
Entity Information |
The following are the options for entity information:
...
...
| Specifies the unique identifier of the entity. |
| Entity Name |
...
...
| Specifies the name of the entity. |
| Process Center |
...
...
| Specifies the entity's process center. |
| Conversion Status |
...
...
| Indicates the current status of the entity. |
| Anchor |
|---|
| _Toc422492253 |
|---|
| _Toc422492253 |
|---|
|
Security Information |
The following are the options for security information:
...
...
| Specifies the name of the security. |
| Ticker |
...
...
| Specifies the system of letters used to uniquely identify a security. |
| Xref Type |
...
...
| Specifies the cross reference security type, such as SEDOL, CUSIP, and so on. |
| Xref ID |
...
...
| Specifies the cross reference security identifier. |
| Partition ID |
...
...
| Specifies the entity partition code. |