Service Agreement Service Points File
The service agreement service points file includes fields related to the relationship between a customer's service point and service agreement. The data for this entity is expected to be sent in a separate file. If there are any changes to a service agreement's service point list, then Oracle Utilities Opower will attempt to merge them into a cohesive history. However, the sa_sp_start_date
and sa_sp_end_date
history must not overlap for a single service agreement and service point combination. If the same combination of service_agreement_id
, service_point_id
, and sa_sp_start_date
is sent again, it is assumed to be a correction and will overwrite previously-imported values.
Service Agreement Service Points File Naming Convention:
opwr_[utility]_[specification version number]_billing_account_sa_sp_[yyyymmdd].[gz or zip]
See Account Data File Name Conventions for an explanation of each component of the file name.
Field |
Description |
---|---|
service_agreement_id |
The unique identifier of a service agreement. Type: VARCHAR(40) Can Be Empty?: No. Primary Key. |
service_point_id |
The unique identifier of a service point on a service agreement. This relates to the Type: VARCHAR(40) Can Be Empty?: No. Primary Key. |
service_point_name |
A user-friendly name for the service point. The purpose of this field is to make the service point name easier to understand when displayed in the user interface of an Oracle Utilities product. Type: VARCHAR(40) Can Be Empty?: Yes. Business Key. |
usage_flag |
A flag that indicates whether usage for this service point is additive or subtractive for the overall service agreement. Allowed Values:
Note: Rows containing any values for this field other than plus (+) or minus (-) will be rejected. Type: ENUM Can Be Empty?: No. |
usage_percent |
The percentage contribution to the total usage of the related service agreement. For example, a service agreement in a roommate arrangement may have one service point but is only contributing 50% of its usage to each of two different service agreements. This field defaults to 100 if no value is provided. Type: DECIMAL(3,0) Can Be Empty?: Yes. |
sa_sp_start_datetime |
The date on which the service agreement was associated with the service point. Type: DATETIME. See Date and Time Handling for details. Can Be Empty?: No. Primary Key. |
sa_sp_end_datetime |
The date on which the service agreement was disassociated from the service point. Type: DATETIME. See Date and Time Handling for details. Can Be Empty?: Yes. |