Customer Fields

The billing data customer fields capture details such as the utility customer's name, address, and other contact information.

Each table row represents a column in the data file. The header row of the data file must contain all table "Column Name" values, even if all values in those columns are blank. The columns must appear from left to right in the order in which they appear in the table and be separated by tab characters. See Legacy Billing Data File Specifications for more information.

Column Name	Description
customer_id	Unique identifier for the customer that is familiar to the customer. This field is the default id that will be displayed on Oracle Utilities Opower communications. It is also used for web portal account creation and by Customer Service Representatives to locate customer accounts in the Customer Service Interface. Type: STRING Can Be Empty?: No. Default: Not applicable.
premise_id	An identifier for a site occupied by an individual customer. Multiple service points (one per fuel type) may be tied to one premise, but only one customer can be tied to a premise at any given time. Type: STRING Can Be Empty?: No. Default: Not applicable.
secondary_id	Additional field for a secondary customer id. If `customer_id` is unknown to your customers, you can use this field as the value included on Oracle Utilities Opower communications, for Energy Efficiency Web Portal - Classic account creation, and for CSRs searching for customer accounts in the Customer Service Interface. Type: STRING Can Be Empty?: Yes. Default: Null.
ccb_account_id	Unique identifier for an account in the Oracle Utilities Customer Care and Billing (CCB) system. For more information about CCB, see the Oracle Utilities Customer Care and Billing documentation. Note: If you are using Oracle Utilities CCB, this is a required field. Type: STRING Can Be Empty?: Yes. Default: Not applicable.
mail_address_line_1	The first line of the mailing address that should contain the street address. Note: The mailing address does not necessarily match the service point address. Type: STRING Can Be Empty?: No. Default: Not applicable.
mail_address_line_2	Optional second line of the mailing address. Type: STRING Can Be Empty?: Yes. Default: Not applicable.
mail_address_line_3	Optional third line of the mailing address. Type: STRING Can Be Empty?: Yes. Default: Not applicable.
mail_city	The city in which the mailing address is located. For example, Richmond. Type: STRING Can Be Empty?: No. Default: Not applicable.
mail_state	The 2-character state code where the mail address is located. For example, VA for Virginia. Type: STRING - 2 characters Can Be Empty?: No. Default: Not applicable.
mail_zip_code	5-digit zip or 9-digits of zip+4. For example, 22209 or 22209-1234. Type: STRING Can Be Empty?: No. Default: Not applicable.
first_name	Customer's first name. Type: STRING Can Be Empty?: Yes.* For residential customers, at least one of the following must be specified: `first_name`, `last_name`. If the name on a customer’s bill includes a middle initial, this should be concatenated in the `first_name` field. If you have the `first_name` of a contact for a business customer (not residential), enter it here. If the name on a customer’s bill includes a middle initial, this should be concatenated in the `first_name` field. For business customers, the `business_name` must be specified, as well as either `first_name` or `last_name`. Default*: Null.
last_name	Customer's last name. Type: STRING Can Be Empty?: Yes.* For residential customers, at least one of the following must be specified: `first_name`, `last_name`. If you have a `last_name` contact name for a business customer (not residential), enter it here. For business customers, the `business_name` must be specified, as well as either `first_name` or `last_name`. Default*: Null.
phone_1	The primary phone number for a customer. For most utilities, this will be the only phone number that is used. Example US formats: (xxx)xxx-xxxx, xxxxxxxxxx, xxx-xxx-xxxx, x-xxx-xxx-xxxx Type: STRING Can Be Empty?: Yes. Default: Null.
phone_2	A secondary phone number. This is used to denote SMS numbers. If this field is completed, the number must be able to receive SMS messages. Example US formats: (xxx)xxx-xxxx, xxxxxxxxxx, xxx-xxx-xxxx, x-xxx-xxx-xxxx Type: STRING Can Be Empty?: Yes. Default: Null.
email	Customer's email address. This is required to enable delivery of email communications. Only one address should be sent. Type: STRING Can Be Empty?: Yes. Default: Null.
owner	A flag to indicate whether a customer is an owner of the home. Type: STRING - 1 character Allowed Values: O Customer is an owner. R Customer is a renter. Can Be Empty?: Yes. If left blank, the customer's status as owner is marked "unknown." Default: Null.
customer_type	A classification for the customer, such as a residential or commercial customer. Only customers marked as `RESIDENTIAL` or `R` will receive a normative comparison experience. A normative comparison experience is a feature that compares a customer's energy use against that of their neighbors, such as the Neighbor Comparison in Home Energy Reports. Type: STRING Allowed Values: A Customer is agricultural. AGRICULTURAL Customer is agricultural. C Customer is commercial. This value maps to the SMB value below. I Customer is industrial. INDUSTRIAL Customer is industrial. OTHER Customer is another type that does not fall into the commercial, industrial, residential, or SMB categories. R Customer is residential. RESIDENTIAL Customer is residential. SMB Customer is a small and medium business or commercial customer. Can Be Empty?: Yes. Default: Null. If left Null, the customer will be marked as RESIDENTIAL.
language_preference	A five-character code specifying a customer's preferred language/country. The language is specified by the two letter lowercase ISO language code defined in ISO-639. The country is specified by the two letter uppercase ISO country code defined in ISO-3166. The code must begin with the language and then the country separated by an underscore. If the value in this field is empty or NULL, then the default language code that is configured for the utility will be used for the customer. Note: This field is primarily designed to support the multilingual functionality that is provided for utilities whose customers speak multiple languages. It is not frequently used. Contact your Delivery Team if you have any questions. Type: STRING Example Values: fr_FR en_US Can Be Empty?: Yes. Default: None.

Additional Customer Fields for Businesses

Column Name Description

Column Name	Description
business_name	The name of the business. Use this field if the `customer_type` field has a value of `C` or `SMB` to refer to commercial customers. Type: STRING Can Be Empty?: Yes. Note: If the `business_name` field is filled, you must also include information in `first_name` and `last_name` fields. If `business_name` is filled, but there is no information in `first_name` or `last_name`, the record will be rejected. Default: Not applicable.
other_business_segment	Utility specified business segment if the utility has a unique segmenting schema other than NAICS or SIC code. Note: Only enter values in this column if your utility is part of the Oracle Utilities Opower SMB Energy Efficiency Pilot program. If your utility is not part of this pilot program, do not enter any values in this column. Type: STRING Can Be Empty?: Yes. Default: Null.

business_name

The name of the business. Use this field if the customer_type field has a value of C or SMB to refer to commercial customers.

Type: STRING

Can Be Empty?: Yes.

Note: If the business_name field is filled, you must also include information in first_name and last_name fields. If business_name is filled, but there is no information in first_name or last_name, the record will be rejected.

Default: Not applicable.

other_business_segment

Utility specified business segment if the utility has a unique segmenting schema other than NAICS or SIC code.

Note: Only enter values in this column if your utility is part of the Oracle Utilities Opower SMB Energy Efficiency Pilot program. If your utility is not part of this pilot program, do not enter any values in this column.

Type: STRING

Can Be Empty?: Yes.

Default: Null.