TOU Data Set

You must create a data set for each batch of records being uploaded in the system for the same classic TOU Map. The name of this table is CI_​TOU_​DATA_​SET. The following table describes each column on this table.

Column Name

Length

Req'd

Data Type

Comments

TOU_​DATA_​SET_​ID

12

Y

A/N

This is a unique key. This key is referenced on the TOU Data record.

It's suggested that this key is built as follows:

  • The first five digits are the first five digits of the TOU MAP_​ID.
    • The last seven digits are randomly generated.

      This facilitates set based processing of the data. If your process that inserts records on this table is capable of calling a routine, call ProgramCIPZKEYG passing the first five digits and it supplies a seven-digit random number.

TOU_​MAP_​ID

12

Y

A/N

This is a foreign key reference to the classic TOU map to which this set is linked.

Refer to Classic TOU Map Maintenance for more information.

SET_​DTTM

26

Y

DateTime

This is the date/time that the data set was received. This must be populated with the current date/time. This is considered a server date and follows the seasonal time shifting as defined on the base time zone. Refer to Seasonal Time Shifts for more information.

Refer to Algorithms Find the Most Up-To-Date Data for information about why this date/time is important.