tIndiaCropGeography Table

Description

Stores general geographic information that Touchstone Re uses to support the Multiple Peril Crop Insurance (MPCI) Model for India. For example, the table stores the areas and subareas that the model supports.

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

In the Exposure Set pane of the Touchstone Re user interface, India is listed as two countries: India and India Crop. For India, Touchstone Re uses the geographical information in tGeography Table. For India Crop, Touchstone Re uses the geographic information in tIndiaCropGeography Table.

Properties

Creation Date	10/30/2018 9:26 AM
File Group	PRIMARY
Text File Group
System Object
Published for Replication
Rows	754
Data Space Used	120.00 KB
Index Space Used	16.00 KB

Columns

Column Name	Description	Datatype	Length	Default
GeographySID	Unique system-generated sequential identifier for the geography record.	int	4
ParentGeographySID	Unique system-generated sequential identifier for the parent geography record. A parent geography is a geographic region that includes another geographic region. For example, theParentGeographySID for a PostalCode record is the GeographySID for the subarea that contains the PostalCode.	int	4
GeoLevelCode	Code that represents the resolution of the geography record. For a complete list of codes, see tGeoLevel Table.	varchar	10
CountryCode	ISO 2-character code for the country associated with the geography record. For a complete list of codes, see tCountry Table.	varchar	15
CountryName	Name of the country associated with the geography record.	varchar	255
CRESTACode	CRESTA code associated with the geography record.	varchar	15
CRESTAName	Name of the CRESTA associated with the geography record.	varchar	255
AreaCode	Code for the area associated with the geography record.	varchar	15
AreaName	Name of the area associated with the geography record.	varchar	255
SubareaCode	Code for the subarea associated with the geography record.	varchar	15
SubareaName	Name of the subarea associated with the geography record.	varchar	255
PostalCode	Postal code associated with the geography record.	varchar	15
PostalName	Name of the postal code associated with the geography record.	varchar	255
Subarea2Code	Code for the subarea 2 geography level associated with the geography record.	varchar	15
Subarea2Name	Name of the subarea 2 geography level associated with the geography record.	varchar	255
Latitude	Latitude associated with the geography record.	numeric	9 (9,6)
Longitude	Longitude associated with the geography record.	numeric	9 (9,6)
CountryGeographySID	Unique system-generated sequential identifier for the country.	int	4
CRESTAGeographySID	Unique system-generated sequential identifier for the CRESTA.	int	4
AreaGeographySID	Unique system-generated sequential identifier for the area.	int	4
SubAreaGeographySID	Unique system-generated sequential identifier for the subarea.	int	4
PostalGeographySID	Unique system-generated sequential identifier for the postal code.	int	4
Subarea2GeographySID	Unique system-generated sequential identifier for the subarea 2 geography level.	int	4
RemappedGeographySID	Unique system-generated sequential identifier for the standard Touchstone Re geography associated with the MPCI Model for India geography record. For a complete list of records, see tGeography Table.	int	4
GuidExternal	Globally unique identifier associated with the geography record from TblAreaExternal.	binary	16
GuidRemodel	Globally unique identifier for the remodeled geography record. The identifier joins the tGeography and TblAreaExternal tables.	binary	16
AreaScheme	Code that represents the area scheme for the country. The area scheme specifies the type of area that the application supports for the country, for example, CRESTA.	smallint	2
IsReinsuranceGeography	Indicates whether the geography record can be used for aggregate loss analyses. 1 = Yes (can be used) 0 = No (cannot be used)	bit	1	((0))
IsDetailLossGeography	Indicates whether the geography record can be used for detailed loss analyses. 1 = Yes (can be used) 0 = No (cannot be used)	bit	1

Related Objects

AIRGeography Database