Touchstone 4.0 Database Documentation
tConvertEDCPeril Table
Description

Stores information regarding the peril codes when using the exposure data conversion tool (EDC). This information is used when using the EDCto convert RMS peril codes for use in Touchstone.

Properties
Creation Date11/3/2011 10:37 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows7
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EDCPerilCode

Code that represents the peril in the EDC.

  • 1 = Earthquake (PEA)
  • 2 = Hurricane (PWH)
  • 3 = Severe Storm (PWX)
  • 4 = Flood (PFL)
  • 5 = Fire (PEF)
  • 6 = Terrorism (PTR)
  • 7 = Workers' Compensation (Not applicable)
Integer4   
 EDCPeril

Name of the EDC peril.

Corresponds to the code in EDCPerilCode.

VarChar40   
 UPXPeril

Code for the peril as used in a UPX record.

Corresponds to the code in EDCPerilCode.

VarChar10  
 IsActive

Indicates whether the peril is available for use.

  • 1 = Yes (available
  • No (not available)
Boolean1 dbo.D_1 
Check Constraints
NameDescriptionExpression
CKC_ISACTIVE_TCONVERT 
([IsActive]>=(0) AND [IsActive]<=(1))
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.