7. Structure Maintenance

7.1 Introduction

Multiple structures have to be created within a framework to add accounts to allow sweeps/notional pooling. Structure maintenance allows you to do the following:

• Create Structures
• Add accounts to it.
• Assign instruction to pair of accounts
• Assign frequencies to marked instructions

System allows you to add as many accounts and as many hierarchies as required.It also enables hybrid structures, where both pool and sweep can be configured.Hybrid structures are basically pool over sweep structures.

7.2 Creating Structure

This section contains the following topics:

• Section 7.2.1, "Creating a New Structure"
• Section 7.2.2, "Maintaining Accounts in the Structure"
• Section 7.2.3, "Maintaining a Structure"
• Section 7.2.4, "Validating the structure"
• Section 7.2.5, "Setting Instruction Details"
• Section 7.2.6, "Specifying Payment Details"
• Section 7.2.7, "Modifying Structure"
• Section 7.2.8, "Resume/Pause the Structure"
• Section 7.2.9, "Get history for structure"

7.2.1 Creating a New Structure

You can invoke the ‘Structure Maintenance’ page by clicking on the Structure Maintenance tab in application..

Click New button to add a new structure. Specify the following details:

Structure ID

The system displays the auto generated unique structure ID.

Structure Description

Specify a description for the new structure.

Version Number

Displays the version number

MultiBank Cash Concentration

This field will get automatically selected on save if the underlying structure created has external bank accounts.

Structure Type

Specify the Structure Type from the drop down list. The option are:

Sweep

Pool

Hybrid

Cross Currency

This field will get automatically selected on save if the underlying structure is created with accounts which are in different currencies.

Customer ID

Specify the customer. You can select the customer ID from the option list. The list displays all the customer IDs maintained in the system

Customer Description

The system displays the description of the customer selected.

Cross Border

This field will get automatically selected on save if the underlying structure is created with accounts which are from two or more different countries.

Status

Indicate the status of the Structure to be maintained. The options are:

Resumed

Paused

A user should be able view the flag 'Status' at the structure level and be able to select either Paused or Resumed for a new structure or an existing structure. Default value would be “Resumed”.

Default Frequency

Specify the default frequency at which the structure should be executed. You can select the frequency from the option list. The list displays all the frequencies maintained in the system.

The frequency defined at the structure level will get defaulted to all the account pairs in the structure, but you can over ride and define a specific frequency for a specific pair of account.

This changed preference will override the global preference.

Effective Date

Specify the date from which the structure becomes effective.This date cannot be less than the system date but can be a future date.

Rate Type

Specify the rate type to be used in case the underlying structure has cross currency pairs.

End Date

Specify the date till which the structure is effective.This date should always be greater than the effective date.

EOD

Check this box to execute the structure at end of day.

Allow Sweep on Currency Holidays

Check this field to allow sweep on currency holidays.

Central Account Number

Specify the Central Account to be applied to the structure. You can select the Central account from the option list. The list displays all the accounts maintained in the system.

Central Account Branch

Displays the Central Account Branch

Central Account Currency

Displays the Central Account Currency

Rate PickUp

Specify the rate pick up for the sweeps on currency holidays from the drop down list. The option are:

• Previous Days Rate
• Last Swept Rate for the Pair (when sweep frequency is not daily)
• Past 5 day Average Rate

Note

This field is active only if ‘Allow Sweep on Currency Holidays’ is selected.

Reverse Frequency

Specify the reverse frequency at which the reverse sweep for structure should be executed. You can select the frequency from the option list. The list displays all the frequencies maintained in the system.

The frequency defined at the structure level will get defaulted to all the account pairs in the structure, but you can over ride and define a specific frequency for a specific pair of account.

This changed preference will override the global preference.

Interest Method

Specify the Interest method for the structure from the drop down list. The options are:

• Interest
• Advantage
• Optimization

This data needs to be captured only for Pooling Structures.

Instruction Type

Specify the instruction type to be applied to the structure. You can select the instruction type from the option list. The list displays all the instruction types maintained in the system.

 

Reallocation Method

Specify the reallocation method for the structure from the drop down list. This refers to the method in which the interest is shared with the participating account entities.The options are:

• No Reallocation - No interest is paid back to the child accounts
• Reallocation without benefits - Interest is allocated back to child account but without the additional benefits of accumulation.
• Reallocation with benefit - Interest is allocated back to the child account with the additional benefits of accumulation.
• Central Distribution - Here the interest arrived at is credited to one central account, which can be any one of the participating accounts or a separate account.
• Even Distribution - Here the interest is evenly distributed among the participating accounts.
• Even Direct Distribution - Here Interest reward is evenly spread across all accounts with positive balances
• Percentage Based Distribution - Here pre defined percentage of the interest is distributed among the participating accounts.
• Fair Share Distribution - Here if the interest is positive, it is distributed among the positive contributors in the ratio of their contribution and if the interest is negative, it is distributed among the negative contributors in the ratio of their contribution.
• Reverse Fair Share Distribution - Here if the interest is positive, it is distributed among the negative contributors in the ratio of their contribution and if the interest is negative, it is distributed among the positive contributors in the ratio of their contribution.
• Absolute Pro-Data Distribution - Here absolute balances of all accounts are considered and the interest would be shared proportionally to all accounts.

 

Investment Sweep

Investment sweep type should be selected as TD(term deposits) or MM (Money Market) at structure level.

The structure will have header account as Notional account, this account will have only one child account and that child account can have multiple other sub child accounts.

 

 

Holiday Treatment

Specify the action to be taken on the structure in case of a holiday from the drop down list.The options are:

• Next Working Date - Perform the action on the next working day.
• Previous working Date - Perform the action on the previous working day
• Holiday - Perform the action on the designated day itself

Max Backward Days

Specify the maximum number of days the system can go back to execute the structure when the execution day falls on a holiday.

Note

This field will be enabled only if ‘Holiday Treatment’ is selected as ‘Previous Working Date’.

Backward Treatment

When the ‘Holiday Treatment’ is selected as ‘Previous Working Day’ and the ‘Max Backward Days’ set is also falling on a holiday, then the system decides on the day of execution of the action based on the Backward Treatment.

Select the backward treatment to be applied from the drop down list. The options are:

• Move Forward - The action is performed on the next working day
• Holiday - Perform the action on the holiday

Note

This field is enabled only if ‘Holiday Treatment’ is selected as ‘Previous Working Date’.

Parameters like Frequency, Reverse Frequency and Instruction type which are defined at the structure level will be applicable at each account pair level in the structure however user can change these parameters at the account pair level. If the user changes them at the account pair level the system will ignore the structure level set up and go by the pair level settings

FX Rate Pickup

Specify the FX Rate Pickup for the structure from the drop down list. The options are:

Online

Offline

Default value would be “Offline”

7.2.2 Maintaining Accounts in the Structure

Accounts have to be added to create a structure. Click ‘+’ button under the Accounts section to add accounts.The search box opens.

You can search for an account using the following parameters:

 

• Account Number
• Branch Code
• Currency Code
• BIC Code
• External Account

User can search for Account by entering Prefixes in Account Number, Branch Code, External Account, Currency Code and BIC Code text boxes.

 

After clicking on search user will get a list of accounts to be added to the Structure.

 

Select the accounts to be added and click ADD button. The accounts get listed under the Accounts section.

 

You can view the following details of the added accounts:

• Account Number - The account number of the account
• Branch - The branch to which the account belong to
• Currency - The currency of the account
• Current Balance - The current balance in the account
• Available Balance - The available balance in the account
• External Account - If the account is linked to external account or not
• Select - Check this box to select the accounts and delete if not required.

Click ‘Save’ button to save the details.

7.2.3 Maintaining a Structure

After the participating accounts for a structure are selected, you can start creating the structure. Click Next button to start creating a structure.

You can drag and drop accounts into the drawing plane to make the structure. For any account selected, click on the account to view the account details in the ‘Account Details’ section in left. You have to enter the following details:

Account Type

Select the account type of the account from the drop down list. The options are:

• Pool
• Sweep

When an account is set as ‘Pool’, this account is highlighted in blue in the system.

To set account as a child account, drag and drop the accounts onto the parent account.

Mouseover the account to view the ‘+’ link. Click on it to view the structure expanded.

You can mouseover the account to view the ‘-’ link. Click on it to compress the structure.

When an account selected is an external account, this account is highlighted in amber colour..

To view the parent account details of an account, select the account and click on the ‘Parent Details’ link in the left side of the application.You can view the following details:

• Parent Account Number
• Parent Account Bank
• Parent Account Branch
• Parent Branch Currency
• Parent Account Balance
• Parent Account Country
• Parent Account Type
• Parent Account Customer

7.2.3.1 Isolating an account from the structure

Mouseover an account in a structure to view the isolate link. Click on it to isolate the account and view its details. This will be helpful in case of complex structures.

To restore back and view the entire structure, you can click the restore link.

7.2.3.2 Deleting an account in the structure

Click on the account in the structure to view the ‘Delete’ button enabled. Click on this button to delete the account..

7.2.3.3 Maintaining the Control Panel

A control panel allows you to view the designed structure better. Click the control panel icon to open it. The table below briefs the icon and their functions in the control panel.

Icons	Function	Description
	Control Panel	Click this icon to open and close the control panel
	Structure Panel	Click this icon to view the designed structure in vari­ous inbuilt views.
	Zoom to Fit	Click this icon to view the map zoomed to fit the screen
	Zoom In	Click this icon to zoom in and get a closer look
	Zoom Out	Click this icon to zoom out and get an overall look.

7.2.4 Validating the structure

Once the structure is set, click ‘Validate’ button to validate the structure. The system checks the validations set up at the various setup screens and throws error, if the structure formed is not complying.

 

If all the validations are met, system displays a message ‘Structure Validated Successfully’.Click ‘OK’.

7.2.5 Setting Instruction Details

Click ‘Next’ to set the instruction parameters.

Click on a child account to set the instruction details for that child-parent account pair.

Click ‘Instruction Details’ link in the left of the application.Click ‘+’ button to add instruction ID. An option list is displayed with all the instruction IDs maintained in the system.

You can select the instruction ID from the option list. One or more instruction IDs can be selected for an account. Click ‘ADD’ to add them.

In case of multiple Instruction IDs, you can select the instruction priority from the drop down list.

Setting Frequency

To set frequencies for the selected Instruction ID, click on ‘+’ button. An option list is displayed with all the frequencies maintained in the system.

You can select the frequencies from the option list. One or more frequencies can be selected for an instruction. Click ‘ADD’ to add them.

You can click on the Instruction set and view the selected frequencies for it under the tab Frequency.

Delete

Select the check box and click ‘-’ button to delete the frequency.

Viewing Parameters

You can view the parameters values set for an instruction. Select the Instruction and Click on Parameter tab to view the parameter values set for it.

Specifying Instruction Details

You can enter the following details in the Instruction Details section:

Sweep Priority

When a parent has more than one child accounts sweeps are executed based on the Sweep priority. During the sweep execution the least account priority pair will get executed first

Select the sweep priority for the account pair from the drop down list.

Sweep Direction

Select the sweep direction from the drop down list. The options are:

• One Way - Credit balances are only swept out of the account
• Two Way - Sweepin is also supported when the balance of the child account are overdrawn

Rev Sweep Frequency

Reverse sweep frequency is the frequency at which the swept funds are remitted back to remitter account.Specify the frequency of reverse sweep. You can select the frequency from the option list. The list displays all the frequencies maintained in the system.

Parent Sweep Priority

The system provides prioritized sweeps to child accounts if a parent has multiple child accounts in debit balances and the Master/parent account does not have sufficient funds to cover all child account overdrafts during the 2 way sweep

The child account having the least priority will get the funds first.

Instruction Priority

Select the instruction priority from the drop down list. When more than one instruction is set up between a pair of accounts the instruction priority comes in to picture, the instruction with the least number will get executed first

Rate Type

Specify the rate type of the account pair. You can select the rate type from the option list. The list displays all the rate types maintained in the system

EOD

Check this box to execute the instructions at EOD.

Hold

Check this box to hold the execution of instruction of the account pair.

7.2.6 Specifying Payment Details

Payment details are set for the account pair based on which payment parameters will be sent to DDA to fetch the balances.

If the account pair is set for one way, only one way parameter can be viewed on screen. Else both one way and two way options can be viewed. Select the one way and two way parameters from the drop down list. The list displays all the parameters that are set for the account in payment parameters setup.

Payment Instruction for Beneficiary Account details are displayed on the payment instruction panel.

Click Save to save the structure.

7.2.7 Modifying Structure

Any structure which is designed can be modified by opening the structure and clicking on the Modify button.The following modifications can be done:

• Add or delete accounts in the structure
• Change the Instruction parameters set for an account pair
• Resume/Pause the Structure.

You cannot change the header account of a structure..

7.2.8 Resume/Pause the Structure

 

The processing of sweeps\pools on a structure can be paused temporarily by selecting the pause button on the structure though the modification operation.

Following are the effects of Pause on structure.

• If structure is Paused then all the Sweeps (Sweep Structure (Including Investment sweeps of TD & MM)) will be stopped.
• Pools contribution updates (Pool Structure) or Sweep and Pools contribution updates (Hybrid) on the paused structure will be stopped.
• BVT transactions hitting the accounts which are part of a structure\s marked for Pause will be ignored and BVT processing would be skipped for those structures.

The structure processing can be resumed the by unselecting the Pause option.

On Pausing the Structure, Alert gets generated on the alert widget on banker dashboard about the structure being paused for execution.

On revoking the Pause, an Alert message should be generated on the Alert widget on banker dashboard about the structure pause being revoked.

 

7.2.9 Get history for structure

On selection of Get History option user would be able to view the entire history for that specific Structure starting from the creation, pause, resume and modifications.

 

 

 

7.3 Structure Summary

This screen is used to find out the structure in which the selected account is a participant . User can search records using Customer ID, Account Number & Structure ID.

 

 

Customer ID

Specify the customer ID.

Account Number

Specify the account number of the customer.

Structure ID

Specify the Structure ID associated to the customer

On Click of Get Details button, Structure details will be display in Structure Summary Tab