This file contains the member pensionable service dates.
Note:
Pensionable service dates can also be taken on using the transfer and service details file. Refer to
Processes
File Transfer
File Layouts
Member Values
The following validations are performed during the process:
- The date format must be correct (e.g. a date of 19521560 will reject because the month and day are invalid).
- The member must exist on the system.
- The processing of pensionable service dates for exited members is allowed.
Log in to the system from the Logon page.
Click clients.
The Welcome screen will be displayed.
From the main menu on top, click Members. The JU3AO List of Members for a Scheme/Pay Centre screen will be displayed.
Once the required member has been selected, the JU3AO List of Members for a Scheme/Pay Centre screen will be displayed.
Highlight the required member and select Membership Details > Membership Transfer Detail from the sub-menu on the left.
The JU3AL Membership Transfer Details List screen will be displayed.
The transfer date shown is the date the data was loaded into the system.
To view details of the transfer, select the item and select OPEN. The JU3AL Membership Transfer Details Maintain screen will display the transfer details that were loaded.
The pensionable service date that was loaded via the conversion tool will be shown.
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 |
AB60 |
|
2 |
Fund number |
7 |
|
5 |
11 |
Char |
M |
Scheme code |
|
3 |
Member number |
20 |
|
12 |
31 |
Char |
M |
Member reference number |
|
4 |
Pensionable service date |
8 |
|
32 |
39 |
Num |
M |
Member’s pensionable service date - CCYYMMDD |
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 AB60) |
|
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 |
Pensionable service date |
13 |
|
44 |
56 |
Num |
#total of pensionable service dates |
Note:
If the member reference number is greater than 20 characters, the trailer record will not produce the correct results.