Maintaining Pool Positions

This section provides an overview of the investment pool maintenance process discusses how to:

Import pool position data from an external investment management source.
Manually update pool positions.
Distribute investment pool income.

Pages Used to Update Pool Positions

Page Name	Definition Name	Navigation	Usage
Import Pool Position	BSP_IMPORT	select Cash Management, then select Investment Pools, then select Import Pool Position	Update an investment pool's position by importing data in a flat file format from an outside investment source.
Layout Catalog	PMT_FORMAT_CATLOG	Click the View Layout Details link on the Import Pool Position page. select Banking, then select Administer Bank Integration, then select Layout Catalog	Define and configure the files that will be used to import a flat file containing pool position data into the system. Modify the POOL file layout to define your pool-position, flat file.
Update Pool Position	TRP_POOL_POS_ADD	select Cash Management, then select Investment Pools, then select Pool Position Click the Update Pool Position link.	Manually update the pool's cash position with current values obtained from outside investment sources. Obtaining the updated pool data may require running the Import Pool Position process.
Income Distribution	TRP_INC_RUN	select Cash Management, then select Investment Pools, then select Income Distribution	Run the Income Distribution Application Engine (TRP_INC_DIST) process to disburse investment pool income and maintenance fees among participants based on the parameters set on the Pool Information page.

Updating Investment Pools

In order to have an accurate view of an investment pool's position, as well as the position of its participants, you must periodically update the investment data. To do so requires importing income and fee data from external investment managers into the pool and distributing it among the pools participants.

There are two ways to update investment pool data:

Import the data in a flat-file format from the Import Pool Position page.

A file layout already provided will need to be modified along with its transformation code.
Obtain a hard copy of the data and manually enter it using the Update Pool Position page.

Once the pool has been updated, run the Income Distribution Application Engine process (TRP_INC_DIST) to update the pool's participant positions by distributing the income and maintenance fees among them.

Import Pool Position Page

Use the Import Pool Position page (BSP_IMPORT) to update an investment pool's position by importing data in a flat file format from an outside investment source.

Navigation

select Cash Management, then select Investment Pools, then select Import Pool Position

Image: Import Pool Position page

This example illustrates the fields and controls on the Import Pool Position page. You can find definitions for the fields and controls later on this page.

Parameters

Import Type

Select the method for importing the data file. The options are:

FTP: Select if you are importing the file by using file transfer protocol, and enter a bank node through which to transfer the data.
File: Select if you are importing a file, and complete the File Path and File Name fields.
HTTP: Select if you are importing a file using a URL that is included as part of the node configuration. No file path or file name is required.

Integration Node

Enter the integration node used to transfer the data. This field appears only if FTP or HTTP is selected as the Import Type.

See PeopleTools : PeopleSoft Integration Broker Administration, "Adding and Configuring Nodes."

See PeopleTools : PeopleSoft Integration Broker Administration, "Using Listening Connectors and Target Connectors," Working With the AS2 Connectors.

See Understanding Electronic Banking.

View Integration Node Details

Click to access the Integration Node Details page and review property details of the selected node. This link appears only if FTP or HTTP is selected as the Import Type.

File Path

Enter the complete file path location. To select files by using the Select File button, the file path must have a trailing backslash (\).

You can also search for files of a specific type by entering an asterisk and the extension suffix. For example, to search all files with a .txt suffix enter \*.txt.

File Selection Help

Click to view help information on specifying file paths and file names.

File Name

Select the specific file to import. If you want to import multiple files based on extension, leave this field blank.

Advanced Options

Encryption Profile

Select an encryption profile to decrypt the data file. Encryption profiles contain both encryption and decryption information.

Use Integration Broker

Select this check box to format the files and publish the formatted document to PeopleSoft Integration Broker. Integration Broker then processes the formatted file accordingly.

You select this option if you want to use the pool position information as a trigger for Integration Broker to perform other processes, or to integrate with other systems.

Post Process File Action

Select what action, if any, to be performed on the pool position data file after the data has been processed. The options are:

Copy: Copy the file to the directory entered in the Post Process File Directory field.
Delete: Delete the file after the data in it is processed.
Move: Move the file to the directory entered in the Post Process File Directory field.
None: Take no action. The data file remains unprocessed.

Post Process File Directory

Enter a file path to the directory to which the file will be moved or copied if either option is selected as the Post Process File Action.

See also PeopleTools: PeopleSoft Integration Broker, Configuring Nodes and Transactions.

Update Pool Position Page

Use the Update Pool Position page (TRP_POOL_POS_ADD) to manually update the pool's cash position with current values obtained from outside investment sources.

Image: Update Pool Position page

This example illustrates the fields and controls on the Update Pool Position page. You can find definitions for the fields and controls later on this page.

Note: Obtaining the updated pool data may require running the Import Pool Position process.

Obtaining the updated pool data may require running the Import Pool Position process.

Position Type

Select the type of position being updated. The options are:

Market Value:Update the current value of the investment pool based on the last reported sale price of securities to which the pool funds are invested.
Interest: Updated the interests accrued on the pool's investments.

Amount

Enter the new market value of the investment pool.

Accounting Template ID

Select the accounting template for the pool that depicts the correct accounting and debit and credit configuration for this update transaction.

Document Type

Select the document type that the system uses to assign document sequence numbers.

Participant Acctg Template ID

Select the accounting template for the participants account that depicts the correct accounting and debit and credit configuration for this update transaction.