U.S. Reinsurance

Property Cat Data Information Requirements
Based On Territory

UNITED STATES

Exposure Data

•

Policy Level Data (Street Level) including construction, yearbuilt, number of stories (see sample attached).

•	Text file
•	Spreadsheet
•	RMS Multi-Relational Import File or EDM
•	AIR Cl2Exp.mdf file or Unicede/px
•	EQE flatfile

Please include definitions of construction, occupancy and portfolio information (ie. Data as of date, clear portfolio name descriptions)

•

Aggregated Data: Unicede/1 or Unicede/2 file

•

Aggregated premium underlying modeling results/exposure

Results Data

•

Model Output from detailed runs

•	AIR 10K CLF, RMS RDM (preferably both 4.2 and 4.3), EQE Event by Event Output

Accompanying client or broker run model output we require the exposure file which generated these results and a description of the perils and options analysed in each model (ie. Uncertainty included, demand surge, use of RMS Secondary Characteristics, EQE Quality Modifiers etc.)

INTERNATIONAL

Exposure Data

•

Policy Level Data if available.

•

Aggregated Data:

•	Unicede/1 or Unicede/2 file
•	CrestaPlus file
•	Cresta Level exposure data.
•	RMS EDM
•	EQE Worldcat Locator format

Please include definitions of construction, occupancy and portfolio information (ie. Data as of date, clear portfolio name descriptions)

•

Aggregated premium underlying modeling results/exposure

Results Data
•	EQE Event by Event Output
•	RMS RDM (preferably both 4.2 and 4.3)
	Accompanying client or broker run model output we require the exposure file which generated these results and a description of the perils and options analysed in each model (ie. Uncertainty included, demand surge etc.)
•	AIR 10K CLF where applicable

Insertion For Property Cat Data Format Requirement


Field Name	Description	Required/ Optional
Policy Number	Unique Policy Number
Policy Blanket Limit	Full Policy Limit	x
Policy Attachment	Policy Retention/Attachment Point	x
Pro Rata	Company Share of Policy Blanket Limit	x
Line of Business	Line of Business Code with definitions
Policy Blanket Deductible	Policy Level Coverage Specific Terms
Policy Building Limit	Policy Level Coverage Specific Terms
Policy Building Attachment	Policy Level Coverage Specific Terms
Policy Building Deductible	Policy Level Coverage Specific Terms
Policy Contents Limit	Policy Level Coverage Specific Terms
Policy Contents Attachment	Policy Level Coverage Specific Terms
Policy Contents Deductible	Policy Level Coverage Specific Terms
Policy BI Limit	Policy Level Coverage Specific Terms
Policy BI Attachment	Policy Level Coverage Specific Terms
Policy BI Deductible	Policy Level Coverage Specific Terms
Location Number	Unique Location Number	x
Location Name	Location Name
Street Number	Street Number of Insured Property	x
Street Name	Street Name of Insured Property	x
City	City of Insured Property	x
State	State of Insured Property	x
Zip Code	Zip Code of Insured Property	x
Latitude	Location latitude
Longitude	Location longitude
Building Value	Location Specific Value	x
Building Limit	Location Specific Terms	x
Building Deductible	Location Specific Terms
Appurtenant Structure Value	Location Specific Value	x
Appurtenant Structure Limit	Location Specific Terms	x
Appurtenant Structure Deductible	Location Specific Terms
Contents Value	Location Specific Value	x
Contents Limit	Location Specific Terms	x
Contents Deductibe	Location Specific Terms
BI Value	Location Specific Value	x
BI Limit	Location Specific Terms	x
BI Deductible	Location Specific Terms
Occupancy Scheme	Definition of Occupancy Schema	x
Occupancy Code	Occupancy Code (with definitions)	x
Construction Scheme	Definition of Construction Schema	x
Construction Code	Construction Code (with definitions)	x
Year Built	Original Year of Construction	x
Number of Stories		x
Retrofit Year	Roof or Earthquake Retrofit Year
CA Mini Policy	CEA Mini Policy Identifier
EQ included	Peril identifier	x
Wind Included	Peril identifier	x
Site Specific Deductible	Location % or $ Deductible	x