The results tables

The results tables contain historical data about sensors that are run by the Scheduler.

Most sensors create a new table to store their results. The name of the table is listed in the tk_result_table column in the ph_task table. The structure of the table is defined by the CREATE TABLE statement in the tk_create column of the ph_task table.

The built-in sensors automatically create results tables when they run that start with the prefix mon_.

Table 1. Results tables
Column Type Description
ID integer The iteration sequence number of the sensor. Must be set to $DATA_SEQ_ID.

Referenced from the run_task_seq column of the ph_run table.

user columns any You can specify any types of columns to hold the information returned by a sensor.

Copyright© 2018 HCL Technologies Limited