Understanding the CSV Output for SuperStream Superannuation Reporting

Run the Superannuation XML Extract report (R75A0350) after you have run the payroll to extract the superannuation data and generate the output to send to funds or the clearing house. You run this report to generate the output in the PDF, or the CSV. You use this report to report the fund and employee payroll data in the format specified by your clearing house. The CSV format is controlled by a Word template in BIP (Business Intelligence Publisher) named Superannuation XML Extract - CSV Template (TP75A0350A). You can download it from the BI Publisher Object Repository program (P95600). You can make modifications to the template to conform to your clearing house format and then upload it using the BI Publisher Object Repository program. To do this, you need to first select the template, click Select, and then click OK in the BI Publisher Object Repository program.

Note:

Enter a default value 111111111 in the Member Client ID field in the Superannuation XML Extract- CSV Template (TP75A0350A). You set up the Member Client ID when the employee has not yet received the Membership Number. Therefore, the CSV file prints Member Client ID as a blank field.

To print the registration data, you must run at least one payroll process.

Then, after changing the extension of the .txt generated by the system to .csv, you send the report in the CSV format to your clearing house for further processing and for conversion to the standard XBRL format. The CSV file supports the exchange of contribution and member registration data between employers and funds.

Table Number	Table Name	Columns in CSV/PDF
F0010	Company Constants	Message sender details based on processing option setting and payer details
F0111	Address Book - Who's Who	Message sender details and superannuation find member name details
F01151	Electronic Address	Sender's electronic mail
F0115	Address Book - Phone Numbers	Sender's phone numbers and superannuation fund member's phone numbers
F0030	Bank Transit Master	Payer's bank details and payee's bank details
F07845	Fund Master	Payee details (customer reference number and BPAY Biller code)
F08001	Job Information	Occupation Description
F060116	Employee Master Information	Superannuation fund member's Demographic details, Country code, Employment payroll number, Last employment date, Employment Start Date, Annual Salary for Contributions, Effective Start Date, Annual Salary for Insurance Amount, Weekly Hours Worked Number, Fund Registration Date, Employment Status Code
F0116	Address by Date	Superannuation fund member's address details
F01151	Electronic Address	Superannuation fund member's electronic mail ID
F75A0006	Australian Employee Tax Override	Superannuation fund member's tax file number
F07855	Employee Fund Allocation	Superannuation fund member's client ID, Super Contribution start date
F75A0010	Australian Employee Termination	Superannuation fund member's last employment end reason
F0719	DBA Transaction Detail History	Superannuation fund member contribution details related to pay period end date, Superannuation guarantee amounts award or productivity amount, personal contribution amount, Employer contributions salary sacrificed amount, Contribution voluntary amount, Spouse contribution amount, Child contribution amount, and Third party contribution amount. The system assigns DBAs based on the special handling code defined in UDC table 07/FD.

Table Number	Table Name	Columns in CSV/PDF
F0010	Company Constants	Message sender details based on processing option setting and payer details
F0111	Address Book - Who's Who	Message sender details and superannuation find member name details
F01151	Electronic Address	Sender's electronic mail
F0115	Address Book - Phone Numbers	Sender's phone numbers and superannuation fund member's phone numbers
F0030	Bank Transit Master	Payer's bank details and payee's bank details
F07845	Fund Master	Payee details (customer reference number and BPAY Biller code)
F08001	Job Information	Occupation Description
F060116	Employee Master Information	Superannuation fund member's Demographic details, Country code, Employment payroll number, Last employment date, Employment Start Date, Annual Salary for Contributions, Effective Start Date, Annual Salary for Insurance Amount, Weekly Hours Worked Number, Fund Registration Date, Employment Status Code
F0116	Address by Date	Superannuation fund member's address details
F01151	Electronic Address	Superannuation fund member's electronic mail ID
F75A0006	Australian Employee Tax Override	Superannuation fund member's tax file number
F07855	Employee Fund Allocation	Superannuation fund member's client ID, Super Contribution start date
F75A0010	Australian Employee Termination	Superannuation fund member's last employment end reason
F0719	DBA Transaction Detail History	Superannuation fund member contribution details related to pay period end date, Superannuation guarantee amounts award or productivity amount, personal contribution amount, Employer contributions salary sacrificed amount, Contribution voluntary amount, Spouse contribution amount, Child contribution amount, and Third party contribution amount. The system assigns DBAs based on the special handling code defined in UDC table 07/FD.