| AIRReference Database : tActivityType Table |
| Creation Date | 2/16/2011 6:00 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object | ![]() |
| Published for Replication | ![]() |
| Rows | 77 |
| Data Space Used | 8.00 KB |
| Index Space Used | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| ActivityTypeCode | Code that represents the activity type.
| varchar | 10 | |||
| ActivityType | Name of the activity type. Corresponds to the code in ActivityTypeCode. | varchar | 40 | ![]() | |||
| ActivityTypeSeqNum | Defines the sequential execution order for a set of activities. This field is only applicable for Data Quality activities. Data Quality analysis activities are numbered as follows:
| tinyint | 1 | ![]() | |||
| ParentActivityTypeCode | Code that represents the parent's activity type. Codes are identified in ActivityTypeCode. | varchar | 10 | ![]() | |||
| Description |
Description of the activity type.
| varchar | 1024 | ![]() | |||
| IsEnabled | Indicates whether the activity type is capable of assignment by the HPC Worker Host, thereby making it visible in the Activity Monitor on the user interface.
| bit | 1 | dbo.D_0 | |||
| IsDistributable | Indicates whether the activity type can be distributed to more than one HPC Worker Host core.
| bit | 1 | dbo.D_1 | |||
| ISSystem | Indicates whether the activity type is initiated by the system.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
![]() | tActivityTypeActivityStageXref | Table | System reference table used by the Activity Monitor to determine the current stage of the activity. | 1 |