Touchstone 4.0 Database Documentation
tRRRR_CMPLOSS_ContractKey Table
Description
Stores information about the contracts used during the Comparative Loss analysis.
Properties
Creation Date5/31/2016 9:45 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 ContractRowIDSystem-assigned table row identifier for the contract.Integer4   
 ExposureDataSourceSID

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

For a complete list of records, see dbo.tDataSource Table.

Integer4  
 ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see dbo.tContract Table.

Integer4  
 ContractID

Unique user-defined identifier for the contract.

Corresponds to the identifier in ContractSID.

VarChar100  
Objects that depend on tRRRR_CMPLOSS_ContractKey
 Database ObjectObject TypeDescriptionDep Level
tRRRR_TTTT_CMPLOSS_ContractLOBAAL tabletRRRR_TTTT_CMPLOSS_ContractLOBAALTable

Stores the deltas for the aggregate average annual losses by contract LOB that are calculated during a Comparative Loss analysis.

tRRRR denotes the Results SID for the Comparative Loss analysis and TTTT represents the identifier for the loss analysis.
1
See Also

Related Objects

AIRResult
Locating Results for a Specific Analysis

 

 


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.