Touchstone Re 2022 Database Reference
tRRRR_LOSS_USR_TreatyTracking Table
AIRResultRe Database : tRRRR_LOSS_USR_TreatyTracking Table
Description

Stores results by treaty for one portfolio loss analysis saved to the Analyze Re cloud.

When you configure a portfolio loss analysis, you can optionally enable Touchstone Re to upload the results of the analysis to the Analyze Re cloud, and then use the results to speed up future analyses.

Touchstone Re uploads loss results by treaty.

Properties
Creation Date4/11/2022 6:17 PM
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 For internal use.int4   
Primary Key 

Unique system-generated sequential identifier for the reinsurance treaty.

For a complete list of records, see tReinsuranceTreaty Table.

int4   
 

Code that represents the status of the upload job.

  • 0 = No results (zero losses)
  • 1 = Completed
  • 2 = Failed
tinyint1   
 Location of the treaty loss result data.varchar255  
 Date and time that the treaty loss result data was uploaded.datetime4
(getdate())
 
See Also

Related Objects

AIRResultRe Database