File Layout: New Pensioners and Changes to Pensioner Records

Interface:           3

Frequency:          Monthly

Description:         New pensioners and changes to pensioner and beneficiary records.  After the annuity run or a separate increase run has been authorized, a file will be created containing new pensioners and changes to pensioner records which have occurred since the last payment run.

 

The annuity run must be scheduled at a holding fund level.

 

After the annuity run has been authorized, a file will be created containing new pensioners, changes to pensioners and beneficiary records that have occurred since the last payment run.

 

File layout

NO HEADER

 

DATA

Field

Position

Length

Type

Group SAP Fields

Comments

BASIC.MEMBNO

1 – 8

8

N

 

Right justified with leading zeros
Populated on every row

BASIC.MEMBNO SUFFIX

9 - 10

2

 

 

2 digit suffix of beneficiary member number.  Blank for member pensioners

Staff Number (BASIC.ALTKEY)

11 - 18

8

N

 

Right justified with leading zeros.

 

Populated on every row using SAP pensioner staff number, but would be '00000000' for new member & beneficiary pensioners.

Blank (BASIC.ALTKEY)

19 - 22

4

X

 

Position 19 to 22 must be left Blank as they will be ignored.

 

No staff number should ever by longer than eight characters, but to should the situation arise, the value should be truncated from the left.  (123456789876 will therefore appear as 56789876 and 12345 will appear as 00012345.)

PEN.PENDTE

23 - 32

10

D

 

dd/mm/ccyy
Populated for new pensioners only

BASIC.SEX

33 - 33

1

C

 

Populated for new pensioners only

BASIC.SURNAM

34 - 63

30

X

 

Populated for new pensioners or if data item has been updated

BASIC.DOB

64 - 73

10

D

 

dd/mm/ccyy
Populated for new pensioners only

BASIC.NINO

74 - 82

9

X

 

Populated for new pensioners only

BASIC.TITLE

83 - 83

1

C

 

Populated for new pensioners or if data item has been updated

BASIC.NAME1

84 - 113

30

X

 

Populated for new pensioners or if data item has been updated

BASIC.NAME2

114 - 143

30

X

 

Populated for new pensioners or if data item has been updated

ADDRESS.ADDCDE

144 - 144

1

C

 

Populated for new pensioners or if data item has been updated

ADDRESS.ADLIN1

145 - 184

40

X

 

Populated for new pensioners or if data item has been updated

ADDRESS.ADLIN2

185 - 224

40

X

 

Populated for new pensioners or if data item has been updated

ADDRESS.ADLIN3

225 - 264

40

X

 

Populated for new pensioners or if data item has been updated

ADDRESS.ADLIN4

265 - 304

40

X

 

Populated for new pensioners or if data item has been updated

ADDRESS.PSTCDE

305 - 314

10

X

 

Populated for new pensioners or if data item has been updated

ADDRESS.CNTRY

315 - 316

2

C

 

Populated for new pensioners or if data item has been updated

ADDRESS.ADDNME

317 - 344

28

X

 

Populated for new pensioners or if data item has been updated

PENSION.TAXIND

345 - 346

2

C

 

Populated for new pensioners only

TAXCDE1

347 - 351

5

X

 

Populated for new pensioners only

TAXBAS1

352 - 356

5

X

 

Populated for new pensioners only

PEN.REINCDE

357 - 358

2

C

 

Populated for reinstatements only

PEN.REINDTE

359 - 368

10

D

 

dd/mm/ccyy
Populated for reinstatements only

PEN.SUSCDE

369 - 370

2

C

 

Populated for suspensions only

PEN.SUSDTE

371 - 380

10

D

 

dd/mm/ccyy
Populated for suspensions only

PEN.DOCESS

381 - 390

10

D

 

dd/mm/ccyy
Populated for cessations only

PEN.BKSORT1

391 - 396

6

X

 

Populated for new pensioners or if data item has been updated

PEN.BKACC1 *

397 - 414

18

X

 

Populated for new pensioners or if data item has been updated

PEN.BSROLL1

415 - 432

18

X

 

Populated for new pensioners or if data item has been updated.

If the account type is BUILDINGSOCIETY in the PEN.BSROLL1 field, include the Building Society Roll Number that is stored on the member values table. 

PEN.METHOD

433 - 433

1

C

 

Populated for new pensioners only

PEN.OSBANK *

434 - 463

30

 

 

 

PEN.OSBRANCH *

464 - 493

30

 

 

 

PEN.OSTOWN *

494 - 523

30

 

 

 

PEN.OSCNTRY *

524 - 553

30

 

 

 

PEN.BSNAME

554 - 580

27

X

 

Building Society Name

PAYAMT.STARTDTE1

581 - 590

10

D

 

dd/mm/ccyy
Populated for new pensioners and pension increases

PAYAMT.PAYCDE1

591 - 594

4

C

 

Populated for new pensioners and pension increases

PAYAMT.AMOUNT1

595 - 606

12

N

 

Populated for new pensioners and pension increases

PAYAMT.STARTDTE2

607 - 616

10

D

 

dd/mm/ccyy
Populated for new pensioners and pension increases

PAYAMT.PAYCDE2

617 - 620

4

C

 

Populated for new pensioners and pension increases

PAYAMT.AMOUNT2

621 - 632

12

N

 

Populated for new pensioners and pension increases

PAYAMT.STARTDTE3

633 - 642

10

D

 

dd/mm/ccyy
Populated for new pensioners and pension increases

PAYAMT.PAYCDE3

643 - 646

4

C

 

Populated for new pensioners and pension increases

PAYAMT.AMOUNT3

647 - 658

12

N

 

Populated for new pensioners and pension increases

PAYAMT.STARTDTE4

659 - 668

10

D

 

dd/mm/ccyy
Populated for new pensioners and pension increases

PAYAMT.PAYCDE4

669 - 672

4

C

 

Populated for new pensioners and pension increases

PAYAMT.AMOUNT4

673 - 684

12

N

 

Populated for new pensioners and pension increases

PAYAMT.STARTDTE5

685 - 694

10

D

 

dd/mm/ccyy
Populated for new pensioners and pension increases

PAYAMT.PAYCDE5

695 - 698

4

C

 

Populated for new pensioners and pension increases

PAYAMT.AMOUNT5

699 - 710

12

N

 

Populated for new pensioners and pension increases

Initials

711 - 715

5

X

 

 

 

NO TRAILER