Batch File Upload

This facility is used for the upload of the following Batch Processes:

- BENEFICIARY MEMBER LOAD

- BIB BANK STATEMENT UPLOAD

- BIB EFT FILE

- MEMBER VALUES LOAD

- EXTERNAL PORTFOLIO VALUE UPLOAD

- MEMBERS DWP VALUES UPLOAD

- AUDIT FILE UPLOAD

- HOME AFFAIRS LOAD

- CPS UPLOAD

- PERSON DETAILS LOAD

- BANK STATEMENT UPLOAD - EFT

Navigate the system as follows:

From the Main Functionality menu select Process > File Transfer > File Transfer

Select Batch File Upload from the sub-menu on the left. 

The Batch File Upload screen will be displayed.

Select one of the following Batch Processes from the drop-down list:

- BENEFICIARY MEMBER LOAD

- BIB BANK STATEMENT UPLOAD

- BIB EFT FILE

- MEMBER VALUES LOAD

- EXTERNAL PORTFOLIO VALUE UPLOAD

- MEMBERS DWP VALUES UPLOAD

- AUDIT FILE UPLOAD

- HOME AFFAIRS LOAD

- CPS UPLOAD

- PERSON DETAILS LOAD

- BANK STATEMENT UPLOAD - EFT

Use BROWSE (refer to File upload above) to find the document to be uploaded, then click SUBMIT.  A message will confirm that the file has been successfully

Once the file has been loaded, the relevant batch job can be submitted.

For information about submitting batch jobs refer to

Reports

Batch Runs

Locate the required batch job from the list.

To initiate the batch job, click Submit in the action column.

The progress of the batch job can be monitored in the error log.

After the batch job has completed, the error log must be checked for any errors. 

Refer to

Reports

General

Error Log Report

For details of the file layout, refer to

Processes

File Transfer

File Layouts

Batch Files

For more details on uploading a file received from Home Affairs refer to

Supplements

Processes

Processing the Home Affairs File

Input file layout

Detail record layout

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.

ITAX TAX DIRECTIVE FILE UPLOAD

Translation Values

The system uses Translation values with a Translation Purpose of ITAX and with Source System Attributes as per the following table:

The system uses Translation values as per the following table:

File Upload

The iTax Directive Reconciliation file is uploaded via the File Transfer > Batch File Upload page.

The file is a text file in the format in the table below.

File Processing

When the iTax file is uploaded the system finds the Benefit Tax Directive record with a value for FUND_NAME equal to the value for FundName in the iTax import file and for which the following values are equal to the equivalent value in the table below and for which the Membership Status of the Membership to which the Benefit Tax Directive record is linked is EXIT IN PROCESS.

Note:  The MemberNo value in the file is not equal to the Membership Reference Number on the system.  In the case of Scheme Code 008000 it is made up of the Membership Reference Number followed by PSSPF e.g. 80335269PSSPF.

The applicable fields on the Benefit Tax Directive record are updated as per details in the Benefit Tax Directive Value column in the table below.

If a Benefit Tax Directive record cannot be found an error message is written to the error log.