tRRRR_DQ_AUG_ResultDetail Table

Touchstone Re 2022 Database Reference

tRRRR_DQ_AUG_ResultDetail Table

Collapse All

AIRResultRe Database : tRRRR_DQ_AUG_ResultDetail Table

Properties

Creation Date	4/11/2022 6:17 PM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	0
Data Space Used	0.00 KB
Index Space Used	0.00 KB

Columns

	Column Name	Description	Datatype	Length	Allow Nulls	Default	Formula
	ResultDetailSID		int	4
	ExposureDataSourceSID		int	4
	ExposureDataSourceName		varchar	255
	AreaName		varchar	255
	CountryCode		varchar	15
	SubareaCode		varchar	15
	SubAreaName		varchar	255
	CountryName		varchar	255
	LocationID		varchar	100
	AreaFips		varchar	15
	AreaCode		varchar	15
	PostalCode		varchar	15
	PostalName		varchar	255
	ContractSID		int	4
	ExposureViewName		varchar	255
	ExposureSetSID		int	4
	PerilSetCode		int	4
	UserLOBSID		int	4
	UserLineOfBusiness		varchar	60
	ExposureViewSID		int	4
	ConstructionCode		int	4
	Address		varchar	255
	OccupancyCode		int	4
	OccupancyName		varchar	255
	OriginalCurrency		char	3
	ReplacementValueA		float	9
	Stories		smallint	2
	ReplacementValueD		float	9
	City		varchar	255
	ConstructionName		varchar	255
	FormLOBSID		int	4
	ReplacementValueC		float	9
	TotalInsuredValue		float	9
	TotalReplacementValue		float	9
	GrossArea		float	9
	Latitude		numeric	9 (9,6)
	PolicyForm		varchar	60
	ExposureSetName		varchar	255
	ReplacementValueB		float	9
	LocationSID		int	4
	ISOBIN		varchar	14
	NewBIN		bit	1
	YearBuilt		smallint	2
	ContractID		varchar	100
	Longitude		numeric	9 (9,6)
	SubmitStatus		varchar	60
	LocPhyPropsBinData		binary	768
	GeographySID		int	4
	AuditStatusCode		int	4
	GeocoderCode		varchar	10
	GeocoderAccountId		nvarchar	50

See Also

Related Objects

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