Touchstone 4.0 Database Documentation
tRRRR_NONCAT_ByContract Table
Description
Stores contract-level loss results from a non-catastrophe detailed loss analysis.  This table is created when the user specifies "Save Loss by Contract" in the analysis Output Options.
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   
 GroundUpLossGround-Up loss value prior to the application of terms. For reinsurance, this is the ground-up loss for the treaty.Double9  
 GrossLossGross loss value, which is the loss after layer-level terms are applied.Double9  
 RetainedLossRetained loss value, which is the Ground-Up loss minus the insured Gross loss.Double9  
 NetOfPreCATLossNet-of-Pre Catastrophe loss value, which is the expected net loss value before the application of catastrophe excess of loss reinsurance.Double9  
Objects that tRRRR_NONCAT_ByContract depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_NONCAT_DimContract tabletRRRR_NONCAT_DimContractTableStores information about contracts that experienced loss in a non-catastrophe loss analysis. This dimension table is created when losses are saved by contract.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.