Touchstone 4.0 Database Documentation
tCatalogType Table
Description

Stores the possible catalogs that can be used during a Loss analysis.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows8
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CatalogTypeCode

Code that represents the catalog type.

  • ALERT = ALERT
  • CUST = Custom
  • EXT = External
  • HIST = Historical Events
  • RDS = Lloyd's Realistic Disaster Scenarios
  • REAL = RealTime
  • STC = Stochastic
  • USER = User Custom Events
VarChar10   
 CatalogType

Name of the catalog type.

Corresponds to the code in CatalogTypeCode.

VarChar40   
 DescriptionDescription of the catalog.VarChar1024  
 CatalogTypeID

System-defined identifier for the catalog type.

Corresponds to the code in CatalogTypeCode.

UnsignedTinyInt1   
Objects that depend on tCatalogType
 Database ObjectObject TypeDescriptionDep Level
tCLFINFVersion tabletCLFINFVersionTableStores information used to define the INF version during a CLF export.1
tConvertCL2CatalogType tabletConvertCL2CatalogTypeTable

Stores information regarding the catalog types used in CLASIC/2. This information is used to convert CLASIC/2 catalog types to Touchstone catalog types.

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.