File Layout: Membership Group Category Changes

Interface:           1b

Frequency:          Monthly

Description:        

 

The requirement from SAP is to receive the pensions scheme indicator whenever it changes on Vision.  In certain scenarios, this will be received from SAP on Interface 1 and for the other scenarios; these changes will be extracted from Vision and sent to SAP in the interface 1B file.

 

For the schemes that have the scheme parameter of INTERFACE 1B, once a month the following membership group category changes that have not been extracted in a previous extract, will be extracted:

-       For all new members that have been added manually to Vision without going through Interface 1.

-       When the eligibility batch job moves a member from one membership group to another.

-       When there are manual category changes.

 

File layout

NO HEADER

 

DATA

Field

Position

Length

Type

Group SAP Fields

Comments

Member Number (MEMBNO)

1 - 8

8

N

 

Right justified with leading zeros

Staff Number (ALTKEY)

9 - 16

8

N

 

 

Pension Scheme Indicator (PSCHIND)

17 - 18

2

X

 

 

Pension Scheme change date (PSCHDTE)

19 - 28

10

D

 

dd/mm/ccyy

 

OUTPUT TRAILER RECORD

Field

Position

Length

Type

Group SAP Fields

Comments

Identifier

1 – 4

4

X

 

TR01

Record Count

5 – 14

10

X

 

A count of the number of records supplied in the file, excluding the trailer record.

Filler

15 - 44

30

X

 

Blanks