Touchstone 4.0 Database Documentation
tWidgetTemplate Table
Description

Stores information about the widget templates available in Touchstone. 

Information regarding the custom, user-defined widget templates are available in the following database tables:

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows4
Data Space Used8.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key WidgetTemplateSIDUnique system-generated sequential identifier for the widget template record.Integer4   
 WidgetTypeCode

Code that represents the widget type.

For a complete list of codes, see tWidgetType Table.

VarChar25  
 WidgetNameName of the widget template.VarChar255  
 PassPercent

Maximum percentage in the "pass" range.

Depending on the value provided by the user, the flag color is as follows:

  • Green:  results are greater than the pass value
  • Yellow: results are less than the pass percent but greater than warning percent
Single4  
 WarningPercent

Maximum percentage in the "warning" range.

Depending on the value provided by the user, the flag color is as follows:

  • Green:  results are greater than the pass value
  • Yellow: results are less than the pass percent but greater than warning percent
Single4  
 IsCustom

Indicates whether the widget template is a custom, user-defined template.

  • 1 = Yes (custom)
  • 0 = No (default)
Boolean1   
Objects that depend on tWidgetTemplate
 Database ObjectObject TypeDescriptionDep Level
tHazardWidgetTemplate tabletHazardWidgetTemplateTable

Stores information about the custom, user-defined hazard widget template.

Information regarding the underlying widget template is available in tWidgetTemplate Table.

1
tLossWidgetTemplate tabletLossWidgetTemplateTable

Stores information about the custom, user-defined loss widget template.

Information regarding the underlying widget template is available in tWidgetTemplate Table.

1
See Also

Related Objects

AIRUserSetting 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.