Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Summary:

These metric updates refer to the Data Access Layer.  The DAL is a powerful, yet simple endpoint to pull data from jobs.  Please click here to find a full overview and explanation.

Sprint 2.15 - 20 - 3/08/18 Release (Expected)

Sprint 2.19 - 2/22/18 Release

Metrics Added:

  • degradation_percent
  • quote_channel_manager_id
  • quote_channel_manager_name
  • quote_owner_organization_id
  • quote_owner_organization_name
  • quote_financier_id
  • quote_financier_name

Metrics Removed:

  • degradation_pct

Sprint 2.18 - 2/12/18 Release

Metrics Added:

  • user_name - name of the user assigned to the job
  • user_phone - phone number of the user assigned to the job
  • next_payment_month_post_amort_period

  • next_payment_month_post_grace_period

  • next_payment_month_post_promo_period

  • next_payment_month_post_start_period

  • next_payment_post_amort_period

  • next_payment_post_grace_period

  • next_payment_post_promo_period

  • next_payment_post_start_period

Sprint 2.17 - 1/25/18 Release

Metrics Updated:

  • carbon_equivalent_coal_pounds
  • carbon_equivalent_gasoline_gallons
  • carbon_equivalent_home_energy
  • carbon_equivalent_homes_electricity
  • carbon_equivalent_metric_tons
  • carbon_equivalent_oil_barrels
  • greenhouse_gas_equivalent_vehicle_count
  • greenhouse_gas_equivalent_vehicle_miles
  • sequestered_equivalent_forest_acres
  • sequestered_equivalent_seedlings_count

Sprint 2.161/11/18 Release

Metrics Added:

  • production_month_X - X ranges from 1-12 where 1 = January and 12 = December.  Monthly production numbers are only available for year 1. 
  • quote_adder_[project_type]_name_quantities
  • quote_adder_[project_type]_names
  • quote_adder_[project_type]_price_total
  • quote_adder_name_quantities
  • quote_adder_names
  • quote_adder_price_total

Sprint 2.15 - 12/21/17 Release

Metrics removedRemoved:
credit_expiration_date
credit_last_updated
credit_qualification_amount_approved
credit_qualification_amount_approved_override
credit_qualification_application_status
credit_qualification_date_updated
credit_qualification_decision_status
credit_qualification_external_id
credit_qualification_id
credit_qualification_is_active
credit_qualification_modified_by
credit_qualification_status
credit_status_for_job
external_ids
legal_contact_applicant_type
legal_contact_date_updated
property_expiration_date
qualification_credit_qualification_external_id
qualification_status
title_expiration_date

...

  • incentives_[incentive_type]_[assignee]_yr[year] - incentive type given to an assignee in a specified year (expected)
    • example: incentives_itc_s_yr1, the first year itc assigned to the siteowner
    • incentive_type options: pbi, stc, ongoing, rbt, itc, rec, upfront; all types are option
    • assignees: i, f, s (installer, financier, siteowner)
    • year is required
  • incentives_[incentive_type]_[assignee]_cum_yr[year] - incentive type given to an assigned over the specified number of years, starting from year 1 (expected)
    • example: incentives_ongoing_f_cumyr20, the cumulate ongoing incentives assigned to the financier over the next 20 years
    • incentive_type options: pbi, stc, ongoing, rbt, itc, rec, upfront; all types are option
    • assignees: i, f, s (installer, financier, siteowner)
    • year is required
  • federal_tax_savings_cum_yr[year] - cumulative federal tax deductions over the specified number of years, starting from year 1 (expected)
  • federal_tax_savings_yr[year] single year federal tax savings (expected)
  • state_tax_savings_cum_yr[year] - cumulative state tax deductions over the specified number of years, starting from year 1 (expected)
  • state_tax_savings_yr[year] single year state tax savings (expected)
  • total_tax_savings_cum_yr[year] - cumulative tax deductions over the specified number of years, starting from year 1 (expected)
  • total_tax_savings_yr[year] - single year total tax savings (expected)
  • savings_cum_yr[year] - cumulative savings over the specified number of years, starting from year 1 (expected)
  • savings_yr[year] - single year savings (expected)
    • savings_yr[year] = utility bill pre - utility bill post - solar bill + year 1 Incentives, excluding upfront

Sprint 2.13 - 11/16/17 Release

New:

  • array_id_x
  • array_inverter_count_x (replaces: array_n_inverters_x) 
  • array_module_count_x (replaces: array_number_of_modules_x) 
  • array_inverter_manufacturer_x
  • array_inverter_model_x
  • array_module_manufacturer_x
  • array_module_model_x
  • array_capacity_x
  • system_module_models
  • system_inverter_models
  • system_inverter_model_counts
  • system_module_model_counts
  • system_inverter_manufacturer_counts
  • system_module_manufacturer_counts
  • system_inverter_manufacturers
  • system_module_manufacturers
  • system_snapshot_url - returns a URL that has the image of the designed system

...

  • solar_spend_average_monthly_yr[year] - average cost of solar for a specified year (expected)
  • utility_bill_pre_average_monthly_yr[year] - average utility bill for a specified year if there is no solar system installed (expected)
  • utility_bill_post_average_monthly_yr[year] - average utility bill for a specified year after the designed solar system is installed (expected)
  • site_usage_yr[year] - annual energy usage for a specified year (expected)
  • federal_tax_rate
  • state_tax_rate

Sprint 2.10 - 10/5/17 Release

...

  • avg_utility_cost_pre - average cost of power pre-solar
  • credit_expiration_date - credit expiration date
    • ability to filter with credit_expiration_date_before / credit_expiration_after
  • array_solar_access_percent_X - solar access values for month x
  • initial_contract_date - date of the first signed contract in a workflow