Touchstone Re 2022 Database Reference
tModelInfo Table
AIRUserSetting Database : tModelInfo Table
Description
Stores information about the models available in the application. 
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows143
Data Space Used16.00 KB
Index Space Used48.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-generated sequential identifier for the model.int4   
 

Code that represents the model as presented in Touchstone.

For a complete list of codes, see tModel Table.

smallint2   
 

Name of the model.

varchar255   
 

Numeric code for the peril that corresponds to the model.

For a complete list of codes, see tPerilSet Table.

int4  
 

Code that represents the model as presented in the catalog.

smallint2   
 Version of the model's .dll file.varchar20  
 

Type of contract to which the model applies.

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

varchar10  
 Date and time when the model was created.date8   
 Date and time when the model was last modified.date8   
 

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

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

varchar10   
 Application version.varchar10   
 

Not used by Touchstone Re.

bit1 
((0))
 
 

Indicates whether the NGM Loss Engine is applicable for a model.

  • 1 = Yes
  • 0 = No
bit1 
((0))
 
See Also

Related Objects

AIRUserSetting Database