Program Participation Definition File

The program participation definition file lists the different energy efficiency programs in which utility customers can participate. The following table defines the elements that should be provided in the columns of the file. Each row in the table is a column in the data file.

Note:

The Program Participation Definition file must be sent prior to the Program Participation file. This is because the programs listed in the definition file are used to validate the data in the participation file.

Column Name	Format
program_id	A unique identifier for the program. This can only contain letters, numbers, underscores, hyphens, dashes, and periods. Spaces and special characters are not accepted. Be consistent with upper and lower case. For example, do not use both Home_Energy_Audit and home_energy_audit. Choose one. Type: varchar Can Be Empty?: No. String Limit: 40 characters.
program_description	A description of the program and its purpose for the utility. Type: varchar Can Be Empty?: Yes. String Limit: 255 characters.
measure	A standardized identifier for a procedure or action that was implemented. Use a standard set of measures and be consistent with upper and lower case. For example, do not use both Replaced_Light_Bulbs and replaced_light_bulbs. Choose one. Type: varchar Can Be Empty?: No. Format: This field can only contain letters, numbers, underscores, hyphens, dashes, and periods. Spaces may not be used. String Limit: 255 characters.
measure_description	A description of the program measure. Type: varchar Can Be Empty?: No. String Limit: 255 characters.
active_date	Date and time that the program began. If an invalid datetime format is used, the record will be rejected. Type: datetime (YYYYMMDD HHmm) Can Be Empty?: Yes.
inactive_date	Date and time that the program ended. If left blank, this will leave the program valid indefinitely. If an invalid datetime format is used, the record will be rejected. Type: datetime (YYYYMMDD HHmm) Can Be Empty?: Yes.

Additional Notes

To add new program definitions, add a new row containing the program_ID and measure pair in the file. To deactivate an existing program_id and measure value pair, assign an inactive_date to an existing row. After this is done, any new assignments of customers to that pair that fall after the inactive date are rejected.

Note:

Consult with your Oracle Utilities Delivery Team to make ensure that the products exhibit the correct behavior for each program_id and measure pair.

Example Program Participation Definition File

The following table is an example of a Program Participation Definition file.

program_id	program_description	measure	measure_description	active_date	inactive_date
Home_Energy_Audit	An audit of a customer’s home	Replaced_light_bulbs	As part of the audit, the auditor replaced the customer’s light bulbs with compact florescent light bulbs	20130110 1200	20200110 1200
Home_Energy_Audit	An audit of a customer’s home	Replaced_HVAC_filters	As part of the audit, the auditor replaced the customer’s HVAC filters	20130110 1200
Recycling	Recycling of old appliance	Freezer_recycled	Customer recycled freezer
Recycling	Recycling of old appliance	Washer_recycled	Customer recycled washer