Touchstone 4.0 Database Documentation
tRRRR_NONCAT_DimContract Table
Stores information about contracts that experienced loss in a non-catastrophe loss analysis. This dimension table is created when losses are saved by contract.
Creation Date5/31/2016 9:45 AM
Text File Group
System Object
Published for Replication
Data Space Used0.00 KB
Index Space Used0.00 KB
 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.

Primary Key ContractSID

Unique system-generated sequential identifier for the contract record.

For a complete list of records, see tContract Table.

 ContractIDUnique user-provided identifier for the contract.VarChar100  
 InsuredNameClient's name.VarChar60  
 ExposureSetNameUnique user-defined name for the exposure set.VarChar255  
 UserLineOfBusinessName of the user line of business.VarChar60  

Code for the contract type.

For a complete list of codes, see dbo.tContractType Table.


ISO 3-character code for the currency.

For a complete list of codes, see dbo.tCurrency Table.

 PolicyFormUser-defined policy.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  

Code for the submission status.

For a complete list of codes, see dbo.tSubmitStatus Table.

 InceptionDateInception date of the non-catastrophe contract.  Also referred to as the Effective FROM Date.DBTimeStamp4  
 ExpirationDateNon-catastrophe contract expiration date. Also referred to as the Effective TO Date.DBTimeStamp4  
Objects that depend on tRRRR_NONCAT_DimContract
 Database ObjectObject TypeDescriptionDep Level
tRRRR_NONCAT_ByContract tabletRRRR_NONCAT_ByContractTableStores contract-level loss results from a non-catastrophe loss analysis.  This table is created when the user specifies "Save Loss by Contract" in the analysis Output Options.1
See Also

Related Objects

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.