Termination Notices File (System Reports General)

This report provides an extract of information relating to terminations for contracted out Schemes.

 

Although the Personal Investment Plan scheme is the only contracted out scheme, the extract also applies to the members in the Afterwork scheme with a deferred membership for which the previous scheme within the UK is a contracted out scheme.

 

For more information, refer to

Client Specific

ACA

UK MI Reports

Termination Notices File

 

From the General menu, click  alongside Termination Notices File on the sub-menu on the left.  Additional options will be displayed.

 

 

New

Click New below Termination Notices File.  The Termination Notices Report screen will be displayed.

 

 

Capture the effective date of the report and your email address.  Click GENERATE REPORT.

 

A message will indicate once the job has been successfully submitted (and an e-mail will be sent to you, if you requested to be notified).

 

Job submitted successfully

 

 

A CSV file will be created as per the following file layouts:

 

Header Record Layout

Field No.

Field

1

Header Record Identifier

2

Authoriser User Number

3

User’s Name

4

User’s Address

5

FGN

6

Filler

 

Data Record Layout

Field No.

Field

N/A for UK

1

Data Record Identifier

Yes

2

Designator

Yes

3

Dual Guaranteed Minimum Pension calculation

N/A

4

Employer’s Contracted-Out Number (ECON)

Yes

5

Scheme Contracted-Out Number (SCON)

Yes

6

National Insurance Number (NINO)

Yes

7

Employees Full Surname

Yes

8

First and Second Initials Respectively

Yes

9

Pre-payment Indicator

N/A

10

Remittance amount payable

N/A

11

Commencement Date

Yes

12

Termination Date

Yes

13

Employees Earnings between lower and upper earnings limits during tax year of termination

N/A

14

Employees Earnings between lower and upper earnings limits during tax year before termination

N/A

15

Retrospective Earnings

Yes

16

Transferred ECON

Yes

17

Transferred SCON

Yes

18

Appropriate Scheme Contracted-Out Number (ASCN)

Yes

19

New ECON

Yes

20

New SCON

Yes

21

New ASCN

Yes

22

New Commencement Date

Yes

23

Transfer Date

N/A

24

Revaluation Date

N/A

25

Revaluation Indicator

Yes

26

Premium Liability Indicator

N/A

27

Widow/Widowers/Surviving Civil Partners Indicator

N/A

28

Employer’s Reference Number

Yes

29

Change ECON (Contracted Out Money Purchase Indicator CA1953)

Yes

30

Date of Effect

N/A

31

Method of Preservation Indicator

N/A

32

Date of Death

Yes

33

Widow/Widowers/Surviving Civil Partners NINO

N/A

34

Widow/Widowers/Surviving Civil Partners Checkbrick

N/A

35

Transfer of Contracted Out Mixed Benefit Scheme membership

N/A

36

Filler

Yes

 

Trailer Record Layout

Field No.

Field

1

Record Identifier

2

Total Input Items (Type 2 records)

3

Total Remittances

4

Total Amount Paid (Designator X)

6

Filler

 

For more detail, refer to

Client Specific

ACA

UK MI Reports

Termination Notices File

 

View

Click View below Termination Notices File.  The Terminations Report screen will be displayed.

 

 

This screen displays a list of the extracts created.

 

The following columns are displayed:

-          Processed Timestamp

-          Effective Date

-          Report Type

-          File Name

-          Sequence Number

-          Action

 

The following fields are available as search criteria:

-          Report Type

-          File Name

 

To download an extract file, click on the hyperlinked Download File in the Action column alongside the appropriate extract.

 

The following screen will be displayed, with the message: 

 

The selected file(s) have been combined into 1 compressed file.

Click here to download the files selected.

 

 

The CSV file will be downloaded to a selected directory.  The data will can be accessed in a CSV file via WinZip.