Program Participation File
Note:
If Oracle Utilities encounters any program that has not already been defined and sent in a Program Participation Definition file, the corresponding rows in the Program Participation file will be rejected. Oracle Utilities recommends that you confirm with your Delivery Team that the latest definition file has been received before sending any customers with newly-defined program-allowed value pairs. Additionally, if an inactive date is assigned for a program-measure pair, Oracle Utilities will reject any new assignments of customers to that program-measure after that inactive date. Existing customers with the program-measure assignment will not be deactivated.| Column Name | Format |
|---|---|
| customer_id |
Unique identifier for the customer. Note: This customer ID should be the same customer ID that is sent in the billed usage files, as described in Customer Fields. Type: varchar Can Be Empty?: No. |
| premise_id |
An identifier for a site occupied by an individual customer. Note: This premise ID should be the same premise ID that is sent in the billed usage data files, as described in Customer Fields. Type: varchar Can Be Empty?: No. |
| program_id |
Key identifier for the program. The Type: varchar Can Be Empty?: No. |
| measure |
A standardized identifier for a procedure or action that was implemented. The Type: varchar Can Be Empty?: No. |
| deemed_annual_savings |
Energy saved over the course of the year (in kWh, CCFs, or Therms) for the customer. Type: floating point Can Be Empty?: Yes. |
| deemed_ annual_savings_unit |
Unit of measure for Type: enum - KWH, K, THERM, T, CCF, C Note: K, T, and C are alternate short form representations of KWH, THERM, and CCF, respectively. Can Be Empty?: Yes. |
| deemed_lifetime_savings |
Energy saved over the course of the program (in kWh, CCFs, or Therms) for the customer. Type: floating point Can Be Empty?: Yes. |
| deemed_lifetime_savings_unit |
Unit of measure for Type: enum - KWH, K, THERM, T, CCF, C Note: K, T, and C are alternate short form representations of KWH, THERM, and CCF, respectively. Can Be Empty?: Yes. |
| measure_life |
The number of years over which the benefits of the energy efficiency measure are expected to accrue. Type: floating point Can Be Empty?: Yes. |
| start_date |
The start date of the customer's enrollment in the program. The start date must fall inside the active and inactive program dates specified in the program participation definition file. Otherwise, it will be marked as invalid. Type: datetime (YYYYMMDD HHmm) Can Be Empty?: No. |
| end_date |
The end date of the customer's enrollment in the program. If this
field is left empty, then it is assumed that there is no end date
for the customer's enrollment. If this field is populated, then the
end date must come after the Type: datetime (YYYYMMDD HHmm) Can Be Empty?: Yes. |
Example Program Participation File
The following table is an example of a Program Participation file.
| customer_id | premise_id | program_id | measure | deemed_annual_savings | deemed_annual_savings_unit | deemed_lifetime_savings | deemed_lifetime_savings _unit | measure_life | start_date | end_date |
|---|---|---|---|---|---|---|---|---|---|---|
| 4268110141 | 304892 | Home_energy_audit | Replaced_filter | 20 | KWH | 40 | KWH | 1 | 20130101 1200 | |
| 8427500652 | 492783 | Home_energy_audit | Replaced_light_bulbs | 10 | KWH | 35 | KWH | 1.2 | 20130101 1200 | |
| 3934977649 | 622774 | Recycling | Washer_recycled | 20130101 1200 | ||||||
| 1080095742 | 654078 | Recycling | Washer_recycled | 20130101 1200 | ||||||
| 7611477224 | 208315 | Recycling | Freezer_recycled | 20130101 1200 |