Touchstone 4.0 Database Documentation
tLocTerm Table
Description

Contains information about location terms.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LocTermSIDUnique system-generated sequential identifier for the location term record.Integer4   
 LocationSID

Unique system-generated sequential identifier for the location record.

For a complete list of records, see tLocation Table.

Integer4   
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 LimitTypeCode

Code that represents the type of limit applied to the location. 

For a complete list of codes, see tLimitType Table.

VarChar10   
 Limit1Insured limit for the building (Coverage A).Double9  
 Limit2Insured limit for the appurtenant structures (Coverage B).Double9  
 Limit3

Insured limit for the contents (Coverage C).

Note that if limit type is EE, this field may contain values less than 1.0.

Double9  
 Limit4Insured limit for the time element (Coverage D).Double9  
 DeductibleTypeCode

Code that represents the type of deductible applied to the location. 

For a complete list of codes, see tDeductibleType Table.

VarChar10   
 Deductible1

Deductible amount applied to Coverage A (building). Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%).

Double9  
 Deductible2

Deductible amount applied to Coverage B (appurtenant structures). Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). 

Double9  
 Deductible3Deductible amount applied to Coverage C (contents). Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). Double9  
 Deductible4Deductible amount applied to the Coverage D (time element). Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). Double9  
 CededAmount

Ceded amount expressed as an amount of percentage.

Note that this value is provided on the user interface as a whole number percentage (e.g. 30.00) but is stored in the database as a decimal (e.g. 0.3).

Double9  
 Participation1Percentage of the location layer losses assumed by the contract. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). Single4  
 Participation2Second percentage of location layer losses assumed by the contract. Any values that are less than or equal to 1 will be interpreted as percentages (e.g., 0.12 as 12%). Single4  
 RowVersionUsed for version stamping.Binary8   
Objects that tLocTerm depends on
 Database ObjectObject TypeDescriptionDep Level
tContract tabletContractTable

Contains records for primary insurance policies.

2
tExposureSet tabletExposureSetTableContains exposure set information. An exposure set is a collection of contracts, locations, and other related information.3
tLocation tabletLocationTable

Contains geographical attributes and primary risk characteristics for each location. It serves as a reference point between Location and Contract entities.  All locations entities are tied together by the same Location SID.

1
See Also

Related Objects

AIRExposure Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.