Stores information about each export.
Touchstone 2022 Database Reference
tExportActivityOption Table
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ActivitySID | Unique system-generated sequential identifier for the activity record. For a complete list of records, see tActivity Table. | int | 4 | |||
| ExportTypeCode | Code that represents the type of the exported data. For a complete list of codes, see tExportType Table. | varchar | 10 | ||||
| ExportTargetTypeCode | Code that represents the target of the export. For a complete list of codes, see tExportTargetType Table. | varchar | 20 | ||||
| ExportTargetSID | Unique system-generated sequential identifier for the target of the export. | int | 4 | ||||
| FileBaseName | Name of the saved file that contains the exported data. | varchar | 1000 |  | |||
| DestinationPath | Location of the saved file that contains the exported data. | varchar | 4000 | | |||
| AdditionalOption | XML expression for the additional options used during export. Used internally by Touchstone. | xml | 0 | | |||
| IsSingleExposureSet | When you export multiple exposure view(s), indicates whether to merge the exposure sets into one exposure set.
| bit | 1 | ((0)) | |||
| ExposureSetName | User-specified name for the exposure set. | varchar | 255 | | |||
| ExposureDataSourceSID | Unique system-generated sequential identifier for the data source that stores the exposure data. For a complete list of records, see tDataSource Table. | int | 4 | | |||
| Comments | User-specified comment about the export. | varchar | 8000 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tExportActivityFilter | Table | Stores information about the filter attribute applied during each export. | 1 |
| 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 |
| tAnalysis | Table | Stores information about each analysis. | 2 |
| tDataServer | Table | Stores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server. | 2 |
| tDataSource | Table | Stores information about the databases registered with the application, for example, the exposure and results databases. | 1 |
| tExposureSet | Table | Stores exposure set information from each exposure database on the server. | 2 |
| tProject | Table | Stores information about each project, for example, the project name and status code. | 2 |