AIRProject Database

Description

The AIRProject database stores information about the activities you perform in Touchstone Re.

The following tables apply only to Touchstone, but may appear in your installation for internal purposes:

tActivityHpcJob
tActivityParentXref
tActivityTargetStatus
tAnalysisFilterXRef
tClashAnalysisOption
tComparativeLossAnalysisOption
tComparativeLossAnalysisTargetOption
tDataChangeTracking
tDataChangeTrackingHash
tDataQualityAnalysisOption
tDataQualityAnalysisOutputOption
tDataServer
tDataSource
tDataSourceActivityOption
tDBVersion
tDQAnalysisRule
tDQAnalysisRuleSet
tDQAnalysisRuleSetRuleSubTypeSelected
tDQAnalysisSetting
tDQIndustryFilterLOB
tECAAreaZoneOption
tECACustomSaveOption
tECARingDefinition
tECARingGeoMatchLevelOption
tECARingLandmarkOption
tECARingLocationList
tECARingOption
tECASpatialDataSetBucketDefinition
tECASpatialDataSetBucketDetail
tECASpatialDataSetOption
tECASpatialEventOption
tECASpatialLossOption
tExportActivityFilter
tExportActivityOption
tExposureConcentrationAnalysisOption
tExposureSet
tExposureView
tExposureViewDefinition
tExposureViewFilterXRef
tEXPSAnalysisOutputOption
tFilter
tHazardAnalysisAttributeOption
tHazardAnalysisOption
tHazardAnalysisOutputOption
tImpactAnalysisAdditionalOption
tImpactAnalysisOption
tImportActivityOption
tIntensityAttributeOption
tLossAnalysisEarthquakeOption
tLossAnalysisFloodOption
tLossAnalysisPerilSetULOBOption
tLossAnalysisSTStormOption
tLossAnalysisTerrorismOption
tLossAnalysisZoneOption
tNonCatAnalysisOption
tProject
tProjectExposureViewXref
tShrinkQueue

For more information about the tables, see Touchstone Database Reference on AIR's Developer Zone.

The tMigrationRecordCountsLoad and tMigrationRecordCountsTransform tables are for internal use only, and have been excluded from the reference.

Schema Diagram

You can view a diagram of the AIRProject database in Schema Diagrams.

Tables

Table	Description
tActivity	Stores information about each activity, including the unique sequential identifiers for analyses and activities. You can use the information in the table to find analysis results.
tActivityOutput	Stores the identifier, status, and the file path for the output of each activity. An activity can include one or more tasks. Consequently, an activity output is a logical grouping of one or more task outputs.
tActivityOutputDetail	Stores information about the task outputs of each activity output. The application writes to the table during each task.
tAggregateAnalysisJapanCFLOption	Stores information about the reinsurance program option specified at the time of an aggregate loss analysis.
tAggregateAnalysisParticipationOption	Stores information about the participation option specified for each loss analysis.
tAggregateAnalysisTerrorismOption	Stores information about the terrorism option specified for each loss analysis.
tAggregateLossAnalysisOption	Stores information about the options specified for each loss analysis.
tAggregateLossAnalysisOutputOption	Stores information about the output options specified for each loss analysis.
tAggregateLossAnalysisZoneSetXref	System reference table that identifies the zone sets associated with each loss analysis.
tAnalysis	Stores information about each analysis.
tAnalysisTargetXref	System reference table used to the identify the target of each analysis.
tAuditHistory	Stores audit records. The application creates audit records for changes users make, such as: Saving a change in the Administration Console Running an analysis Creating, updating, or deleting exposure data, and so on
tAuditHistoryParentObjectXRef	System reference table used to identify the parent object associated with each audit record. A parent object is a higher-level container for an object. For example, the parent object for an exposure set is a company.
tDbHistory	Stores information about any packages applied to the database.
tExposureSet	Stores exposure set information from each exposure database on the server.
tLossAnalysisCustomFrequencySetXref	Stores the loss analysis information associated with the custom frequency set.
tLossAnalysisOption	Stores some of the options used during aggregate loss analyses. Touchstone Re stores additional options in tAggregateLossAnalysisOption Table. Columns that do not apply to Touchstone Re have values of null.
tSIDControl	Contains a list of all SID tables and the last SID value in use for each table. After each insert operation, the SID value will update.
tUpgradeLog	Stores information about upgrade scripts.