Roll Positions and Open Lots

You can copy (that is, roll) accounting data from the previous business day to the current business day using the Roll Positions and Open Lots process. This process runs at the start of the day and reduces the system overhead involved in the Batch mode.

The system retrieves Eagle PACE position records in the HOLDINGS POSITION table for the "from" accounting date and source combination. The roll procedures retrieve the data in the position and lot level tables that are linked to the Position ID of the relevant position records. The system creates a new position record in the POSITION table, if required, and copies the data with the Position ID value for the new date.

To transfer accounting data using the roll positions and open lots process:

  1. In Accounting Center, in the left navigation pane, click Processing and Exceptions > Global Processes.
    You see the Global Process workspace.

  2. In the left navigation, click STAR to PACE Direct Processing > Roll Positions and Open Lots.
    You see the Roll Positions and Open Lots panel.

  3. Complete the options on the Roll Positions and Open Lots panel.

  4. Click Submit.
    You see the Status window with the status of your request.

  5. Click Print to print the status information. Or, click OK to close the Status window.
    You see the Global Processing Results in the bottom pane. The Summary tab shows the event types associated with your request, along with a batch identifier. The Detail tab shows the processing status for each event.

You must run the Revalue Positions and Open Lots process after you run the Roll Positions and Open Lots process.

Roll Positions and Open Lots Panel Options

The following table lists the fields and field descriptions for the Roll Positions and Open Lots panel.

Option

Description

Option

Description

Entity Parameters

 

Generate For

Specifies the accounting basis associated with data to send from STAR to PACE. Options include:

  • Primary Accounting Basis Only. Only rolls data for the primary accounting basis for the entity.

  • Specific Accounting Basis. Allows you to choose a specific accounting basis to roll. If you select this value, you must specify an Accounting Basis value in the Entity Parameters section.

  • Only Secondary Accounting Basis. Only rolls data for the secondary accounting basis for the entity.

  • All Accounting Bases. Default. Rolls data for every accounting basis of the selected entities.

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.

Accounting Basis

Specifies the accounting basis associated with data. This field appears only if you set the Generate For field to Specific Accounting Basis.

Process Center

Segregates entities into "n" amount of Process Center groups. Doing so allows you to allocate the STAR to PACE workload across multiple STAR engine instances. The STAR to PACE Direct functionality generates the individual request messages for each entity/accounting basis combination at a much faster rate using Process Centers. The global processes incorporate the ability to run by the entity Process Center election. This allows you to schedule STAR to PACE Direct runs by custom defined groups.

Note: Eagle strongly recommends that you either use this option or the Conversion Status option.

Calendar Name

Specifies a calendar name, allowing you to add the roll to a scheduled process.

Conversion Status

Specifies the conversion status. Global processes incorporate the ability to run by the entity Conversion Status election. This allows you to include/exclude STAR to PACE Direct runs by the status of the entity (if, for example, entities in a specific Conversion Status are not ready for STAR to PACE Direct).

Note: Eagle strongly recommends that you either use this option or the Process Center option. Specify a conversion status only as part of the initial data conversion process. Do not use it for normal production processing.

Partition

Specifies the database partition for the position. This value is automatically established by a lookup based on the specific entity.

Run Options

 

STAR Data Filter

Specifies the type of data warehouse data to roll. Options include:

  • Positions. Rolls positions and cash balances.

  • Positions/Open Lots (Default). Rolls positions, cash balances, and open lots.

Position Valuation Election

Specifies the price used by S2P. Options include:

  • Default. Use the latest price available.

  • Valuation. Used by appropriate STAR valuation process.

Date Type

Specifies the date type. You can roll data for different date types and store it in Eagle PACE under different sources. Options include:

  • Accounting Date (Default). The system assigns the accounting date record a source of STARDIRECT (or one of the secondary accounting bases).

  • Month End Accounting Date. The system assigns the month end date record a source of MSTARDIRECT.

  • Settlement Date. The system assigns the settlement date record a source of SSTARDIRECT.

  • Trade Date. The system assigns the trade date record a source of TSTARDIRECT.

  • Post Date. The system assigns the trade date record a source of PSTARDIRECT.

Event Type

Displays the event type value SPD_ROLL_OVER_TRIGGER.

From Date

Specifies the date from which to roll data. The Date Type value determines available values for this field. For example, if you want to roll the end-of-day holdings from 12/10/10 to the begin-of-day holdings for 12/11/10, you use a From Date of 20101210. The default is today's date.

New Date

Specifies the date to which to roll data. The Date Type value determines available values for this field. For example, if you want to roll the end-of-day holdings from 12/10/10 to the begin-of-day holdings for 12/11/10, you use a New Date of 20101211. The default is today's date.

FX Date Switch

Indicates whether the process extracts the FX rate for the given accounting date or the most recent available FX rate. Options include:

  • Actual. Extracts the FX rate for the given accounting date.

  • Recent. Default. Extracts the FX rate for the most recent available FX rate.

Price Date Switch

Indicates whether the process extracts the price for the given accounting date or the most recent available price. Options include:

  • Actual. Extracts the price for the given accounting date.

  • Recent. Default. Extracts the most recent available price.

STAR to PACE Position Income Receivable Switch

Indicates whether to store income receivable data on the individual data warehouse position records. Options include:

  • Insert Income Receivable Values (Default). Eagle Performance recommends selecting this value, the default.

  • Do Not Insert Income Receivable Values. Select this value if you have a requirement to calculate performance returns using a custom and non AIMR compliant performance calculation.

SPD Cash Balances Switch

Indicates whether STAR to PACE Direct rolls up cash balances by currency and cash account in the Eagle data warehouse. In the STAR database, the system stores cash balances at the asset and custodian level. Options include:

  • Sourced from Cash Balances. Allows STAR to PACE Direct to use the ESTAR_TRADED_CASH_BALANCE table and the ESTAR_SETTLED_CASH_BALANCE table to provide cash balances in the position and lot level position tables for both non custody and custody accounting bases. It generates cash balances for all five date types (post, trade, accounting, settle, and month end accounting). It creates cash records for each custody cash account level in the data warehouse lot level. This option allows you to report on segregated cash balances if you use cash segregation, and affects all accounting bases for a given entity.

  • Sourced from Cash Activity. Default. Allows STAR to PACE Direct to use cash information from the STAR cash activity tables and the cost cash blob. This legacy option does not allow you to report on segregated cash balances if you use cash segregation.

Â