TOU Data
Each time period definition for the classic TOU map will be stored as a TOU Data record linked to the newly created data set. The name of this table is CI_TOU_DATA. 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 foreign key reference to the TOU Data Set that groups the TOU definitions together. This should be your newly created ID from above. |
TOU_DATA_DTTM |
26 |
Y |
DateTime |
This is the date and time of the time period definition. This must be stored relative to the base time zone. Refer to Time Zone and Time Changes for more information. |
TOU_CD |
30 |
Y |
A/N |
This is the TOU code that this time period shall be mapped to. |