Touchstone 2022 Database Reference
tLossVulnerabilitySet Table
AIRUserSetting Database : tLossVulnerabilitySet Table
Description
Stores information about vulnerability loss sets.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-generated sequential identifier for the loss vulnerability set record.int4   
 Unique system-generated sequential identifier for the business unit record.int4  
 Name of the vulnerability loss set file.varchar255   
 Additional comments associated with the vulnerability loss set file.varchar2000  
 

Code that represents the types of vulnerability set files.

  • LID = Location ID
  • PC = Primary Characteristics
varchar10  
 Code that represents the model in Touchstone associated with the vulnerability loss file set.smallint2   
 

Indicates whether the event set included in the analysis corresponds to the current or previous version of the AIR models.

  • 1 = Yes (previous version)
  • 0 = No (current version)
bit1
((0))
 
 System-provided status code for the record.varchar10 
('A')
 
 Version of the vulnerability loss set file.varchar50   
 Version of the product associated with the vulnerability loss file.varchar50   
 

Indicates whether you can import vulnerability loss set files as binary binary.

  • 1 = Yes
  • 0 = No 
bit1 
((0))
 
 Reserved for future use.int4 
((0))
 
 Name of the person who created the vulnerability loss set file.varchar255  
 Date and time when the vulnerability set file was created.datetime4
(getutcdate())
 
 Date and time when the vulnerability set file was modified.datetime4
(getutcdate())
 
 Used for time stamping.timestamp8   
Objects that depend on tLossVulnerabilitySet
 Database ObjectObject TypeDescriptionDep Level
tLossVulnerabilitySetDetails tabletLossVulnerabilitySetDetailsTableStores additional information about each loss vulnerability file sets.1
See Also

Related Objects

AIRUserSetting Database