{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["RMBS Security Level Template","No Data"],"not_rendered":{"images":1,"external_links":2,"defined_names":4},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"RMBS Security Level Template","index":0,"n_rows":126,"n_cols":12,"rows_kept":126,"merged":[[3,9,3,10],[4,9,4,11],[6,9,6,10],[97,1,97,11]],"flags":["formulas_cached_only"]}
[]
[]
[]
[{"$nulls":9},"Legend"]
[{"$nulls":9},"Material data fields to be reported from 31 December 2014"]
[{"$nulls":9},"Non-material data fields to be reported from 30 June 2015"]
[null,"REPORTING TEMPLATE SPECIFICATION FOR REPO-ELIGIBLE SECURITIES"]
[]
[null,"Residential Mortgage Backed Securities"]
[null,"Security Level Data"]
[]
[null,"Version 2.0 (July 2014)"]
[]
[null,"GUIDANCE NOTES"]
[null,"•  All data fields are mandatory."]
[null,"•  Entries should comply with the data formats specified for the relevant field."]
[null,"•  For fields with an ‘M’ entry in the refresh column, it is expected that these fields will be updated on a monthly basis in line with updates to the relevant loan level information."]
[null,"•  When data are not available for a particular field, refer to the \"No Data\" template to record an appropriate response. Unless specified in the guidance notes, data fields should not be left blank under any circumstances."]
[null,"•  For fields with a 'Dynamic' reporting frequency, related data should be as at the most recent report date."]
[null,"•  For fields with a 'Static' reporting frequency, related data should be as at origination. However, if updated information for these fields is available, these data should be recorded."]
[null,"•  Issuers are expected to adhere to the definitions and guidance notes provided in the data template."]
[null,"• This template is to be completed for every security issued from the trust for the transaction."]
[]
[null,"Field Code","Cateogry","Previous Field Name","Revised Field Name","Reporting\nFrequency","Refresh (M = monthly)","Original Description","Revised Description","Data Type","Data Format","Guidance Notes"]
[null,"RS001","Field removed",{"$nulls":8},"Former field name: Report Date"]
[null,"RS002","Field removed",{"$nulls":8},"Former field name: Transaction ID"]
[null,"RS003","Field removed",{"$nulls":8},"Former field name: Master Trust Name"]
[null,"RS004","Field removed",{"$nulls":8},"Former field name: Series Trust Name"]
[null,"RS005","General","Class Name","Tranche Name ","Static",null,"The designation (typically a letter and/or number) given to a class of RMBS which exhibit the same rights, priorities and characteristics as defined in the offering document. Also known as a tranche.","The designation given to a tranche as defined in the deal documentation. ","Text","N/A","Enter as the full tranche name (as defined in the deal documents) including any associated letters, numbers or symbols, e.g. \"Class A1-R\""]
[null,"RS006","General","ISIN","ISIN","Static",null,"ISIN code for the security","ISIN code, if applicable. ","Text","N/A","The security identification code assigned to securities pursuant to the ISO 6166 standards. An ISIN generally consists of three parts, a two letter country code, a 9 digit security identifier and a check code."]
[null,"RS007","Security/Tranche","Austraclear Series ID","Austraclear Series ID","Static",null,"Unique security (series) identifier assigned by Austraclear. Enter N/A for the data field if this security does not have an Austraclear identifier.","Unique security (series) identifier assigned by Austraclear, if applicable.","Text","N/A","Generally a six character combination identifier for securities lodged in Austraclear."]
[null,"RS008","Security/Tranche","Clearing system","Clearing system","Static",null,"Name of any clearing / settlement systems that each class of note will be lodged into. Enter N/A for this data field if the security is not logged with any clearing or settlement system.","Naming convention for the clearing and/or settlement system in which the tranche is lodged.","Text","N/A","Please include one clearing system in which the security is lodged for each entry, if applicable e.g. \"Austraclear\", \"Clearstream\", \"Euroclear\", etc."]
[null,"RS009","Security/Tranche","Issue Date","Issue Date","Static",null,"The date on which a class of securities was first issued","The date on which the tranche was first issued.","Date","dd-mm-yyyy"]
[null,"RS010","Security/Tranche","Accrual Start Date","Accrual Begin Date ","Dynamic",null,"The start date of the accrual period for calculating coupon earned on the securities, in relation to the period being covered in this report.","The date on which the accrual period of the current reporting period begins.","Date","dd-mm-yyyy"]
[null,"RS011","Security/Tranche","Accrual End Date","Accrual End Date","Dynamic",null,"The end date of the accrual period for calculating coupon earned on the securities, in relation to the period being covered in this report.","The date on which the accrual period of the current reporting period ends.","Date","dd-mm-yyyy"]
[null,"RS012","Security/Tranche","Accrual Period","Accrual Period","Dynamic",null,"The number of calendar days in the accrual period inclusive of the Accrual Start Date and the Accrual End Date, in relation to the period being covered in this report.","The number of calendar days in the current accrual period.","Numeric",12]
[null,"RS013","Security/Tranche","Currency of issuance","Tranche Currency","Static",null,"Currency denomination of the security as specified in the currency codes published by the International Organisation for Standardisation (ISO 4217 codes).","Currency denomination of the security as specified in the deal documentation. ","Text","ABC","Use ISO 4217 codes.  For example, \"USD\" should be entered for US dollar denominated tranches."]
[null,"RS014","Field removed",{"$nulls":8},"Former field name: Denomination"]
[null,"RS015","Security/Tranche","Stock Exchange Listings","Exchange Listing ","Static",null,"Full legal name of any exchanges or regulated markets on which the security is intended to be listed and traded. Enter N/A for this data field if the security is not listed or not intended to be listed on an exchange.","Naming convention for the exchange or regulated market on which the tranche is listed.","Text","N/A","Please include one exchange in which the security is listed for each entry, if applicable e.g. \"ASX\", \"Singapore Stock Exchange\", \"Chicago Board of Trade\", etc."]
[null,"RS016","Credit Rating","Credit Ratings Agency","Credit Ratings Agency Name","Static",null,"Identify all credit rating agencies that have rated the security:\n1 - Fitch\n2 - Moody's\n3 - Standard and Poor's\n4 - Other (specify)\nEnter N/A for this data field if the security has not been rated by a ratings agency.","The name of any credit ratings agencies providing a final rating to the security, as at the Report Date. \n1 - Moody’s Investors Service\n2 - Standard and Poors\n3 - Fitch\n4 - Other Credit Ratings Agency","Text","ABC","Only Credit Rating Agency's which have provided final ratings should be included. Any with expected ratings should not be included."]
[null,"RS017","Credit Rating","Original Credit Rating","Original Credit Rating","Static",null,"The original public rating assigned to the security by each Credit Rating Agency. Enter N/A for this data field if the security has not been rated by a ratings agency.","The original credit rating of the security, as at the Settlement Date of the deal.","Text","N/A","Enter the credit rating applying to the tranche in the form provided by the credit ratings agency, e.g. \"AAA\"; \"Aaa\",\"AA+\",etc."]
[null,"RS018","Credit Rating","Current Credit Rating","Current Credit Rating","Dynamic",null,"The current public rating assigned to the security by each Credit Rating Agency. Enter N/A for this data field if the security has not been rated by a ratings agency.","The current credit rating of the security, as at the Report Date.","Text","N/A","Enter the credit rating applying to the tranche in the form provided by the credit ratings agency, e.g. \"AAA\"; \"Aaa\"."]
[null,"RS019","Field removed",{"$nulls":8},"Former field name: Business Day Calendar"]
[null,"RS020","Field removed",{"$nulls":8},"Former field name: Business Day Convention"]
[null,"RS021","Security / Tranche","Original Subordination","Original Subordination","Static",null,"The original level of subordination (expressed as a percentage of the notes issued) supporting each class of security.","Aggregate original principal balance of tranches in subordination to this tranche as a proportion of the original principal balance of all tranches of securities in the deal, as at the Settlement Date of the deal. ","Numeric",12.34,"Expressed as a percentage. E.g. for a deal with a 90m AAA, 5m AA and 5m unrated structure, the subordination to AAA notes will be '10.00' and subordination to the AA notes will be '5.00'."]
[null,"RS022","Security / Tranche","Current Subordination","Current Subordination","Dynamic",null,"The current level of subordination (expressed as a percentage of the current level of notes outstanding) supporting each class of security.","Aggregate Stated Amount of tranches in subordination to this tranche as a proportion of the Stated Amount of all tranches of securities in the deal, as at the Report Date. ","Numeric",12.34,"Expressed as a percentage. E.g. for a deal with a 90m AAA, 5m AA and 5m unrated structure, the subordination to AAA notes will be '10.00' and subordination to the AA notes will be '5.00'."]
[null,"RS023","Security / Tranche","Offer Amount","Current Principal (Face) Amount","Static",null,"Total dollar amount of the security issued.","Total dollar amount (face value) of the securities issued.","Numeric",1234567.89]
[null,"RS024","General","Offer Type","Offer Type","Static",null,"A description of the manner in which the offering is obliged to be made, relevant to the jurisdictions involved. It is dependent on the rules governing the location of investors, and the type of investors to which the offer of securities is made. Examples include REG-AB, REG D and 144A, UCITS regulations.","A description of the manner in which the offering is obliged to be made, relevant to the jurisdictions involved. ","Text","N/A","It is dependent on the rules governing the location of investors, and the type of investors to which the offer of securities is made. E.g. 'REG-AB', 'REG 144A', 'UCITS'."]
[null,"RS025","Field removed",{"$nulls":8},"Former field name: Principal Distribution Frequency"]
[null,"RS026","Field removed",{"$nulls":8},"Former field name: Coupon Distribution Frequency"]
[null,"RS027","Payments","Coupon Payment Reference","Coupon Payment Reference","Static",null,"Is the coupon payment based on the 'invested' or 'stated' amount? Choose one of:\n1 - Invested\n2 - Stated","Is the coupon payment referenced by the Invested Amount. ","Boolean","True/False","Enter True if the Invested Amount is used to calculate the coupon payment, otherwise enter False if the calculation is based on the Stated Amount. For securities that exhibit a hybrid methodology, choose the option that is most representative."]
[null,"RS028","Field removed",{"$nulls":8},"Former field name: Books Close Convention"]
[null,"RS029","Field removed",{"$nulls":8},"Former field name: Books Close Period"]
[null,"RS030","Field removed",{"$nulls":8},"Former field name: Payment Convention"]
[null,"RS031","Field removed",{"$nulls":8},"Former field name: Payment Day Count"]
[null,"RS032","Payments","Coupon Payment Date","Distribution Date","Dynamic",null,"The date on which payment of coupon to holders of a specific class of securities occurred in relation to the current reporting period.","The date on which distributions are made to the note holders and the service providers by the special-purpose vehicle, in the current reporting period.","Date","dd-mm-yyyy"]
[null,"RS033","Field removed",{"$nulls":8},"Former field name: Principal Payment Date"]
[null,"RS034","General","Record Date","Record Date","Dynamic",null,"The date on which registered note holders are determined by the Trustee for the purpose of making payments.","The date on which the entitlement to distributions vests with registered security holders, in the current reporting period.","Date","dd-mm-yyyy"]
[null,"RS035","General","Determination Date","Determination Date","Dynamic",null,"The date on which payments to note holders will be calculated by the Trust Manager for a given payment date.","The date on which the amount of distributions to security holders (and other distributions in respect of special-purpose vehicle assets and liabilities) is determined in the current reporting period.","Date","dd-mm-yyyy"]
[null,"RS036","Payments","Stated Amount per Note Prior to Payment","Beginning Stated Factor ","Dynamic",null,"The ratio of the Stated Amount prior to payment of a specific class of RMBS to the original Stated Amount of the class.","The total principal factor of a tranche inclusive of any charge-offs, at the beginning of the current reporting period.","Numeric",0.1234,"Calculated as the Beginning Stated Amount ÷ Current Principal (Face) Amount"]
[null,"RS037","Payments","Stated Amount per Note after Payment","Ending Stated Factor ","Dynamic",null,"The ratio of the Stated Amount of a specific RMBS class subsequent to payment to the original Stated Amount of the class.","The total principal factor of a tranche inclusive of any charge-offs, at the end of the current reporting period. ","Numeric",0.1234,"Calculated as the Ending Stated Amount ÷ Current Principal (Face) Amount"]
[null,"RS038","Security / Tranche","Total Original Invested Amount ","Original Principal (Face) Amount ","Static",null,"The total original principal balance of a specific class of RMBS at issuance.","The original issued amount (face value) of the securities, as at the Settlement Date of the deal.","Numeric",1234567.89,"Only required if this value is different from the Current Principal (Face) Amount, where a top-up or restructuring of the note balances has occurred."]
[null,"RS039","Payments","Total Invested Amount Prior to Payment","Beginning Invested Amount ","Dynamic",null,"The total principal balance of a specific class of RMBS after the immediately preceding Principal Payment Date (excluding charge-offs and reimbursements).","The total principal balance of a tranche (with no adjustment for charge-offs) at the beginning of the current reporting period. ","Numeric",1234567.89]
[null,"RS040","Payments","Total Invested Amount after Payment","Ending Invested Amount ","Dynamic",null,"The total principal balance of a specific class of RMBS after the Principal Payment Date (excluding charge-offs and reimbursements).","The total principal balance of a tranche (with no adjustement for charge-offs) at the end of the reporting period. ","Numeric",1234567.89]
[null,"RS041","Payments","Total Stated Amount Prior to Payment","Beginning Stated Amount ","Dynamic",null,"The total principal balance of a specific class of RMBS after the preceding Principal Payment Date, after deducting charge-offs and adding reimbursements.","The total principal balance of a tranche adjusted for charge-offs, at the beginning of the current reporting period. ","Numeric",1234567.89]
[null,"RS042","Payments","Total Stated Amount after Payment","Ending Stated Amount ","Dynamic",null,"The total principal balance of a specific class of RMBS after the Principal Payment Date, after deducting charge-offs and adding reimbursements.","The total principal balance of a tranche adjusted for charge-offs at the end of the reporting period. ","Numeric",1234567.89]
[null,"RS043","Payments","Invested Amount per Note Prior to Payment","Beginning Invested Factor ","Dynamic",null,"The principal balance of a single note within a specific class of RMBS after the immediately preceding Principal Payment Date (excluding charge-offs and reimbursements).","The total principal factor of a tranche exclusive of any charge-offs, at the beginning of the current reporting period. ","Numeric",0.1234,"Calculated as the Beginning Invested Amount ÷ Current Principal (Face) Amount"]
[null,"RS044","Payments","Invested Amount per Note after Payment","Ending Invested Factor ","Dynamic",null,"The principal balance of a single note within a specific class of RMBS after the Principal Payment Date (excluding charge-offs and reimbursements).","The total principal factor of a tranche exclusive of any charge-offs, at the end of the current reporting period. ","Numeric",{"v":0.1234,"d":"0.12"},"Calculated as the Ending Invested Amount ÷ Current Principal (Face) Amount"]
[null,"RS045","Field removed",{"$nulls":8},"Former field name: Stated Amount per Note Prior to Payment"]
[null,"RS046","Field removed",{"$nulls":8},"Former field name: Stated Amount per Note after Payment"]
[null,"RS047","Security / Tranche","Coupon Reference Index","Coupon Reference Index","Static",null,"The name of the base reference coupon index as defined in the offering document applicable to a specific class of securities:\n1 - BBSW (Bank Bill Swap Rate)\n2 - Libor\n3 - Euribor\n4 - Other (specify)\nEnter N/A for this data field if there is no base reference coupon index for this security.","The index on which the coupon of a floating-rate security will be paid. ","Text","N/A","If the rate is linked to BBSW or LIBOR 1-month rates then use “BBSW1M”, \"LIBORAUD1M\" as the appropriate value. If it is linked to mortgage rates use “Standard Variable Rate”. If it is linked to another index use a naming convention which clearly identifies the index and the tenor. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS048","Field removed",{"$nulls":8},"Former field name: Coupon Reference Index Tenor"]
[null,"RS049","Security / Tranche","Coupon Reference Rate","Coupon Reference Index Value","Dynamic",null,"Current applicable reference rate applied to a specific class of securities for the Accrual Period. Expressed as a percentage. Enter N/A for this data field if there is no base reference coupon index for this security.","Current interest rate of the Coupon Reference Index.","Numeric",12.3456,"All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS050","Security / Tranche","Current Coupon Margin","Coupon Margin","Static",null,"Margin over/under the Coupon Reference Rate for the current Accrual Period for a specific class. Only required for floating rate notes. Expressed in basis points. Enter N/A for this data field if there is no base reference coupon index for this security.","Margin to the index used to calculate the interest payable to holders of floating-rate securities.","Numeric",123,"Expressed in basis points. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS051","Security / Tranche","Next Step-up Margin","Step-up Margin","Static",null,"The incremental change to the coupon margin for a class of securities. Expressed in basis points. If the transaction does not have a step-up (or similar) margin in the transaction, enter N/A for this data field.","Margin to index or rate (as applicable) to which the interest payable to security holders is increased if the special-purpose vehicle fails to exercise a call or redeem the tranche in full.","Numeric",123,"Expressed in basis points. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS052","General","Step-up Date","Step-up Date","Dynamic",null,"Date upon which there is to be an increase in the coupon payable. If there is no step-up (or similar) margin in the transaction, enter N/A for this data field.","The date on which (if any), the rate or margin on the securities is increased if the special-purpose vehicle fails to exercise a call or redeem the tranche in full.","Date","dd-mm-yyyy"]
[null,"RS053","Payments","Total Scheduled Coupon","Scheduled Coupon ","Dynamic",null,"Total amount of scheduled coupon due on the Coupon Payment Date for a class of notes. ","The total interest scheduled to be paid to note holders, on the current Distribution Date. ","Numeric",1234567.89,"Can be calculated as the Beginning Invested or Stated Amount × Coupon Rate (or Current Coupon Rate, refer to the Coupon Payment Reference field). All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS054","Payments","Scheduled Coupon per Note","Scheduled Coupon Factor ","Dynamic",null,"Amount of scheduled coupon due on the relevant Coupon Payment Date for a single note within a class of notes. ","The total interest distributed to note holders as a factor, on the current Distribution Date. ","Numeric",0.1234,"Calculated as the Coupon Distribution ÷ Current Principal (Face) Amount. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS055","Security / Tranche","Current Coupon Rate","Current Coupon Rate","Dynamic",null,"The coupon rate on the security, which is used to calculate coupon due for the coupon period for each specific class.  Expressed as a percentage.","Rate for calculating interest payable to holders of floating-rate securities. ","Numeric",12.3456,"This field is for floating-rate securities only. Do not include the coupon rate paid on fixed rate securities in this field (these should be reported in Coupon Rate). All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS056","Payments","Total Coupon Payments","Coupon Distribution ","Dynamic",null,"The total amount of coupon paid on a class of RMBS  for the current Coupon Payment Date. ","The total interest distributed to note holders, on the current Distribution Date. ","Numeric",1234567.89,"All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS057","Payments","Coupon Payment per Note","Coupon Distribution Factor ","Dynamic",null,"The total amount of coupon paid on a single note within a specific class of RMBS for the current Coupon Payment Date. ","The total interest scheduled to be paid to note holders as a factor, on the current Distribution Date. ","Numeric",0.1234,"Calculated as the Scheduled Coupon ÷ Current Principal (Face) Amount. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS058","Payments","Total Scheduled Principal","Scheduled Principal ","Dynamic",null,"The total amount of principal scheduled to be paid on a class of RMBS on the Principal Payment Date, as specified in the Offer Document for notes with a pre-defined amortisation schedule.","The total principal scheduled to be paid to note holders, on the current Distribution Date.","Numeric",1234567.89," Applicable to planned or targeted amortisation bonds or soft bullets. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS059","Payments","Scheduled Principal per Note","Scheduled Principal Factor ","Dynamic",null,"The total amount of principal scheduled to be paid on a single note within a specific class of RMBS on the Principal Payment Date, as specified in the Offer Document.","The total principal scheduled to be paid to note holders as a factor, on the current Distribution Date. ","Numeric",0.1234,"Applicable to planned or targeted amortisation bonds or soft bullets. Calculated as the Scheduled Principal ÷ Current Principal (Face) Amount. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS060","Payments","Total Principal Payments","Principal Distribution ","Dynamic",null,"The total amount of principal paid on a class of RMBS for the current Principal Payment Date.","The total principal distributed to note holders, on the current Distribution Date. ","Numeric",1234567.89]
[null,"RS061","Payments","Principal Payment Per Note","Principal Distribution Factor ","Dynamic",null,"The total amount of principal paid on a single note within a specific class of RMBS for the current Principal Payment Date.","The total principal distributed to note holders as a factor, on the current Distribution Date. ","Numeric",0.1234,"Calculated as the Principal Distribution ÷ Current Principal (Face) Amount."]
[null,"RS062","Payments","Current Coupon Shortfall per Note","Coupon Shortfall Factor ","Dynamic",null,"The difference between the Total Coupon Payments per Note and the Scheduled Coupon per Note for the current Accrual Period for the current Coupon Payment Date. ","The difference between the Scheduled Coupon and the Coupon Distribution as a factor, in the current reporting period. ","Numeric",0.1234,"Calculated as the Coupon Shortfall ÷ Current Principal (Face) Amount."]
[null,"RS063","Payments","Cumulative Coupon Shortfall per Note","Ending Cumulative Coupon Shortfall Factor ","Dynamic",null,"The cumulative difference between the Total Coupon Payments per Note and the Scheduled Coupon per Note up to and including the current Accrual Period on a specific class of note. ","The cumulative difference between the Scheduled Coupon and the Coupon Distribution as a factor, at the end of the current reporting period. ","Numeric",0.1234,"Calculated as the Ending Cumulative Coupon Shortfall ÷ Current Principal (Face) Amount."]
[null,"RS064","Payments","Total Coupon Shortfall","Coupon Shortfall ","Dynamic",null,"The difference between the Total Scheduled Coupon and the Total Coupon Payments for the current Accrual Period for a specific class of notes. ","The difference between the Scheduled Coupon and the Coupon Distribution, in the current reporting period.","Numeric",1234567.89]
[null,"RS065","Payments","Cumulative Coupon Shortfall ","Ending Cumulative Coupon Shortfall ","Dynamic",null,"The cumulative difference between Total Scheduled Coupon amounts and the Total Coupon Payment for the current Accrual Period and all previous Accrual Periods on a specific class of notes. ","The cumulative difference between the Scheduled Coupon and the Coupon Distribution, at the end of the current reporting period.","Numeric",1234567.89]
[null,"RS066","Payments","Total Principal Shortfall","Principal Shortfall ","Dynamic",null,"The difference between the Total Scheduled Principal and the Total Principal Payments for the current Accrual Period for a specific class of notes. ","The difference between the Scheduled Principal and the Principal Distribution, in the current reporting period. ","Numeric",1234567.89,"Applicable to planned or targeted amortisation bonds or soft bullets."]
[null,"RS067","Payments","Cumulative Principal Shortfall ","Ending Cumulative Principal Shortfall ","Dynamic",null,"The cumulative difference between Total Scheduled Principal amounts and the Total Principal Payment for the current Accrual Period and all previous Accrual Periods for a specific of class of note.","The cumulative difference between the Scheduled Principal and the Principal Distribution, at the end of the current reporting period.","Numeric",1234567.89]
[null,"RS068","General","Legal Maturity Date","Legal Maturity Date","Static",null,"The date by which a specific class of securities must be fully repaid in order not to be in default.","The date by which the tranche must be redeemed in full, the failure of which constitutes a default.","Date","dd-mm-yyyy"]
[null,"RS069","Security / Tranche","Original Estimated Weighted Average Life (WAL)","Original Estimated Weighted Average Life","Static",null,"As at the date of issuance, the expected weighted average number of years a dollar of principal on the security remains outstanding based on its total original balance. Using the issuer's (not rating agency) underlying assumptions.","The estimated average life of the security as at the Settlement Date of the deal.","Numeric",12.34,"Entered as the number of a years. Use the pricing speeds implied by the Initial CPR (for a constant CPR) or incorporate any ramp assumptions from Ramp Period or Terminal CPR if applicable.For internal (self) or external securitisations with pool top-up facilities, assume that the pool is closed in order to calculate this data field."]
[null,"RS070","Security / Tranche","Current WAL","Current Weighted Average Life ","Dynamic",null,"The estimated current WAL of each class of security. Using the issuer's (not rating agency) underlying assumptions.","Current average life of the security, as at the Report Date.","Numeric",12.34,"Entered as the number of a years. Use the pricing speeds implied by the Initial CPR (for a constant CPR) or incorporate any ramp assumptions from Ramp Period or Terminal CPR if applicable.For internal (self) or external securitisations with pool top-up facilities, assume that the pool is closed in order to calculate this data field."]
[null,"RS071","General","Estimated last principal payment date","Expected Final Maturity Date ","Dynamic",null,"The estimated last principal payment date of each class of security.","The date on which the tranche is expected to be fully redeemed.","Date","dd-mm-yyyy","Use the pricing speeds implied by the Initial CPR (for a constant CPR) or incorporate any ramp assumptions from Ramp Period or Terminal CPR if applicable.For internal (self) or external securitisations with pool top-up facilities, assume that the pool is closed in order to calculate this data field."]
[null,"RS072","Field removed",{"$nulls":8},"Former field name: Original CPR"]
[null,"RT072","Security / Tranche","Redemption Pricing","Redemption Price","Static",null,"The price at which the Issuer is required to repurchase each security from the investor, expressed as a percentage of the Stated Amount or Investment Amount. If the transaction does not have this feature, enter N/A for this data field.","The price at which the tranche will be redeemed under an existing redemption facility, expressed as a percentage of the Stated Amount or Investment Amount, if applicable.","Numeric",12.45]
[null,"ADDITIONAL DATA FIELDS "]
[null,"RS073","Credit Rating","NEW","ABN of Credit Ratings Agency","Static",null,null,"The applicable Australian Business Number of the Rating Agency, if organised under the laws of Australia.","Numeric",12345678912]
[null,"RS074","Credit Rating","NEW","Credit Ratings Agency Jurisdiction","Static",null,null,"Jurisdiction, if not Australia, under the laws of which the Issuing Trustee is organised.","Text","N/A","Use ISO 3166-1 alpha-3 codes. E.g. the United states would be represented as 'USA' while the UK would be represented as 'GBR'."]
[null,"RS075","Credit Rating","NEW","Credit Ratings Agency ID","Static",null,null,"Registration number or ABN equivalent issued by the jurisdiction under the laws of which the entity is organised.","Text","N/A"]
[null,"RS076","Credit Rating","NEW","Credit Ratings Agency ID Descriptor","Static",null,null,"A brief description of the business identifier if an ABN is not available.","Text","N/A"," E.g. for a US business use \"US Employer Identification Number\" if applicable."]
[null,"RS077","General","NEW","Governing Law","Static",null,null,"Jurisdiction under the laws of which the securities are issued.","Text","ABC","Use ISO 3166-1 alpha-3 codes. For example, \"USA\" should be entered for tranches issued under US law."]
[null,"RS078","General","NEW","Soft Bullet Date ","Static",null,null,"The date on which the tranche is expected to be redeemed in full by virtue of a soft bullet provision.","Date","dd-mm-yyyy"]
[null,"RS079","Security / Tranche","NEW","Coupon Basis","Static",null,null,"Basis for calculating interest payable to securityholders.","Text","N/A","This is also sometimes called the day count convention. e.g. “Actual/Actual”, “30/360”"]
[null,"RS080","Security / Tranche","NEW","Step-up Rate","Dynamic",null,null,"Future interest rate to which the loan will be reset at the step-up date.","Numeric",12.3456,"Include the rate for either floating or fixed rate tranches in this field. All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]
[null,"RS081","Payments","NEW","Beginning Cumulative Charge-Offs ","Dynamic",null,null,"The total dollar value of any charge-offs applied to the security, at the beginning of the current reporting period. ","Numeric",1234567.89]
[null,"RS082","Payments","NEW","Beginning Cumulative Coupon Shortfall ","Dynamic",null,null,"The cumulative difference between the Scheduled Coupon and the Coupon Distribution, at the beginning of the current reporting period.","Numeric",1234567.89]
[null,"RS083","Payments","NEW","Beginning Cumulative Principal Shortfall ","Dynamic",null,null,"The cumulative difference between the Scheduled Principal and the Principal Distribution, at the beginning of the current reporting period.","Numeric",1234567.89]
[null,"RS084","Payments","NEW","Coupon Shortfall Makeup","Dynamic",null,null,"Interest distributed in the Coupon Distribution in order to restore amounts from a previous Coupon Shortfall, in the current reporting period.","Numeric",1234567.89]
[null,"RS085","Payments","NEW","Principal Shortfall Makeup","Dynamic",null,null,"Principal distributed in the Principal Distribution in order to restore amounts from a previous Principal Shortfall, in the current reporting period.","Numeric",1234567.89]
[null,"RS086","Payments","NEW","Allocated Charge-Offs","Dynamic",null,null,"Losses allocated to the tranche, net of any current-period recoveries or restorations calculated at the pool level, in the current reporting period.","Numeric",1234567.89]
[null,"RS087","Payments","NEW","Charge-Off Restorations","Dynamic",null,null,"Aggregate excess spread collected during the collection period and allocated to restore net chargeoffs.","Numeric",1234567.89]
[null,"RS088","Payments","NEW","Ending Cumulative Charge-Offs","Dynamic",null,null,"The total dollar value of any charge-offs applied to the security, at the end of the reporting period. ","Numeric",1234567.89]
[null,"RS089","Payments","NEW","Beginning Cumulative Charge-Off Factor","Dynamic",null,null,"The total dollar value of any charge-offs applied to the security as a factor, at the beginning of the current reporting period. ","Numeric",0.1234,"Calculated as the Beginning Cumulative Charge-Offs ÷ Current Principal (Face) Amount."]
[null,"RS090","Payments","NEW","Beginning Cumulative Coupon Shortfall Factor ","Dynamic",null,null,"The cumulative difference between the Scheduled Coupon and the Coupon Distribution as a factor, at the beginning of the current reporting period. ","Numeric",0.1234,"Calculated as the Beginning Cumulative Coupon Shortfall ÷ Current Principal (Face) Amount."]
[null,"RS091","Payments","NEW","Beginning Cumulative Principal Shortfall Factor ","Dynamic",null,null,"The cumulative difference between the Scheduled Principal and the Principal Distribution as a factor, at the beginning of the current reporting period. ","Numeric",0.1234,"Calculated as the Beginning Cumulative Principal Shortfall ÷ Current Principal (Face) Amount. "]
[null,"RS092","Payments","NEW","Coupon Shortfall Makeup Factor ","Dynamic",null,null,"Interest distributed in the Coupon Distribution in order to restore amounts from a previous Coupon Shortfall as a factor, in the current reporting period. ","Numeric",0.1234,"Calculated as the Coupon Shortfall Makeup ÷ Current Principal (Face) Amount."]
[null,"RS093","Payments","NEW","Principal Shortfall Makeup Factor ","Dynamic",null,null,"Principal distributed in the Principal Distribution in order to restore amounts from a previous Principal Shortfall as a factor, in the current reporting period. ","Numeric",0.1234,"Calculated as the Coupon Shortfall Makeup ÷ Current Principal (Face) Amount."]
[null,"RS094","Payments","NEW","Principal Shortfall Factor ","Dynamic",null,null,"The difference between the Scheduled Principal and the Principal Distribution as a factor, in the current reporting period. ","Numeric",0.1234,"Applicable to planned or targeted amortisation bonds or soft bullets. Calculated as the Principal Shortfall ÷ Current Principal (Face) Amount."]
[null,"RS095","Payments","NEW","Allocated Charge-Off Factor","Dynamic",null,null,"Charge-offs allocated to the tranche as a factor, net of any current-period recoveries or restorations calculated at the pool level, in the current reporting period. ","Numeric",0.1234,"Calculated as the Allocated Charge-Offs ÷ Current Principal (Face) Amount."]
[null,"RS096","Payments","NEW","Charge-Off Restoration Factor","Dynamic",null,null,"Any restorations to cumulative charge-offs as a factor made during the current reporting period. ","Numeric",0.1234,"Calculated as the Charge-Off Restorations ÷ Current Principal (Face) Amount."]
[null,"RS097","Payments","NEW","Ending Cumulative Charge-Off Factor","Dynamic",null,null,"The total dollar value of any charge-offs applied to the security as a factor, at the end of the current reporting period. ","Numeric",0.1234,"Calculated as the Ending Cumulative Charge-Offs ÷ Current Principal (Face) Amount."]
[null,"RS098","Payments","NEW","Ending Cumulative Principal Shortfall Factor ","Dynamic",null,null,"The cumulative difference between the Scheduled Principal and the Principal Distribution as a factor, at the end of the current reporting period. ","Numeric",0.1234,"Calculated as the Ending Cumulative Principal Shortfall ÷ Current Principal (Face) Amount."]
[null,"RS099","General","NEW","Tranche ID","Static",null,null,"RBA-assigned tranche identifier.","Numeric",12345678,"This field will be provided by the RBA upon application."]
[null,"RS100","Payments","Variant of existing field","Coupon Rate","Dynamic",null,null,"Rate for calculating interest payable to holders of fixed-rate securities. ","Numeric",12.3456,"This field is for fixed-rate securities only. Do not include the coupon rate paid on floating rate securities in this field (these should be reported in Current Coupon Rate). All public transactions must report this data. However, for placements with a private coupon and internal (self) securitisations, this data can be made available to the RBA only. "]

{"sheet":"No Data","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"flags":["formulas_cached_only"]}
[]
[null,null,"\"No Data\" Responses"]
[null,null,"To capture non-available data fields, a set of six \"No data\" (ND) options are included in this template which must be used whenever a particular data field cannot be submitted in accordance with the template or when the field is not applicable."]
[]
[null,null,"Reason","Example"]
[null,null,"Data not collected at loan origination","ND1"]
[null,null,"Data collected at loan origination but not loaded into the reporting system at completion","ND2"]
[null,null,"Data collected at loan origination but loaded into a separate system from the reporting one","ND3"]
[null,null,"Data collected at loan origination but will only be available from YYYY-MM","ND4, YYYY-MM"]
[null,null,"Data Not Applicable - N/A","ND5"]
[null,null,"Data not collected reason being Pending Sale","ND6"]