Member Investment Splits

If a member's investment is split across multiple portfolios, one record per portfolio is required. Applicable to live members and living annuitants.

 

Validations

The following validations are performed during the process:

-          The member must exist on the system.

-          The scheme must exist on the system.

-          If multiple records are found in the same file for the same member, the process will ensure that the total of the splits adds up to 100%.

-          Investment portfolios must be valid for the scheme.  The user is able to change the input portfolio to a valid one in order to continue processing.

-          The income type for the member must match the scheme income type otherwise the file will be reject.

 

View data uploaded

Log in to the system from the Logon page.

 

Click , then click . 

Note:

This will only be available to users with PAYROLL or SUPER USER security access.

 

The Welcome screen will be displayed.

 

 

From the main menu on the top, select Payroll.  The Payroll screen will be displayed.

 

 

From the main menu on the top, select Reports.

 

The Pay Centre / Fund Selection screen will be displayed. 

 

 

Select the required pay centre and cycle.  The Reports screen will be displayed.

 

 

Select the Investment Splits report from the sub-menu on the left.

 

 

The Investment Splits screen will be displayed.

 

 

 

The following screen shows a member record prior to the load of investment splits.

 

 

 

The following screen shows the report after the load of investment splits.

 

 

 

Input file example

 

 

Input file layout

Header record

 

Field Name

Field Size

DEC

ATTR

Start

End

Description / Value

1

File id code

4

 

Char

1

4

AB00

2

Fund number

7

 

Char

5

11

Fund number

3

IN.pensions scheme code

7

 

Char

12

18

IN.pensions scheme code

4

Conversion Date

8

 

Num

19

26

CCYYMMDD - Conversion date

5

System date

8

 

Num

27

34

CCYYMMDD - system date

6

System time

6

 

Num

35

40

Hhmmss - system time

 

Detail record

 

Field Name 

Field Size 

DEC

Start

End

ATTR 

O/M

Description / Value 

1 

File indicator

4 

 

1

4

Char 

M

MINV

2 

Fund number

7 

 

5

11

Char 

M

Scheme code

3 

Member number

20 

 

12

31

Char 

M

Member reference number

4 

Investment Portfolio

8

 

32

39

Char

M

Investment Portfolio Code

5

Investment percentage

7

2

40

46

Num

M

Investment Split percentage

6

Income Type

4

 

47

50

Char

O

Scheme income type

O = Optional field

M = Mandatory

 

Note:

All optional text fields must be padded with trailing spaces.

All numeric fields must be padded with leading zeroes.

 

Trailer record

 

Field Name 

Field Size 

DEC

Start

End

ATTR 

Description / Value 

1 

File indicator

4 

 

1

4

Char 

AB99

2

Number of detail records

13

 

5

17

Num

Total number of detail records      (Prefix MINV)

3 

Fund number

13 

 

18

30

Num 

#total of scheme codes on file

4 

Member number

13 

 

31

43

Num 

#total of member numbers

5

Total Percentage in File

13

2

44

56

Num

#total of investment percentages

 

Note:

If the member reference number is greater than 20 characters, the trailer record will not produce the correct results.