{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["Amendments RMBS loan-level"],"not_rendered":{"images":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Amendments RMBS loan-level","index":0,"n_rows":27,"n_cols":10,"rows_kept":27,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,"REPORTING TEMPLATE SPECIFICATION FOR REPO-ELIGIBLE SECURITIES"]
[]
[null,"Residential Mortgage Backed Securities"]
[null,"Amendments to Loan Level Data"]
[]
[]
[null,null,"Amended field"]
[null,null,"New field"]
[]
[null,"Amendment Type","Field Code","Category","Field Name","Reporting\nFrequency","Description","Data Type","Data Format","Guidance Notes"]
[null,"Guidance change","RL022","Loan Characteristics","Settlement Date","Static","The date on which loan funds were originally provided by the lender to the borrower?","Date","dd-mm-yyyy","In the template reported to permitted users, the date should be reported as the calendar year quarter within which the exact date falls. The data format to be used is Qn-yyyy, where n is the quarter number 1, 2, 3 or 4. For example, if the date is 23/2/2011, report Q1 2011. The exact date should be reported to the RBA."]
[null,"Guidance change","RL025","Loan Characteristics","Loan Term","Static","The number of months from the Settlement Date to the legal Maturity Date for the loan.","Numeric",123.45,"In the template reported to permitted users, this should be expressed as a number of quarters, equal to the difference between the quarter in which the maturity date falls and the quarter in which the settlement date falls. For example, if the legal Settlement Date occurs in Q3 2010 and the legal Maturity Date occurs in Q4 2015, then the Loan Term is 21 quarters. The exact number of months should be reported to the RBA."]
[null,"Guidance change","RL026","Loan Characteristics","Remaining Term","Dynamic","The number of months from the Report Date to the legal Maturity Date of a loan.","Numeric",123.45,"In the template reported to permitted users, this should be expressed as a number of quarters, equal to the difference between the quarter in which the maturity date falls and the quarter in which the report date falls. For example, if the Report Date occurs in Q3 2010 and the legal Maturity Date occurs in Q4 2015, then the Remaining Term is 21 quarters. The exact number of months should be reported to the RBA."]
[null,"Guidance change","RL027","Loan Characteristics","Seasoning","Dynamic","The number of months from the Settlement Date to the Report Date for a loan.","Numeric",123.45,"In the template reported to permitted users, this should be expressed as a number of quarters, equal to the difference between the quarter in which the report date falls and the quarter in which the settlement date falls. For example, if the Settlement Date occurs in Q3 2010 and the Report Date occurs in Q4 2015, then the Seasoning is 21 quarters. The exact number of months should be reported to the RBA."]
[null,"Guidance change","RL028","Loan Characteristics","Maturity Date","Static","The date on which a loan must be fully repaid.","Date","dd-mm-yyyy","In the template reported to permitted users, the date should be reported as the calendar year quarter within which the exact date falls. The data format to be used is Qn-yyyy, where n is the quarter number 1, 2, 3 or 4. For example, if the date is 23/2/2011, report Q1 2011. The exact date should be reported to the RBA."]
[null,"Guidance change","RL047","Interest Rate","Interest Only Expiry Date","Static","The date non-amortising loans (i.e. Loan Type is equal to 2,3 or 4 in RL034) revert to amortising loans. Enter N/A for this data field if Loan Type is NOT equal to 2,3 or 4 in RL034","Date","dd-mm-yyyy","In the template reported to permitted users, the date should be reported as the calendar year quarter within which the exact date falls. The data format to be used is Qn-yyyy, where n is the quarter number 1, 2, 3 or 4. For example, if the date is 23/2/2011, report Q1 2011. The exact date should be reported to the RBA."]
[null,"Guidance change","RL048","Interest Rate","Fixed Rate Expiry Date","Static","The date on which the rate on the fixed rate loan (i.e. Interest Rate Type is equal to 2,3 or 4 on RL041) is reset or expires? Enter N/A if Interest Rate Type is NOT equal to 2,3 or 4 on RL041","Date","dd-mm-yyyy","In the template reported to permitted users, the date should be reported as the calendar year quarter within which the exact date falls. The data format to be used is Qn-yyyy, where n is the quarter number 1, 2, 3 or 4. For example, if the date is 23/2/2011, report Q1 2011. The exact date should be reported to the RBA."]
[null,"Guidance change","RL052","Defaults, Losses \nand Claims","Date of Foreclosure","Dynamic","Date of sale of the foreclosed property. In the case of multiple properties, record the sale date of the most recently sold property. Enter N/A for this data field if the Account Status is NOT equal to 4 'Foreclosure' in RL049.","Date","dd-mm-yyyy","In the template reported to permitted users, the date should be reported as the calendar year quarter within which the exact date falls. The data format to be used is Qn-yyyy, where n is the quarter number 1, 2, 3 or 4. For example, if the date is 23/2/2011, report Q1 2011. The exact date should be reported to the RBA."]
[null,"Guidance change","RL068","Property & Collateral","Property Valuation Date","Dynamic","The date on which the latest valuation for the property was undertaken. For multiple properties, report the date of the property most recently valued.","Date","dd-mm-yyyy","In the template reported to permitted users, the date should be reported as the calendar year quarter within which the exact date falls. The data format to be used is Qn-yyyy, where n is the quarter number 1, 2, 3 or 4. For example, if the date is 23/2/2011, report Q1 2011. The exact date should be reported to the RBA."]
[null,"Guidance change","RL062","Property Region","Property Postcode","Static","The postal code of each property over which a mortgage exists in favour of the lender, as specified by Australia Post. If the property is not located in Australia, enter N/A for this data field.","Numeric",1234,"For multiple properties, separated with a semi-colon (;). In the template reported to permitted users, the last three digits of the postcode should be redacted. The complete four-digit postcode should be reported to the RBA."]
[null,"New field","RL094","Property Region","ABS Statistical Area (Level 4)","Static","The ABS Statistical Area (Level 4) of each property over which a mortgage exists in favour of the lender, as specified in the ABS’s Australian Statistical Geography Standard (ASGS) on the date that the mortgage secured by the property entered the collateral pool. If the property is not located in Australia, enter N/A for this field.","Numeric",123,"Report the property's ABS Statistical Area (Level 4) (SA4) as defined in the Australian Statistical Geography Standard. The property’s SA4 should be reported by mapping its postcode to its SA4 using the postcode-to-SA4 mapping tables provided by the ABS. Alternatively, the exact SA4 of the property, derived from a third-party provider specializing in this service, can be reported. The property’s SA4 should be reported using the most up-to-date ABS postcode-to-SA4 mapping (or an exact mapping by a third-party provider specialising in this service) in effect at the date that the mortgage secured by the property entered the collateral pool. For RMBS deals outstanding in July 2011, the SA4 should be reported using the postcode-to-SA4 mapping in effect on July 2011 which can be found in 1270.0.55.006 - Australian Statistical Geography Standard (ASGS): Correspondences, July 2011 (under Postcode 2011 to Statistical Area Level 4 2011 ‘Table 3 Correspondence’) or an exact mapping effective as at July 2011 by a third-party provider specialising in this service. In cases where the postcode maps to more than one SA4, report the SA4 region which contains the largest percentage of that postcode as reported by the ABS in its mapping table. When there are ties between the SA4s with the highest percentage to which the postcode is mapped to, the information provider can assign the property to any of these SA4s. Where there are multiple properties, separate their SA4s with a semi-colon (;)."]