Interval Value Set
You must create a data set for each batch of records being uploaded in the system for the same bill factor / characteristic. The name of this table is CI_INTV_VAL_SET. 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 random unique key. This key is referenced on the interval value record. It's suggested that this is a random number. If your process that inserts records on this table is capable of calling a routine, call ProgramCIPZKEYG and it will supply a 12 digit random number for you. |
|
BF_CD |
8 |
Y |
A/N |
This along with CHAR_TYPE_CD and CHAR_VAL indicate the bill factor / characteristic to which this interval value set belongs. Refer to Setting Up Bill Factors for more information. |
|
CHAR_TYPE_CD |
8 |
Y |
A/N |
This along with BF_CD and CHAR_VAL indicate the bill factor / characteristic to which this interval value set belongs. Refer to Setting Up Bill Factors for more information. |
|
CHAR_VAL |
16 |
Y |
A/N |
This along with BF_CD and CHAR_TYPE_CD indicate the bill factor / characteristic to which this interval value set belongs. Refer to Setting Up Bill Factors for more information. |
|
SET_DTTM |
26 |
Y |
DateTime |
This is the data/time that the data set was received. This must be populated with the current date / time. This is considered a server date and will follow the seasonal time shifting as defined on the base time zone. Refer to Seasonal Time Shifts for more information. Refer to Algorithms Find the Most Up To Data for information about why this date/time is important. |