System reference table used to associate the output type tables during a loss analysis.
Touchstone 2022 Database Reference
tOutputTypeTableXref Table
| Creation Date | 6/30/2011 10:33 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 724 |
| Data Space Used | 32.00 KB |
| Index Space Used | 176.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | OutputTypeCode | Code that represents the output type. For a complete list of codes, see tOutputType Table. | varchar | 10 | |||
| | OutputTableSID | Unique system-generated sequential identifier for the output table. For a complete list of records, see tOutputTable Table. | int | 4 | |||
| PrimaryFactTableSID | Unique system-generated sequential identifier for the primary fact table, which is used to generate the content of the OutputTableSID. For example, if the OutputTableSID is 17, the primary support table is 5. For a complete list of records, see tOutputTable Table | int | 4 |  | |||
| SecondaryFactTableSID | Unique system-generated sequential identifier for the primary fact table, which is used to generate the content of the OutputTableSID. For example, if the OutputTableSID is 17, the secondary support table is 7. For a complete list of records, see tOutputTable Table | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tAnalysisType | Table | Stores the analysis types available in the application. | 2 |
| tExposureAttributeType | Table | Stores the possible types of exposure attributes used for the Loss analysis results options. | 3 |
| tOutputTable | Table | Stores the database tables where the output is stored. | 1 |
| tOutputTableType | Table | Stores the possible output table types to which the output is written. | 2 |
| tOutputType | Table | Stores the possible types of output for each analysis type. | 1 |
| tResultGroupBy | Table | Stores the possibly categorization (grouping) types for Data Quality analysis results. | 3 |
| tResultViewBy | Table | Stores information identifying the options for viewing results in Touchstone. | 2 |