{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Pool Level Data by Postcode","No Data"],"not_rendered":{"images":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Pool Level Data by Postcode","index":0,"n_rows":40,"n_cols":31,"rows_kept":40,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,"REPORTING TEMPLATE SPECIFICATION FOR REPO-ELIGIBLE SECURITIES"]
[null,"THIS TEMPLATE MUST BE MADE AVAILABLE TO 'PERMITTED USERS' AND SHOULD NOT BE REPORTED TO THE RBA."]
[null,"Commercial Mortgage Backed Securities"]
[null,"Draft Pool Level Data by Postcode"]
[]
[null,"Version 0.1 (October 2013)"]
[]
[null,"GUIDANCE NOTES"]
[null,"•  All data fields are mandatory."]
[null,"•  Entries should comply with the data formats specified for the relevant field."]
[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,"•  Issuers are expected to adhere to the definitions and guidance notes provided in the data template."]
[]
[null,"Transaction Identifiers",{"$nulls":5},"Corresponding Item Code in Other Templates"]
[null,"Transaction ID (same as in Transaction Level Data Template)",{"$nulls":3},"enter here",null,"CT002"]
[null,"Master Trust Name (same as in Transaction Level Data Template)",{"$nulls":3},"enter here",null,"CT003"]
[null,"Series Trust Name (same as in Transaction Level Data Template)",{"$nulls":3},"enter here",null,"CT004"]
[]
[null,"Variable","Number of loans within postcode","Current Balance","Loan purpose: 1 – Purchase - Existing dwelling","Loan purpose: 2 –  Construction Finance","Loan purpose: 3 – Wholesale finance (no specific purpose)","Loan purpose: 4 – Purchase of plant and equipments","Loan purpose: 5 – Purchase of land other than for construction (e.g. rural property)","Loan purpose: 6 – Refinance","Loan purpose: 7 – Other","Seasoning","Original LTV","Current LTV","Loan Documentation Type: 1 – Full Documentation","Loan Documentation Type: 2 – Low Documentation","Loan Documentation Type: 3 – No Documentation","Account Status: 1- Performing","Account Status: 2- Arrears","Account Status: 3- Default","Account Status: 4- Foreclosure","Account Status: 5- Redeemed","Account Status: 6- Repurchased by Seller","Days in Arrears : 0 to 30 days","Days in Arrears : 31 to 60 days","Days in Arrears : 61 to 90 days","Days in Arrears : 91+ days","Employment Type – Primary Borrower: 1 – Pay-as-you-go employee","Employment Type – Primary Borrower: 2 – Self employed","Employment Type – Primary Borrower: 3 – Other","Headline profit or income (as at loan origination)"]
[null,"Corresponding Field Code in Loan Level Template","CL059","CL012","CL023","CL022","CL022","CL022","CL022","CL022","CL022","CL026","CL030","CL031","CL033","CL033","CL033","CL050","CL050","CL050","CL050","CL050","CL050","CL055","CL055","CL055","CL055","CL078","CL078","CL078","CL088"]
[null,"Calculation Method/Guidance Notes","Number of loans in the pool secured by a property located in the corresponding postcode (field CL059).","Sum of Current Balance (field CL012) of mortgages secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan purpose (field CL022) is 1 - Purchase - Existing dwelling and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan purpose (field CL022) is 2 – Construction Finance and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan purpose (field CL022) is 3 – Wholesale finance and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan purpose (field CL022) is 4 – Purchase of plant and equipments and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan purpose (field CL022) is 5 – Purchase of land other than for construction (e.g. rural property) and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan purpose (field CL022) is 6 – Refinance and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan purpose (field CL022) is 7 – Other and is secured by a property located in the corresponding postcode (field CL059)","Weighted average of Seasoning (field CL026) of mortgages secured by a property located in the corresponding postcode (field CL059). Weights to be used in the average are based on the Current Balance (field CL012) of each mortgage.","Weighted average of Original LTV (field CL030) of mortgages secured by a property located in the corresponding postcode (field CL059). Weights to be used in the average are based on the Current Balance (field CL012) of each mortgage.","Weighted average of Current LTV (field CL031) of mortgages secured by a property located in the corresponding postcode (field CL059). Weights to be used in the average are based on the Current Balance (field CL012) of each mortgage.","Sum of Current Balance (field CL012) of mortgages where Loan Documentation Type (field CL033) is 1 – Full Documentation and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan Documentation Type (field CL033) is 2 – Low Documentation and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Loan Documentation Type (field CL033) is 3 – No Documentation and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Account Status (field CL050) is 1- Performing and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Account Status (field CL050) is 2- Arrears and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Account Status (field CL050) is 3- Default and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Account Status (field CL050) is 4- Foreclosure and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Account Status (field CL050) is 5- Redeemed and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Account Status (field CL050) is 6- Repurchased by Seller and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Days in Arrears (field CL055) is 0 to 30 days and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Days in Arrears (field CL055) is 31 to 60 days and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Days in Arrears (field CL055) is 61 to 90 days and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Days in Arrears (field CL055) is 91+ days and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Employment Type – Primary Borrower (field CL078) is 1 – Pay-as-you-go employee and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Employment Type – Primary Borrower (field CL078) is 2 – Self employed and is secured by a property located in the corresponding postcode (field CL059)","Sum of Current Balance (field CL012) of mortgages where Employment Type – Primary Borrower (field CL078) is 3 – Other and is secured by a property located in the corresponding postcode (field CL059)","Weighted average of Primary Income (field CL088) of borrowers who have mortgages secured by a property located in the corresponding postcode (field CL059). Weights to be used in the average are based on the Current Balance (field CL012) of each mortgage."]
[null,"Data Type","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric","Numeric"]
[null,"Data Format",1,{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},123.45,12.3456,12.3456,{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"},{"v":123456.78,"d":"$123,456.78"}]
[null,"Postcode1"]
[null,"Postcode1"]
[null,"Postcode2"]
[null,"Postcode3"]
[null,"…"]
[null,"Outside of Australia2"]
[null,"Redacted Postcode3"]
[null,"Notes:"]
[null,"1 List all postcodes covered in CL059 for this transaction"]
[null,"2 Group all loans that do not fall within an Australian postcode in this category"]
[null,"3 Group all loans that fall within a postcode that has less than 3 properties within the mortgage pool in this category"]

{"sheet":"No Data","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"flags":["formulas_cached_only"]}
[]
[null,null,"\"No Data\" Responses"]
[null,null,"To capture non-available data fields, a set of five \"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."]
[]
[null,"Value","Reason","Example"]
[null,1,"Data not collected at loan origination","ND1"]
[null,2,"Data collected at loan origination but not loaded into the reporting system at completion","ND2"]
[null,3,"Data collected at loan origination but loaded into a separate system from the reporting one","ND3"]
[null,4,"Data collected at loan origination but will only be available from YYYY-MM","ND4, YYYY-MM"]
[null,5,"Field not applicable to the transaction","N/A"]