Advanced Enterprise Technologies, Inc.
Table of Contents

Structures Metadata

 

Name Property Data Type Max Length Notes
Account ID accountId Integer 9 Required when no accountNumber provided
Account Number accountNumber Text 250 Required when no accountId provided
Account Name accountName Text 300  
Structure ID structureId Integer 9  
Structure Type structureType Text 100 Required
Ownership Type ownershipType Text 100 Required
Insurance Responsibility insuranceResponsibility Text 120  
Structure Name structureName Text 150 Required
Site Identifier siteIdentifier Text 120  
Date Added dateAdded Date 24 Required
Date Dropped dateDropped Date 24 When valued this record will appear as removed
Address address Text 120 Required
Address 2 address2 Text 120  
Address 3 address3 Text 120  
City city Text 120 Looked up by zip
State state Text 2 Looked up by zip
Zip zip Text 10 Required and must be a valid five digit zip code
County county Text 256  
Block Number blockNumber Text 50  
Tax Lot Number taxLotNumber Text 50  
Tax Area Type taxAreaType Text 50  
Tax Area taxArea Decimal 18  
Construction Category constructionCategory Text 150  
ISO Construction Source isoConstructionSource Text 120  
Floor Area floorArea Decimal 18  
Year Built yearBuilt Integer 9  
Stories stories Integer 9  
Stories Height storiesHeight Decimal 18  
Basement Type basementType Text 150  
Basement Height basementHeight Decimal 18  
Stories Above Ground storiesAboveGround Integer 9  
Stories Below Ground storiesBelowGround Integer 9  
Sq Ft Above Ground sqFtAboveGround Decimal 18  
Sq Ft Below Ground sqFtBelowGround Decimal 18  
Percent Finished Below Ground percentFinishedBelowGround Integer 9  
Construction Types constructionTypes Collection 255  
Construction Component constructionComponent Text 120 Required when importing construction type data
Construction Type Percent of Total constructionTypePercentofTotal Integer 9 Required when importing construction type data
Material Type materialType Text 120 Required when importing construction type data
Construction Types - Other constructionTypesOther Collection 255  
Construction Component - Other constructionComponentOther Text 150 Required when importing construction type - other data
Construction Type - Other constructionTypeOther Text 150 Required when importing construction type - other data
Occupancies occupancies Collection 255  
Occupant Contact ID occupantContactId Integer 9 Required when importing occupancy data and no occupantCompanyName or occupantFirstName and occupantLastName provided
Occupant Company Name occupantCompanyName Text 50 Required when importing occupancy data and no occupantContactId or occupantFirstName and occupantLastName provided
Occupant First Name occupantFirstName Text 50 Required when importing occupancy data and no occupantContactId or occupantCompanyName provided
Occupant Last Name occupantLastName Text 50 Required when importing occupancy data and no occupantContactId or occupantCompanyName provided
Occupant Address occupantAddress Text 150  
Occupant Address 2 occupantAddress2 Text 150  
Occupant Address 3 occupantAddress3 Text 150  
Occupant City occupantCity Text 100 Looked up by occupantZip
Occupant State occupantState Text 2 Looked up by occupantZip
Occupant Zip occupantZip Text 10 Must be a valid five digit zip code
Occupant Phone occupantPhone Text 15  
Occupant E-mail occupantEmail Text 1024  
Occupant Fax occupantFax Text 15  
Occupancy Type occupancyType Text 150 Required when importing occupancy data
Percent Occupied percentOccupied Text 4 Required when importing occupancy data
Protections protections Collection 255  
Percent Sprinkled percentSprinkled Integer 9  
Percent Manual Fire Alarm percentManualFireAlarm Integer 9  
Percent Automatic Fire Detection percentAutomaticFireDetection Integer 9  
Percent Security Detection percentSecurityDetection Integer 9  
Alarm System alarmSystem Text 256  
Automatic External Defibrillator automaticExternalDefibrillator Text 256  
Fire Detection System fireDetectionSystem Text 256  
Fire Suppression System fireSuppressionSystem Text 256  
Security Alarm securityAlarm Text 256  
Security Camera securityCamera Text 256  
Sprinkler System sprinklerSystem Text 256  
Flood Zone floodZone Text 150  
Earthquake Zone earthquakeZone Text 150  
Wind Zone windZone Text 150  
Values values Collection 100  
Valuation Type valuationType Text 50 Required when importing value data
Value Amount valueAmount Decimal 18 Required when importing value data
Value Effective Date valueEffectiveDate Date 24 Required when importing value data
Value Source valueSource Text 150  
User-Defined Fields userDefinedFields Collection 100  
Field Name fieldName Text 50  
Field Value fieldValue Text 4000 Required when user-defined field fieldName has "Is Required" checked