Payment File Extracts (Annuity)

This facility extracts the electronic payment file or the Bureau Focus extract file.

 

Click  alongside Payment File Extract on the sub-menu on the left.  Additional options will be displayed.

 

 

EFT extract

Click EFT Extract below Payment File Extract.  A message will confirm that the batch job has started successfully.

 

 

Note:

JU2AB_EFT\Bju2ABo0.bat is the JU2AB Creation of the EFT files batch job.

 

All EFT files (with the exception of Bureau Focus) will be extracted.

 

Bureau Focus extract

Click Bureau Focus Extract below Payment File Extract.  A message will confirm that the batch job has started successfully.

 

 

Note:

JU2AS_BF\Bju2ASo0.bat is the JU2AS BUREAU FOCUS File Extract batch job.

 

Bureau Focus files will be extracted.

 

Note:

When the Bureau Focus file is created for EFT collections for Debit Orders, the system will read the value for Description on the Global Parameter with a Parameter Type of EFT CUT-OFF.  If the current time is greater than the value found and the Date Effective on the EFT Instruction is less than or equal to current date, the value for Action Date on the EFT file will be set to the next working day.

 

Effective date of annuity payment

If a member retires on any day other than the last day of the month, a pro-rata portion of the monthly pension is calculated and paid together with the first monthly pension.

 

Bank disks

Note:

The following functionality is restricted, and is only available to PSPF.

 

When the batch job has run successfully, and provided the payment method is EFT, bank disks will be produced for the following banks only:

 

-          NEDBANK SWAZILAND

-          STANDARD BANK

-          SWAZI BUILDING SOCIETY

 

The files will be written to the directory specified for the batch parameter BANK DISKS.

 

NEDBANK SWAZILAND

One file is produced.  It will be named [month][YY] PSPF Payroll.txt
(e.g. August05 PSPF Payroll.txt).

 

The file is written as a text file, but it must be opened in Excel.  The file must be imported as comma delimited, and the column data format must be set as shown in the file layout below.

 

Column 

Description 

Column Data Format

A 

Account Number 

Text

B

Branch Code

Text

C 

Amount 

General

D

Account Holder

Text

 

STANDARD BANK

One file is produced.  It will be named Std [month][YY].prn
(e.g. Std AUGUST05.prn).  The following is the file layout:

 

Description 

Position

Bank Account Number 

1-14

Branch Code

15-20

Amount 

21-28

Account Holder

29- end of name

 

SWAZI BUILDING SOCIETY

One file per bank branch is produced.  It will be named SBS[month][branch].txt
(e.g. SBSAUGUSTML.TXT - the branch name is SWAZI BUILDING SOCIETY - ML, and it MUST be named in this format). 

 

The first line contains the number of payments in the file, prefixed with *
(e.g. *         50).

 

The last line contains the total of the payments, prefixed with prefixed with *
(e.g. *         12598273).

 

The following is the file layout:

 

Description 

Position

Amount  

1-25 (no decimals)

Account Holder

26-100

Account Number 

101- end of account number