Process X - Populate Interval Data

Process X refers to the mechanism used by your organization to populate the Interval Data tables. Process X has the following responsibilities:

• It attempts to determine the appropriate profile to which this data belongs using the external ID. If a profile with this external ID is not found, the data set is created without being linked to a profile and the external ID is stored on the data set.
• It creates a new interval data set with the current date and time.
• If the interval data is from a different time zone, or is not in standard time for the base time zone, the time of each interval must be converted to standard time in the base time zone. Refer to Time Zone and Time Changes for more information.
• All quantities being uploaded for the same profile should be inserted into the Interval Data table and should reference the same interval data set.
• Set the status of the new data set:
  • If the data set is not linked to a profile, set the status to pending.
  • If the profile type has a validation algorithm, set the status to pending.
  • If the profile type does not have a validation algorithm, this data should be clean. Set the status to complete.
• Inserts a record in the interval data set key table.

The topics in this section describe the tables to populate.