Transfer Data Using the S2P Batch Mode

The STAR to PACE Batch mode transfers accounting data at the entity/accounting basis level. The system deletes the position data and then re-inserts it for a given entity accounting basis and effective date. Typically, you use the Batch mode to:

  • Insert the end of day accounting data into Eagle PACE.

  • Seed data in Eagle PACE for the next accounting day.

  • Insert intraday valuation data into Eagle PACE if you use intraday NAV processing. 

  • Insert holdings and valuation data into Eagle PACE if you use Performance NAV processing. 

STAR to PACE Direct deletes and inserts only the levels of data requested. Therefore, if you run the Batch mode for positions and open lots only, the system does not delete the transaction data from a prior run.

Before You Begin

Prior to running the end of day Batch mode process, you must do the following to ensure accurate reporting and performance:

  • Add the issue prices and foreign exchange rates to the Eagle reference tables for the day.

  • Complete and reconcile all daily accounting processes.

  • If you are processing a master fund that uses intraday NAV processing, ensure you have a valuation source for each intraday NAV sequence you plan to process. 

  • If you are processing a master fund that uses Performance NAV processing, ensure you have Performance NAV sources for each master fund you plan to process. 

Once these actions are complete, you are ready to transfer data using the S2P batch mode.

Use S2P Batch Mode

To transfer accounting data using the S2P Batch mode:

  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 > Transfer Data - Batch.
    You see the Transfer Data - Batch panel.

  3. Complete the options on the Transfer Data - Batch panel. 
    You must specify at least one of the fields in the Entity Parameters section to narrow the scope of the request. For more information, see About Qualifying Entities to Process in Batch or Delta Mode. You can specify one of the following fields in the Position Parameters section: Issue Name, Issue Symbol, or Primary Asset ID. The Long Short field is a required field.

  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.

Transfer Data – Batch Panel Options

The following table lists the fields and field descriptions for the Transfer Data – Batch panel.

Option

Description

Option

Description

Push Activity Only Mode

 

Push Activity Only

Copies trade, disposal lot, cash activity, settled foreign cash activity, and settled cash disposal lots to Eagle PACE for a defined accounting date range. Options include:

  • Yes. Select this value only as part of initial conversions of data. Do not use it for normal production processing.

  • No. Default. Select this value for normal production processing.

Entity 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.

Intraday Source Election

If you select an entity that uses intraday NAV processing, identifies the intraday NAV period for the data you want to process. When you select a value, the STAR Intraday Data Filter field appears under Run Options. Options include: 

  • 1st Intraday NAV

  • 2nd Intraday NAV

  • 3rd Intraday NAV

  • 4th Intraday NAV

  • 5th Intraday NAV

Source Name

Displays the pricing original source for the intraday NAV sequence associated with the selected NAV period. This field appears if you select an entity eligible for intraday NAV processing. 

Prs Instance

Displays the pricing source instance number for the selected Source Name value. This field appears if you select an entity eligible for intraday NAV processing. 

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 use this option or the Conversion Status option.

Conversion Status

Specifies the conversion status. The 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 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 Number

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

Position Parameters

 

Issue Name

Specifies the issue name for the security.

Issue Symbol

Specifies the issue symbol for the security.

Primary Asset ID

Specifies the primary asset identifier for the security.

Asset Currency

Specifies the currency used to price the security.

Xref Security ID

Specifies the cross reference security ID for the security.

Xref Type

Specifies the cross reference type for the xref ID.

Long Short

Allows you to process only long or short positions.

Run Options

 

Generate For

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

  • Primary Accounting Basis Only (Default). Only sends data for the primary accounting basis for the entity.

  • Specific Accounting Basis. Allows you to choose a specific accounting basis to transfer. If you select Specific Accounting Basis, the Accounting Basis field unhides for data entry in the Entity Parameters section.

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

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

STAR Data Filter

Specifies the type of data. Options include:

  • Positions. Sends positions and cash balances.

  • Positions/Open Lots. Sends positions, cash balances, and open lots.

  • Positions/Open Lots/Trades/Disposal Lots. Sends positions, cash balances, open lots, trades, and disposal lots.

  • Positions/Open Lots/Trades/Disposal Lots/Cash Activity. Sends positions, cash balances, open lots, trades, disposal lots, and cash activity.

  • Positions/Open Lots/Trades/Disposal Lots/Settled Cash. Sends positions, cash balances, open lots, trades, disposal lots, and settled cash.

  • Positions/Open Lots/Trades/Disposal Lots/Cash Activity/Settled Cash (Default). Sends positions, cash balances, open lots, trades, disposal lots, cash activity, and settled cash.

  • Positions/Trades/Disposal Lots. Sends positions, cash balances, trades, and disposal lots.

  • Positions/Trades/Disposal Lots/Cash Activity. Sends positions, cash balances, trades, disposal lots, and cash activity.

  • Positions/Trades/Disposal Lots/Cash Activity/Settled Cash. Sends positions, trades, disposal lots, cash activity, and settled cash.

  • Positions/Trades/Disposal Lots/Settled Cash. Sends positions, trades, disposal lots, and settled cash.

  • Positions/Cash Activity. Sends positions and cash activity.

Note: The value you select for Batch mode must correspond to the value you select when you use the Delta mode, to ensure the necessary data accuracy for reporting and Performance Measurement. If you are not using Eagle's Performance Measurement solution, you do not need cash activity data posted to Eagle PACE, because you can directly use the ESTAR cash activity tables.

STAR Intraday Data Filter

If you select a value for the Intraday NAV Election for an entity that uses intraday NAV processing, specifies the type of data. Options include:

  • Positions. Sends positions and cash balances.

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

Note: The value you select for Batch mode must correspond to the value you select when you use the Delta mode, to ensure the necessary data accuracy for reporting and Performance Measurement. If you are not using Eagle's Performance Measurement solution, you do not need cash activity data posted to Eagle PACE, because you can directly use the ESTAR cash activity tables.

Position Valuation Election

Specifies the price used by S2P. Options include:

  • Default. Use the latest price available.

  • Valuation. Use the appropriate STAR valuation.

Include Zero Positions (Days)

Controls whether Eagle Accounting includes zero positions in the result set for a specified number of days past the position's last settlement date. This field is automatically populated with a value of "0" and you must only change the option after discussions with your Relationship Manager about your processing workflow.

The process automatically generates zero positions through the position's last settlement date.

Event Type

Displays the event value GEN_STAR_PACE.

Date Type

Specifies the date type. You can bring over 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.

Fund Valuation View Option

Identifies the type of position valuation to use in the Eagle data warehouse. Options include: 

  • Default. Default value. Applies to normal position valuation. 

  • Performance NAV. Applies to position valuation when you use Performance NAV processing with the Eagle mutual fund accounting solution. If you select this option, ensure you set the Date Type field to Accounting Date. 

  • Swing NAV. (For future use)

End Date

Specifies the date on which to send the data to Eagle PACE. 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. When set to Recent, the system ignores entity price overrides. 

The system uses the following hierarchy for calculating valuation in Eagle PACE:

  • Short Term Security logic (cost or price method)

  • Price Override

  • Price Table

  • No Price Found logic (entity accounting basis election)

Auto Perf Switch

Indicates whether to flag the position for performance re-computation. STAR to PACE Direct automatically sets Eagle PACE position record to Y (perform_flag) for back dated position updates via the Delta mode. You can set the batch mode either way. Options include:

  • Yes. Flag position for performance recomputation.

  • No (Default). Do not flag position for performance recomputation.

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.

Income Based Cash Switch

Indicates whether to generate an income based cash record. Options include:

  • Settled cash (Default). When you initiate the STAR to PACE Process, the process populates income based cash activity by using the actual income settlement event (ESTAR_SETTLED_CASH_ACTIVITY table record).

  • Traded cash. When you initiate the STAR to PACE Process, the process populates income based cash activity from the income entitlement event (ESTAR_TRADED_CASH_ACTIVITY table record), including coupon entitlements.

Note: The S2P Position Income Receivable Switch determines whether or not the income receivables populate the position records and works independent of the CASH_ACTIVITY records creation. You may populate the CASH_ACTIVITY table by using the income based cash settlement event or the performance computation and still have income receivables values populate from the income entitlement event for positions reporting.

S2P 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. As example, derived POSITION_DETAIL fields include settled_base_sec_urgl, settled_base_total_urgl, settled_market_value, and settled_local_sec_urgl.

  • Do Not Insert Income Receivable Values. Not recommended by Eagle Performance. Select this value if you want to calculate performance returns using a custom and non AIMR compliant performance calculation.

Calculate Contractual Settlement

Indicates whether to calculate contractual settlement values. STAR to PACE Direct stores contractual settled values in Eagle PACE. These fields require additional processing, which affects the performance of the STAR to PACE Direct Batch and Delta process. Options include:

  • Yes. Calculate contractual settlement. Select this value only if calculation of contractual settlement is necessary.

  • No (Default). Do not calculate contractual settlement. For optimal performance, select this value if calculation of contractual settlement is not necessary.

System Currency

Displays the system currency for calculating enterprise wide performance returns, if specified. For details about setting up a system currency to calculate enterprise wide performance returns, see Add a System Currency to Calculate Performance Returns.

Note: If you specified a system currency for Performance Measurement use, the Delta mode process values portfolio holdings, income receivables, and cash activity in the system currency for all portfolios across the entire enterprise.

Â