Touchstone 4.0 Database Documentation
tActivityTypeActivityStageXref Table
Description
System reference table used by the Activity Monitor to determine the current stage of the activity.
Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows99
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ActivityTypeCode

Code for the activity type.

For a complete list of codes, see tActivityType Table.

VarChar10   
Primary Key ActivityStageID

Identifier for the current stage of the activity.

UnsignedTinyInt1   
 ActivityStageCode

Code for the current stage of the activity; corresponds to the identifier in ActivityStageID.

For a complete list of codes, see tActivityStage Table.

VarChar10   
 ActivityStageWeightUsed 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.UnsignedTinyInt1   
Objects that tActivityTypeActivityStageXref depends on
 Database ObjectObject TypeDescriptionDep Level
tActivityStage tabletActivityStageTableUsed by all jobs to identify the activity's current stage in the process.1
tActivityType tabletActivityTypeTableDefines the type of activity.1
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.