Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

You must determine the message streams to use for loading positions, ledger balances, and lots to the Eagle data warehouse. You can also load positions to work tables for local reconciliation.

There are several message streams available to load positions, ledger balances, and lots for each type of record, depending on the location of your data. 

Data Location

Source Code

Description

Eagle Data Warehouse

CUSTODY1
CUSTODY2/ STARDIRECT

For warehouse to warehouse matching

ESTAR Portfolio Valuation to STARDIRECT

PORT_VAL
CUSTODY/ STARDIRECT

For ESTAR to warehouse matching

Custodian

CUSTODY1
CUSTODY2

For local to local positions matching using work tables

Eagle Accounting

STAR

For local to STAR matching

Eagle Data Warehouse Load Streams

Content on this page:

Eagle data warehouse positions, ledger balances, and lots for a custodian source are matched to the data warehouse for source STARDIRECT or to the warehouse positions for a second custodian. Data warehouse records act as both a left side match and a right side match. 

Stream Name

Stream Type

Rule

eagle_default_in_csv_ThirdParty2Pace

CSV

csv-pace_table_uploads.rsfcsv-pace_position_upload.xml
csv-pace-balances
csv-pace_lot_upload.xml

eagle_default_in_star_ThirdParty2Pace

TAG value

star-pace_table_uploads.rsf
star-pace_position_upload.xml
star-pace-balances
 star-pace_lot_upload.xml

Custodian Positions Work Table Load Streams

Custodian data is typically sent as sequential files in character-delimited, fixed, or SWIFT format. Sequential position files are remapped and loaded to the Message Center database POSITIONS_CUST work tables, for a given custodian source and business date. 

Stream Name

Stream Type

Rule

posrecon-custodian

CSV

csv-posrecon-externaldata.xml

For fixed width or SWIFT formats, custom streams can be configured based on vendor interface requirements and sample data.

Eagle Accounting Positions Work Table Load Streams

Eagle Accounting positions information is loaded to the Message Center database POSITIONS work tables. Eagle Accounting positions data may be more current than the Eagle data warehouse positions which depend on the scheduling of STAR to PACE Direct. You can invoke the load stream using the Refresh STAR Positions menu option from the Position Recon console. 

Stream Name

Stream Type

Rule

posrecon-getentitypositions

TAG value

getentitypositions.xmlloadstarpositions.sch

posrecon-loadstarpos

TAG value

recon_loadstardata.xml

If you need to load the local Message Center work tables with STARDIRECT positions for a left side match, use the default streams shown below, invoked from the console via the Refresh PACE Positions menu option.

Stream Name

Stream Type

Rule

posrecon-getentitypacepositions

TAG value

getentitypacepositions.xmlloadpacepositions.sch

posrecon-loadstarpos

TAG value

recon_loadstardata.xml

The getentitypacepositions.xml rule uses the Position Table Query report panel to obtain warehouse positions data for a given source and position effective date. 

  • No labels