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

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.

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

Unique system-generated sequential identifier for the cluster set associated with the cluster.

For a complete list of records, see tIndiaMPCIClusterSet Table.

int4   
Primary Key 

Unique system-generated sequential identifier for the state in India included in the cluster.

For a complete list of records, see tIndiaCropGeography Table.

int4   
Primary Key 

Unique system-generated sequential identifier for the district in India included in the cluster.

For a complete list of records, see tIndiaCropGeography Table.

int4   
 Identifier for the cluster.int4   
Objects that tIndiaMPCICluster depends on
 Database ObjectObject TypeDescriptionDep Level
tIndiaMPCIClusterSet tabletIndiaMPCIClusterSetTable

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.

1
See Also

Related Objects

AIRUserSetting Database