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 |