EDI867CA export

Use the following procedure to configure a task template:

Go to System Operations > Task Management > Task Templates.
Use the dropdown menu to select the Task Type and Task Template. (Click Add to create a new task template. For more information, see Adding task templates.)
Configure the Task specific parameters. These parameters are defined after step 5 of this procedure.
Configure the Common task template parameters. For more information, see Task template parameters.
Click Save.

Task specific parameters:

ID Selection

Defines the entity that IEE builds the export file or report around. Entity type supports all main configuration entities. The valid values are as follows:

service point
account
meter
data routing program
monitoring data program

In a task template, select the entity type from the dropdown menu and click Search to find the specific ID. Click the appropriate row in the search results and click OK to add the ID to the task template.

Customer ID

The residential, commercial, or industrial consumers with whom the utility company has a contractual commitment to sell metered resources.

Date Selection

Time Period

Defines the time span of the data to include in the task for exports, reports, and other tasks. Some common time periods include: Today, Yesterday, Month, Month to Date, Week, Week to Date, Year, and Year to Date.

Start Date

Defines the first day from which to include data in the task.

Tip: Defines the date to start the baseline calculation. Use this parameter to indicate how far back your baseline is needed. Typically, this is the first day of operation or recovery period. If this value is not properly set, it may default to the beginning of time, and Like Days may calculate as far back as historic data is available. This will overwhelm the LikeDayAlgorithmDate table and lead to slower processing.

End Date

Defines the last day from which to include data in the task. To include the full 24 hours of the last day, the task will be scheduled with an adjusted End Date (that is, adding one day to the End Date entered in the task parameter).

Time Zone

Defines the time zone that corresponds to the time period and start/end dates you select in the task template.

For Rate Event Report, the time zone format is PacificUS, PacificUSNoDst, and EasternUS.
For TOU Schedules, the IDs cannot start with a numeric character. For example, "400_TOUSchedule" is not a valid ID. Instead, name the ID "TOUSchedule_400".

Other Properties

Export Directory

Defines the path where to write the export files. Where applicable, click Search to navigate to the appropriate directory.

Interval Length

Defines the number of minutes to use for intervals in exported data, in the absence of a specified value for exports and workgroups data. Instead of specifying an interval length here, you can check As Metered. If you select As Metered, then the Interval Length option is inactive.

As Metered

Determines if IEE exports data using the metered interval length (instead of specifying an Interval Length). Select this check box to enable this parameter.

Aggregate on Export

Determines whether IEE eliminates separate aggregation tasks that would normally run before the export. Reducing the number of tasks generated on an automated C&I cycle improves performance and reduces the overall cycle processing completion time. Run aggregation on stored formula channels, which store the data and then export the aggregated data in the results. If the export does not run because of some other condition such as 'Export partial = false', then no aggregation takes place.

A channel that holds data calculated from a formula. The data can be regularly or irregularly spaced data.

Output Usage

Defines whether to export all data using demand or consumption units. The valid values are as follows:

Raw. Export readings as they are stored, with no conversion.
Consumption. Export readings after UCE converts them to consumption values.
Demand. Export readings after UCE converts them to demand values.

The UOM must be set correctly for UCE to make these conversions. If you omit this parameter or if the UOM cannot be converted to consumption or demand, IEE passes through the raw values.
Pulse. Export readings in pulses. With this setting, IEE converts the engineering units data into pulses using the correct multipliers for the period being exported. This functionality can be used if the receiving system is expecting data in pulses.

Usage Indicator

Defines the purpose of the usage data. For example, you can filter the export to include only test usage data or only production usage data.

Transaction Set Purpose Code

Defines the reason code to use for this export.

Billing Cycle ID

Defines the unique identifier of the billing system cycle associated with the entity type. Billing cycles enable prioritization by billing due dates. The valid values are as follows:

Allow Overrides
Valid ScheduleID Only
Override Default

Summary Directory

Defines directory where the task creates a file with summary information about the export. Type the file path to the directory or click Search to navigate to the directory.

Summary File Name

Defines the filename of the summary file created by the export task. Enter a descriptive name.