Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Version published after converting to the new editor

The Settle Cash Disposal Lot Table Query allows you to research settled cash disposal lots processed by STAR to PACE Direct based on data stored in the SETTLED_CASH_DISPOSAL_LOTS table in the TRADES database in Eagle PACE.

...

Option

Description

Optional Parameters


Entity ID

Specifies the entity identifier for a portfolio, sector portfolio, composite portfolio, or Master Fund.

Entity Name

Specifies the entity by the name of the entity.

Acctg Basis

Specifies the accounting basis for the entity. For example, USTAX, GAAP, or IFRS. This field appears if you set the Reporting Source field to Specific Accounting Basis.

Search Criteria


Reporting Source

Specifies the accounting basis as the reporting source to use for qualifying the query. Options include:

  • Across All Accounting Basis. Every accounting basis of the selected entities is used as the reporting source.
  • Primary Accounting Basis Only (Default). Only the primary accounting basis for the entity is used as the reporting source.
  • Specific Accounting Basis. Allows you to choose a specific accounting basis to use as the reporting source. The Accounting Basis field unhides for data entry in the Optional Parameters section.

Source Name

Displays the source name. For example, STARDIRECT. The field appears if you set the Reporting Source field to Primary Accounting Basis.

Query Based On

Allows you to qualify your query result. Options include:

  • Date Range.
  • Entity ID. Default.
  • Security Alias. The Issue Name, Issue Symbol, and Primary Asset ID fields unhide for data entry in the Optional Parameters section.
  • Security Alias and Entity ID. The Issue Name, Issue Symbol, and Primary Asset ID fields unhide for data entry in the Optional Parameters section.

Date Type

Specifies the type of date to use for qualifying the query. Options include:

  • Post Date
  • Trade Date
  • Accounting Date (Default)
  • Settlement Date
  • Month End Date

Event Type

Displays the event type value Q_SCDL.

Start Date

Specifies the start date for your query results. The default is today's date.

End Date

Specifies the end date for your query results. The default is today's date.

...