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 customer_id column sent by the utility in other data files, but not always. Additional identifiers may need to be added to the extract. Discuss this modification with your Delivery Team, if necessary.

Example: 1234-1234-1234-1234

Field Size: 40.

Can Be Empty?: No.

home_type

Indicates the type of home.

Allowed Values:

  • MULT
  • NON_RESIDENTIAL
  • SING

Field Size: 15.

Can Be Empty?: Yes.

owner

Indicates whether the customer is an owner or renter.

Allowed Values:

  • O
  • R

Field Size: 1.

Can Be Empty?: Yes.

heating_type

Indicates the heating method used.

Allowed Values:

  • DISTRICT_HEATING
  • ELEC
  • GAS
  • GEOTHERMAL
  • LPG
  • NONE
  • OIL
  • OTHER
  • WOOD

Field Size: 16.

Can Be Empty?: Yes.

ac

Indicates the cooling method used.

Allowed Values:

  • CENTRAL
  • CENTRAL_EVAPORATIVE
  • CENTRAL_HEAT_PUMP
  • CENTRAL_UNKNOWN
  • FAN
  • INFERRED_NONE
  • NONE
  • OTHER
  • ROOM
  • ROOM_HEAT_PUMP
  • ROOM_PORTABLE
  • UNKNOWN_TYPE

Field Size: 20.

Can Be Empty?: Yes.

pool

Indicates whether the customer has a pool or not.

Allowed Values:

  • NONE
  • POOL

Field Size: 4.

Can Be Empty?: Yes.

spa

Indicates whether the customer has a spa or sauna.

Allowed Values:

  • NONE
  • SAUNA
  • SPA

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:

  • N
  • Y

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.