Touchstone 4.0 Database Documentation
tModelInfo Table
Description
Stores information regarding the models currently avaible with Touchstone. 
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows78
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ModelSIDUnique system-generated sequential identifier for the model.Integer4   
 ModelCode

Code that represents the model as presented in Touchstone.

For a complete list of codes, see dbo.tModel Table.

UnsignedTinyInt1   
 Model

Name of the model.

VarChar255   
 PerilSetCode

Numeric code for the peril that corresponds to the model.

For a complete list of codes, see dbo.tPerilSet Table.

Integer4  
 CatalogModelCode

Code that represents the model as presented in the catalog.

UnsignedTinyInt1   
 ModelDLLVersionVersion of the model's .dll file.VarChar20  
 ModelLOB

Type of contract to which the model applies.

For a complete list of codes, see dbo.tContractType Table.

VarChar10  
 EnteredDateDate and time when the model was created.VarWChar10   
 EditedDateDate and time when the model was last modified.VarWChar10   
 StatusCode

System-provided status code for the record in the table.

For a complete list of codes, see dbo.tStatus Table.

VarChar10   
 ModelInfoProductVersionApplication version.VarChar10   
See Also

Related Objects

AIRUserSetting 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.