System reference table used by the Activity Monitor to determine the current stage of the activity.
Creation Date | 2/16/2011 6:00 PM |
File Group | PRIMARY |
Text File Group | |
System Object | |
Published for Replication | |
Rows | 196 |
Data Space Used | 8.00 KB |
Index Space Used | 40.00 KB |
Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
---|---|---|---|---|---|---|---|
ActivityTypeCode | Code for the activity type. For a complete list of codes, see tActivityType Table. | varchar | 10 | ||||
ActivityStageID | Identifier for the current stage of the activity. | tinyint | 1 | ||||
ActivityStageCode | Code for the current stage of the activity; corresponds to the identifier in ActivityStageID. For a complete list of codes, see tActivityStage Table. | varchar | 10 | ||||
ActivityStageWeight | Used to provide the status on the overall activity/job, which is done by summing all the previous stages at a particular time. To enable this calculation, each stage is given a weight based on the time spent by activity type. | tinyint | 1 |
Database Object | Object Type | Description | Dep Level | |
---|---|---|---|---|
tActivityType | Table | Stores codes that represent types of activities. | 1 |