Program Participation Data Verification Checklist

Use the checklist in this section to ensure you have completed all required actions before sending the data files to Oracle Utilities.

File Format Checks

• The filename follows the appropriate pattern. Program Participation Data File Name Conventions
• The file is tab-delimited.
• The same number of tabs exists in each row.

Header Row Checks

Column headers must match exactly the headers shown below.

Program Participation Definition File:

program_id program_description measure measure_description active_date
                inactive_date

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

Data Field Checks

• All data fields in the Program Participation Definition file follow the rules described in this document. See Program Participation Definition File for more information.
• All data fields in the Program Participation file follow the rules described in this document. See Program Participation File for more information.
• Null values are empty strings. (They must be not denoted by /N, NA, null, or some other non-supported notation.)