Touchstone 2022 Database Reference
tFilterAttributeActivityTypeXref Table
AIRReference Database : tFilterAttributeActivityTypeXref Table
Description
System reference table used to determine the possible activities that can be applied to specific filter attributes.
Properties
Creation Date5/10/2012 4:03 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows5
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key FilterAttributeCode

Code that represents the filter attribute type.

For a complete list of codes, see tFilterAttribute Table.

int4   
Primary Key ActivityTypeCode

Code that represents the activity type.

For a complete list of codes, see tActivityType Table.

varchar10   
 FilterTableAliasAlias used internally to develop dynamic SQL script.varchar255   
Objects that tFilterAttributeActivityTypeXref depends on
 Database ObjectObject TypeDescriptionDep Level
tActivityType tabletActivityTypeTableStores codes that represent types of activities.1
tFilterAttribute tabletFilterAttributeTable

Stores the possible filters that are available for the activities

1
See Also

Related Objects

AIRReference Database

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.