Touchstone Re 2022 Database Reference
tIndiaMPCIClusterSet Table
AIRUserSetting Database : tIndiaMPCIClusterSet Table
Description

Stores information about each cluster set defined in the Administration Console for the Multiple Peril Crop Insurance (MPCI) Model for India. A cluster set is a collection of government-defined group of districts created to smooth out the risk to crop insurance providers.

The geographic information in the table is specific to the MPCI peril.

Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows1
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the cluster set.

int4   
 Unique system-generated sequential identifier for the business unit associated with the cluster set.int4   
 Name of a cluster associated with the cluster set.nvarchar255   
 

Indicates whether the cluster set is an AIR-standard cluster set.

  • 1 = Yes (AIR standard)
  • 0 = No (user defined)
bit1   
 Date and time the cluster was created.date8   
 Date and time the cluster was last edited.date8   
Objects that depend on tIndiaMPCIClusterSet
 Database ObjectObject TypeDescriptionDep Level
tIndiaMPCICluster tabletIndiaMPCIClusterTable

Stores information about each cluster defined in the Administration Console for the Multiple Peril Crop Insurance (MPCI) Model for India. A cluster is a government-defined group of districts created to smooth out the risk to crop insurance providers.

The geographic information in the table is specific to the MPCI peril.

1
See Also

Related Objects

AIRUserSetting Database