Task: equi-join-detect (source dataset: Auto-BI)

Your are given a database with related tables used for business intelligence analysis. Your task is to identify all key/foreign-key join relationships between the tables for this database. Recall that a join is a relationship between two tables, that allows rows from one table to be combined with rows from another, based on a set of common join columns.
 
 
No explanation needed. Please return all join relationships in the following JSON format:
{
  "joins": [
    {
      "from_table": "table-1",
      "from_column": "column-1",
      "to_table": "table-2",
      "to_column": "column-3"
    }, 
	...
  ]
}

Tables:

Table: BTI_MethMaxPoints
| _nadb_riskindicator_value            |   Max Points | nadb_riskratingmethodologyid         |
|:-------------------------------------|-------------:|:-------------------------------------|
| e19930ab-c154-ea11-a813-000d3a4ed0f6 |           10 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| e39930ab-c154-ea11-a813-000d3a4ed0f6 |           10 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| e59930ab-c154-ea11-a813-000d3a4ed0f6 |            5 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| e79930ab-c154-ea11-a813-000d3a4ed0f6 |            5 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| e99930ab-c154-ea11-a813-000d3a4ed0f6 |            0 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| eb9930ab-c154-ea11-a813-000d3a4ed0f6 |           10 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| ed9930ab-c154-ea11-a813-000d3a4ed0f6 |           10 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| ef9930ab-c154-ea11-a813-000d3a4ed0f6 |           15 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| f19930ab-c154-ea11-a813-000d3a4ed0f6 |           10 | 06c0009c-c154-ea11-a813-000d3a4e6589 |
| f39930ab-c154-ea11-a813-000d3a4ed0f6 |           10 | 06c0009c-c154-ea11-a813-000d3a4e6589 |


Table: BTI_ProbabilityofDefault
|   Credit Scoring |   KeyPI100 | nadb_measuredate_pjrisk   | _nadb_creditriskratingadministration_value   |   MethodologySum |   Prob Of Default | Date     | _nadb_internalcreditriskrating_value   |   Value for Scale |
|-----------------:|-----------:|:--------------------------|:---------------------------------------------|-----------------:|------------------:|:---------|:---------------------------------------|------------------:|
|               79 |         79 | 2019-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         |              100 |        0.00652663 | 1/1/2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   |          0.652663 |
|               79 |         79 | 2018-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         |              100 |        0.00652663 | 1/1/2018 | f917e21c-1859-ea11-a811-000d3a4f6c19   |          0.652663 |
|               84 |         84 | 2017-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         |              100 |        0.00275453 | 1/1/2017 | f917e21c-1859-ea11-a811-000d3a4f6c19   |          0.275453 |
|               80 |         80 | 2019-01-01 00:00:00.000   | d8c2e488-e658-ea11-a811-000d3a4f6db7         |              100 |        0.00549392 | 1/1/2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   |          0.549392 |
|               85 |         85 | 2018-01-01 00:00:00.000   | d8c2e488-e658-ea11-a811-000d3a4f6db7         |              100 |        0.00231729 | 1/1/2018 | f917e21c-1859-ea11-a811-000d3a4f6c19   |          0.231729 |


Table: BTI_ScaleGrade
| nadb_measuredate_pjrisk   | _nadb_creditriskratingadministration_value   | Year                    |   Credit Scoring |   KeyPI100 |     Scale | Internal                             |
|:--------------------------|:---------------------------------------------|:------------------------|-----------------:|-----------:|----------:|:-------------------------------------|
| 2019-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         | 2019-01-01 00:00:00.000 |               79 |         79 | 180830008 | 739a0343-d754-ea11-a812-000d3a4f6c19 |
| 2018-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         | 2018-01-01 00:00:00.000 |               79 |         79 | 180830008 | f917e21c-1859-ea11-a811-000d3a4f6c19 |
| 2017-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         | 2017-01-01 00:00:00.000 |               84 |         84 | 180830008 | f917e21c-1859-ea11-a811-000d3a4f6c19 |
| 2019-01-01 00:00:00.000   | d8c2e488-e658-ea11-a811-000d3a4f6db7         | 2019-01-01 00:00:00.000 |               80 |         80 | 180830008 | 739a0343-d754-ea11-a812-000d3a4f6c19 |
| 2018-01-01 00:00:00.000   | d8c2e488-e658-ea11-a811-000d3a4f6db7         | 2018-01-01 00:00:00.000 |               85 |         85 | 180830008 | f917e21c-1859-ea11-a811-000d3a4f6c19 |


Table: Chart
|   Credit Scoring | _nadb_internalcreditriskrating_value   | nadb_measuredate_pjrisk   | _nadb_creditriskratingadministration_value   | Date     |   KeyPI100 |   MethodologySum | Prob Of Default   |   Value for Scale |
|-----------------:|:---------------------------------------|:--------------------------|:---------------------------------------------|:---------|-----------:|-----------------:|:------------------|------------------:|
|               79 | 739a0343-d754-ea11-a812-000d3a4f6c19   | 2019-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         | 1/1/2019 |         79 |              100 | 0.65%             |           65.2663 |
|               79 | f917e21c-1859-ea11-a811-000d3a4f6c19   | 2018-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         | 1/1/2018 |         79 |              100 | 0.65%             |           65.2663 |
|               84 | f917e21c-1859-ea11-a811-000d3a4f6c19   | 2017-01-01 00:00:00.000   | 06b27cba-1459-ea11-a811-000d3a4f6c19         | 1/1/2017 |         84 |              100 | 0.28%             |           27.5453 |
|               80 | 739a0343-d754-ea11-a812-000d3a4f6c19   | 2019-01-01 00:00:00.000   | d8c2e488-e658-ea11-a811-000d3a4f6db7         | 1/1/2019 |         80 |              100 | 0.55%             |           54.9392 |
|               85 | f917e21c-1859-ea11-a811-000d3a4f6c19   | 2018-01-01 00:00:00.000   | d8c2e488-e658-ea11-a811-000d3a4f6db7         | 1/1/2018 |         85 |              100 | 0.23%             |           23.1729 |


Table: innetable
| Credit Scoring   | KeyPI100   | nadb_measuredate_pjrisk   | _nadb_creditriskratingadministration_value   | MethodologySum   | Prob Of Default   | Date   | _nadb_internalcreditriskrating_value   | Value for Scale   |   EX-Probabilitylist |   EX-CreditScorelist | EXMeth                        |   EX-CreditScorelist - Copy |
|:-----------------|:-----------|:--------------------------|:---------------------------------------------|:-----------------|:------------------|:-------|:---------------------------------------|:------------------|---------------------:|---------------------:|:------------------------------|----------------------------:|
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.999827 |                    0 | Clean Energy (Solar and Wind) |                           0 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.999795 |                    1 | Clean Energy (Solar and Wind) |                           1 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.999756 |                    2 | Clean Energy (Solar and Wind) |                           2 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.99971  |                    3 | Clean Energy (Solar and Wind) |                           3 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.999655 |                    4 | Clean Energy (Solar and Wind) |                           4 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.99959  |                    5 | Clean Energy (Solar and Wind) |                           5 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.999512 |                    6 | Clean Energy (Solar and Wind) |                           6 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.99942  |                    7 | Clean Energy (Solar and Wind) |                           7 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.99931  |                    8 | Clean Energy (Solar and Wind) |                           8 |
|                  |            |                           |                                              |                  |                   |        |                                        |                   |             0.999179 |                    9 | Clean Energy (Solar and Wind) |                           9 |


Table: Level
|   LevelID | LevelDescr   |
|----------:|:-------------|
| 180830000 | Pass         |
| 180830001 | OAEM         |
| 180830002 | Substandard  |
| 180830003 | Doubtful     |
| 180830004 | Loss         |


Table: nadb_creditriskadministrations
| modifiedon              | nadb_creditriskadministrationid      | importsequencenumber   | _modifiedby_value                    | _nadb_relatedloanadministration_crisk_value   | _createdby_value                     |   statuscode | _owninguser_value                    | createdon               | utcconversiontimezonecode   | _nadb_originopportunity_value        |   statecode | _modifiedonbehalfby_value   |   versionnumber | _nadb_sponsor_cradmin_value   | _ownerid_value                       | _owningteam_value                    | overriddencreatedon   | nadb_name                                                                                        | _owningbusinessunit_value            | timezoneruleversionnumber   | _createdonbehalfby_value   |
|:------------------------|:-------------------------------------|:-----------------------|:-------------------------------------|:----------------------------------------------|:-------------------------------------|-------------:|:-------------------------------------|:------------------------|:----------------------------|:-------------------------------------|------------:|:----------------------------|----------------:|:------------------------------|:-------------------------------------|:-------------------------------------|:----------------------|:-------------------------------------------------------------------------------------------------|:-------------------------------------|:----------------------------|:---------------------------|
| 2020-03-18 22:43:02.000 | 45287dec-af64-ea11-a811-000d3a4e6589 |                        | c7205e36-d6ee-42c5-8733-e670621cd834 | 13f778e6-af64-ea11-a811-000d3a4e6589          | c7205e36-d6ee-42c5-8733-e670621cd834 |            1 |                                      | 2020-03-12 22:22:15.000 |                             | 46a8ed5a-11d4-e911-a976-000d3a4e890b |           0 |                             |        13820007 |                               | 1517bb53-bcd0-e911-a964-000d3a4f1a4f | 1517bb53-bcd0-e911-a964-000d3a4f1a4f |                       | CE Project esVolta Energy Storage California             - Credit risk rating                    | 1417bb53-bcd0-e911-a964-000d3a4f1a4f |                             |                            |
| 2020-03-18 22:43:28.000 | 221f6574-bb5d-ea11-a811-000d3a4edd29 |                        | c7205e36-d6ee-42c5-8733-e670621cd834 | fa171170-bb5d-ea11-a811-000d3a4ed4e6          | c7205e36-d6ee-42c5-8733-e670621cd834 |            1 |                                      | 2020-03-04 01:57:09.000 |                             | eca9ed5a-11d4-e911-a976-000d3a4e890b |           0 |                             |        13820024 |                               | 1517bb53-bcd0-e911-a964-000d3a4f1a4f | 1517bb53-bcd0-e911-a964-000d3a4f1a4f |                       | SW Project Landfill Cell in Maverick County TX - Credit risk rating                              | 1417bb53-bcd0-e911-a964-000d3a4f1a4f |                             |                            |
| 2020-02-27 03:53:41.000 | 06b27cba-1459-ea11-a811-000d3a4f6c19 |                        | c7205e36-d6ee-42c5-8733-e670621cd834 | 4da616c1-49d4-e911-a983-000d3a4e83d0          | c7205e36-d6ee-42c5-8733-e670621cd834 |            1 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 03:53:41.000 |                             | c2a8ed5a-11d4-e911-a976-000d3a4e890b |           0 |                             |        12470008 |                               | c7205e36-d6ee-42c5-8733-e670621cd834 |                                      |                       | Energia Sierra Juarez Wind Energy Project First Phase Tecate Municipality, Baja California - CRR | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                             |                            |
| 2020-02-26 22:22:56.000 | d8c2e488-e658-ea11-a811-000d3a4f6db7 |                        | c7205e36-d6ee-42c5-8733-e670621cd834 | 9ba616c1-49d4-e911-a983-000d3a4e83d0          | c7205e36-d6ee-42c5-8733-e670621cd834 |            1 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-26 22:22:56.000 |                             | fca9ed5a-11d4-e911-a976-000d3a4e890b |           0 |                             |        12457892 |                               | c7205e36-d6ee-42c5-8733-e670621cd834 |                                      |                       | Victoria Wind Energy Project In Güémez, Tamaulipas                                               | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                             |                            |
| 2020-04-10 05:41:31.000 | ea9e40e9-ed7a-ea11-a811-000d3a4f6db7 |                        | c7205e36-d6ee-42c5-8733-e670621cd834 | 57a616c1-49d4-e911-a983-000d3a4e83d0          | c7205e36-d6ee-42c5-8733-e670621cd834 |            1 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-04-10 05:41:31.000 |                             | 04a9ed5a-11d4-e911-a976-000d3a4e890b |           0 |                             |        15581315 |                               | c7205e36-d6ee-42c5-8733-e670621cd834 |                                      |                       | Community Solar Credit risk rating                                                               | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                             |                            |


Table: nadb_creditriskstatuses (2)
| _ownerid_value                       | _createdby_value                     |   versionnumber | _owningbusinessunit_value            | nadb_creditriskstatusid              | modifiedon              | _owningteam_value   | nadb_indicatorname_status                                                                                                                                                                  | _nadb_riskindicator_value            | nadb_statusname   | _modifiedonbehalfby_value   | _createdonbehalfby_value   | nadb_statuscode                                                                              |   statuscode | overriddencreatedon   |   importsequencenumber | nadb_statuspoints   | timezoneruleversionnumber   |   statecode |   nadb_statuspoints2 | _modifiedby_value                    | _nadb_statusmethodology_value   | _owninguser_value                    | nadb_variablerange   | createdon               | nadb_name2   | utcconversiontimezonecode   |
|:-------------------------------------|:-------------------------------------|----------------:|:-------------------------------------|:-------------------------------------|:------------------------|:--------------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:-------------------------------------|:------------------|:----------------------------|:---------------------------|:---------------------------------------------------------------------------------------------|-------------:|:----------------------|-----------------------:|:--------------------|:----------------------------|------------:|---------------------:|:-------------------------------------|:--------------------------------|:-------------------------------------|:---------------------|:------------------------|:-------------|:----------------------------|
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032424 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c27f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:06:59.000 |                     | There is a 100% funded Debt Service Reserve Fund in place                                                                                                                                  | e39930ab-c154-ea11-a813-000d3a4ed0f6 | 1.10.3            |                             |                            | Parent corporate guaranty supported on a rating below BBB                                    |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:52.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032398 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c87f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:06:59.000 |                     | Sector Outlook                                                                                                                                                                             | e59930ab-c154-ea11-a813-000d3a4ed0f6 | 1.11.2            |                             |                            | Level 2: Neutral                                                                             |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:52.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032435 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | ce7f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:06:59.000 |                     | Project Outlook                                                                                                                                                                            | e79930ab-c154-ea11-a813-000d3a4ed0f6 | 1.12.2            |                             |                            | Level 2: Neutral                                                                             |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:52.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032413 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | d47f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:06:59.000 |                     | Number of times that the ratio of 6-month rolling actual production to (seasonalized) 6-month rolling P99 probability of exceedance production has fallen below 1.0x in the past 12 months | e99930ab-c154-ea11-a813-000d3a4ed0f6 | 1.2.2             |                             |                            | Has not fallen more than 2 consecutive times in the last 12 months                           |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:52.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032412 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | d87f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:06:59.000 |                     | Historical Debt Service Coverage Ratio                                                                                                                                                     | eb9930ab-c154-ea11-a813-000d3a4ed0f6 | 1.3.2             |                             |                            | Between 1.0x and 1.2x                                                                        |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:52.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032467 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | e67f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:06:59.000 |                     | Level of support at the sponsor's corporate level                                                                                                                                          | ef9930ab-c154-ea11-a813-000d3a4ed0f6 | 1.5.3             |                             |                            | Level 3: Inexistent and non likely                                                           |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:53.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032576 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | f27f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:07:00.000 |                     | Experience of O&M Contractor                                                                                                                                                               | f39930ab-c154-ea11-a813-000d3a4ed0f6 | 1.7.4             |                             |                            | External ISP/OEM or Self Performing Operator with < 3+ YoE & < 500 MW wind or < 100 MW solar |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:53.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032584 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | f87f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:07:00.000 |                     | Term of O&M Agreement                                                                                                                                                                      | f59930ab-c154-ea11-a813-000d3a4ed0f6 | 1.8.3             |                             |                            | Without O&M Agreement or Self Operating                                                      |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:53.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032624 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | fe7f9979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:07:00.000 |                     | Additional enhancements in place                                                                                                                                                           | f79930ab-c154-ea11-a813-000d3a4ed0f6 | 1.9.3             |                             |                            | Parent corporate guaranty supported on a rating below BBB                                    |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:53.000 |              |                             |
| c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |        12032620 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | 06809979-cc54-ea11-a813-000d3a4edd29 | 2020-02-21 17:07:00.000 |                     | Borrower's Rol in Group                                                                                                                                                                    | f99930ab-c154-ea11-a813-000d3a4ed0f6 | 10.1.3            |                             |                            | Weak                                                                                         |            1 |                       |                    107 |                     |                             |           0 |                    0 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 | c7205e36-d6ee-42c5-8733-e670621cd834 |                      | 2020-02-21 17:06:53.000 |              |                             |


Table: nadb_creditriskstatuses
| _modifiedby_value                    | createdon               |   versionnumber | _modifiedonbehalfby_value   | utcconversiontimezonecode   | nadb_statuscode                                                                              | nadb_statuspoints   | nadb_indicatorname_status                                                                                                                                                                  | _createdonbehalfby_value   | nadb_name2   |   importsequencenumber | _owningbusinessunit_value            |   nadb_statuspoints2 | _nadb_riskindicator_value            |   statuscode | overriddencreatedon   | modifiedon              | _owningteam_value   | _createdby_value                     | _owninguser_value                    | timezoneruleversionnumber   | nadb_statusname   |   statecode | nadb_variablerange   | nadb_creditriskstatusid              | _ownerid_value                       | _nadb_statusmethodology_value   |
|:-------------------------------------|:------------------------|----------------:|:----------------------------|:----------------------------|:---------------------------------------------------------------------------------------------|:--------------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------------------------|:-------------|-----------------------:|:-------------------------------------|---------------------:|:-------------------------------------|-------------:|:----------------------|:------------------------|:--------------------|:-------------------------------------|:-------------------------------------|:----------------------------|:------------------|------------:|:---------------------|:-------------------------------------|:-------------------------------------|:--------------------------------|
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:52.000 |        12032424 |                             |                             | Parent corporate guaranty supported on a rating below BBB                                    |                     | There is a 100% funded Debt Service Reserve Fund in place                                                                                                                                  |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | e39930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:06:59.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.10.3            |           0 |                      | c27f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:52.000 |        12032398 |                             |                             | Level 2: Neutral                                                                             |                     | Sector Outlook                                                                                                                                                                             |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | e59930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:06:59.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.11.2            |           0 |                      | c87f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:52.000 |        12032435 |                             |                             | Level 2: Neutral                                                                             |                     | Project Outlook                                                                                                                                                                            |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | e79930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:06:59.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.12.2            |           0 |                      | ce7f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:52.000 |        12032413 |                             |                             | Has not fallen more than 2 consecutive times in the last 12 months                           |                     | Number of times that the ratio of 6-month rolling actual production to (seasonalized) 6-month rolling P99 probability of exceedance production has fallen below 1.0x in the past 12 months |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | e99930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:06:59.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.2.2             |           0 |                      | d47f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:52.000 |        12032412 |                             |                             | Between 1.0x and 1.2x                                                                        |                     | Historical Debt Service Coverage Ratio                                                                                                                                                     |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | eb9930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:06:59.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.3.2             |           0 |                      | d87f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:53.000 |        12032467 |                             |                             | Level 3: Inexistent and non likely                                                           |                     | Level of support at the sponsor's corporate level                                                                                                                                          |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | ef9930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:06:59.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.5.3             |           0 |                      | e67f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:53.000 |        12032576 |                             |                             | External ISP/OEM or Self Performing Operator with < 3+ YoE & < 500 MW wind or < 100 MW solar |                     | Experience of O&M Contractor                                                                                                                                                               |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | f39930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:07:00.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.7.4             |           0 |                      | f27f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:53.000 |        12032584 |                             |                             | Without O&M Agreement or Self Operating                                                      |                     | Term of O&M Agreement                                                                                                                                                                      |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | f59930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:07:00.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.8.3             |           0 |                      | f87f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:53.000 |        12032624 |                             |                             | Parent corporate guaranty supported on a rating below BBB                                    |                     | Additional enhancements in place                                                                                                                                                           |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | f79930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:07:00.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 1.9.3             |           0 |                      | fe7f9979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |
| c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 17:06:53.000 |        12032620 |                             |                             | Weak                                                                                         |                     | Borrower's Rol in Group                                                                                                                                                                    |                            |              |                    107 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    0 | f99930ab-c154-ea11-a813-000d3a4ed0f6 |            1 |                       | 2020-02-21 17:07:00.000 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             | 10.1.3            |           0 |                      | 06809979-cc54-ea11-a813-000d3a4edd29 | c7205e36-d6ee-42c5-8733-e670621cd834 |                                 |


Table: nadb_internalcreditratingscales
|   nadb_pointsrequiredfrom |   importsequencenumber | _createdonbehalfby_value   |   utcconversiontimezonecode | nadb_activedate         |   nadb_level |   statuscode | _organizationid_value                | nadb_name                                |   nadb_pointsrequiredto | nadb_scale   | _createdby_value                     | nadb_internalcreditratingscaleid     |   nadb_borrowerrating | overriddencreatedon   |   nadb_riskgrade | _modifiedonbehalfby_value   |   timezoneruleversionnumber |   versionnumber | createdon               | _modifiedby_value                    | modifiedon              |   statecode |   Year | _nadb_internalcreditriskrating_value   | Risk grade.RiskgradeDescr   | Level.LevelDescr   |
|--------------------------:|-----------------------:|:---------------------------|----------------------------:|:------------------------|-------------:|-------------:|:-------------------------------------|:-----------------------------------------|------------------------:|:-------------|:-------------------------------------|:-------------------------------------|----------------------:|:----------------------|-----------------:|:----------------------------|----------------------------:|----------------:|:------------------------|:-------------------------------------|:------------------------|------------:|-------:|:---------------------------------------|:----------------------------|:-------------------|
|                      0    |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830000 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                    0.05 | A            | c7205e36-d6ee-42c5-8733-e670621cd834 | 181ff2d6-d754-ea11-a813-000d3a4ed7ce |                     1 |                       |        180830000 |                             |                           0 |        13471900 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | A-1                         | Pass               |
|                      0    |                    142 |                            |                          10 | 2017-01-03 00:00:00.000 |    180830000 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 01/01/2017 |                    0.05 | A            | c7205e36-d6ee-42c5-8733-e670621cd834 | 2c6ce934-5565-ea11-a811-000d3a4edd29 |                     1 |                       |        180830000 |                             |                           0 |        13471266 | 2020-03-13 18:05:44.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:05:44.000 |           0 |   2017 | f917e21c-1859-ea11-a811-000d3a4f6c19   | A-1                         | Pass               |
|                      0.05 |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830000 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                    0.5  | A            | c7205e36-d6ee-42c5-8733-e670621cd834 | 1a1ff2d6-d754-ea11-a813-000d3a4ed7ce |                     2 |                       |        180830001 |                             |                           0 |        13471901 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | A-2                         | Pass               |
|                      0.5  |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830000 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                    3    | A            | c7205e36-d6ee-42c5-8733-e670621cd834 | 1c1ff2d6-d754-ea11-a813-000d3a4ed7ce |                     3 |                       |        180830002 |                             |                           0 |        13471902 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | A-3                         | Pass               |
|                      3    |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830001 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                    5    | B            | c7205e36-d6ee-42c5-8733-e670621cd834 | 1e1ff2d6-d754-ea11-a813-000d3a4ed7ce |                     4 |                       |        180830003 |                             |                           0 |        13471903 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | B-1                         | OAEM               |
|                      5    |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830001 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                   10    | B            | c7205e36-d6ee-42c5-8733-e670621cd834 | 201ff2d6-d754-ea11-a813-000d3a4ed7ce |                     5 |                       |        180830004 |                             |                           0 |        13471904 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | B-2                         | OAEM               |
|                     10    |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830001 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                   20    | B            | c7205e36-d6ee-42c5-8733-e670621cd834 | 221ff2d6-d754-ea11-a813-000d3a4ed7ce |                     6 |                       |        180830005 |                             |                           0 |        13471905 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | B-3                         | OAEM               |
|                     20    |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830002 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                   30    | C            | c7205e36-d6ee-42c5-8733-e670621cd834 | 241ff2d6-d754-ea11-a813-000d3a4ed7ce |                     5 |                       |        180830006 |                             |                           0 |        13471906 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | C                           | Substandard        |
|                     30    |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830003 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                   50    | D            | c7205e36-d6ee-42c5-8733-e670621cd834 | 261ff2d6-d754-ea11-a813-000d3a4ed7ce |                     6 |                       |        180830007 |                             |                           0 |        13471907 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | D                           | Doubtful           |
|                     50    |                    109 |                            |                          10 | 2019-01-03 00:00:00.000 |    180830004 |            1 | 485254b6-aef7-41ed-995e-fa22317007e7 | Internal Credit risk rating - 4/01/2019  |                  100    | E            | c7205e36-d6ee-42c5-8733-e670621cd834 | 281ff2d6-d754-ea11-a813-000d3a4ed7ce |                     7 |                       |        180830008 |                             |                           0 |        13471908 | 2020-02-21 18:27:59.000 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 18:25:51.000 |           0 |   2019 | 739a0343-d754-ea11-a812-000d3a4f6c19   | E                           | Loss               |


Table: nadb_internalcreditriskratings (2)
|   statuscode | modifiedon              | timezoneruleversionnumber   |   versionnumber |   nadb_name | _modifiedonbehalfby_value   | _createdby_value                     | _organizationid_value                | _createdonbehalfby_value   | _modifiedby_value                    | importsequencenumber   | utcconversiontimezonecode   | createdon               |   statecode | nadb_internalcreditriskratingid      | overriddencreatedon   |
|-------------:|:------------------------|:----------------------------|----------------:|------------:|:----------------------------|:-------------------------------------|:-------------------------------------|:---------------------------|:-------------------------------------|:-----------------------|:----------------------------|:------------------------|------------:|:-------------------------------------|:----------------------|
|            1 | 2020-02-27 04:17:55.000 |                             |        12470754 |        2017 |                             | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                            | c7205e36-d6ee-42c5-8733-e670621cd834 |                        |                             | 2020-02-27 04:17:55.000 |           0 | f917e21c-1859-ea11-a811-000d3a4f6c19 |                       |
|            1 | 2020-02-21 18:23:33.000 |                             |        12037922 |        2019 |                             | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                            | c7205e36-d6ee-42c5-8733-e670621cd834 |                        |                             | 2020-02-21 18:23:33.000 |           0 | 739a0343-d754-ea11-a812-000d3a4f6c19 |                       |
|            1 | 2020-02-26 23:25:33.000 |                             |        12461677 |        2018 |                             | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                            | c7205e36-d6ee-42c5-8733-e670621cd834 |                        |                             | 2020-02-26 23:25:33.000 |           0 | 91826b44-ef58-ea11-a811-000d3a4f6db7 |                       |


Table: nadb_internalcreditriskratings
| _organizationid_value                | _createdby_value                     | _createdonbehalfby_value   | timezoneruleversionnumber   | overriddencreatedon   |   nadb_name | utcconversiontimezonecode   |   statecode | _modifiedby_value                    | createdon               | _modifiedonbehalfby_value   | modifiedon              | nadb_internalcreditriskratingid      |   statuscode | importsequencenumber   |   versionnumber |
|:-------------------------------------|:-------------------------------------|:---------------------------|:----------------------------|:----------------------|------------:|:----------------------------|------------:|:-------------------------------------|:------------------------|:----------------------------|:------------------------|:-------------------------------------|-------------:|:-----------------------|----------------:|
| 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                             |                       |        2017 |                             |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:17:55.000 |                             | 2020-02-27 04:17:55.000 | f917e21c-1859-ea11-a811-000d3a4f6c19 |            1 |                        |        12470754 |
| 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                             |                       |        2019 |                             |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 18:23:33.000 |                             | 2020-02-21 18:23:33.000 | 739a0343-d754-ea11-a812-000d3a4f6c19 |            1 |                        |        12037922 |
| 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                             |                       |        2018 |                             |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-26 23:25:33.000 |                             | 2020-02-26 23:25:33.000 | 91826b44-ef58-ea11-a811-000d3a4f6db7 |            1 |                        |        12461677 |


Table: nadb_Loan Administration
| overriddencreatedon   |   nadb_projectid_proj | traversedpath   | nadb_warranty_plad   | nadb_repaymentsource_plad   | timezoneruleversionnumber   | _owningbusinessunit_value            | nadb_sponsoracceptancedate_pj   | nadb_name                | nadb_dscrdefault   | nadb_projectdescriptionenglish   | nadb_oneyearoperationalert_pj   | utcconversiontimezonecode   | nadb_dscrcashtrap   | nadb_opportunitydescription_pj   | nadb_nabdabkprojectid                | modifiedon              |   statecode | nadb_creditratingofftaker_plad   | processid   | nadb_requirement_plad   | createdon               | _createdby_value                     | _modifiedby_value                    | _nadb_projectcategory_pj_value   |   importsequencenumber | nadb_projectdescriptionspanish_pj   | _nadb_ownerbackup_ladmin_value       | _createdonbehalfby_value   | nadb_dateandinforeviewed   | _ownerid_value                       | _nadb_originppportunity_proj_value   | _stageid_value   | _owninguser_value                    | nadb_offtaker_plad   | nadb_closeoutreportcomplete_pj   | _nadb_projecttype_pj_value           | nadb_closeoutreportsubmitted_pj   | nadb_projectprogram   | nadb_loantype_plad   | _owningteam_value   | nadb_projectregion_pj   | nadb_observed_plad   |   statuscode | _modifiedonbehalfby_value   |   versionnumber | nadb_workgroup_pj   | _nadb_currentsponsor_loa_value   |
|:----------------------|----------------------:|:----------------|:---------------------|:----------------------------|:----------------------------|:-------------------------------------|:--------------------------------|:-------------------------|:-------------------|:---------------------------------|:--------------------------------|:----------------------------|:--------------------|:---------------------------------|:-------------------------------------|:------------------------|------------:|:---------------------------------|:------------|:------------------------|:------------------------|:-------------------------------------|:-------------------------------------|:---------------------------------|-----------------------:|:------------------------------------|:-------------------------------------|:---------------------------|:---------------------------|:-------------------------------------|:-------------------------------------|:-----------------|:-------------------------------------|:---------------------|:---------------------------------|:-------------------------------------|:----------------------------------|:----------------------|:---------------------|:--------------------|:------------------------|:---------------------|-------------:|:----------------------------|----------------:|:--------------------|:---------------------------------|
|                       |               8000618 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Nogales Los Alisos       |                    |                                  |                                 |                             |                     |                                  | 29a616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:15.000 |           0 |                                  |             |                         | 2019-09-11 04:08:15.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | 8e6797a1-95d0-e911-a978-000d3a4e8ef8 |                            |                            | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 | fba7ed5a-11d4-e911-a976-000d3a4e890b |                  | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 863e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         1999056 |                     |                                  |
|                       |                   866 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | El Mezquite Wind         |                    |                                  |                                 |                             |                     |                                  | 2ba616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | 846797a1-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 0a51ffa8-95d0-e911-a978-000d3a4e8ef8 | fea7ed5a-11d4-e911-a976-000d3a4e890b |                  | 0a51ffa8-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 7a3e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         1999058 |                     |                                  |
|                       |               8000924 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Nuevo Laredo Basic Infr. |                    |                                  |                                 |                             |                     |                                  | 2fa616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | 846797a1-95d0-e911-a978-000d3a4e8ef8 |                            |                            | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 | 28a8ed5a-11d4-e911-a976-000d3a4e890b |                  | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 6e3e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         1999060 |                     |                                  |
|                       |               8000626 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Hermosillo BUI           |                    |                                  |                                 |                             |                     |                                  | 31a616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 | 2aa8ed5a-11d4-e911-a976-000d3a4e890b |                  | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 6e3e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         1999061 |                     |                                  |
|                       |               8000441 |                 |                      |                             |                             | 45adc747-bcd0-e911-a964-000d3a4f1a4f |                                 | Playas de Rosarito BUI   |                    |                                  |                                 |                             |                     |                                  | 33a616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 8e6797a1-95d0-e911-a978-000d3a4e8ef8 | 2ca8ed5a-11d4-e911-a976-000d3a4e890b |                  | 8e6797a1-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 6e3e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |        13762287 |                     |                                  |
|                       |               8000657 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Hermosillo AQ            |                    |                                  |                                 |                             |                     |                                  | 35a616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 | 62a8ed5a-11d4-e911-a976-000d3a4e890b |                  | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 6c3e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         1999063 |                     |                                  |
|                       |               8000543 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Juarez Paving            |                    |                                  |                                 |                             |                     |                                  | 37a616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 0a51ffa8-95d0-e911-a978-000d3a4e8ef8 | 64a8ed5a-11d4-e911-a976-000d3a4e890b |                  | 0a51ffa8-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 6c3e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         1999065 |                     |                                  |
|                       |               8000701 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Ciudad Acuña-A           |                    |                                  |                                 |                             |                     |                                  | 39a616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | 846797a1-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 7a6797a1-95d0-e911-a978-000d3a4e8ef8 | 6aa8ed5a-11d4-e911-a976-000d3a4e890b |                  | 7a6797a1-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 863e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         5935392 |                     |                                  |
|                       |               8000703 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Piedras Negras           |                    |                                  |                                 |                             |                     |                                  | 3ba616c1-49d4-e911-a983-000d3a4e83d0 | 2019-09-11 04:08:16.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 8994a541-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | 846797a1-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 7a6797a1-95d0-e911-a978-000d3a4e8ef8 | 6ca8ed5a-11d4-e911-a976-000d3a4e890b |                  | 7a6797a1-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 863e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       |                      |                     |                         |                      |            1 |                             |         5923482 |                     |                                  |
|                       |               8000517 |                 |                      |                             |                             | d915bb53-bcd0-e911-a964-000d3a4f1a4f |                                 | Juarez Sur-Sur           |                    |                                  |                                 |                             |                     |                                  | 3fa616c1-49d4-e911-a983-000d3a4e83d0 | 2019-12-04 20:13:33.000 |           0 |                                  |             |                         | 2019-09-11 04:08:16.000 | 8994a541-95d0-e911-a978-000d3a4e8ef8 | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 |                                  |                     27 |                                     | f17bf7ae-95d0-e911-a978-000d3a4e8ef8 |                            |                            | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 | 88a8ed5a-11d4-e911-a976-000d3a4e890b |                  | 197cf7ae-95d0-e911-a978-000d3a4e8ef8 |                      | False                            | 863e27bf-aad2-e911-a97c-000d3a4e8ef8 | False                             |                       | 180830001            |                     |                         |                      |            1 |                             |         7427232 |                     |                                  |


Table: nadb_projectriskratings
| nadb_statusdescription_projrr                                      |   statuscode | overriddencreatedon   |   timezoneruleversionnumber |   versionnumber | _owningteam_value   | _owninguser_value                    | _nadb_riskindicator_rating_value     | _nadb_project_rating_value   | nadb_projectriskratingid             | _createdby_value                     | modifiedon              | _owningbusinessunit_value            | _modifiedby_value                    | nadb_indicatordescription_projrr   | createdon               |   nadb_statuspoints_porjrr | nadb_value_pjrisk   |   importsequencenumber | nadb_name                                                                        | _ownerid_value                       | _createdonbehalfby_value   | nadb_methodologydescription_projrr   | utcconversiontimezonecode   | nadb_measuredate_pjrisk   | _nadb_riskratingproject_projrr_value   |   statecode | _modifiedonbehalfby_value   | _nadb_riskstatus_rating_value        | _nadb_nadbinternalscaleused_value   | _nadb_internalcreditriskrating_value   | _nadb_methodologyused_value          | _nadb_creditriskratingadministration_value   |
|:-------------------------------------------------------------------|-------------:|:----------------------|----------------------------:|----------------:|:--------------------|:-------------------------------------|:-------------------------------------|:-----------------------------|:-------------------------------------|:-------------------------------------|:------------------------|:-------------------------------------|:-------------------------------------|:-----------------------------------|:------------------------|---------------------------:|:--------------------|-----------------------:|:---------------------------------------------------------------------------------|:-------------------------------------|:---------------------------|:-------------------------------------|:----------------------------|:--------------------------|:---------------------------------------|------------:|:----------------------------|:-------------------------------------|:------------------------------------|:---------------------------------------|:-------------------------------------|:---------------------------------------------|
| Between 0.85x and 1.15x                                            |            1 |                       |                           0 |        12471065 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | e19930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 6a6184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:22:38.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:37.000 |                         10 |                     |                    123 | Between 0.85x and 1.15x-1/1/2019-2019                                            | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2019-01-01 00:00:00.000   |                                        |           0 |                             | ba7f9979-cc54-ea11-a813-000d3a4edd29 |                                     | 739a0343-d754-ea11-a812-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| Between 0.85x and 1.15x                                            |            1 |                       |                           0 |        13477777 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | e19930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 6c6184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 21:55:43.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                         10 |                     |                    123 | Between 0.85x and 1.15x-1/1/2019-2018                                            | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2018-01-01 00:00:00.000   |                                        |           0 |                             | ba7f9979-cc54-ea11-a813-000d3a4edd29 |                                     | f917e21c-1859-ea11-a811-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| Between 0.85x and 1.15x                                            |            1 |                       |                           0 |        12471871 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | e19930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 6e6184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:45:13.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                         10 |                     |                    123 | Between 0.85x and 1.15x-1/1/2019-2017                                            | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2017-01-01 00:00:00.000   |                                        |           0 |                             | ba7f9979-cc54-ea11-a813-000d3a4edd29 |                                     | f917e21c-1859-ea11-a811-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| Has not fallen more than 2 consecutive times in the last 12 months |            1 |                       |                           0 |        12471071 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | e99930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 706184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:22:38.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                          0 |                     |                    123 | Has not fallen more than 2 consecutive times in the last 12 months-1/1/2019-2019 | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2019-01-01 00:00:00.000   |                                        |           0 |                             | d47f9979-cc54-ea11-a813-000d3a4edd29 |                                     | 739a0343-d754-ea11-a812-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| Has not fallen more than 2 consecutive times in the last 12 months |            1 |                       |                           0 |        13477785 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | e99930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 726184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 21:55:44.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                          0 |                     |                    123 | Has not fallen more than 2 consecutive times in the last 12 months-1/1/2019-2018 | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2018-01-01 00:00:00.000   |                                        |           0 |                             | d47f9979-cc54-ea11-a813-000d3a4edd29 |                                     | f917e21c-1859-ea11-a811-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| Has not fallen more than 2 consecutive times in the last 12 months |            1 |                       |                           0 |        12471883 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | e99930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 746184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:45:14.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                          0 |                     |                    123 | Has not fallen more than 2 consecutive times in the last 12 months-1/1/2019-2017 | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2017-01-01 00:00:00.000   |                                        |           0 |                             | d47f9979-cc54-ea11-a813-000d3a4edd29 |                                     | f917e21c-1859-ea11-a811-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| At 1.2x or higher                                                  |            1 |                       |                           0 |        12471077 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | eb9930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 766184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:22:38.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                         10 |                     |                    123 | At 1.2x or higher-1/1/2019-2019                                                  | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2019-01-01 00:00:00.000   |                                        |           0 |                             | d67f9979-cc54-ea11-a813-000d3a4edd29 |                                     | 739a0343-d754-ea11-a812-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| At 1.2x or higher                                                  |            1 |                       |                           0 |        13477787 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | eb9930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 786184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-03-13 21:55:44.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                         10 |                     |                    123 | At 1.2x or higher-1/1/2019-2018                                                  | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2018-01-01 00:00:00.000   |                                        |           0 |                             | d67f9979-cc54-ea11-a813-000d3a4edd29 |                                     | f917e21c-1859-ea11-a811-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| At 1.2x or higher                                                  |            1 |                       |                           0 |        12471886 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | eb9930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 7a6184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:45:14.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                         10 |                     |                    123 | At 1.2x or higher-1/1/2019-2017                                                  | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2017-01-01 00:00:00.000   |                                        |           0 |                             | d67f9979-cc54-ea11-a813-000d3a4edd29 |                                     | f917e21c-1859-ea11-a811-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |
| History shows no more than 30 days past due                        |            1 |                       |                           0 |        12471083 |                     | c7205e36-d6ee-42c5-8733-e670621cd834 | ed9930ab-c154-ea11-a813-000d3a4ed0f6 |                              | 7c6184c2-1859-ea11-a811-000d3a4ed0f6 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-27 04:22:38.000 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 |                                    | 2020-02-27 04:22:38.000 |                         10 |                     |                    123 | History shows no more than 30 days past due-1/1/2019-2019                        | c7205e36-d6ee-42c5-8733-e670621cd834 |                            |                                      |                             | 2019-01-01 00:00:00.000   |                                        |           0 |                             | dc7f9979-cc54-ea11-a813-000d3a4edd29 |                                     | 739a0343-d754-ea11-a812-000d3a4f6c19   | 06c0009c-c154-ea11-a813-000d3a4e6589 | 06b27cba-1459-ea11-a811-000d3a4f6c19         |


Table: nadb_riskratingindicators (2)
| _nadb_projecttype_risk_value   | modifiedon              | nadb_factortype   | nadb_customertype_risk   |   statecode | _owningbusinessunit_value            |   importsequencenumber | createdon               | nadb_riskratingindicatorid           | timezoneruleversionnumber   |   versionnumber | nadb_numberid                                             |   statuscode | _nadb_indicatormethodology_value     | nadb_domain   | _ownerid_value                       | _createdby_value                     | _modifiedby_value                    | _owninguser_value                    | utcconversiontimezonecode   | _owningteam_value   | overriddencreatedon   | _createdonbehalfby_value   |   nadb_indicatorname | _modifiedonbehalfby_value   |
|:-------------------------------|:------------------------|:------------------|:-------------------------|------------:|:-------------------------------------|-----------------------:|:------------------------|:-------------------------------------|:----------------------------|----------------:|:----------------------------------------------------------|-------------:|:-------------------------------------|:--------------|:-------------------------------------|:-------------------------------------|:-------------------------------------|:-------------------------------------|:----------------------------|:--------------------|:----------------------|:---------------------------|---------------------:|:----------------------------|
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | bb9930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005493 | Project complexity and sacle                              |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.1  |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | bd9930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005494 | Exposure to elements of demand or price risk              |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.1  |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | bf9930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005495 | Grantor's rating (payment obligation)                     |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.11 |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | c19930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005496 | Amortization                                              |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.12 |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | c39930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005497 | Reserving provisions                                      |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.13 |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | c59930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005498 | Interest rate risk                                        |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.14 |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | c79930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005499 | Guaranty Type                                             |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.15 |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | c99930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005500 | Debt Service Reserve Fund                                 |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.16 |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | cb9930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005501 | DSCR                                                      |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.17 |                             |
|                                | 2020-02-21 15:49:19.000 |                   |                          |           0 | b5152e2f-ebcb-e911-a9aa-000d3a14431b |                    103 | 2020-02-21 15:49:19.000 | cd9930ab-c154-ea11-a813-000d3a4ed0f6 |                             |        12005502 | Full Compliance with Contractual Conditions and Covenants |            1 | 04c0009c-c154-ea11-a813-000d3a4e6589 |               | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |                     |                       |                            |                 6.18 |                             |


Table: nadb_riskratingindicators
| nadb_customertype_risk   | _ownerid_value                       | nadb_riskratingindicatorid           | _nadb_indicatormethodology_value     | _owningbusinessunit_value            | _modifiedby_value                    | modifiedon              | _createdby_value                     | timezoneruleversionnumber   |   versionnumber | _nadb_projecttype_risk_value   | nadb_domain   | _createdonbehalfby_value   | _owninguser_value                    | nadb_numberid                                             | _owningteam_value   |   statuscode | utcconversiontimezonecode   |   importsequencenumber | _modifiedonbehalfby_value   |   statecode |   nadb_indicatorname | nadb_factortype   | createdon               | overriddencreatedon   |
|:-------------------------|:-------------------------------------|:-------------------------------------|:-------------------------------------|:-------------------------------------|:-------------------------------------|:------------------------|:-------------------------------------|:----------------------------|----------------:|:-------------------------------|:--------------|:---------------------------|:-------------------------------------|:----------------------------------------------------------|:--------------------|-------------:|:----------------------------|-----------------------:|:----------------------------|------------:|---------------------:|:------------------|:------------------------|:----------------------|
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | bb9930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005493 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Project complexity and sacle                              |                     |            1 |                             |                    103 |                             |           0 |                 6.1  |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | bd9930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005494 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Exposure to elements of demand or price risk              |                     |            1 |                             |                    103 |                             |           0 |                 6.1  |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | bf9930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005495 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Grantor's rating (payment obligation)                     |                     |            1 |                             |                    103 |                             |           0 |                 6.11 |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | c19930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005496 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Amortization                                              |                     |            1 |                             |                    103 |                             |           0 |                 6.12 |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | c39930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005497 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Reserving provisions                                      |                     |            1 |                             |                    103 |                             |           0 |                 6.13 |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | c59930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005498 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Interest rate risk                                        |                     |            1 |                             |                    103 |                             |           0 |                 6.14 |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | c79930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005499 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Guaranty Type                                             |                     |            1 |                             |                    103 |                             |           0 |                 6.15 |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | c99930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005500 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Debt Service Reserve Fund                                 |                     |            1 |                             |                    103 |                             |           0 |                 6.16 |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | cb9930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005501 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | DSCR                                                      |                     |            1 |                             |                    103 |                             |           0 |                 6.17 |                   | 2020-02-21 15:49:19.000 |                       |
|                          | c7205e36-d6ee-42c5-8733-e670621cd834 | cd9930ab-c154-ea11-a813-000d3a4ed0f6 | 04c0009c-c154-ea11-a813-000d3a4e6589 | b5152e2f-ebcb-e911-a9aa-000d3a14431b | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:49:19.000 | c7205e36-d6ee-42c5-8733-e670621cd834 |                             |        12005502 |                                |               |                            | c7205e36-d6ee-42c5-8733-e670621cd834 | Full Compliance with Contractual Conditions and Covenants |                     |            1 |                             |                    103 |                             |           0 |                 6.18 |                   | 2020-02-21 15:49:19.000 |                       |


Table: nadb_riskratingmethodologies (2)
| _createdonbehalfby_value   |   statuscode | modifiedon              | nadb_riskratingmethodologyid         |   importsequencenumber |   versionnumber | _modifiedby_value                    | _createdby_value                     | _organizationid_value                | timezoneruleversionnumber   | utcconversiontimezonecode   | overriddencreatedon   |   nadb_methodologycode | nadb_name                                   | createdon               | _modifiedonbehalfby_value   |   statecode |
|:---------------------------|-------------:|:------------------------|:-------------------------------------|-----------------------:|----------------:|:-------------------------------------|:-------------------------------------|:-------------------------------------|:----------------------------|:----------------------------|:----------------------|-----------------------:|:--------------------------------------------|:------------------------|:----------------------------|------------:|
|                            |            1 | 2020-02-21 15:48:44.000 | 04c0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004902 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      6 | Availability based infraestructure Projects | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:44.000 | 06c0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004903 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      1 | Clean Energy (Solar and  Wind)              | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:44.000 | 08c0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004904 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                     10 | Corporate Loans                             | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:44.000 | 0ac0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004905 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      2 | Mexican Municipalities                      | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:44.000 | 0cc0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004906 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      3 | Mexican Water Utilities                     | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:44.000 | 0ec0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004907 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      8 | PPP's in Operation                          | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:44.000 | 10c0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004908 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      7 | Projects under Construction                 | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:44.000 | 12c0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004909 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      9 | Projects with Specific Source of Payment    | 2020-02-21 15:48:44.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:45.000 | 14c0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004910 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      5 | Revolving Lines of Credit                   | 2020-02-21 15:48:45.000 |                             |           0 |
|                            |            1 | 2020-02-21 15:48:45.000 | 16c0009c-c154-ea11-a813-000d3a4e6589 |                    102 |        12004911 | c7205e36-d6ee-42c5-8733-e670621cd834 | c7205e36-d6ee-42c5-8733-e670621cd834 | 485254b6-aef7-41ed-995e-fa22317007e7 |                             |                             |                       |                      4 | US Revenue Bonds                            | 2020-02-21 15:48:45.000 |                             |           0 |


Table: nadb_riskratingmethodologies
| utcconversiontimezonecode   | nadb_name                                   |   statecode | _modifiedby_value                    | createdon               | _organizationid_value                | _createdby_value                     | modifiedon              | nadb_riskratingmethodologyid         | timezoneruleversionnumber   |   versionnumber |   importsequencenumber | _createdonbehalfby_value   |   statuscode | _modifiedonbehalfby_value   |   nadb_methodologycode | overriddencreatedon   |
|:----------------------------|:--------------------------------------------|------------:|:-------------------------------------|:------------------------|:-------------------------------------|:-------------------------------------|:------------------------|:-------------------------------------|:----------------------------|----------------:|-----------------------:|:---------------------------|-------------:|:----------------------------|-----------------------:|:----------------------|
|                             | Availability based infraestructure Projects |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 04c0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004902 |                    102 |                            |            1 |                             |                      6 |                       |
|                             | Clean Energy (Solar and  Wind)              |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 06c0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004903 |                    102 |                            |            1 |                             |                      1 |                       |
|                             | Corporate Loans                             |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 08c0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004904 |                    102 |                            |            1 |                             |                     10 |                       |
|                             | Mexican Municipalities                      |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 0ac0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004905 |                    102 |                            |            1 |                             |                      2 |                       |
|                             | Mexican Water Utilities                     |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 0cc0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004906 |                    102 |                            |            1 |                             |                      3 |                       |
|                             | PPP's in Operation                          |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 0ec0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004907 |                    102 |                            |            1 |                             |                      8 |                       |
|                             | Projects under Construction                 |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 10c0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004908 |                    102 |                            |            1 |                             |                      7 |                       |
|                             | Projects with Specific Source of Payment    |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:44.000 | 12c0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004909 |                    102 |                            |            1 |                             |                      9 |                       |
|                             | Revolving Lines of Credit                   |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:45.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:45.000 | 14c0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004910 |                    102 |                            |            1 |                             |                      5 |                       |
|                             | US Revenue Bonds                            |           0 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:45.000 | 485254b6-aef7-41ed-995e-fa22317007e7 | c7205e36-d6ee-42c5-8733-e670621cd834 | 2020-02-21 15:48:45.000 | 16c0009c-c154-ea11-a813-000d3a4e6589 |                             |        12004911 |                    102 |                            |            1 |                             |                      4 |                       |


Table: New table
|   EX-Prob |   EX-Score | Date   | ProjectID   |
|----------:|-----------:|:-------|:------------|
|  0.999827 |          0 |        |             |
|  0.999795 |          1 |        |             |
|  0.999756 |          2 |        |             |
|  0.99971  |          3 |        |             |
|  0.999655 |          4 |        |             |
|  0.99959  |          5 |        |             |
|  0.999512 |          6 |        |             |
|  0.99942  |          7 |        |             |
|  0.99931  |          8 |        |             |
|  0.999179 |          9 |        |             |


Table: Opps
| opportunityid                        |   nadb_projectid_opp |
|:-------------------------------------|---------------------:|
| c2a8ed5a-11d4-e911-a976-000d3a4e890b |              8000435 |
| fca9ed5a-11d4-e911-a976-000d3a4e890b |              8000938 |


Table: PIat100
|   EX-Probabilitylist |   EX-CreditScorelist | EXMeth                        |   EX-CreditScorelist - Copy |
|---------------------:|---------------------:|:------------------------------|----------------------------:|
|             0.999827 |                    0 | Clean Energy (Solar and Wind) |                           0 |
|             0.999795 |                    1 | Clean Energy (Solar and Wind) |                           1 |
|             0.999756 |                    2 | Clean Energy (Solar and Wind) |                           2 |
|             0.99971  |                    3 | Clean Energy (Solar and Wind) |                           3 |
|             0.999655 |                    4 | Clean Energy (Solar and Wind) |                           4 |
|             0.99959  |                    5 | Clean Energy (Solar and Wind) |                           5 |
|             0.999512 |                    6 | Clean Energy (Solar and Wind) |                           6 |
|             0.99942  |                    7 | Clean Energy (Solar and Wind) |                           7 |
|             0.99931  |                    8 | Clean Energy (Solar and Wind) |                           8 |
|             0.999179 |                    9 | Clean Energy (Solar and Wind) |                           9 |


Table: PIat100_Project



Table: Risk grade
|   RiskgradeID | RiskgradeDescr   |
|--------------:|:-----------------|
|     180830000 | A-1              |
|     180830001 | A-2              |
|     180830002 | A-3              |
|     180830003 | B-1              |
|     180830004 | B-2              |
|     180830005 | B-3              |
|     180830006 | C                |
|     180830007 | D                |
|     180830008 | E                |

 


tables: name: BTI_MethMaxPoints
data: BTI_MethMaxPoints.csv
name: BTI_ProbabilityofDefault
data: BTI_ProbabilityofDefault.csv
name: BTI_ScaleGrade
data: BTI_ScaleGrade.csv
name: Chart
data: Chart.csv
name: innetable
data: innetable.csv
name: Level
data: Level.csv
name: nadb_creditriskadministrations
data: nadb_creditriskadministrations.csv
name: nadb_creditriskstatuses (2)
data: nadb_creditriskstatuses (2).csv
name: nadb_creditriskstatuses
data: nadb_creditriskstatuses.csv
name: nadb_internalcreditratingscales
data: nadb_internalcreditratingscales.csv
name: nadb_internalcreditriskratings (2)
data: nadb_internalcreditriskratings (2).csv
name: nadb_internalcreditriskratings
data: nadb_internalcreditriskratings.csv
name: nadb_Loan Administration
data: nadb_Loan Administration.csv
name: nadb_projectriskratings
data: nadb_projectriskratings.csv
name: nadb_riskratingindicators (2)
data: nadb_riskratingindicators (2).csv
name: nadb_riskratingindicators
data: nadb_riskratingindicators.csv
name: nadb_riskratingmethodologies (2)
data: nadb_riskratingmethodologies (2).csv
name: nadb_riskratingmethodologies
data: nadb_riskratingmethodologies.csv
name: New table
data: New table.csv
name: Opps
data: Opps.csv
name: PIat100
data: PIat100.csv
name: PIat100_Project
data: PIat100_Project.csv
name: Risk grade
data: Risk grade.csv
label: nadb_riskratingindicators
_nadb_indicatormethodology_value
nadb_riskratingmethodologies
nadb_riskratingmethodologyid
nadb_creditriskstatuses
_nadb_riskindicator_value
nadb_riskratingindicators
nadb_riskratingindicatorid
nadb_projectriskratings
_nadb_methodologyused_value
nadb_riskratingmethodologies
nadb_riskratingmethodologyid
nadb_projectriskratings
_nadb_creditriskratingadministration_value
nadb_creditriskadministrations
nadb_creditriskadministrationid
nadb_internalcreditratingscales
_nadb_internalcreditriskrating_value
nadb_internalcreditriskratings
nadb_internalcreditriskratingid
nadb_creditriskadministrations
_nadb_relatedloanadministration_crisk_value
nadb_Loan Administration
nadb_nabdabkprojectid
nadb_creditriskstatuses (2)
_nadb_riskindicator_value
nadb_riskratingindicators (2)
nadb_riskratingindicatorid
nadb_riskratingindicators (2)
_nadb_indicatormethodology_value
nadb_riskratingmethodologies (2)
nadb_riskratingmethodologyid
nadb_projectriskratings
_nadb_riskstatus_rating_value
nadb_creditriskstatuses (2)
nadb_creditriskstatusid
nadb_projectriskratings
_nadb_internalcreditriskrating_value
nadb_internalcreditriskratings (2)
nadb_internalcreditriskratingid
nadb_Loan Administration
_nadb_originppportunity_proj_value
Opps
opportunityid
output: {
    "joins": [
        {
            "from_table": "nadb_riskratingindicators",
            "from_column": "_nadb_indicatormethodology_value",
            "to_table": "nadb_riskratingmethodologies",
            "to_column": "nadb_riskratingmethodologyid"
        },
        {
            "from_table": "nadb_creditriskstatuses",
            "from_column": "_nadb_riskindicator_value",
            "to_table": "nadb_riskratingindicators",
            "to_column": "nadb_riskratingindicatorid"
        },
        {
            "from_table": "nadb_projectriskratings",
            "from_column": "_nadb_methodologyused_value",
            "to_table": "nadb_riskratingmethodologies",
            "to_column": "nadb_riskratingmethodologyid"
        },
        {
            "from_table": "nadb_projectriskratings",
            "from_column": "_nadb_creditriskratingadministration_value",
            "to_table": "nadb_creditriskadministrations",
            "to_column": "nadb_creditriskadministrationid"
        },
        {
            "from_table": "nadb_internalcreditratingscales",
            "from_column": "_nadb_internalcreditriskrating_value",
            "to_table": "nadb_internalcreditriskratings",
            "to_column": "nadb_internalcreditriskratingid"
        },
        {
            "from_table": "nadb_creditriskadministrations",
            "from_column": "_nadb_relatedloanadministration_crisk_value",
            "to_table": "nadb_Loan Administration",
            "to_column": "nadb_nabdabkprojectid"
        },
        {
            "from_table": "nadb_creditriskstatuses (2)",
            "from_column": "_nadb_riskindicator_value",
            "to_table": "nadb_riskratingindicators (2)",
            "to_column": "nadb_riskratingindicatorid"
        },
        {
            "from_table": "nadb_riskratingindicators (2)",
            "from_column": "_nadb_indicatormethodology_value",
            "to_table": "nadb_riskratingmethodologies (2)",
            "to_column": "nadb_riskratingmethodologyid"
        },
        {
            "from_table": "nadb_projectriskratings",
            "from_column": "_nadb_riskstatus_rating_value",
            "to_table": "nadb_creditriskstatuses (2)",
            "to_column": "nadb_creditriskstatusid"
        },
        {
            "from_table": "nadb_projectriskratings",
            "from_column": "_nadb_internalcreditriskrating_value",
            "to_table": "nadb_internalcreditriskratings (2)",
            "to_column": "nadb_internalcreditriskratingid"
        },
        {
            "from_table": "nadb_Loan Administration",
            "from_column": "_nadb_originppportunity_proj_value",
            "to_table": "Opps",
            "to_column": "opportunityid"
        }
    ]
}