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 above. |
|
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. Refer to Time Zone and Time Changes for more information. |
|
INTV_VAL |
18.7 |
Y |
N |
This is the value (price) for the interval. |