Touchstone 4.0 Database Documentation
tComparativeLossAnalysisTargetOption Table
Description
Stores information regarding the target analysis in a Comparative Loss analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSID

Unique system-generated sequential identifier for the analysis record.

For a complete list of records, see dbo.tAnalysis Table.

Integer4   
Primary Key AnalysisTargetIDIdentifier of the analysis target on which the analysis is going to be performed.Integer4   
 EventSetSID

Unique system-generated sequential identifier for the event set record.

For a complete list of records, see dbo.tEventSet Table.

Integer4   
 SaveGroundUp

Indicates whether Ground-Up loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveRetained

Indicates whether Retained loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SavePreLayerGross

Indicates whether Pre-Layer Gross loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveGrossIndicates whether Gross loss results are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveNetOfPreCATIndicates whether Net-of-Pre loss results are saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SavePostCATNet

Indicates whether Net-of-Post loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
Check Constraints
NameDescriptionExpression
CKC_SAVEGROUNDUP_TCOMPARA 
([SaveGroundUp]>=(0) AND [SaveGroundUp]<=(1))
CKC_SAVENETOFPRECAT_TCOMPARA 
([SaveNetOfPreCAT]>=(0) AND [SaveNetOfPreCAT]<=(1))
CKC_SAVEPOSTCATNET_TCOMPARA 
([SavePostCATNet]>=(0) AND [SavePostCATNet]<=(1))
CKC_SAVEPRELAYERGROSS_TCOMPARA 
([SavePreLayerGross]>=(0) AND [SavePreLayerGross]<=(1))
CKC_SAVERETAINED_TCOMPARA 
([SaveRetained]>=(0) AND [SaveRetained]<=(1))
Objects that tComparativeLossAnalysisTargetOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tAnalysisTargetXref tabletAnalysisTargetXrefTableSystem reference table used to the identify the target on which the analysis is going to be performed.2
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

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