Profile Updates Extract (Incremental)
The Profile Updates extract contains demographic and parcel information that has been updated by utility customers through the Oracle Utilities Energy Efficiency Web Portal - Classic or Customer Service Interface. It does not include initial data that Oracle Utilities has licensed through third-party providers. Each row includes customer-updated data within a specified date range. It is available from your Delivery Team upon request.
Column | Description |
---|---|
utility_customer_id |
The customer identifier that is used on customer communications. This is usually the same value as the Example: 1234-1234-1234-1234 Field Size: 40. Can Be Empty?: No. |
home_type |
Indicates the type of home. Allowed Values:
Field Size: 15. Can Be Empty?: Yes. |
owner |
Indicates whether the customer is an owner or renter. Allowed Values:
Field Size: 1. Can Be Empty?: Yes. |
heating_type |
Indicates the heating method used. Allowed Values:
Field Size: 16. Can Be Empty?: Yes. |
ac |
Indicates the cooling method used. Allowed Values:
Field Size: 20. Can Be Empty?: Yes. |
pool |
Indicates whether the customer has a pool or not. Allowed Values:
Field Size: 4. Can Be Empty?: Yes. |
spa |
Indicates whether the customer has a spa or sauna. Allowed Values:
Field Size: 5. Can Be Empty?: Yes. |
fireplace |
Number of fireplaces. Integer value. Field Size: 2. Can Be Empty?: Yes. |
photovoltaic |
Indicates whether the customer uses solar panels. Allowed Values:
Field Size: 3. Can Be Empty?: Yes. |
num_adults |
Number of adults in the household. Integer value. Field Size: 2. Can Be Empty?: Yes. |
num_children |
Number of children in the household. Integer value. Field Size: 2. Can Be Empty?: Yes. |
living_sqft |
Living square footage. Integer value. Field Size: 6. Can Be Empty?: Yes. |