Web Logins Extract (Incremental)

14 Web Logins Extract (Incremental)

The Web Logins extract contains a list of customer logins to the Energy Efficiency Web Portal - Classic within a specified date range. It is available as a standard recurring extract if you Contact Your Delivery Team.

Column Description

utility_customer_id

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.
login_time	Date and time of login. Field Size: 19. Can Be Empty?: No.

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.

login_time

Date and time of login.

Field Size: 19.

Can Be Empty?: No.