Specifications
20 – Using PlantScape Data in Other Applications
402 R400
FROM ControlModulePoint
WHERE Parameter001 = ‘PIDA.SP’
The result set is shown below.
The Quality field indicates the point parameter status when the data was
retrieved. It can take the following values:
UNIM
The parameter has not been implemented for the point.
UNSPECIFIED
No parameter has been specified in the parameter field.
NaN
The numeric value is not a floating point number (NaN).
BAD
The parameter status is bad and not NaN.
GOOD
There are no errors for the value.
The Type field indicates one of four parameter types: ENUM, NUMBER, TEXT, or
INVALI.
The relationship between the Quality and Type field is as follows:
• If the quality is shown as BAD, then the type is shown as INVALI.
• If the quality is shown as NaN, then the type will be set and the
corresponding value will be the last good value of the parameter.
Figure 20.5 Result for Example Query for Control Module Point
plscpcg.book Page 402 Monday, May 28, 2001 10:11 AM