Documentation: shs

device_external_id

id for the specific shs system as tracked by the data provider (source)

account_external_id

id for the specific account (e.g. paygo loan) associated with the shs device

serial_number

serial number of system

manufacturer

manufacturer of system, needed to make id when combined with serial number

customer_external_id

ID for the specific customer associated with the shs device

uid

customer_uid + device_uid

purchase_date

date system was purchased

model

model of system, needed e.g. for matching eligible systems of an rbf program

pv_power_w

PV panel size in watts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

battery_energy_wh

battery capacity in watt-hour

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

voltage_v

system voltage in volts; e.g. - 5, 12 if DC or 110, 230 if AC

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

rated_power_w

max rated capacity in watts

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

customer_category

how the system is to be used: household, institutional, commercial

customer_sub_category

which type of business, which institution

primary_use

what appliance is the main load of system

payment_plan_days

repayment plan of system/loan

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

payment_plan_down_payment

amount paid at time of purchase, total cost if paid in full at purchase

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

payment_plan_amount_financed

amount to be repaid after down payment, 0 if paid in full at purchase

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

total_price

Total sales price of the device

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

payment_plan_type

\"paygo\" or \"full\" if paid in full at purchase

payment_plan_currency

currency code of payment plan, in ISO 4217 three character format

paid_off_date

date system was paid off, null if not paid off

repossession_date

date system was repossessed, null if not repossessed

is_test

is a test system, should be excluded in overall analyses

customer_name

customer first and last name (p14)

customer_id_number

customer identification number

customer_id_type

type of customer identification

customer_gender

Male, Female, Other, or Unknown (null)

customer_birth_year

year of purchaser birth, for demographic analysis

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

customer_former_electricity_source

e.g. none, solar, genset

customer_household_size

Number of residents of household (if residential use)

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

customer_profession

profession of customer - e.g. farmer or shop owner

customer_address

customer address (p14)

customer_country

two-letter country code according to https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2

customer_latitude

customer latitude (blurred to 3 decimal points)

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

customer_longitude

customer longitude (blurred to 3 decimal points)

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

customer_email

customer email (p14)

customer_phone

customer telephone (p14)

customer_phone_2

customer telephone 2 (p14)

customer_location_area_1

customer first-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

customer_location_area_2

customer second-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

customer_location_area_3

customer third-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

customer_location_area_4

customer fourth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

customer_location_area_5

customer fifth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

seller_external_id

ID for the specific sales agent associated with the shs device

seller_name

sales agent name (p14)

seller_gender

male (M), female (F), other (O) or unknown (null)

seller_address

sales agend address (p14)

seller_country

two-letter country code according to https://en.wikipedia.org/wiki/ISO_3166-1_alpha-2

seller_latitude

sales agent's latitude (blurred to 3 decimal points)

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

seller_longitude

sales agent's longitude (blurred to 3 decimal points)

Only period (.) decimal delimiters are supported. Do not use commas (,) — they will cause an error.

seller_email

sales agent email (p14)

seller_phone

sales agent telephone (p14)

seller_location_area_1

sales agent first-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

seller_location_area_2

sales agent second-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

seller_location_area_3

sales agent third-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

seller_location_area_4

sales agent fourth-level location according to Administrative division, see https://en.wikipedia.org/wiki/List_of_administrative_divisions_by_country

device_uid

organization_id + manufacturer + serial_number

customer_uid

organization_id + data_origin + customer_external_id

account_uid

organization_id + data_origin + account_external_id

created_at

Timestamp when row was inserted

updated_at

Timestamp when row was updated

source_id

References Source of data

import_id

References Import of data

organization_id

References Organization of data

custom

Saves additional imported data out of standard structure

data_origin

Origin of the data, generic or name of the api

last_import_id

Id of the last import which updated the record

last_source_id

Id of the last Source which updated the record