Touchstone 4.0 Database Documentation
tRRRR_LOSS_DimContract Table
Description
Stores information about contracts that experienced Loss in the analysis. This dimension table is generated when losses are saved by contract or by location.
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 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 contract type. 

For a compete list of codes, see tContractType Table.

VarChar10   
 ExposureSetNameName of the exposure set.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-defined policy.VarChar60  
 InsuredNameClient's nameVarChar60  
 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_LOSS_DimContract
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_ByContract tabletRRRR_LOSS_ByContractTableStores contract-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Contract" in the analysis Output Options.2
tRRRR_LOSS_ByContractGeo tabletRRRR_LOSS_ByContractGeoTableStores contract geography-level loss results from a detailed Loss analysis. This table is created when the user specifies "Save Loss By Contract and Geography" in the analysis Output Options.2
tRRRR_LOSS_ByContractSummary tabletRRRR_LOSS_ByContractSummaryTableStores contract summary loss results from a detailed Loss analysis. This table is created when the user selects Contract Summary in the analysis Output Options.2
Objects that tRRRR_LOSS_DimContract depends on
 Database ObjectObject TypeDescriptionDep Level
tRRRR_LOSS_DimExposureDataSource tabletRRRR_LOSS_DimExposureDataSourceTableStores information about databases that contain exposures that have been analyzed. This dimension table is created for every 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.