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