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 . The following table describes each column on this 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. |