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

{"sheet":"CMBS Transaction Level Template","index":0,"n_rows":144,"n_cols":9,"rows_kept":144,"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,"REPORTING TEMPLATE SPECIFICATION FOR REPO-ELIGIBLE SECURITIES"]
[]
[null,"Commercial Mortgage Backed Securities"]
[null,"Transaction Level Data"]
[]
[null,"Version 1.0 (December 2013)"]
[]
[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, 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,"Field Code","Category","Field Name","Reporting\nFrequency","Description","Data Type","Data Format","Guidance Notes"]
[null,"CT001","General","Report Date","Dynamic","As at date of the data. Should correspond with the last day of the collection period for post-issuance reporting.","Date","dd-mm-yyyy"]
[null,"CT002","General","Transaction ID","Static","Unique numeric identifier of the transaction assigned by the Trust Manager.","Numeric",12345]
[null,"CT003","General","Master Trust Name","Static","Full name of the master trust for the transaction.","Text","N/A","For transactions structured under a master trust arrangement. Enter N/A if a master trust structure is not applicable to this transaction."]
[null,"CT004","General","Series Trust Name","Static","Full name of the series trust for the transaction.","Text","N/A","May also be known as the transaction name."]
[null,"CT005","Transaction Parties","Data Template Publisher","Dynamic","Full legal name of the entity publishing this data template.","Text","N/A","If template is being disclosed directly by the sponsor or other related party, use their full legal name. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT006","Transaction Parties","ABN of Data Template Publisher","Dynamic","Australian Business Number (ABN) of the entity publishing this data template.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT007","Transaction Parties","Contact name","Dynamic","Name of the person or department responsible for the data template.","Text","N/A"]
[null,"CT008","Transaction Parties","Contact phone number","Dynamic","Full telephone number of the contact responsible for the data template.","Numeric",61295518111,"Include country and area codes."]
[null,"CT009","Transaction Parties","Contact email address","Dynamic","Email address of the contact responsible for the data template.","Text","N/A"]
[null,"CT010","Transaction Parties","Data Template Location","Static","Publically available internet address of the completed data templates.","Text","N/A","Must be the full URL for each individual data template. If data submitted to a recognised data repository system, list the url of this system "]
[null,"CT011","Transaction Parties","Name of Responsible Party","Static","Full legal name of the entity responsible for the information contained in the information memorandum, prospectus or offering circular (\"Offer Document\").","Text","N/A","If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT012","Transaction Parties","ABN of Responsible Party","Static","ABN of the entity responsible for the information contained in the information memorandum, prospectus or offering circular (\"Offer Document\").","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT013","Transaction Parties","Trustee","Dynamic","Full legal name of the trustee to the transaction.","Text","N/A","If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT014","Transaction Parties","ABN of Trustee","Dynamic","ABN of the trustee to the transaction.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT015","Transaction Parties","Security Trustee","Dynamic","Full legal name of the security trustee to the transaction.","Text","N/A","The entity that has a charge over the trust assets (the commercial mortgage loans and property securing those mortgage loans) on behalf of security holders. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT016","Transaction Parties","ABN of Security Trustee","Dynamic","ABN of the security trustee to the transaction.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT017","Transaction Parties","Sponsor","Static","Full legal name of the entity that organises the transaction by selling or transferring commercial mortgage loans that it originated or acquired. ","Text","N/A","The Sponsor is the party that sells or transfers loans to the Issuer. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT018","Transaction Parties","ABN of Sponsor","Static","ABN of the entity that organises the transaction by selling or transferring commercial mortgage loans that it originated or acquired. ","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT019","Transaction Parties","Arranger","Static","Full legal name of the entity that structures and arranges the transaction on behalf of the Sponsor. ","Text","N/A","If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT020","Transaction Parties","ABN of Arranger","Static","ABN of the entity that structures and arranges the transaction on behalf of the Sponsor. ","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT021","Transaction Parties","Underwriter/Dealer","Static","Full legal name of the entity that agrees to undertake purchases of CMBS if required, at issue, at a specified price (excluding any non-firm undertakings). If there is no such entity to the transaction, enter N/A for this data field.","Text","N/A","If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT022","Transaction Parties","ABN of Underwriter/Dealer","Static","ABN of the entity that agrees to undertake purchases of CMBS if required, at issue, at a specified price (excluding any non-firm undertakings). If there is no such entity to the transaction, enter N/A for this data field.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT023","Transaction Parties","Manager","Dynamic","Full legal name of the entity that is responsible for the day-to-day operations of the transaction.","Text","N/A","Tasks performed by the manager include determining the cash flows generated from the mortgage loans and the calculation of payments and fees due to the relevant counterparties of the transaction. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT024","Transaction Parties","ABN of Manager","Dynamic","ABN of the entity that is responsible for the day-to-day operations of the transaction.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT025","Transaction Parties","Back-up Servicer","Dynamic","Full legal name of the entity responsible for taking on the role of Servicer in the case of the Servicer requiring replacement. If there is no back-up servicer, enter N/A for this data field.","Text","N/A","If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT026","Transaction Parties","ABN of Back-up Servicer","Dynamic","ABN of the entity responsible for taking on the role of Servicer in the case of the Servicer requiring replacement. If there is no back-up servicer, enter N/A for this data field.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT027","Transaction Parties","Liquidity Provider","Dynamic","Full legal name of any entity that is providing a liquidity facility to the transaction.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT028","Transaction Parties","ABN of Liquidity Provider","Dynamic","ABN of any entity that is providing a liquidity facility to the transaction.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT029","Transaction Parties","Mortgage Insurer(s)","Static","Full legal name of any mortgage insurer(s) in the transaction. If there is no mortgages insurer, enter N/A for this data field.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT030","Transaction Parties","ABN of mortgage insurer(s)","Static","ABN  of any mortgage insurer(s) in the transaction. If there is no mortgages insurer, enter N/A for this data field.","Numeric",12345678901,"If there are multiple entities, list the ABNs separated by a semi-colon ';'. If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT031","Transaction Parties","Paying Agent","Dynamic","Full legal name of any entity that is responsible for making the payment of interest and principal to note holders on behalf of the note issuer.","Text","N/A","If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT032","Transaction Parties","ABN of Paying Agent","Dynamic","ABN of any entity that is responsible for making the payment of interest and principal to note holders on behalf of the note issuer.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT033","Transaction Parties","Interest Rate Swap Provider","Dynamic","Full legal name of any entity that has entered into a contract with the Trustee to hedge any interest rate risk in the transaction. If there is no interest rate swap provider, enter N/A for this data field.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT034","Transaction Parties","ABN of Interest Rate Swap Provider","Dynamic","ABN of any entity that has entered into a contract with the Trustee to hedge any interest rate risk in the transaction. If there is no interest rate swap provider, enter N/A for this data field.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT035","Transaction Parties","Basis Swap Provider","Dynamic","Full legal name of any entity that has entered into a contract with the Trustee to hedge any basis risk in the transaction. If there is no basis swap provider, enter N/A for this data field.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT036","Transaction Parties","ABN of Basis Swap Provider","Dynamic","ABN of any entity that has entered into a contract with the Trustee to hedge any basis risk in the transaction. If there is no basis swap provider, enter N/A for this data field.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT037","Transaction Parties","Currency Swap Provider","Dynamic","Full legal name of any entity that has entered into a contract with the Trustee to hedge any currency risk in the transaction. If there is no currency swap provider, enter N/A for this data field.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT038","Transaction Parties","ABN of Currency Swap Provider","Dynamic","ABN of any entity that has entered into a contract with the Trustee to hedge any currency risk in the transaction. If there is no currency swap provider, enter N/A for this data field.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT039","Transaction Parties","Name of Guaranteed Investment Contract (GIC) Provider","Dynamic","Full legal name of any entity that has entered into a contract with the Trustee to hold funds in a GIC account to redeem notes. If there is no GIC provider, enter N/A for this data field.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT040","Transaction Parties","ABN of Guaranteed Investment Contract Provider","Dynamic","The ABN of any entity that has entered into a contract with the Trustee to hold funds in a GIC account to redeem notes. If there is no GIC provider, enter N/A for this data field.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT041","Transaction Parties","Other Hedge Provider","Dynamic","Full legal name of any entity that has entered into a contract with the Trustee to hedge any other market or credit risk in the transaction. If there is no other hedge provider, enter N/A for this data field.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT042","Transaction Parties","ABN of Other Hedge Provider","Dynamic","ABN of any entity that has entered into a contract with the Trustee to hedge any other market or credit risk in the transaction. If there is no other hedge provider, enter N/A for this data field.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT043","Transaction Parties","Type of Other Hedge","Dynamic","Description of the derivatives product provided by the Other Hedge Provider to the Trustee. If there is no other hedge provider, enter N/A for this data field.","Text","N/A"]
[null,"CT044","Governing Laws/Regulations","Governing Law of Mortgages","Static","Jurisdictions whose laws and regulations govern the mortgage loan pool.","Text","NSW; VIC; New Zealand; Canada","If there are multiple entities, list the names separated by a semi-colon ';'. For Australian mortgages please specify states &/or territories, using the approved abbreviated form of Australia Post."]
[null,"CT045","Mortgage Pool Claimants","Name of Potential Mortgage Pool Claimants","Static","Full legal name of any entity other than a note holder that has a direct or contingent claim on any pool assets, other than those listed above. If there are no other entities which have a direct or contingent claim on any pool assets, enter N/A for this data field.","Text","N/A","These claims may include cross-collateralisation or cross-default provisions, such as second ranking mortgages or split loans that are securitised into different pools. If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT046","Mortgage Pool Claimants","ABN of Potential Mortgage Pool Claimants","Static","ABN of any entity other than a note holder that has a direct or contingent claim on any pool assets, other than those listed above. If there are no other entities which have a direct or contingent claim on any pool assets, enter N/A for this data field.","Text","N/A","These claims may include cross-collateralisation or cross-default provisions, such as second ranking mortgages or split loans that are securitised into different pools. If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT047","Revolving Facility","Revolving period end date","Static","The end date of any revolving period during which cash flows from the commercial mortgage loans may be used to acquire additional commercial mortgage loans. If the transaction does not have a revolving period, enter N/A for this data field.","Date","dd-mm-yyyy","Revolving period - Is a period of time in which principal receipts can be used to purchase new loans (subject to underwriting criteria) from the originator or seller. Revolving periods (also known as top-ups) are generally used to maintain the value of the collateral pool at or around the original invested amount.\n\nSubstitution Period - A substitution period is where loans may be removed from the collateral pool (due to no longer satisfying eligibility criteria or if it is discovered that any warranties or representations in respect to any of the loans were deemed to be in breach at the time of underwriting) and replaced by other loans (which satisfy eligibility criteria). Substitution periods, generally have little impact on the balance of the collateral pool as the loans released from the mortgage pool are replaced with loans of similar value. "]
[null,"CT048","Revolving Facility","Revolving account triggers","Static","Any triggers that would limit or terminate the revolving period. If the transaction does not have a revolving period, enter N/A for this data field.","Text","N/A","Refer to guidance notes to CT047 for a definition of revolving and substitution periods."]
[null,"CT049","Pre-funding Facility","Pre-funding end date","Static","The end date of any pre-funding period during which funds from investors are accumulated for future acquisitions of commercial mortgage loans. If the transaction does not have a pre-funding facility, enter N/A for this data field.","Date","dd-mm-yyyy"]
[null,"CT050","Pre-funding Facility","Pre-funding account balance","Dynamic","The current balance of the pre-funding account. If the transaction does not have a pre-funding facility, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT051","Pre-funding Facility","Pre-funding account triggers","Dynamic","Any triggers that would limit or terminate the pre-funding period. If the transaction does not have a pre-funding facility, enter N/A for this data field.","Text","N/A"]
[null,"CT052","Asset Substitutions","Asset substitution end date","Static","Specify, if applicable, the end date of any period during which any asset substitutions may occur. If the transaction does not have a substitution facility, enter N/A for this data field.","Date","dd-mm-yyyy","Refer to guidance notes to CT047 for a definition of revolving and substitution periods."]
[null,"CT053","Asset Substitutions","Asset substitution parties","Static","Specify, if applicable, the parties which determine whether asset substitutions will occur. If the transaction does not have a substitution facility, enter N/A for this data field.","Text","N/A","Refer to guidance notes to CT047 for a definition of revolving and substitution periods."]
[null,"CT054","Asset Substitutions","Asset substitution triggers","Static","Describe any circumstances (qualitative/quantitative) which trigger asset substitutions. For example, if it is discovered that there was a breach of warranty or a misrepresentation as at time of underwriting. If the transaction does not have a substitution facility, enter N/A for this data field.","Text","N/A","Refer to guidance notes to CT047 for a definition of revolving and substitution periods."]
[null,"CT055","Asset Substitutions","Asset substitution process","Static","Describe the process for asset substitutions, including eligibility criteria. If the transaction does not have a substitution facility, enter N/A for this data field.","Text","N/A","Refer to guidance notes to CT047 for a definition of revolving and substitution periods."]
[null,"CT056","Principal Draw","Principal Draw Account Balance","Dynamic","The balance of the principal draw account as at report date used to pay required trust expenses such as fees and note coupons, due to insufficient income collections.","Numeric",{"v":1234567.89,"d":"$1,234,567.89"}]
[null,"CT057","Cash Receipts Pending Distribution","Cash Receipts Pending Distribution - Frequency","Dynamic","The frequency with which cash is remitted by the Servicer to the Trust Collections Account:\n1 - Daily\n2 - Every second business day\n3 - Weekly\n4 - Fortnightly\n5 - Monthly\n6 - Quarterly\n7 - Semi-annually\n8 - Annually\n9 - Bullet\n10 - Other","Numeric",1]
[null,"CT058","Cash Receipts Pending Distribution","Trust Collections Account - Access","Static","Full legal name of any party which has full signatory access to the Trust Collections Account.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT059","Cash Receipts Pending Distribution","Trust Collections Account - Access","Static","ABN of any entity that has full signatory access to the Trust Collections Account.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT060","Cash Receipts Pending Distribution","Trust Collections Account - Authority","Static","Full legal name of any entity which has authority to make decisions regarding the use of funds in the Trust Collections Account.","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT061","Cash Receipts Pending Distribution","Trust Collections Account - Authority","Static","ABN of any entity which has authority to make decisions regarding the use of funds in the Trust Collections Account.","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT062","Cash Receipts Pending Distribution","Trust Collections Account - Liabilities","Static","Full legal name of any entity which holds cash distributions on its balance sheet as a liability (i.e. the institution(s) where the Collections Account is held).","Text","N/A","If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT063","Cash Receipts Pending Distribution","Trust Collections Account - Liabilities","Static","ABN of any entity which holds cash distributions on its balance sheet as a liability (i.e. the institution(s) where the Collections Account is held).","Numeric",12345678901,"If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT064","Reserve Accounts and Cash Collateral Accounts","Operator of Reserve/Cash Collateral Accounts","Static","Full legal name of all entities which have signatory access to any reserve or cash collateral accounts in the transaction.","Text","N/A","Cash may be set aside in a reserve or cash collateral account, rather than paid to note holders. If there are multiple entities, list the names separated by a semi-colon ';'. If non resident entity, list the full legal name of the entity followed by the applicable foreign jurisdiction."]
[null,"CT065","Reserve Accounts and Cash Collateral Accounts","ABN of Operator of Reserve/Cash Collateral Accounts","Static","ABN of all entities which have signatory access to any reserve or cash collateral accounts in the transaction.","Numeric",12345678901,"If there are multiple entities, list the ABNs separated by a semi-colon ';'. If non resident entity, list the applicable business serial number in the foreign jurisdiction."]
[null,"CT066","Reserve Accounts and Cash Collateral Accounts","Drawdown Events on Reserve/Cash Collateral Accounts","Static","List all material trigger events which would permit the reserve or cash collateral account to be drawn down.","Text","N/A","Only include events which are the most material and/or most likely to occur. Some examples include;  to ensure timely payment of coupons/fees in the event of insufficient cashflows during the collection or to replenish a liquidity draw/advance account. Do not include all trigger events."]
[null,"CT067","Cash Maintenance","Cash Maintenance","Static","Frequency of collection periods for the transaction.\n1 - Daily\n2 - Every second business day\n3 - Weekly\n4 - Fortnightly\n5 - Monthly\n6 - Quarterly\n7 - Semi-annually\n8 - Annually\n9 - Bullet\n10 - Other","Numeric",1]
[null,"CT068","Fees and Expenses","Senior Fees and Expenses in total dollars","Dynamic","A consolidated figure of senior fees and expenses (excluding note holder payments) that cannot be deferred, expressed in total dollars (for recurring fixed or minimum fees) for each accrual period.","Numeric",{"v":123456.78,"d":"$123,456.78"},"All public transactions must report this data. However, for private placements and internal (self) securitisations, this data should be made available to the RBA only. "]
[null,"CT069","Excess Cash Flow","Minimum Excess Cash Flow","Static","The minimum amount of excess cash flow to be captured from the transaction.","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT070","Excess Cash Flow","Consequences of Failing to meet Minimum Excess Cash Flow","Static","The consequences if the minimum required excess cash flows are not met.","Text","N/A"]
[null,"CT071","Note Redemptions","Note Redemption or Termination","Static","Disclose any redemption or termination triggers and procedures (including any notices to CMBS note holders), and list the obligations of the Trustee if the securities are not redeemed. Examples include Call Options and Clean Ups. If the transaction does not have any of these features, enter N/A for this data field.","Text","N/A","Redemption occurs when the securities can be redeemed (effectively bought back by the Issuer/Trustee) prior to the maturity date. This may often be at the option of one of the transaction parties, upon certain events being triggered."]
[null,"CT072","Note Redemptions","Redemption Pricing","Static","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.","Numeric",12.34]
[null,"CT073","Transaction enhancement and support","External Credit Enhancement ","Static","Any form of irrevocable and unconditional external credit enhancements (e.g. Letters of Credit, Guarantees or monoline insurance) that only apply at the transaction level, along with a description of the form of enhancement and provider(s) name and ABN. If the transaction does not have any external credit enhancements, enter N/A for this data field.","Text","N/A"]
[null,"CT074","Transaction enhancement and support","Default Allocation - Changes to Structure","Static","Describe any events specific to the transaction that would force a change in the structure of the Default Allocation Structure and their impact on the Default Allocation Structure.","Text","N/A"]
[null,"CT075","Transaction enhancement and support","Reserve Account A - Name and Description","Static","If there is a reserve account, name this account and describe the circumstance(s) under which it is to be used. For example, is it used to provide credit or liquidity support to the transaction, meet credit losses or subsequent claims by security holders. If there is no reserve account to the transaction, enter N/A for this data field. If there is more than one reserve account to the transaction, enter details of other reserve accounts in fields CT078-CT086.","Text","N/A"]
[null,"CT076","Transaction enhancement and support","Reserve Account A - Current Balance","Dynamic","The balance of the Reserve Account A (described CT075) as at the report date. If there is no reserve account in the transaction, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT077","Transaction enhancement and support","Reserve Account A - Target Balance","Dynamic","The target balance of the Reserve Account A (described in CT075) as at the report date. If there is no reserve account in the transaction, or there is no target balance for reserve account A, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT078","Transaction enhancement and support","Reserve Account B - Name and Description","Static","If there are more than one reserve account to the transaction, name this account and describe the circumstance(s) under which it is to be used. For example, is it used to provide credit or liquidity support to the transaction, meet credit losses or subsequent claims by security holders. If there are less than two reserve accounts to the transaction, enter N/A for this data field. If there are more than two reserve accounts to the transaction, enter details of other reserve accounts in fields CT081-CT086.","Text","N/A"]
[null,"CT079","Transaction enhancement and support","Reserve Account B - Current Balance","Dynamic","The balance of the Reserve Account B (described in CT078) as at the report date. If there is no second reserve account in the transaction, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT080","Transaction enhancement and support","Reserve Account B - Target Balance","Dynamic","The target balance of the Reserve Account B (described CT078) as at the report date. If there is no second reserve account in the transaction, or there is no target balance for reserve account B, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT081","Transaction enhancement and support","Reserve Account C - Name and Description","Static","If there are more than two reserve accounts to the transaction, name this account and describe the circumstance(s) under which it is to be used. For example, is it used to provide credit or liquidity support to the transaction, meet credit losses or subsequent claims by security holders. If there are less than three reserve accounts to the transaction, enter N/A for this data field. If there are more than three reserve accounts to the transaction, enter details of other reserve accounts in the fields below.","Text","N/A"]
[null,"CT082","Transaction enhancement and support","Reserve Account C - Current Balance","Dynamic","The balance of the Reserve Account C (described in CT081) as at the report date. If there is no third reserve account in the transaction, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT083","Transaction enhancement and support","Reserve Account C - Target Balance","Dynamic","The target balance of the Reserve Account C (described in CT081) as at the report date. If there is no third reserve account in the transaction, or there is no target balance for reserve account C, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT084","Transaction enhancement and support","Reserve Account D - Name and Description","Static","If there are more than three reserve accounts to the transaction, name this account and describe the circumstance(s) under which it is to be used. For example, is it used to provide credit or liquidity support to the transaction, meet credit losses or subsequent claims by security holders. If there are less than four reserve accounts to the transaction, enter N/A for this data field. If there are more than four reserve accounts to the transaction, enter the details of other reserve accounts in this data field but clearly separate the name and description of these reserve accounts from the fourth reserve account.","Text","N/A"]
[null,"CT085","Transaction enhancement and support","Reserve Account D - Current Balance","Dynamic","The balance of the Reserve Account D (described in CT084) as at the report date. If there is no fourth reserve account in the transaction, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT086","Transaction enhancement and support","Reserve Account D - Target Balance","Dynamic","The target balance of the Reserve Account D (described CT084) as at the report date. If there is no fourth reserve account in the transaction, or there is no target balance for reserve account D, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT087","Transaction enhancement and support","Internal Credit Enhancement - Overcollateralisation","Dynamic","Indicate, if applicable, the level of overcollateralisation (where the assets to be used as security (i.e. loans) exceed the amount of debt that is issued) for the transaction.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT088","Transaction enhancement and support","Internal Credit Enhancement - Cash collateral","Dynamic","Indicate, if applicable, the level of collateralisation in the form of cash (not loans as per above) for the transaction. Reported figure should reflect the amount of cash held by the party originating the loans only. ","Numeric",{"v":123456789.12,"d":"$123,456,789.12"},"For undercollateralisation, report this figure as a negative number and for overcollateralisation report this as a positive."]
[null,"CT089","Transaction enhancement and support","Liquidity Facility","Static","The aggregate notional size of the liquidity facility - as agreed to at the set up of the trust - per liquidity provider listed in CT027/28. For multiple liquidity facilities, list the amounts in the order of the providers listed in fields CT027/28, separating these amounts with a semi colon \";\". ","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT090","Transaction enhancement and support","Starting Liquidity Facility","Dynamic","The balance of funds on deposit in each liquidity facility at the Accrual Start Date. For multiple liquidity facilities, separate amounts with a semi colon \";\" in the same order as that presented in CT089.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT091","Transaction enhancement and support","Ending Liquidity Facility","Dynamic","The balance of funds on deposit in each liquidity facility at the Accrual End Date. For multiple liquidity facilities, separate amounts with a semi colon \";\" in the same order as that presented in CT089.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT092","Transaction enhancement and support","Other Account Balance","Dynamic","The amount of funds that would be on deposit in any other account as at Report Date. If there are no other funds on deposit in any other account, enter N/A for this data field.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT093","Transaction enhancement and support","Fixed-for-floating Interest Rate Swap Notional Amount","Dynamic","The current aggregate notional face value of fixed-for-floating interest rate swaps per interest rate swap provider listed in CT033/34. If there is no fixed-for-floating interest rate swap in the transaction, enter N/A for this data field. For multiple notional amounts, list the amounts in the order of the parties listed in fields CT033/34, separating these amounts with a semi colon \";\". ","Numeric",{"v":123456789.12,"d":"$123,456,789.12"},"A fixed-for-floating interest rate swap is used when the interest rate on an underlying pool of fixed rate mortgages is hedged into a floating rate exposure."]
[null,"CT094","Transaction enhancement and support","Floating-for-fixed Interest Rate Swap Notional Amount","Dynamic","The current aggregate notional face value of floating-for-fixed interest rate swaps per interest rate swap provider listed in CT033/34. If there is no floating-for-fixed interest rate swap in the transaction, enter N/A for this data field. For multiple notional amounts, list the amounts in the order of the parties listed in fields CT033/34, separating these amounts with a semi colon \";\". ","Numeric",{"v":123456789.12,"d":"$123,456,789.12"},"A floating-for-fixed interest rate swap is used when the interest rate on an underlying pool of variable rate mortgages is hedged into a fixed rate exposure."]
[null,"CT095","Transaction enhancement and support","Currency Swap Notional Amount","Dynamic","The current aggregate notional face value of currency swap (or other currency hedging facility) per currency swap provider listed in CT037/38. If there is no currency swap facility in the transaction, enter N/A for this data field. For multiple notional amounts, list the amounts in the order of the parties listed in fields CT037/38, separating these amounts with a semi colon \";\".","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT096","Affiliations and related transactions","Interests of Experts and Counsel","Static","If any of the experts or counsels named in the Offer Document has a material direct or indirect economic interest as at the time of issue in the Issuer, Arranger/Sponsor, Depositor or their Affiliates, or an interest that depends on the success of the offering or listing, or otherwise has a material conflict of interest in rendering its advice or opinion, the nature and terms of that interest or conflict of interest must be disclosed.","Text","N/A"]
[null,"CT097","Collateral Pool","Currency","Static","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","For example, \"AUD\" for Australian dollar denominated transactions."]
[null,"CT098","Collateral Pool","Collections Period Start Date","Dynamic","The first day on which principal and interest receipts from borrowers are allocated by the Servicer in respect of the current payment date.","Date","dd-mm-yyyy"]
[null,"CT099","Collateral Pool","Collections Period End Date","Dynamic","The final day on which principal and interest receipts from borrowers are allocated by the Servicer in respect of the current payment date.","Date","dd-mm-yyyy"]
[null,"CT100","Collateral Pool","Current Pool Balance","Dynamic","The aggregate balance of all loans in the trust.","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT101","Collateral Pool","Scheduled Pool Balance ","Dynamic","The total balance of loans in the trust at the end of the period assuming only contractual repayments have been made when due (i.e. excluding any prepayments that may have been made). ","Numeric",{"v":123456789.12,"d":"$123,456,789.12"}]
[null,"CT102","Collateral Pool","Unconsolidated Loan Count ","Dynamic","Number of loans in the trust before consolidating split-loans that are secured by the same properties.","Numeric",123456]
[null,"CT103","Collateral Pool","Weighted Average Approval Amount","Dynamic","The average original loan balance for all the loans in the trust weighted by loan balance as at Report Date.","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT104","Collateral Pool","Weighted Average Current LTV","Dynamic","The average Current LTV for all the loans in the trust weighted by their current balance as at Report Date. Expressed as percentage.","Numeric",12.3456]
[null,"CT105","Collateral Pool","Weighted Average Remaining Term ","Dynamic","The average Remaining Term for all the loans in the trust weighted by loan balance as at Report Date. Expressed as number of months.","Numeric",123.45]
[null,"CT106","Collateral Pool","Weighted Average Seasoning ","Dynamic","The average Seasoning of the loans in the trust weighted by loan balance as at Report Date. Expressed as number of months.","Numeric",123.45]
[null,"CT107","Collateral Pool","Pool Factor","Dynamic","Outstanding principal balance of all receivables on the last day of the immediately preceding collection period divided by the original principal balance of the receivables at cut-off date (i.e. pool cut date). Expressed as a percentage.","Numeric",123.45]
[null,"CT108","Collateral Pool","Trustee Interest Rate Authority ","Static","Does the Trustee have the authority under any circumstances to direct the Servicer to increase the interest rate on the mortgages in the pool?","Text","Yes/No","Examples include, if the Trust is unable to meet its obligations or fails to meet a predetermined threshold interest rate. Report Y if the Trustee has the power, whether express or implied, to compel changes in interest rates. This includes cases where the Servicer and/or Manager have an enforceable obligation to set or direct interest rates. Report N if the Servicer and/or Manager are under a best endeavours duty, but not an obligation, to set or direct interest rates."]
[null,"CT109","Lenders' Mortgage Insurance","Mortgage Insurance Coverage","Dynamic","The percentage of mortgages (by the number of mortgages) with any form of lenders' loan or mortgage insurance.","Numeric",123.45]
[null,"CT110","Prepayments","Unscheduled Principal Payments","Dynamic","The total principal balance of unscheduled payments received (i.e. prepayments only) of commercial mortgage loans during the Collection Period.","Numeric",{"v":123456.78,"d":"$123,456.78"},"Estimates are permitted if actuals cannot be accurately calculated."]
[null,"CT111","Prepayments","Total Redraws","Dynamic","Gross total redraws by borrowers during the Collection Period.","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT112","Prepayments","Total Inward Substitutions","Dynamic","Total current balance of mortgages substituted into the trust during the Collection Period via either a revolving or substitution facility (defined in the guidance notes to CT047).","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT113","Prepayments","Total Outward Substitutions","Dynamic","Total current balance of mortgages substituted out of the trust during the Collection Period via a substitution facility (defined in the guidance notes to CT047).","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT114","Prepayments","Average Constant Prepayment Rate (CPR) ","Dynamic","Average (Avg) CPR speed of the underlying commercial mortgage loans. Avg CPR speed is the amount expressed as an annualised percentage of principal prepaid in excess of scheduled repayments. Expressed as a percentage.","Numeric",12.3456,"The Avg CPR speed can be calculated by first dividing the Current Balance of the Pool by the Scheduled Pool Balance assuming no prepayments have been made (i.e. only scheduled repayments have been made).  This quotient is then raised to a power whereby the exponent is the quantity twelve divided by the number of months since issue.  Subtract this result from one then multiply it by one hundred (100) to determine the Avg CPR speed.  This calculation is expressed as follows:"]
[null,"CT115","Prepayments","Periodic Constant Prepayment Rate (CPR)","Dynamic","Periodic CPR speed is the amount expressed as a periodical percentage of principal prepaid in excess of scheduled repayments. Expressed a percentage.","Numeric",12.3456,"The Periodic CPR speed may be calculated by first dividing the Current Pool Balance (i.e. the actual balance) by the Scheduled Pool Balance assuming no prepayments have been made (i.e. only scheduled repayments have been made).  This quotient is then raised to a power whereby the exponent is the payment period (i.e. one month, two months, three months or six months) divided by the number of months since issue.  Subtract this result from one then multiply it by one hundred (100) to determine the Periodic CPR speed.  This calculation is expressed as follows\n"]
[null,"CT116","Defaults, Losses \nand Claims","Loss Covered by Excess Spread/Income","Dynamic","The cumulative amount of losses/charge offs that were covered/paid for by excess spread/income from the transaction.","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT117","Defaults, Losses \nand Claims","Loss Covered By Other Means","Dynamic","A description of the way losses were covered / paid for by means other than excess spread in the transaction. If there have been no losses in the transaction, enter N/A for this data field.","Text","N/A"]
[null,"CT118","Defaults, Losses \nand Claims","Loss Covered By Other Means","Dynamic","The cumulative amount of losses that were covered / paid for by means other than excess spread. If there have been no losses in the transaction, enter N/A for this data field.","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT119","Defaults, Losses \nand Claims","Timely Payments Claims Paid By Mortgage Insurers Under Timely Payment Cover","Dynamic","The cumulative amount of claims paid by the lender's mortgage insurance provider to cover missed repayments by the borrower.","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT120","Defaults, Losses \nand Claims","Reimbursed Timely Payments Claims ","Dynamic","The cumulative amount repaid / reimbursed to the lender's mortgage insurance provider by the servicer in relation to timely payment claims.","Numeric",{"v":123456.78,"d":"$123,456.78"}]
[null,"CT121","Defaults, Losses \nand Claims","Timely Payment Claims Submitted To Mortgage Insurers","Dynamic","The cumulative amount of claims submitted to the lender's mortgage insurance provider to cover missed repayments by the borrower.","Numeric",{"v":123456.78,"d":"$123,456.78"}]

{"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"]