Support Material
Go to
- RMBS XML Schema (XSD)
- RMBS Excel Data Submission Template
- RMBS Example Excel Data Submission File
- CMBS XML Schema (XSD)
- CMBS Excel Data Submission Template
- CMBS Example Excel Data Submission File
- Other ABS XML Schema (XSD)
- Other ABS Excel Data Submission Template
- Other ABS Example Excel Data Submission File
- Cash Flow Waterfall XML Generation Tool
- Securitisation System B2B API Technical Implementation Notes
- Securitisation System Technical Support Notes
- Information Provider Quick Reference Card
- Support Process
RMBS XML Schema (XSD)
Defines the format in which securitisation data must be submitted to the Securitisation System. Subsequent versions of the XML Schema will be published if necessary as the Project moves through testing. Versions will be released on the Securitisation Industry Forum website on an end-month basis as necessary.
- RMBS XML Schema (XSD) – version 1.2 [XSD] – last updated: 1 October 2014
RMBS Excel Data Submission Template
A formatted Excel spreadsheet with the RMBS XML Schema (XSD) imbedded which Information Providers can directly enter their RMBS submission data (except for the Cash Flow Waterfall Model and related data) into and then easily save in the required XML format from Excel. (Please note that the purpose of the Template is to provide guidance on how to create submission XML files using Excel. It is a point in time aid in your solution development and set up. The Template will not be maintained by the RBA on an ongoing basis beyond the 30th June 2015 commencement of mandatory reporting.)
- RMBS Excel Data Submission Template – version 1.4 [XLSX] – last updated: 19 March 2015
RMBS Example Excel Data Submission File
An example leveraging the RMBS Excel Data Submission Template with dummy data and the associated Excel generated XML file produced using the Excel save as type ‘XML’ option. (Please note the data in these files are dummy data not reflective of the RBA's RMBS reporting requirements and does not contain the Cash Flow Waterfall Model and related data. For detailed guidance regarding data to be reported, refer to Data to be Reported.)
- RMBS Example Excel Data Submission File – version 1.4 [XLSX] – last updated: 31 October 2014
- RMBS Example XML Output – version 1.3 [XML] – last updated: 31 October 2014
CMBS XML Schema (XSD)
Defines the format in which securitisation data must be submitted to the Securitisation System. Subsequent versions of the XML Schema will be published if necessary as the Project moves through testing. Versions will be released on the Securitisation Industry Forum website on an end-month basis as necessary.
- CMBS XML Schema (XSD) – version 1.0 [XSD] – last updated: 1 October 2014
CMBS Excel Data Submission Template
A formatted Excel spreadsheet with the CMBS XML Schema (XSD) imbedded which Information Providers can directly enter their CMBS submission data (except for the Cash Flow Waterfall Model and related data) into and then easily save in the required XML format from Excel. (Please note that the purpose of the Template is to provide guidance on how to create submission XML files using Excel. It is a point in time aid in your solution development and set up. The Template will not be maintained by the RBA on an ongoing basis beyond the 30th June 2015 commencement of mandatory reporting.)
- CMBS Excel Data Submission Template – version 1.1 [XLSX] – last updated: 19 March 2015
CMBS Example Excel Data Submission File
An example leveraging the CMBS Excel Data Submission Template with dummy data and the associated Excel generated XML file produced using the Excel save as type ‘XML’ option. (Please note the data in these files are dummy data not reflective of the RBA's CMBS reporting requirements and does not contain the Cash Flow Waterfall Model and related data. For detailed guidance regarding data to be reported, refer to Data to be Reported.)
- CMBS Example Excel Data Submission File – version 1.0 [XLSX] – last updated: 28 November 2014
- CMBS Example XML Output – version 1.0 [XML] – last updated: 28 November 2014
Other ABS XML Schema (XSD)
Defines the format in which securitisation data must be submitted to the Securitisation System. Subsequent versions of the XML Schema will be published if necessary as the Project moves through testing. Versions will be released on the Securitisation Industry Forum website on an end-month basis as necessary.
- Other ABS XML Schema (XSD) – version 1.1 [XSD] – last updated: 8 December 2014
Other ABS Excel Data Submission Template
A formatted Excel spreadsheet with the Other ABS XML Schema (XSD) imbedded which Information Providers can directly enter their Other ABS submission data (except for the Cash Flow Waterfall Model and related data) into and then easily save in the required XML format from Excel. (Please note that the purpose of the Template is to provide guidance on how to create submission XML files using Excel. It is a point in time aid in your solution development and set up. The Template will not be maintained by the RBA on an ongoing basis beyond the 30th June 2015 commencement of mandatory reporting.)
- Other ABS Excel Data Submission Template – version 1.2 [XLSX] – last updated: 19 March 2015
Other ABS Example Excel Data Submission File
An example leveraging the Other ABS Excel Data Submission Template with dummy data and the associated Excel generated XML file produced using the Excel save as type ‘XML’ option. (Please note the data in these files are dummy data not reflective of the RBA's Other ABS reporting requirements and does not contain the Cash Flow Waterfall Model and related data. For detailed guidance regarding data to be reported, refer to Data to be Reported.)
- Other ABS Example Excel Data Submission File – version 1.0 [XLSX] – last updated: 28 November 2014
- Other ABS Example XML Output – version 1.0 [XML] – last updated: 28 November 2014
Cash Flow Waterfall XML Generation Tool
A utility that will read a Cash Flow Waterfall Excel file (prepared according to Cash Flow Waterfall Template) and produce an associated XML file. (Please note that the purpose of the Template is to provide guidance on how to create submission XML files using Excel. It is a point in time aid in your solution development and set up. The Template will not be maintained by the RBA on an ongoing basis beyond the 30th June 2015 commencement of mandatory reporting.)
- Cash Flow Waterfall XML Generation Tool – version 1.3 [XLSM] – last updated: 19 March 2015
Securitisation System B2B API Technical Implementation Notes
The Securitisation System B2B API Technical Implementation Notes describe how an Information Provider (IP) user can use the B2B API web services to programmatically upload submission files to the Securitisation System.
- B2B API Technical Implementation Notes – version 1.2 [PDF] – last updated: 28 April 2015
Securitisation System Technical Support Notes
Explanatory notes on how to interpret and use the RMBS, CMBS and Other ABS XML Schema (XSD), RMBS Excel Data Submission Template, and Cash Flow Waterfall XML Generation Tool. Subsequent versions will be released as necessary.
- Technical Support Notes – version 1.7 [PDF] – last updated: 28 April 2015
Information Provider Quick Reference Card – Preparing the First Submission
The purpose of this document is to help IPs understand how to produce their first XML submission data file. In the one-page document, IPs are able to access a step-by-step guide with an illustrative submission process using the published Example Tools and Templates. Please note that the document is a guide only and the Example Tools and Templates are not an RBA recommended or supported solution.
- Information Provider Quick Reference Card – Preparing the First Submission [PDF] – last updated: 19 March 2015
Support Process
Please contact the Securitisation Support Centre on ssc@rba.gov.au or 1800 919 211