Stores information regarding exposures views.
Touchstone 2022 Database Reference
tExposureView 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 | 24.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | ExposureViewSID | Unique system-generated sequential identifier for the exposure view record. | int | 4 | |||
| ExposureViewName | Unique user-defined name of the exposure view. | varchar | 255 | ||||
| Description | User-provided description of the exposure view. | varchar | 4000 |  | |||
| Author | User that created the exposure view. | varchar | 255 | | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ('A') | |||
| EnteredDate | Date and time when the exposure view was created. | datetime | 4 | (getutcdate()) | |||
| EditedDate | Date and time when the exposure view was last modified. | datetime | 4 | (getutcdate()) | |||
| RowVersion | Used for version stamping. | timestamp | 8 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tExposureViewDefinition | Table | Stores information about the exposure sets that are part of the exposure view optionally with a filter. | 1 |
| tExposureViewFilterXRef | Table | System reference table used to identify the exposure view filters. | 1 |
| tProjectExposureViewXref | Table | System reference table used to identify the relationship between the project and exposure views. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tProject | Table | Stores information about each project, for example, the project name and status code. | 2 |
| tProjectExposureViewXref | Table | System reference table used to identify the relationship between the project and exposure views. | 1 |