Interval Data Set

You must create a data set for each batch of records being uploaded in the system for the same profile. The name of this table is CI_​INTV_​DATA_​SET. The following table describes each column on this table.

Column Name

Length

Req'd

Data Type

Comments

INTV_​DATA_​SET_​ID

12

Y

A/N

This is a unique key. This key is referenced on the interval data record.

It's suggested that this key is built as follows:

  • The first five digits are the first five digits of the INTV_​PF_​ID
    • The last seven digits are randomly generated.

      This facilitates set based processing of the data. If your process that inserts records on this table is capable of calling a routine, call ProgramCIPZKEYG passing the first five digits and it supplies a seven digit random number.

INTV_​PF_​ID

12

N

A/N

This is a foreign key reference to the interval profile to which this set is linked. It is required if an external ID is not specified.

INTV_​DS_​EXT_​ID

60

N

A/N

This is the external identifier of the profile to which this data belongs. It is required if profile ID is not specified.

SET_​DTTM

26

Y

DateTime

This is the date/time that the data set was received. This must be populated with the current date/time. This is considered a server date and follows 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-Date Data for information about why this date/time is important.

SET_​STATUS_​FLG

2

Y

A/N

Set this value based on whether it will be validated in the system.

Set to P for Pending if the profile ID is blank or if the profile's profile type indicates a validation algorithm.

Set to C for Complete if the data should not go through any further validation.

Refer to Life Cycle of Interval Profile Data for more information