tOutputTable Table

Touchstone 2022 Database Reference

tOutputTable Table

Collapse All

AIRReference Database : tOutputTable Table

Description

Stores the database tables where the output is stored.

Properties

Creation Date	2/16/2011 6:00 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	75
Data Space Used	8.00 KB
Index Space Used	40.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	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 55 = LOSS_ByContractGeoLayer 56 = LOSS_ByZone 57 = LOSS_ByContractZone 58 = LOSS_ByContractZoneLayer 59 = LOSS_ByExposureAttributeZone 60 = LOSS_DimZone 61 = LOSS_AnnualEP_ByZone 62 = LOSS_AnnualEPSummary_ByZone 63 = LOSS_AnnualEP_ByPerilByZone 64 = LOSS_AnnualEPSummary_ByPerilByZone 65 = LOSS_Stats 66 = LOSS_ByReinsuranceGeo 67 = LOSS_ZoneStats	int	4
	OutputTable	Name of the output table. These results tables reside within the AIRResult Database.	varchar	512
	OutputTableTypeCode	Code that represents the type of output table. For a complete list of codes, see tOutputTableType Table.	varchar	10
	OutputDetailedAALCode	Code that represents the average annual loss target type. For a complete list of codes, see tOutputDetailedAAL Table.	varchar	10
	Description	Description of the output table.	varchar	1024

Objects that depend on tOutputTable

	Database Object	Object Type	Description	Dep Level
	tOutputTypeTableXref	Table	System reference table used to associate the output type tables during a loss analysis.	1
	tOutputTypPerspectiveXref_NGM	Table	System reference table that stores the financial perspective codes that correspond to each output table type.	1

Objects that tOutputTable depends on

	Database Object	Object Type	Description	Dep Level
	tOutputDetailedAAL	Table	Stores information regarding the possible targets to which the Average Annual Loss can apply.	1
	tOutputTableType	Table	Stores the possible output table types to which the output is written.	1

See Also

Related Objects

AIRReference Database

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.