CEDE 9.0 Database Reference
tAuditStatus Table
AIRReference Database : tAuditStatus Table
Description

System reference table used internally by the loss and geospatial analysis engines to determine the status of a 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 

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

Name of the status.

Corresponds to the code in AuditStatusCode.

varchar40   
 

Description of the status.

Corresponds to the code in AuditStatusCode.

varchar1024  
See Also

Related Objects

AIRReference Database