Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Anchor
_Toc439930435
_Toc439930435
Eagle Data Warehouse Load Streams

Panel
borderColor#9F9F9F
titleColor#F7F9F9
titleBGColor#B48436
borderStyledashed
titleContent on this page:

Table of Contents
maxLevel2
indent2 px

Anchor
_Toc246483772
_Toc246483772
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

Anchor
_Toc439930436
_Toc439930436
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.

Anchor
_Toc439930437
_Toc439930437
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

Note

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

Note

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