Touchstone 2022 Database Reference
tLossAnalysisEarthquakeOption Table
AIRProject Database : tLossAnalysisEarthquakeOption Table
Description

Stores information about the earthquake options applied during detailed loss analyses.

If the earthquake peril is not included in a given analysis, the table does not include a row for the analysis.

Properties
Creation Date4/4/2022 3:02 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 

Unique system-generated sequential identifier for the analysis  record.

For a complete list of records, see tAnalysis Table.

int4   
 

Indicates whether the analysis included induced events, such as seismic events caused by fracking, in the analysis.

  • 1 = Yes (include)
  • 0 = No (do not include)
bit1   
 Used for version stamping.timestamp8   
 

Indicates whether the analysis included additional events in the event catalog to account for increased seismicity beyond the historical average.

  • 1 = Yes (include)
  • 0 = No (do not include)

Increased seismicity is supported only for New Zealand.

bit1 
((0))
 
Objects that tLossAnalysisEarthquakeOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each analysis.2
tDataServer tabletDataServerTableStores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server.4
tDataSource tabletDataSourceTable

Stores information about the databases registered with the application, for example, the exposure and results databases.

3
tExposureSet tabletExposureSetTableStores exposure set information from each exposure database on the server.4
tLossAnalysisOption tabletLossAnalysisOptionTable

Stores information about the general options specified for each loss analysis.

1
tProject tabletProjectTableStores information about each project, for example, the project name and status code.3
See Also

Related Objects

AIRProject Database