CPY and EB Ledger Overview and Setup

 

The Corporate Payment System (CPY) extract is an interface between IN.pensions and the Metropolitan Corporate Payment System for cheque and EFT payments.

 

The EB Ledger (Smartstream) interface is an interface between the IN.pensions scheme ledger and the Metropolitan Employee Benefits ledger maintained on Smartstream for insured funds (audit exempt funds).

 

These interfaces are dependent on certain data being available and correct on IN.pensions.  The data required is listed below under the appropriate area.

 

Scheme details

The following values need to be available on the scheme details:

 

Administrator Branch

This is used for the BRN_CDE on the CPY interface to indicate the department of the user who initiated the payment

Refer to

Infrastructure

System Entities

*Administrator Structure

 

Registrations

A registration type of METROPOLITAN GENERAL LEDGER ENTITY is used to indicate the Ledger ENTITY (e.g. 024 – Metropolitan SA) and the ENTITY code must be captured as the registration number.

 

Refer to

Infrastructure

System Rules

*Required Registration

 

Investments

The scheme code for the investment only fund must be captured as the ACCOUNT NUMBER on the investment portfolio for those investments managed by Metropolitan Asset Managers for which entries are created in the EB Ledger interface, e.g.:

 

Money Market (Pension Fund)

8027

Money Market (Provident Fund)

8043

Fixed Interest (Pension Fund)

8028

Fixed Interest (Provident Fund)

8044

Futurebuilder (Pension Fund)

8030

Futurebuilder (Provident Fund)

8048

Managed Fund (Pension Fund)

8031

Managed Fund (Provident Fund)

8047

Optimum Growth (Pension Fund)

8032

Optimum Growth (Provident Fund)

8046

Absolute (Pension Fund)

8258

Absolute (Provident Fund)

8256

 

Translation values

Refer to *Corporate Payment System (CPY) and *EB Ledger Interface

 

ACC/QUAL

Source System

Combination of IN.pensions account code and account qualifier code (e.g. income type code, benefit event, portfolio code)

Target System

EB Ledger account code

 

BANK CODE

Source System

IN.pensions scheme code

Target System

CPY bank code

 

TERRITORY

Source System

IN.pensions country

Target System

EB Ledger country code

 

SCHEME CODE

Source System

IN.pensions scheme code

Target System

 

EB Ledger valuation category

FUND

Source System

IN.pensions fund code

Target System

EB Ledger fund code