System reference table used by the Activity Monitor to determine the current stage of the activity.
CEDE 2024 (12.0) Database Reference
tActivityTypeActivityStageXref Table
| Creation Date | 2/16/2011 6:00 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 213 |
| 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 |