Stores information regarding the possible targets to which the Average Annual Loss can apply.
Touchstone 2022 Database Reference
tOutputDetailedAAL Table
Stores information regarding the possible targets to which the Average Annual Loss can apply.
| Creation Date | 1/11/2012 11:28 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 2 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | OutputDetailedAALCode | Code that represents the the average annual loss target type.
| varchar | 10 | |||
| OutputDetailedAAL | Name of the target type. Corresponds to the code in OutputDetailedAALCode. | varchar | 40 | ||||
| Description | Description of the target type. | varchar | 1024 |  |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tDQRuleSetType | Table | Stores the primary rule sets that can be applied during a Data Quality analysis. | 3 |
| tHazardAttribute | Table | Stores the possible the attributes of a hazard. | 3 |
| tIntensityAttribute | Table | Stores information about the intensity attributes that may be used during a hazard analysis. | 3 |
| tOutputTable | Table | Stores the database tables where the output is stored. | 1 |
| tOutputType | Table | Stores the possible types of output for each analysis type. | 2 |
| tOutputTypPerspectiveXref_NGM | Table | System reference table that stores the financial perspective codes that correspond to each output table type. | 2 |
| tResultTemplate | Table | Stores the association between output types and the results. | 2 |
| tResultTemplateFilterAttributeXRef | Table | System reference table used to determine the filter attributes that are applied to the results. | 3 |
| tResultViewBy | Table | Stores information identifying the options for viewing results in Touchstone. | 1 |