{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["RMBS Loan Level Template_Markup"],"not_rendered":{"images":1,"external_links":2,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"RMBS Loan Level Template_Markup","index":0,"n_rows":129,"n_cols":11,"rows_kept":129,"flags":["formulas_cached_only"]}
[]
[{"$nulls":7},"Key"]
[{"$nulls":8},"Data field will be relocated to another template"]
[{"$nulls":8},"Data field will be deleted from final version of template"]
[{"$nulls":8},"New data field or relocated from another template"]
[]
[null,"DRAFT REPORTING TEMPLATE SPECIFICATION FOR REPO-ELIGIBLE SECURITIES"]
[]
[null,"Residential Mortgage Backed Securities"]
[null,"Loan Level Data"]
[]
[null,"Version 0.4 (October 2012)"]
[]
[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 containing multiple entries, the entries should be separated with a semi-colon (;)."]
[null,"•  When data are not available for a particular field, the field should be left blank. Issuers are expected to explain the reasons for any data omissions."]
[null,"•  For fields with an 'ongoing' reporting frequency, related data should be as at the most recent report date."]
[null,"•  For fields with an 'upfront' 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. Where this is not possible, an explanation is required."]
[]
[null,"Field Code","Category","Field Name","Reporting\nFrequency","Description","Data Type","Data Format","Guidance Notes","Selected comments from Submissions","RBA response"]
[null,"RL001","General","Report Date","Upfront","As at date of the data. Should correspond with the last day of the collection period for post-issuance reporting. For RMBS with monthly distribution dates, the collection period is the previous month determination date to the most current determination date. For RMBS with quarterly reset, the collection period is the previous quarter determination date to the most current determination date.  The distribution dates are those disclosed in the individual prospectus for each trust. ","Date","dd-mm-yyyy","Refer to taxonomy in Pool Information template for definitions of collections period.","Some respondents have noted that the collection period does not correspond to previous determination date to the most current determination date. Rather it refers to the first day of a calendar month and either ends on the last day of the calendar month or the last calendar day of the quarter (depending on the payment cycle).\n\nMost respondents have suggested that this field should be \"ongoing\" not \"upfront\".","RBA has decided to delete references to the determination date. It has also agreed to change the Reporting Frequency to 'Ongoing'."]
[null,"RL002","General","Transaction ID","Upfront","Unique numeric identifier of the transaction assigned by the Trust Manager.","Number",12345,"Should agree with the Transaction ID in field RT002 of the Transaction Level Reporting Template.","Some respondents have requested that the Transaction name be included too.","RBA has decided to include an extra field to capture the Transaction Name. This data field will be consistent across all templates."]
[null,"NEW","General","Master Trust Name","Upfront","Full name of the master trust for the transaction.","Text","N/A","For transactions structured under a master trust arrangement."]
[null,"NEW","General","Series Trust Name","Upfront","Full name of the series trust for the transaction","Text","N/A","May also be known as the transaction name."]
[null,"RELOCATED","Loan Characteristics","Servicer","Ongoing","Full legal name of the entity responsible for the collection of principal and interest on the mortgage loans, and distributing those funds to the Trustee.","Text","N/A","The Servicer is responsible for carrying out the functions involved in administering the assets (including arrears and default management). "]
[null,"RELOCATED","Loan Characteristics","ABN of Servicer","Ongoing","ABN of the entity responsible for the collection of principal and interest on the mortgage loans, and distributing those funds to the Trustee.","Numeric",{"v":12345678901,"d":"$12,345,678,901.00"},"If non resident entity, list name of entity and applicable business serial number in foreign jurisdiction"]
[null,"RELOCATED","Loan Characteristics","Originator/Seller","Upfront","Full legal name of any entity that creates the residential mortgage loans that will be included in the pool of mortgage loans for the transaction.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'."]
[null,"RELOCATED","Loan Characteristics","ABN of Originator/Seller","Upfront","ABN of any entity that created the residential mortgage loans that will be included in the pool of mortgage loans for the transaction.","Numeric",{"v":12345678901,"d":"$12,345,678,901.00"},"If non resident entity, list name of entity and applicable business serial number in foreign jurisdiction"]
[null,"RL003","Loan ID","Group Loan ID ","Upfront","Identifier of a mortgage loan contract assigned by the Servicer. This identifier is common to all split loans in the pool that are secured by the same properties. No personal details such as names, addresses or date of birth should be included here.","Number",12345,null,"Some respondents have asked whether alpha-numeric identifiers can be used here.\n\n","Data format will be changed to accommodate alpha-numeric identifiers."]
[null,"RL004","Loan ID","Split Loan ID","Upfront","Unique identifier for a mortgage loan assigned by the Servicer. Must have a common Group Loan ID for each split loan that is secured by the same property. No personal details such as names, addresses or date of birth should be included here.","Number",12345,null,"Some respondents have asked whether alpha-numeric identifiers can be used here.","Data format will be changed to accommodate alpha-numeric identifiers."]
[null,"RL005","Loan Characteristics","Approval Amount","Upfront","Total loan amount approved by the lender; including redraws and further advances. ","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"RL006","Loan Characteristics","Current Balance","Ongoing","The outstanding amount of the loan as at the Report Date. The current loan balance is the sum of the outstanding amount on the loan as at the report date, unpaid and due principal, interest, any penalty interest and all other fees and costs charged to the loan balance.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Participants have requested an amendment in the definition for the current balance to include capitalised interest and fees (not accrued).","The RBA has changed the definition to accommodate this request."]
[null,"RL007","Loan Characteristics","Scheduled Balance","Ongoing","The expected principal balance of the loan, assuming the borrower has made the minimum required payments each time they are due (i.e. the loan is not in arrears or ahead of schedule).","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"RL008","Loan Characteristics","Amount Guaranteed","Upfront","The amount of the loan guaranteed. ","Number",{"v":123456.78,"d":"$123,456.78"},"If there is no guarantee, enter zero.","Some participants said that loans are either guaranteed or not. If a loan is guaranteed then they don’t know what percentage or amount of the loan guarantee. Some participants discuss the merits of changing this field to a binary field - Is the loan guaranteed? Y/N. This would also result in a field name change to \"Loan Guarantee\".","RBA has agreed to make these changes to this data field."]
[null,"RL009","Loan Characteristics","Type of Guarantee Provider","Upfront","Indicate guarantee provider, if applicable; \n1 - No guarantor\n2 - Individual - Family Relation\n3 - Individual- Other\n4 - Government (includes local authorities)\n5 - Bank\n6 - Insurance Product\n7 - Other \n8 - No Data\n","Number",1,null,"Many respondents note that they either do not capture this data in the origination process or do not cover all the data field options.","RBA has agreed to delete this field."]
[null,"NEW","Loan Characteristics","Redraw Facility","Ongoing","Does the loan have a redraw facility?","Text","True/False"]
[null,"NEW","Loan Characteristics","Available Redraw","Ongoing","The amount available to be redrawn through the loan’s redraw facility without further approval, credit assessment, property valuations etc. If there is no redraw facility then enter N/A for this data field.","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"NEW","Loan Characteristics","Offset Account","Ongoing","Is there an offset account associated with this mortgage?","Text","True/False"]
[null,"NEW","Loan Characteristics","Offset Account Balance","Ongoing","The balance of any offset account associated with this loan. If no offset account then enter N/A for this data field.","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"NEW","Loan Characteristics","Scheduled Payment Policy","Ongoing","How does the borrower’s scheduled payment change in response to a change in the mortgage’s reference interest rate? Choose one of:\n1 - Scheduled payment changes with principal component fixed\n2 - Scheduled payment changes with principal component changed\n3 - Scheduled payment fixed with principal component changed\n4 - Other","Number",1]
[null,"NEW","Loan Characteristics","Conforming Mortgage","Upfront","Does the loan conform to the underwriting standards of the lender’s mortgage insurer(s) used by the lender?","Text","Yes/No"]
[null,"NEW","Loan Characteristics","LMI Underwriting Type","Upfront","How was underwriting for LMI undertaken? Choose one from:\n1 - Direct underwriting by LMI\n2 - Delegated underwriting authority\n3 - Group insurance policy\n4 - Any combination of 1,2 or 3 above\n5 - No LMI coverage","Number",1]
[null,"RL010","Loan Characteristics","Settlement Date","Upfront","The date on which loan funds were originally drawn down by the borrower.","Date","dd-mm-yyyy",null,"Some respondents suggest to re-word this field to \"date on which loan funds were originally provided by the lender to the borrower\". Or when the loan was 'drawn down'.","RBA has agreed to make suggested changes to the description."]
[null,"RL011","Loan Characteristics","Loan Purpose","Upfront","The primary reason the borrower obtained the loan. Loan purpose. Permissible answers: \n1 - Business\n2 - Construction\n3 - Debt Consolidation\n4 - Equity Takeout\n5 - Further Advance\n6 - Home Improvement\n7 - Investment \n8 - Purchase - Existing\n9 - Purchase - New\n10 - Purchase - Other\n11 - Refinance\n12 - Other","Number",12,null,"Respondents have request that the RBA considers the following issues:\n- possible overlap between categories (e.g. equity takeout and further advance); and\n- clarification/definitions for each category.","RBA has agreed to streamline these categories as some of them appear to overlap with each other. In doing so, the categories should become less ambiguous."]
[null,"RL012","Loan Characteristics","Loan Origination Channel","Upfront","Origination channel for the loan: \n1 - Office/branch network\n2 - Central/direct\n3 - Mortgage broker\n4 - Internet\n5 - Packager /aggregator\n6 -Third channel but underwriting processes performed 100% by the originator","Number",1,null,"Many respondents said that they only classify loans as being originated via broker/non-broker channels. Some respondents request the RBA include a \"no data\" option here.","RBA has decided to change the description to this data field to specify whether the loan is originated via a broker or non-broker channel."]
[null,"RL013","Loan Characteristics","Loan Origination Date","Upfront","Date of original loan advance. ","Date","dd-mm-yyyy",null,"Many respondents have noted that this fields overlaps with RL010 - Loan Origination Date - and therefore should be deleted.","RBA has agreed to delete this field."]
[null,"RL014","Loan Characteristics","Loan Term","Upfront","The number of months from the Settlement Date to the legal Maturity Date for a loan.","Number",123.45,null,"Some respondents note that this can be calculated using fields already in the template (i.e. the settlement and maturity date of the loan).","RBA is pleased with the current format of this field."]
[null,"RL015","Loan Characteristics","Remaining Term","Ongoing","The number of months from the Report Date to the legal Maturity Date of a loan.","Number",123.45,null,"Some respondents note that this can be calculated using fields already in the template (i.e. the maturity and report date of the loan).","RBA is pleased with the current format of this field."]
[null,"RL016","Loan Characteristics","Seasoning","Ongoing","The number of months from the Settlement Date to the Report Date for a loan.","Number",123.45,null,"Some respondents note that this can be calculated using fields already in the template. (i.e. the settlement and report date for the loan).","RBA is pleased with the current format of this field."]
[null,"RL017","Loan Characteristics","Maturity Date","Upfront","The date on which a loan must be fully repaid.","Date","dd-mm-yyyy"]
[null,"RL018","Loan Characteristics","Account Status","Ongoing","Date which account entered into the securitised pool.","Date","dd-mm-yyyy",null,"Respondents suggested that the RBA change the Field Name to Loan Securitised Date.\nSome participants would like clarification as to whether this is required for transactions with revolving or substitution periods.","RBA has changed the Field Name accordingly. "]
[null,"RL019","Loan Characteristics","Approval LTV","Upfront","The ratio of the Approval Amount to the sum of the Property Values of all the properties used as security for the loan.","Number",12.3456,"Consolidated for all split / linked loans that are secured by common properties (i.e. total Approval Amount / total Security Valuations) as at the latest approval."]
[null,"RL020","Loan Characteristics","Current LTV","Ongoing","The ratio of the Current Balance to the sum of the Property Values of all the properties used as security for the loan.","Number",12.3456,"Consolidated for all split / linked loans that are secured by common security properties (i.e. total Current Balance / total Security Valuations)."]
[null,"RL021","Loan Characteristics","Scheduled LTV","Ongoing","The ratio of the Scheduled Balance to the sum of the Property Values of all the properties used as security for the loan.","Number",12.3456,"Consolidated for all split / linked loans that are secured by common security properties (i.e. total Scheduled Balance / total Security Valuations)."]
[null,"RL022","Loan Characteristics","Loan Documentation Type","Upfront","The level of income and savings verification undertaken by the lender in respect of the borrower when applying for the loan. \n1 - Full Documentation (i.e. full proof of income provided by the Borrower to support loan application)\n2 - Low Documentation (i.e. minimal proof of income provided by the Borrower to support loan application)\n3 - No Documentation (i.e. no proof of income provided by the Borrower to support loan application)","Number",1,null,"Some respondents urge the RBA to provide more detailed descriptions of full and low documentation loans as there is much subjectivity around terms like 'full' and 'minimal'.","RBA has provided further guidance on this data field."]
[null,"RL023","Loan Characteristics","Loan Type","Upfront","The type of payment features the loan had on Settlement Date. This describes the amortisation profile of the loan (i.e. the way in which the principal of the mortgage loan will reduce over time). \nPrincipal payment type:\n1 - Principal & Interest\n2 - Interest-only period followed by bullet repayment\n3 - Interest-only period followed by P&I amortisation\n4 - Line of Credit - Interest Only\n5 - Line of Credit - Amortising\n6 - Other","Number",1,null,"Respondents asked if  the RBA would consider the following:\n- clarifying the term \"Line of credit\" as this term can be referred to a number of loans including IO loans with amortisation periods, IO bullet loans and capitalising loans; and\n- that the repayment type be defined in relation to the Report Date rather than the settlement date (and have this fields at \"ongoing\" not upfront).","RBA has agreed define this data field as at Report Date (instead of settlement date) and change the reporting frequency to' ongoing'."]
[null,"RL024","Loan Characteristics","Scheduled Payment","Ongoing","The minimum required payment by the borrower on each loan repayment date.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Some respondents would like to know how this is to be reported for interest only loans. Should this just be the actual interest only payment for the most recent reporting period?","RBA is pleased with the current format of this field."]
[null,"RL025","Loan Characteristics","Payment Frequency","Upfront","Frequency of payments due, i.e. number of months between payments:\n1 - Daily\n2 - Weekly\n3 - Fortnightly\n4 - Monthly\n5 - Quarterly\n6 - Semi-annually\n7 - Annually\n8 - Bullet\n9 - Other","Number",1,null,"Some respondents have requested that the description be reworded to the frequency \"between\" payments.","RBA has agreed to make these changes to the description."]
[null,"RL026","Loan Characteristics","Mortgage Insurer","Upfront","The lenders' mortgage insurance provider which protects the lender against loss should the borrower default on the loan.\n1 - (No primary insurance)\n2 - AGC\n3 - CGU Lenders Mortgage Insurance\n4 - Colonial\n5 - GE Mortgage Insurance Co. Pty. Ltd\n6 - GE Mortgage Insurance Co. Pty. Ltd/HLIC\n7 - Genworth\n8 - MRM\n9 - PLMI\n10 - PRIME\n11 - QBE LMI\n12 - SGI\n13 - SGIA\n14 - Sunstate\n15 - The Mortgage Insurance Company Pty Ltd\n16 - VERO\n17 - VERO - REINSURANCE\n18 - Westpac LMI\n19 - Other","Number",12,null,"Respondents have suggested the RBA re-number the 'other' option to 99 to allow for the addition of more insurers and to add a 'no data' option under '0'.","RBA has agreed to make some of these changes to the description."]
[null,"RL027","Loan Characteristics","Mortgage Insurance Attachment Point","Upfront","LTV percentage above which losses are insured.","Number",12.3456,null,"Participants have noted that LMI is binary (i.e. loans either have 0 or 100% LMI) in their underwriting process.","RBA has provided further guidance on this data field in the guidance notes."]
[null,"RL028","Loan Characteristics","Second-ranking Mortgage","Ongoing","The total amount of additional debt (other than the securitised mortgage loan) secured by the property securing the loan. This may mean parties other than the RMBS holders have a claim on the mortgage loan or the property securing the mortgage loan.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Respondents expressed a number of concerns about this data field including seeking further clarification on what data is specifically being requested, the inability to accurately capture this data and the relevance of this data.","RBA has agreed to delete this field."]
[null,"RL029","Loan Characteristics","Principal Grace Period","Upfront","Period, in months, from the origination date of the loan during which only interest and no principal is payable.  After this period the loan switches to both interest and principal payments.\nIf no data available specify No Data (ND)","Number",123.45,null,"Respondents have remarked that this field is the same as RL041 - Interest Only Expiry Date.","RBA has agreed to delete this field."]
[null,"RL030","Loan Characteristics","Loan Currency Denomination ","Upfront","The units of exchange in which collateral data is reported as specified in the currency codes published by the International Organisation for Standardisation (ISO 4217 codes).","Text","ABC",null,"Respondents have request that the RBA provide a hyperlink to the ISO codes. Some have asked, given that the vast majority of deals will be in Australian dollars, that the RBA provide the code for Australian dollars.","RBA is pleased with the current format of this field."]
[null,"RL031","Loan Characteristics","Lien","Upfront","Seniority on liquidation of property:\n1. 1st Lien\n2. 2nd Lien \n3. 3rd Lien \n4. Other","Number",1,null,"Many respondents argue that this information is provided in RL028 and not generally applicable for Australian mortgages. Some also noted that this is a property characteristic rather than a loan characteristic.","RBA is pleased with the current description to this data field. RBA will change the Category to 'Property and Collateral'."]
[null,"RL032","Loan Characteristics","Variable Loan Amount","Ongoing","Current obligated amount (scheduled/unscheduled repayments) which can be drawn under the variable loan by the borrower. If loan is not flexible enter 0.\n","Number",{"v":123456.78,"d":"$123,456.78"},"Indicate the total amount which the borrower is entitled to draw on the loan without any additional review, underwriting or credit checks (i.e. The loan limit). This may require ongoing reporting","Respondents have questioned whether the RBA is referring to the amount which can be 'redrawn' (not 'drawn'). Also, whether the RBA is referring to the Scheduled Balance of the loan here?","RBA has provided further guidance on this data field."]
[null,"RL033","Loan Characteristics","Further Loan Advances","Ongoing","Total value of further advances (including redraws) made on the loan during the collection period. If several advances have been made, list all advances (if applicable); comma delimited","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"RL034","Loan Characteristics","Pre-payment Amount","Ongoing","Last pre-payment amount","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"RL035","Loan Characteristics","Cumulative Pre-payments","Ongoing","Cumulative amount of pre-payments to date","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"RL036","Interest Rate","Interest Rate Type","Ongoing","Interest Rate Type:\n1. Variable rate loan set at lenders’ discretion for life of the loan \n2. Variable rate loan permanently benchmarked to another interest rate or index  (excluding interest rate caps and floors)\n3. Variable rate loan temporarily benchmarked to another interest rate or index \n4. Fixed rate loan for life\n5. Fixed rate loan with future periodic resets\n6. Fixed rate loan with compulsory future switch to variable rate loan \n7. Capped\n8. Other ","Number",1,null,"Respondents have request the RBA to provide guidance/definitions for each of these categories.","RBA has agreed to provide further clarification on this data field and notes that some of these categories are more applicable to mortgages which have been originated offshore."]
[null,"RL037","Interest Rate","Current Interest Rate","Ongoing","Current interest rate in % per annum.","Number",12.34]
[null,"NEW","Interest Rate","Reference Rate","Ongoing","Current rate on the loan reference rate (i.e. Interest Rate Type is equal to either 5 or 6 in RL036) in % per annum.","Number",12.34]
[null,"RL038","Interest Rate","Current Interest Rate Margin","Ongoing","Current interest rate margin, for variable rate loans only, measured as the margin over (or under if input as a negative) the bank bill swap rate.\n","Number",123.45,null,"Respondents have request the RBA to provide further clarification on this field. Specifically, is the RBA asking for the spread over a reference rate for floating rate loan? Some participants have expressed concerns in regard to commercial sensitivities in disclosing this information.","RBA has provided more guidance in the description to this data field."]
[null,"RL039","Interest Rate","Interest Rate Reset Interval","Upfront","The interval in months at which the interest rate is adjusted (for floating loans)","Number",12,null,"Respondents have request the RBA to provide further clarification on this field. Specifically, is this in reference to floating rate loans?","RBA has provided more guidance in the description to this data field."]
[null,"RL040","Interest Rate","Restructuring Arrangement","Ongoing","Has the loan been restructured?","Text","True/False",null,"Most respondents have request the RBA to provide further clarification on this field. Specifically, what constitutes a restructure and examples of a restructure.","RBA has provided more guidance in the guidance notes of this data field."]
[null,"RL041","Interest Rate","Interest Only Expiry Date","Upfront","The date non-amortising loans (i.e. Interest Type = Interest Only or Capitalising) revert to amortising loans.","Date","dd-mm-yyyy",null,"Some respondents note that 'Capitalising' is not an option in the interest rate type data field (RL036)","RBA has deleted the reference to 'Capitalising' in the description."]
[null,"RL042","Interest Rate","Fixed Rate Expiry Date","Upfront","The date loans with a set interest rate (i.e. Interest Type = Fixed Rate) revert to Variable Rate loans.","Date","dd-mm-yyyy"]
[null,"RL043","Defaults, Losses \nand Claims","Account Status","Ongoing","Current status of account:\n1 - Performing \n2 - Arrears \n3 - Default \n4 - Foreclosure  \n5 - Redeemed \n6 - Repurchased by Seller \n7 - Other \n","Number",1,"Default is defined as any loan which is > 90 days in arrears.","Respondents have request that the RBA to provide definitions/clarification for each category to avoid varying market interpretations. Some respondents have requested categories be added to this field (e.g. Awaiting LMI Claim)","RBA has provided further guidance on this data field."]
[null,"NEW","Defaults, Losses \nand Claims","Days Since Last Scheduled Payment","Ongoing","Calendar days elapsed since last full scheduled repayment, irrespective of whether a payment has been missed or not.","Number",12,"Partial days should be rounded up to the next whole day. For example, a loan that is 30.3 days in arrears should be reported as 31 days."]
[null,"NEW","Defaults, Losses \nand Claims","Cumulative Missed Payments","Ongoing","Cumulative dollar value of all missed payments since last full scheduled payment.","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"RL044","Defaults, Losses \nand Claims","Default","Ongoing","If the status of the account is Default, specify the total principal balance of the loan in default.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have request clarification as to whether the RBA is referring to the total principal balance of the loan in default or just the principal payments in arrears? Respondents would also like a definition of Default.","RBA has provided further clarification in the description of this data field."]
[null,"RL045","Defaults, Losses \nand Claims","Foreclosure","Ongoing","If the status of the account is Foreclosure, specify the total cumulative sale receipts from the properties securing the loan that are in default and undergoing foreclosure proceedings which satisfy amounts owed by the borrower.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Respondents have suggested that the description for this field be reworded as it is a bit ambiguous.","RBA has reworded the description to this data field to make it less ambiguous."]
[null,"RL046","Defaults, Losses \nand Claims","Date of Foreclosure","Ongoing","Date of sale of the foreclosed property.","Date","dd-mm-yyyy",null,"Respondents have asked for guidance for cases when there are multiple properties securing a loan.","RBA has provided guidance on this issue in the description of the data field."]
[null,"RL047","Defaults, Losses \nand Claims","Loss on Sale","Ongoing","The total cumulative amount by which the money received by the lender when selling security properties that have been foreclosed exceeds the amount owed by the borrower.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Respondents have noted that the description should be re-worded to make reference to monies received on the sale of properties that fall short of the amount owed by the borrower (not exceed).","RBA has made the suggested changes to the description of this data field."]
[null,"RL048","Defaults, Losses \nand Claims","Days In Arrears","Ongoing","The number of days that a loan has been in arrears based on \"scheduled balance\"  arrears methodology and according to the following arrears categories:\n1. Current - 0 days. Current Loan Balance is equal to or less than the Scheduled Loan Balance (not in arrears). \n2. 0 to 30 days (2)\n3. 31 to 60 days (3)\n4. 61 to 90 days (4)\n5. 91+ days (5)\nArrears should be calculated and reported as at the end of the Report Date.","Number",1,"Under the Scheduled Balance Method, a mortgage loan is only classified as being in arrears if the Current Loan Balance exceeds the Scheduled Loan Balance irrespective of whether borrower has any Scheduled Payments past due. Under this approach borrowers who are in distress and no longer making payments will not be in arrears until the actual loan balance exceeds the Scheduled Loan Balance.\n\nPartial days should be rounded up to the next whole day. For example, a loan that is 30.3 days in arrears should be reported in the '31 to 60 days' bucket.","Respondents have suggested that the RBA just request 'days in arrears' for this data field.","RBA has made the suggested changes to the description of this data field."]
[null,"RL049","Defaults, Losses \nand Claims","Amount in Arrears","Ongoing","The principal, interest, fees and charges past due for the loan.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA is pleased with the current format of this field."]
[null,"RL050","Defaults, Losses \nand Claims","Claims Submitted to LMIs","Ongoing","The total cumulative dollar amount of claims submitted including timely payment claims (paid, denied and or unpaid) to the lender's mortgage insurance provider to cover the loss on the sale of the property.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA is pleased with the current format of this field."]
[null,"RL051","Defaults, Losses \nand Claims","Claims Paid by LMIs","Ongoing","The cumulative dollar amount of claims paid by the lender's mortgage insurance provider to cover the loss on sale of property (not including timely payment claims).","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA is pleased with the current format of this field."]
[null,"RL052","Defaults, Losses \nand Claims","Claims Denied by LMI","Ongoing","The cumulative dollar amount of claims rejected by the lender's mortgage insurance provider to cover the loss on sale of property.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA is pleased with the current format of this field."]
[null,"RL053","Defaults, Losses \nand Claims","Claims Pending with LMIs","Ongoing","The cumulative dollar amount of claims submitted to the lender's mortgage insurance provider but has not been processed or paid.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA is pleased with the current format of this field."]
[null,"RL054","Defaults, Losses \nand Claims","Loss Covered by Excess Spread","Ongoing","The cumulative amount of losses that were covered / paid for by excess spread from the transaction.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA has decided to move this data field to the transaction level template."]
[null,"RL055","Defaults, Losses \nand Claims","Loss Covered By Other Means","Ongoing","A description of the way losses were covered / paid for by means other than excess spread in the transaction. If not applicable, leave blank.","Text","N/A",null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA has decided to move this data field to the transaction level template."]
[null,"RL056","Defaults, Losses \nand Claims","Loss Covered By Other Means","Ongoing","The cumulative amount of losses that were covered / paid for by means other than excess spread.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA has decided to move this data field to the transaction level template."]
[null,"RL057","Defaults, Losses \nand Claims","Timely Payments Claims Paid By Mortgage Insurers Under Timely Payment Cover","Ongoing","The  cumulative amount of claims paid by the lender's mortgage insurance provider to cover missed interest payments by the borrower.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA has decided to move this data field to the transaction level template."]
[null,"RL058","Defaults, Losses \nand Claims","Reimbursed Timely Payments Claims ","Ongoing","The cumulative amount repaid / reimbursed to the lender's mortgage insurance provider by the servicer in relation to timely payment claims.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA has decided to move this data field to the transaction level template."]
[null,"RL059","Defaults, Losses \nand Claims","Timely Payment Claims Submitted To Mortgage Insurers","Ongoing","The cumulative amount of claims submitted to the lender's mortgage insurance provider to cover missed interest payments by the borrower.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have noted that this level of detail is difficult to provide at the loan level.","RBA has decided to move this data field to the transaction level template."]
[null,"RL060","Property Region","Property Postcode","Upfront","The postal code of each property over which a mortgage exists in favour of the lender, as specified by Australia Post.","Number",1234,null,"Some respondents have asked for guidance when multiple properties are securing the loan.","RBA has provided further guidance on multiple properties."]
[null,"RL061","Property Region","Property Statistical Area","Upfront","Property Statistical Area Level 2 (SA2) code - as defined by the Australian Bureau of Statistics - based on the postcode of the primary security property (i.e. ideally the one with the highest valuation or as designated by the Issuer). For property in foreign jurisdiction, designate the city","Number",117031337,"Statistical Area codes form part of the Australian Statistical Geography Standard (ASGS), and can be located on the Australia Bureau of Statistics' web site. The SA2 code should be 9 digits in length (the abbreviated 5-digit code should not be used).","Many respondents have asked for guidance when multiple properties are securing the loan. Some have also asked whether the RBA can determine this using postcodes.","RBA has decided to delete this field."]
[null,"NEW","Property Region","Property Country","Upfront","The country where the property is located.","Text","N/A"]
[null,"RL062","Property Region","Property State or Territory","Upfront","Property State or Territory based on the postcode of the primary security property (i.e. the one with the highest valuation or as designated by the Issuer). For property in a foreign jurisdiction, designate State or Territory only when such regional entities exist ","Number","NSW","State and territory names should be entered using the approved abbreviated form of Australia Post.","Many respondents have asked for guidance when multiple properties are securing the loan. Some have also asked whether the RBA can determine this using postcodes.","RBA has decided to delete this data field from the template."]
[null,"NEW","Property & Collateral","Original Property Value","Upfront","The valuation of the property securing the loan as at loan origination date. For multiple properties, report the cumulative valuation.","Number",{"v":123456.78,"d":"$123,456.78"}]
[null,"RL063","Property & Collateral","Property Value","Ongoing","The most recent valuation of each property secured by the loan.","Number",{"v":123456.78,"d":"$123,456.78"},null,"Many respondents have asked for guidance when multiple properties are securing the loan. ","RBA has provided more guidance to this data field."]
[null,"RL064","Property & Collateral","Property Valuation Type","Ongoing","Valuation type at origination:\n1 - Full  \n2 - Drive-by \n3 - Desktop \n4 - Automated (and Unqualified / Qualified)\n5 - Customer estimate\n6 - Contract of sale\n7 - Valuer General\n8 - Other \n","Number",1,null,"Many respondents have asked for guidance when multiple properties are securing the loan. Some have also request that the RBA include a 'no data' category in this field.","RBA is pleased with the current format of this field."]
[null,"NEW","Property & Collateral","Property Valuation Type - Current","Ongoing","Current valuation type:\n1 - Full  \n2 - Drive-by \n3 - Desktop \n4 - Automated (and Unqualified / Qualified)\n5 - Customer estimate\n6 - Contract of sale\n7 - Valuer General\n8 - Other \n","Number",1]
[null,"RL065","Property & Collateral","Property Valuation Date","Ongoing","The date on which the latest valuation for the property was undertaken.","Date","dd-mm-yyyy",null,"Many respondents have asked for guidance when multiple properties are securing the loan. ","RBA has provided more guidance on this data field."]
[null,"RL066","Property & Collateral","Property Purpose","Upfront","The intended purpose of each property that is used as security for the loan. \n1 - Holiday\n2 - Investment\n3 - Owner\n4 - Second Home\n5 - Other","Number",1,null,"Many respondents have request the RBA remove categories to match their internal system specifications.","RBA has agreed to streamline these categories."]
[null,"RL067","Property & Collateral","Property Type","Upfront","Property type: \n1 - Residential - Apartment/Unit/Flat\n2 - Residential - Detached (Fully)\n3 - Residential - Detached (Semi)\n4 - Residential - Duplex\n5 - Residential - House\n6 - Residential - Other\n7 - Residential - Serviced Apartment/Unit/Flat\n8 - Residential - Terrace\n9 - Residential - Townhouse\n10 - Residential - Vacant Land\n11 - Residential - Villa\n12 - Other\n","Number",12,null,"Many respondents have request the RBA change these categories to match their internal system specifications. Many respondents have asked for guidance when multiple properties are securing the loan. ","RBA has agreed to change the categories to this data field to match the internal systems of respondents."]
[null,"RL068","Borrower Information","Borrower ID","Upfront","Unique identifier of the borrower(s) assigned by the Servicer. No personal details such as names, addresses or date of birth should be included here. If more than one borrower list the Borrower ID's comma delimited with  primary borrower first.","Number",12345,null,"Some respondents have asked whether this is separate and distinct from the Loan ID?","RBA is pleased with the current format of this field."]
[null,"RL069","Borrower Information","Primary Borrower","Upfront","Flag indicating whether borrower is the obligor with the highest income at Report Date.","Text","True/False",null,"Many respondents have requested that the RBA change the 'report date' to 'loan origination date' or 'time of underwriting'. Some have also asked that, given there may be multiple borrowers to the loan, that it would be best to supply the loan ID of the primary borrower for this field. Some have also noted that the primary borrower may not be the borrower with the highest income.","RBA has decided to delete this field."]
[null,"RL070","Borrower Information","Significant Borrower Flag","Upfront","Significant borrowers are defined as those that have a current mortgage loan balance greater than 5% of the entire Current Balance of the pool.","Text","True/False",null,"Many respondents noted that this field can be calculated by the RBA.","RBA has agreed to delete this field."]
[null,"RL071","Borrower Information","First Home Buyer Flag","Upfront","Identifies whether the primary borrower is a first-time home buyer. ","Text","True/False",null,"Respondents ask whether this applies to all first home buyers, or just those which apply for the first home owners grant via the originator of the loan.","The intention of this field is to identify first home buyers - regardless of whether they have applied for the first home buyers grant through the originator or not."]
[null,"RL072","Borrower Information","Borrower Residency","Upfront","The country where the borrower resides.","Text","N/A",null,"Many respondents have requested that the RBA change the categories for this field to Australia, Overseas and No Data.","RBA has changed this field slightly to cater for respondents comments."]
[null,"RL073","Borrower Information","Employment Type","Upfront","Employment status of the primary applicant:\n1 - Pay-as-you-go employee (full time)\n2 - Pay-as-you-go employee (part time)\n3 - Pay-as-you-go employee (casual)\n4 - Commission based employee\n5 - Self employed\n6 - Pensioner / retiree, or loan will not be repaid before age\n7 - Unemployed / support payments\n8 - Home Duties\n9 - Other","Number",1,null,"Respondents have request that the RBA change the categories of this data field to more closely match their internal systems. The following is suggested:\nPay-as-you-go employee \nSelf employed\nOther\nNo Data (ND)\n","RBA has agreed to change the categories to this data field to match the internal systems of respondents."]
[null,"RL074","Borrower Information","Months in Business","Upfront","Number of months in business (where Employment Type = Self-Employed).","Number",123.45,null,"Respondents have noted significant difficulties reporting this data.","RBA has decided to delete this field"]
[null,"RL075","Borrower Information","Number of credit defaults","Upfront","Number of defaults on the borrower's credit history lodged with any credit reference agency, lender or other party within 3 years prior to the Settlement Date where each defaulted amount > $1000.","Number",12,null,"Respondents have requested that the RBA change the description of this field so that it is distinguishing between \"Prime\" and \"Non-prime\" loans.","RBA has agreed to make the suggested changes to this field as per respondents' requests."]
[null,"RL076","Borrower Information","Bankruptcy Flag","Upfront","Indicates whether the borrower has been bankrupt within 10 years prior to the Settlement Date.","Text","True/False",null,null,"RBA is pleased with the current format of this field."]
[null,"RL077","Borrower Information","Last Credit Discharge Date","Upfront","Most recent discharged date of defaults or bankruptcies.","Date","dd-mm-yyyy",null,"Respondents have questioned the usefulness of this data against the cost of providing this data. They note that data will generally only be available for non-conforming loans.","RBA is pleased with the current format of this field."]
[null,"RL078","Borrower Information","Number of Debtors","Upfront","Number of borrowers to the loan.","Number",12,null,"Respondents have questioned the usefulness of this data.","RBA is pleased with the current format of this field."]
[null,"NEW","Borrower Information","Credit Score Provider","Ongoing","The provider of a borrower credit score (If both external and internal scores are available please provide the external provider).","Text","N/A"]
[null,"NEW","Borrower Information","Credit Score","Ongoing","Borrower credit score (If both external and internal scores are available please provide the external provider score).","Number",1]
[null,"NEW","Borrower Information","Debt Serviceability Metric","Upfront","A description of the metric used (if any) to assess a borrower’s debt servicing ability.","Text","N/A"]
[null,"NEW","Borrower Information","Debt Serviceability Metric Score","Upfront","Borrower debt serviceability metric score. Enter N/A if debt serviceability metric was not used in assessing the loan.","Number",12.34]
[null,"NEW","Borrower Information","Legal Entity Type","Upfront","Indicate legal entity type of borrower. Choose one from:\n1 - Individual\n2 - Trust (including self-managed super funds)\n3 - Corporation\n4 - Other","Number",1]
[null,"RL079","Borrower Information","Primary Income","Upfront","Primary borrower gross annual income used to underwrite/assess the loan (after allowing for adjustments to bonuses, overtime payments, rental income from other investment properties on which there are separate loans, etc).","Number",123456.78,null,"Respondents have raised a number of concerns about this data field, including:\n- the relevance of borrower income as at time of underwriting as an accurate predictor of future loan performance\n- the cost of retrieving the data\n- the differences between originators underwriting criteria (e.g. treatment of interest/investment income)\n- changes to originators underwriting criteria and treatment/calculation of income over time.\nSome respondents have suggested that the RBA request a net income measure or some other measure of serviceability such as a net servicing ratio.","RBA is pleased with the current format of this field."]
[null,"RL080","Borrower Information","Income Verification for Primary Income","Upfront","Income verification for primary income: \n1 - Self-certified no checks \n2 - Verified \n3 - Non-Verified Income \n4 - Other","Number",1]
[null,"RL081","Borrower Information","Secondary Income","Upfront","Secondary borrower gross annual income used to underwrite/assess the loan (after allowing for adjustments to bonuses, overtime payments, rental income from other investment properties on which there are separate loans, etc).","Number",{"v":123456.78,"d":"$123,456.78"},null,"Respondents have raised a number of concerns about this data field, including:\n- the relevance of borrower income as at time of underwriting as an accurate predictor of future loan performance\n- the cost of retrieving the data\n- the differences between originators underwriting criteria (e.g. treatment of interest/investment income)\n- changes to originators underwriting criteria and treatment/calculation of income over time.\nSome respondents have suggested that the RBA request a net income measure or some other measure of serviceability such as a net servicing ratio.","RBA is pleased with the current format of this field."]
[null,"RL082","Borrower Information","Income Verification for Secondary Income","Upfront","Income verification for secondary income: \n1 - Self-certified no checks \n2 - Verified \n3 - Non-Verified Income \n4 - Other","Number",1]