Process X - Populate Interval Register Data

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

• It attempts to determine the appropriate Register to which this data belongs using the channel ID. If a register with this channel ID is not found, the data set is created without being linked to a register and the channel ID is stored as the external ID on the data set.
• It creates a new Register 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 register should be inserted into the interval register data table and should reference the same register data set.
• Set the status of the new data set:
  • If the data set is not linked to a register, set the status to pending.
  • If the register type has a validation algorithm, set the status to pending.
  • If the register type does not have a validation algorithm, this data should be clean. Set the status to complete.
• Inserts a record in the register data set key table.

The topics in this section describe the tables to populate.