Register Data
Each piece of interval data for the register will be stored as an Interval Register Data record linked to the newly created data set. The name of this table is CI_​REG_​DATA. The following table describes each column on this table.
Column Name
Length
Req'd
Data Type
Comments
REG_​DATA_​SET_​ID
12
Y
A/N
This is a foreign key reference to the Register Data Set that groups the interval values together. This should be your newly created ID from above.
REG_​DATA_​DTTM
26
Y
DateTime
This is the date and time of the register data. This must be stored in standard time for the base time zone. Refer to Time Zone and Time Changes for more information.
INTV_​REG_​DATA
18.7
Y
N
This is the quantity for the interval.