Touchstone Re 2022 Database Reference
tUSMPCIType Table
AIRReference Database : tUSMPCIType Table
Description

Stores codes that represent types of value associated with the Multiple Peril Crop Insurance (MPCI) Model for the United States (U.S.).

For example, Touchstone Re stores the government-specified and user-specified Standard Reinsurance Agreement (SRA) group numbers associated with each U.S. (United States) state in the tUSMPCIGroupAssignments Table. In the context of the table, the USMPCITypeCode indicates whether the group number in a given row is government specified or user specified.

Properties
Creation Date9/21/2018 11:47 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows3
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key USMPCITypeCode

Code that represents a type of value associated with the MPCI Model for the U.S.

  • 1 = Default (AIR- or government-defined)
  • 2 = Custom (user-defined)
  • 3 = Calculated
tinyint1   
 USMPCIType

Name of the type of value.

varchar40  
 DescriptionDescription of the type of value.varchar1024  
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.