Understand sample status updates

The MES middleware maintenance service updates the status of a sample based on the following conditions.

Ready Warning

When the current time is at or later than the requested sample time and the warning interval for a ready sample; the pulled_time_utc is null (i.e., the sample has not been pulled); and no data has been collected for the sample.

Missed

When the current time is at or later than the requested sample time and the expiry interval for a sample; the pulled_time_utc is null (i.e., the sample has not been pulled); and no data has been collected for the sample.

Late

When the current time is at or later than the requested sample time and the expiry interval for a sample, and:

• The pulled_time_utc is null (i.e., the sample has not been pulled) and some but not all the required data has not been collected

  OR

• The pulled_time_utc is not null (i.e., the sample has been pulled) but all required data has not been collected

When a measurement data is recorded in the database, the status is updated based on the following conditions.

In Progress

Specifies the current time is between the requested and expiration time, and that at least one measurement is recorded in the result table for the sample.

Complete

Specifies the measurement time for all the characteristics for a sample that are less than the sample expiration time, and the sample size for each characteristic within the sample is at least equal to the defined minimum sample size.

Complete Late

Specifies at least one measurement time that is greater than the expiration time, and the sample size for each characteristic within the sample is at least equal to the minimum sample size.