Touchstone Re 2022 Database Reference
tAreaPerilEdit Table
AIRReference Database : tAreaPerilEdit Table
Description
Stores information that the application uses to determine whether users can update exposure data at the area or subarea level for each combination of country, peril, and exposure data type.
Properties
Creation Date4/7/2017 3:40 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows25
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CountryCode

Code that represents the country.

For a complete list of codes, see tCountry Table.

varchar15   
Primary Key IntLevel1Internal identifier for the country.int4   
Primary Key PerilSetCode

Numeric code for a peril or set of perils supported for the country.

For a complete list of codes, see tPerilSet Table.

int4   
Primary Key ReinsuranceAggregateDataTypeCode

Code that represents the type of the exposure data.

For a complete list of codes, see tAggregateDataType Table.

int4   
 EditArea

Indicates whether users can edit exposure data at the area level for the combination of country, peril, and exposure data type specified in the row.

  •    
  • True
  • False
bit1  
 EditSubarea

Indicates whether users can edit exposure data at the subarea level for the combination of country, peril, and exposure data type specified in the row.

  •    
  • True
  • False
bit1  
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.