Stores exposure set information from each exposure database on the server.
Touchstone Re 2022 Database Reference
tExposureSet Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 1 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ExposureSetSID | Unique system-generated sequential identifier for the exposure set. | int | 4 | |||
| | DataSourceSID | Unique system-generated sequential identifier for the data source record that stores the project data. | int | 4 | |||
| ExposureSetName | Unique user-defined name of the exposure set. | varchar | 300 |  | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ||||
| EnteredDate | Date and time when the exposure set was created. | datetime | 4 | ('getutcdate()') | |||
| EditedDate | Date and time when the exposure set was last modified. | datetime | 4 | ('getutcdate()') |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tActivity | Table | 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. | 1 |
| tActivityOutput | Table | 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. | 2 |
| tActivityOutputDetail | Table | Stores information about the task outputs of each activity output. The application writes to the table during each task. | 3 |
| tAggregateAnalysisParticipationOption | Table | Stores information about the participation option specified for each loss analysis. | 2 |
| tAggregateAnalysisTerrorismOption | Table | Stores information about the terrorism option specified for each loss analysis. | 1 |
| tAggregateLossAnalysisOption | Table | Stores information about the options specified for each loss analysis. | 1 |
| tAggregateLossAnalysisOutputOption | Table | Stores information about the output options specified for each loss analysis. | 2 |
| tAggregateLossAnalysisZoneSetXref | Table | System reference table that identifies the zone sets associated with each loss analysis. | 2 |
| tAnalysis | Table | Stores information about each analysis. | 1 |
| tAnalysisTargetXref | Table | System reference table used to the identify the target of each analysis. | 2 |
| tLossAnalysisCustomFrequencySetXref | Table | Stores the loss analysis information associated with the custom frequency set. | 3 |
| tLossAnalysisOption | Table | 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. | 2 |