Configuring activities to perform operations on user-defined fields
View Patent ↗A process control system that automatically monitors processes and performs activities based on conditions detected during monitoring. The information needed to do the monitoring and perform activities is contained in tables in a database system. The process control system may be configured by configuring entries in the tables. An administrative query table has records that define administrative queries. Each administrative query has associated with it a query to be executed on a table of process records that indicate statuses of the processes being monitored, a scope that defines a subset of the process records upon which the query is to be executed, a schedule from which a time of next execution of the administrative query can be computed, and an activity. The activity is a set of one or more actions. When an administrative query is executed and the query associated with the administrative query is run on the table of process records and the result set is not empty, the activity is performed with regard to the process records of the result set. Also disclosed are a graphical user interface for defining administrative queries, administrative activities, and activity types and for posting activities as well as techniques for configuring activity types so that an activities of the type can set user-defined fields in a process record in conjunction with the posting of the activity with regard to a process. A disclosed use of the technique is mapping values from fields of records for posted activities to user-defined fields in the PR record for the process, which in turn makes it possible to query the PR records on those fields.
1. A process control system comprising:
a server that has access to a database system and executes program code for the process control system;
a table of process records in the database system, a process record indicating a current condition of a process being controlled by the system and certain ones of the process records including one or more user-defined fields;
a table of activity type records in the database system that define activities to be performed with regard to the process, at least one of the activity type records specifying an operation to be done on a particular user-defined field; and
a portion of the program code which is executed in conjunction with posting an activity defined by at the least one activity type record in the system, the activity being posted as performed with regard to a process represented by a given process record and the operation specified in the at least one activity type record being done during execution of the portion of the program code.
2. The process control system set forth in claim 1 further comprising:
a table of activity records in the database system, an activity being posted by making a record for the activity in the table of activity records.
3. The process control system set forth in claim 1 wherein:
the at least one activity type record defines an activity that the process control system automatically posts with regard to a process represented by a process record returned by a query on the table of process records.
4. The process control system set forth in claim 3 wherein:
the process control system automatically performs the query.
5. The process control system set forth in claim 1 wherein:
the at least one activity type record defines an activity that is posted by a user of the process control system.
6. The process control system set forth in claim 5 wherein:
the user-defined fields include a date-time field whose value represents a date and a time; and
the operation sets the date-time field to a date and time at which the activity is posted.
7. The process control system set forth in claim 5 wherein:
the user-defined fields include a person field whose value represents a person; and
the operation sets the person field to a value which represents a person responsible for posting the activity.
8. The process control system set forth in claim 5 wherein:
the user-defined fields include a date-time field whose value represents a date and a time and a person field whose value represents a person; and
the operation sets the date-time field to a date and time at which the activity is posted and the person field to a value which represents a person responsible for posting the activity.
9. The process control system set forth in claim 1 wherein:
at least one of the activity type records that specifies an operation defines an activity that the process control system automatically posts with regard to a process represented by a record returned by a query on the table of process records and
at least another of the activity type records that specifies an operation defines an activity that is posted by a user of the process control system.
10. The process control system set forth in claim 1 wherein:
the specified operation is setting the particular user-defined field to a value.
11. The process control system set forth in claim 10 wherein:
the specified operation is computing a new value for the particular user-defined field from the user-defined field's present value.
12. The process control system set forth in claim 11 wherein:
the particular user-defined field's value belongs to an ordered set of values; and
the specified operation is an increment operation wherein the particular user-defined field's new value is a value that follows the identified field's current value in the ordered set of values.
13. The process control system set forth in claim 1 wherein:
the particular user-defined field may have a null value or a non-null value; and
what the specified operation does depends on whether the particular user-defined field has a null value.
14. The process control system set forth in claim 1 wherein:
the specified operation computes a new value for the particular user-defined field using a value from a reference field which is another field in the process record.
15. The process control system set forth in claim 14 wherein:
the particular user-defined field and the reference field have time-date values; and
the specified operation computes a time-date value for the particular user-defined field using the time-date value of the reference field.
16. The process control system set forth in claim 15 wherein:
the reference field's value is always set to the current time-date.
17. The process control system set forth in claim 1 wherein:
the particular user-defined field has a person value; and
the reference field's values belong to an ordered set of person values wherein one of the person values is a last-used person value; and
the specified operation sets the user-defined field to the next person following the last-used person value in the ordered set.
18. An improved process control system including:
a server that has access to a database system and executes program code for the process control system;
a table of process records in the database system, a process record indicating a current condition of a process being controlled by the system and certain ones of the process records including one or more user-defined fields;
a table of activity type records in the database system that define activities to be performed with regard to the process; and
a table of activity records in the database system, an activity being posted as performed for the process by making a record for the activity in the table of activity records,
the improved process control system having the improvement comprising:
a specification in at least one activity type record of an operation that sets a particular user-defined field to a value corresponding to a value of a field in an activity record; and
a first portion of the program code that is executed in conjunction with the posting of an activity of the type as performed for the process and does the operation with regard to the activity record made when the activity is posted,
whereby the value of the field in the activity record made when the activity is posted is mapped onto the particular user-defined field.
19. The improved process control system set forth in claim 18 further comprising:
a second portion of the program code which performs first queries on user-defined fields in the table of process records and separate second queries on the table of activity records,
whereby a query of the first queries may return the value of the field in the activity record that was mapped onto the particular user-defined field.
20. The improved process control system set forth in claim 18 wherein:
the activity record includes a date performed field that specifies when the activity is posted as performed; and
the operation sets the particular user-defined field to a value corresponding to the value of the date performed field.
21. The improved process control system set forth in claim 18 wherein:
the activity record includes a responsible person field that specifies the person who is responsible for performing the activity; and
the operation sets the particular user-defined field to a value corresponding to the value of the responsible person field.
22. The improved process control system set forth in claim 18 wherein:
the activity record includes a date performed field that specifies when the activity is posted as performed and a responsible person field that specifies the person who is responsible for performing the activity; and
the operation sets a first particular user-defined field using the date performed field to obtain a value specifying the date performed and a second particular user-defined field using the responsible person field to obtain a value that specifies the person who is responsible.
23. The improved process control system set forth in claim 18 wherein:
the particular user-defined field may have a null value; and
the specification of the operation specifies that the particular user-defined field be set only when the particular user-defined field has a null value.