Touchstone 4.0 Database Documentation
tOutputTable Table
Description

Stores the database tables where the output is stored.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows52
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OutputTableSID

Unique system-generated sequential identifier for the output table record.

  • 1 = LOSS_ByEvent
  • 2 = LOSS_ByGeo
  • 3 = LOSS_ByContract
  • 4 = LOSS_ByContractGeo
  • 5 = LOSS_ByContractSummary
  • 6 = LOSS_ByLocation
  • 7 = LOSS_ByLocationSummary
  • 8 = LOSS_ByExposureAttribute
  • 9 = LOSS_ByExposureAttributeGeo
  • 10 = LOSS_ByLayer
  • 11 = LOSS_ByReinsurance
  • 12 = LOSS_ByReinsuranceExposureAttribute
  • 13 = LOSS_AnnualEP
  • 14 = LOSS_AnnualEPSummary
  • 15 = LOSS_DimContract
  • 16 = LOSS_DimExposureAttribute
  • 17 = LOSS_DimExposureDataSource
  • 18 = LOSS_DimLayer
  • 19 = LOSS_DimLocation
  • 20 = LOSS_DimReinsurance
  • 21 = IMPACT_AnnualEP
  • 22 = IMPACT_AnnualEPSummary
  • 23 = HAZ_Detail
  • 24 = SPTL_Detail
  • 25 = LOSS_ByReinsuranceExposureAttributeGeo
  • 26 = EC_ByAccumulator
  • 27 = EC_ByContract
  • 28 = EC_ByLayer
  • 29 = EC_ByLocation
  • 30 = EC_DimAccumulator
  • 31 = EC_DimContract
  • 32 = EC_DimLayer
  • 33 = EC_DimLocation
  • 34 = EC_ByReinsurance
  • 35 = EC_DimReinsurance
  • 36 = EC_DimSubAccumulator
  • 37 = LOSS_DimContract
  • 38 = LOSS_DimLocation
  • 39 = LOSS_DimContract
  • 40 = EC_DimLocTerm
  • 41 = CATXOL_LOSS_ByEvent
  • 42 = CATXOL_EC_ByAccumulator
  • 43 = CATXOL_LOSS_ByReinsuranceGeo
  • 44 = CATXOL_EC_ByReinsuranceGeo
  • 45 = LOSS_ByMAOL
  • 46 = LOSS_ByMAOLGeo
  • 47 = LOSS_DimEvent
  • 48 = LOSS_DimCountryLOB
  • 49 = HAZ_Intensity
  • 52 = LOSS_AnnualEP_ByPeril
  • 53 = LOSS_AnnualEP_ByModel
  • 54 = LOSS_AnnualEPSummary_ByPerilModel
Integer4   
 OutputTable

Name of the output table.

These results tables reside within the AIRResult Database.

VarChar512   
 OutputTableTypeCode

Code that represents the type of output table.

For a complete list of codes, see tOutputTableType Table.

VarChar10   
 OutputDetailedAALCode

Code that represents the average annual loss target type.

For a complete list of codes, see tOutputDetailedAAL Table.

VarChar10  
 Description

Description of the output table.

VarChar1024  
Objects that depend on tOutputTable
 Database ObjectObject TypeDescriptionDep Level
tOutputTypeTableXref tabletOutputTypeTableXrefTableSystem reference table used to associate the output type tables during a Loss analysis.2
Objects that tOutputTable depends on
 Database ObjectObject TypeDescriptionDep Level
tOutputDetailedAAL tabletOutputDetailedAALTable

Stores information regarding the possible targets to which the Average Annual Loss can apply.

1
tOutputTableType tabletOutputTableTypeTable

Stores the possible output table types to which the output is written.

2
See Also

Related Objects

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