Interval Value

Each piece of interval data for the same bill factor/characteristic will be stored as an Interval Value record linked to the newly created data set. The name of this table is CI_INTV_VAL .

Table 1. - CI_INTV_VAL Table ColumnsThe following table lists and describes the columns of the CI_INTV_VAL table:
Column Name	Length	Req'd	Data Type	Comments
INTV_VAL_SET_ID	12	Y	A/N	This is a foreign key reference to the Interval Value Set that groups the interval values together. This should be your newly created id from
INTV_VAL_DTTM	26	Y	DateTime	This is the date and time of the interval value. This must be stored relative to the base time zone.
INTV_VAL	18.7	Y	N	This is the value (price) for the interval.