Customer Classification 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. See Customer Classification File Name Conventions for more information.
• The file is tab-delimited and is in .tsv or .txt format.
• The same number of tabs exists in each row.

Header Row Checks

Column headers must match exactly the headers shown below.

Customer Classification Definition File:

classifier classifier_description allowed_value allowed_value_description
                inactive_date

Customer Classification File:

customer_id premise_id classifier value start_date end_date

Data Field Checks

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