Question
Infosys ltd
IN
Last activity: 21 Apr 2016 9:42 EDT
PC_HISOTRY_WORK Table cloumn description
Required each and every column description of PC_HISOTRY_WORK table in PEGARULES database
Pegasystems Inc.
IN
Following are few important column details:
The standard properties in the History-Work- class support the work item history display from the History button (
).
This table identifies several of these, in alphabetical order, ignoring the first two characters of the name. Many properties are present only in work history records of specific types. Properties marked (
) are computed by standard rules. Do not set values for these properties in your application rules, except in unusual situations where you intend to override the default computation.
Following are few important column details:
The standard properties in the History-Work- class support the work item history display from the History button ().
This table identifies several of these, in alphabetical order, ignoring the first two characters of the name. Many properties are present only in work history records of specific types. Properties marked () are computed by standard rules. Do not set values for these properties in your application rules, except in unusual situations where you intend to override the default computation.
Property |
Purpose |
More |
| pxAssignment ElapsedTime |
Duration in seconds of all operator time spent on this assignment. For pyHistoryType "F" only.
|
|
| pyHistoryType | A single letter indicating the event that caused this history instance to be created. For example, F indicates that a connector flow action was completed, and M indicates that a memo was added.
|
history type |
| pyPerformer | Operator ID or "system, for history instances created by an agent.
|
|
| pyPerformActionTime | Elapsed time in seconds that the Perform user form was presented when a user processed the most recent (connector or local) flow action. ForpyHistoryType F and L only.
|
Assignment statistics |
| pyPerformAssignmentTime | Elapsed time in seconds spent by the current user on one or more flow actions this assignment. Sum of one or more time intervals from the initial presentation of a Perform user form until it is closed or another appears. If this operator has completed three local actions and then finally completed a connector action, this is be the sum of four times. Time spent on this assignment by other users is not included. For pyHistoryType F only.
|
Assignment statistics |
| pyPerformTaskTime | Similar to pyPerformAssignmentTime but not reset upon reassign. Sum of pyPerformAssignmentTimevalues for all users who worked on the assignment, in seconds. For pyHistoryType "F" only.
|
Assignment statistics |
| pyWorkClass | Work type of the work item. In some applications, a work item's work type may change during processing (to another type within the same work pool.)
|
work type |