Touchstone 4.0 Database Documentation
tLossAnalysisPerilSetULOBOption Table
Stores information regarding the perils and Lines of Business analyzed during the Loss analysis. In addition, it also identifies the percentage of the loss from storm surge or precipitation flood, when applicable.
Creation Date5/31/2016 9:45 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSID

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table.

Primary Key PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Primary Key UserLineOfBusinessUser's Line of Business.VarChar255   
 PercentagePercentage of the loss that is from storm surge or precipitation flood perils.Single4   
 RowVersionUsed for version stamping.Binary8   
Objects that tLossAnalysisPerilSetULOBOption 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
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
tLossAnalysisOption tabletLossAnalysisOptionTableStores information regarding the options selected for a Loss analysis.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.