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