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:
|
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. |