Touchstone 2022 Database Reference
tHazardWidgetTemplate Table
AIRUserSetting Database : tHazardWidgetTemplate Table
Description

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

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

Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the underlying widget template record.

For a complete list of records, see tWidgetTemplate Table.

int4   
Primary Key 

Code that represents the hazard attribute.

For a complete list of codes, see tHazardAttribute Table.

smallint2   
 Display order number for the template.int4  
 

Indicates whether the percent for the total replacement value is used for the calculation (vs. number of locations).

  • 1 = Yes (use %TRV)
  • 0 = No (Use No. of Locations)
bit1  
Objects that tHazardWidgetTemplate depends on
 Database ObjectObject TypeDescriptionDep Level
tWidgetTemplate tabletWidgetTemplateTable

Stores information about the widget templates available in Touchstone. 

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

1
See Also

Related Objects

AIRUserSetting Database