| Table | Description |
|---|---|
| tActivity | Stores information about each activity, including the unique sequential identifiers for analyses and activities. You can use the information in the table to find analysis results. |
| tActivityOutput | Stores the identifier, status, and the file path for the output of each activity. An activity can include one or more tasks. Consequently, an activity output is a logical grouping of one or more task outputs. |
| tActivityOutputDetail | Stores information about the task outputs of each activity output. The application writes to the table during each task. |
| tAggregateAnalysisJapanCFLOption | Stores information about the reinsurance program option specified at the time of an aggregate loss analysis. |
| tAggregateAnalysisParticipationOption | Stores information about the participation option specified for each loss analysis. |
| tAggregateAnalysisTerrorismOption | Stores information about the terrorism option specified for each loss analysis. |
| tAggregateLossAnalysisOption | Stores information about the options specified for each loss analysis. |
| tAggregateLossAnalysisOutputOption | Stores information about the output options specified for each loss analysis. |
| tAggregateLossAnalysisZoneSetXref | System reference table that identifies the zone sets associated with each loss analysis. |
| tAnalysis | Stores information about each analysis. |
| tAnalysisTargetXref | System reference table used to the identify the target of each analysis. |
| tAuditHistory | Stores audit records. The application creates audit records for changes users make, such as:
|
| tAuditHistoryParentObjectXRef | System reference table used to identify the parent object associated with each audit record. A parent object is a higher-level container for an object. For example, the parent object for an exposure set is a company. |
| tDbHistory | Stores information about any packages applied to the database. |
| tExposureSet | Stores exposure set information from each exposure database on the server. |
| tLossAnalysisCustomFrequencySetXref | Stores the loss analysis information associated with the custom frequency set. |
| tLossAnalysisOption | Stores some of the options used during aggregate loss analyses. Touchstone Re stores additional options in tAggregateLossAnalysisOption Table. Columns that do not apply to Touchstone Re have values of null. |
| tSIDControl | Contains a list of all SID tables and the last SID value in use for each table. After each insert operation, the SID value will update. |
| tUpgradeLog | Stores information about upgrade scripts. |
Touchstone Re 2022 Database Reference
dbo Schema