Touchstone 4.0 Database Documentation
tAuditStatus Table
Description

System table that is used internally by the Loss and Geospatial analysis engines to understand the status of the location in the location table.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows11
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AuditStatusCode

Code that represents the status of exposure data import.

  • 536870912 = STATUS_AFTER_IMPORT 
    Description:   Imported but not geocoded. Not valid for loss
  • 1006632960 = STATUS_AFTER_CHECK
    Description: Geocoded but no physical properties assigned. Not valid for loss. 
  • 1056964608 = STATUS_AFTER_PHYSPROP
    Description: Internal memory value after physical properties assigned (value is not stored in database). Valid for loss.
  • 1056964609 = STATUS_AFTER_INVCONA
    Description: Geocoded with valid physical properties but invalid construction A. Valid for loss after remapping.
  • 1056964610 = STATUS_AFTER_INVCONB
    Description: Geocoded with valid physical properties but invalid construction B. Valid for loss after remapping.   
  • 1056964611 = STATUS_AFTER_INVCONAB
    Description: Geocoded with valid physical properties but invalid constructions A and B. Valid for loss after remapping. 
  • 1056964612 = STATUS_AFTER_INVOCC
    Description: Geocoded with valid physical properties but invalid occupancy. Valid for loss after remapping.  
  • 1056964613 = STATUS_AFTER_INVCONAOCC
    Description: Geocoded with valid physical properties but invalid construction A and invalid occupancy. Valid for loss after remapping.  
  • 1056964614 = STATUS_AFTER_INVCONBOCC
    Description: Geocoded with valid physical properties but invalid construction B and invalid occupancy. Valid for loss after remapping. 
  • 1056964615 = STATUS_AFTER_INVCONABOCC
    Description: Geocoded with valid physical properties but invalid constructions A and B and invalid occupancy. Valid for loss after remapping.  
  • 1065353216 = STATUS_AFTER_INDRISK
    Description:  Geocoded with valid physical properties. Construction is valid. Occupancy is valid.  Valid for loss.        
Integer4   
 AuditStatus

Name of the status.

Corresponds to the code in AuditStatusCode.

VarChar40   
 Description

Description of the status.

Corresponds to the code in AuditStatusCode.

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