Touchstone 4.0 Database Documentation
tOutputTypeTableXref Table
Description
System reference table used to associate the output type tables during a Loss analysis.
Properties
Creation Date6/30/2011 10:33 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows557
Data Space Used32.00 KB
Index Space Used176.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OutputTypeCode

Code that represents the output type.

For a complete list of codes, see tOutputType Table.

VarChar10   
Primary Key OutputTableSID

Unique system-generated sequential identifier for the output table.

For a complete list of records, see tOutputTable Table.

Integer4   
 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

Integer4  
 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

Integer4  
Objects that tOutputTypeTableXref depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysisType tabletAnalysisTypeTableStores the various analysis types that can be performed in Touchstone.3
tExposureAttributeType tabletExposureAttributeTypeTable

Stores the possible types of exposure attributes used for the Loss analysis results options.

1
tOutputTable tabletOutputTableTable

Stores the database tables where the output is stored.

1
tOutputTableType tabletOutputTableTypeTable

Stores the possible output table types to which the output is written.

2
tOutputType tabletOutputTypeTable

Stores the possible types of output for each analysis type.

1
tResultGroupBy tabletResultGroupByTable

Stores the possibly categorization (grouping) types for Data Quality analysis results.

1
tResultViewBy tabletResultViewByTable

Stores information identifying the options for viewing results in Touchstone.

2
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.