CUPS

Description

This view aggregates information about consumer supply points (CUPS), including their community, contracted power, appliances, location metadata, and occupancy metadata.

Structure (upc_cups)

Field	Description
id	Unique CUPS identifier in the system
community_id	Identifier of the community the CUPS belongs to
community_name	Name of the community
type	Supply place type
p1_contracted_power_kw	Contracted power in period P1 (kW)
p2_contracted_power_kw	Contracted power in period P2 (kW)
p3_contracted_power_kw	Contracted power in period P3 (kW)
p4_contracted_power_kw	Contracted power in period P4 (kW)
p5_contracted_power_kw	Contracted power in period P5 (kW)
p6_contracted_power_kw	Contracted power in period P6 (kW)
has_electric_kitchen	Whether the supply point has an electric kitchen
has_electric_heater	Whether the supply point has electric heating
has_ac	Whether the supply point has air conditioning
has_dryer	Whether the supply point has a dryer
has_dishwasher	Whether the supply point has a dishwasher
has_pool_pump	Whether the supply point has a pool pump
has_domotics	Whether the supply point has home automation (domotics)
size_m2	Floor area of the property (m²)
construction_year	Year the property was built
people_count	Number of people living at the supply point
has_children	Whether there are children at the supply point
children_count	Number of children at the supply point
presence_pattern	Occupancy presence pattern
remote_work	Whether any occupant works remotely
created_dt	Record creation date