Touchstone 4.0 Database Documentation
tRRRR_EC_DimContract Table
Description
Stores attributes associated with each contract. These attributes are displayed on the user interface together with data from table tRRRR_EC_ByContract Table.
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 ExposureDataSourceSID

Unique system-generated sequential identifier for the exposure data source record.

For a complete list of records, see tDataSource Table.

Integer4   
Primary Key ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

Integer4   
 ContractTypeCode

Code that represents the type of contract. 

For a complete list of codes, see tContractType Table.

VarChar10  
 ExposureSetName

Code that represents the type of contract. 

For a complete list of codes, see tContractType Table.

VarChar255  
 ContractIDUnique user-provided identifier for the contract.VarChar100   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4  
 UserLineOfBusinessUser's Line of Business.VarChar60  
 PolicyFormUser-specified policy form.VarChar60  
 InsuredNameClient's name.VarChar60  
 UserDefined1User-defined field 1.VarChar60  
 UserDefined2User-defined field 2.VarChar60  
 UserDefined3User-defined field 3.VarChar60  
 UserDefined4User-defined field 4.VarChar60  
 UserDefined5User-defined field 5.VarChar60  
Objects that depend on tRRRR_EC_DimContract
 Database ObjectObject TypeDescriptionDep Level
tRRRR_EC_ByContract tabletRRRR_EC_ByContractTableUnique system-generated sequential identifier for the zones, rings, or polygons in which exposure concentration is accumulated for a specified peril in a Geospatial analysis.Stores the results of the Geospatial analysis at the contract level.1
See Also

Related Objects

AIRExposureSummary 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.