Touchstone 4.0 Database Documentation
tDefaultUWAnalysisSetting Table
Description

Stores the default underwriter analysis options. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows10
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
Primary Key AnalysisTypeCode

Code that represents the analysis type.

For a complete list of codes, see tAnalysisType Table.

VarChar10   
 ContractStatusCode

System-provided status code for the contract record.

For a complete list of codes, see tStatus Table.

VarChar15  
 AnalysisTemplateSID

Unique system-generated sequential identifier for the analysis template record record.

For a complete list of records, see tProject Table.

Integer4  
 WidgetTemplateSID

Unique system-generated sequential identifier for the widget template record.

For a complete list of records, see tWidgetTemplate Table.

Integer4  
 IsAutoRun

Indicates whether the analysis is automatically initiated when in underwriting mode.

  • 1 = Yes (initiated)
  • 0 = No (is not initiated)
Boolean1   
 TargetSID

Unique system-generated sequential identifier for the record against which the analysis is performed.  

Integer4  
Check Constraints
NameDescriptionExpression
CKC_ISAUTORUN_TDEFAULT 
([IsAutoRun]>=(0) AND [IsAutoRun]<=(1))
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.