0
edits
Changes
no edit summary
|-
| Intended Land Use Date || Date
|-
| Lat/Long ||
|-
| Linked Hazard Reduction IDs || A derived field that returns a comma separated list of the local IDs of all hazard reductions that are linked to the hazard.
|-
| Location ID || Varchar(38)
|-
| Major Impacts || Text
|-
| Map Coordinate System TC ||
|-
| Marking Type ||
|-
| Measured From View Point ||
|-
| Medical Facility Level 1 || Text
|-
| Medical Facility Level 2 || Text
|-
| Medical Facility Level 3 || Varchar(38)
|-
| Medical Facility Level 4 || Varchar(38)
|-
| Medivac || Varchar(38)
|-
| Metal Contamination Level || Varchar(38)
|-
| Metal Content Level || Varchar(38)
|-
| Mine Action Area Type ||
|-
| Municipality ||
|-
| Number Of Affected Communities || Int(10)
|-
| Ordnance SubCategory List || A derived field that returns "-" separated list of all sub-categories of ordnance that are present in the hazard.
|-
| Other Vital Point Text ||
|-
| Planned Clearance Total Area || A derived field that returns the total area size of all clearances that are linked to the hazard. "Clearance" is defined as a Hazard Reduction where the type is set to "Clearance", "Road Clearance" or "Battle Area Clearance"
|-
| Priority || Varchar(38)
|-
| Reason for Depth || Text
|-
| Recommended Clearance Depth || Float
|-
| Recommended Number Of Demining Teams || Int(10)
|-
| Reliability of Information || Varchar(38)
|-
| Reliability of Source || Varchar(38)
|-
| Road Alternative Text ||
|-
| Road To Other Text ||
|-
| Road Usable For || Varchar(38)
|-
| Seasonal Consideration || Text
|-
| Slope || Varchar(38)
|-
| Soil Type ||
|-
| Status || Varchar(38)
|-
| Suitable for ||
|-
| Terrain Category || Varchar(38)
|-
| Terrain/Locale Information || Text
|-
| Time to Travel to Level 1 || Time
|-
| Time to Travel to Level 2 || Time
|-
| Time to Travel to Level 3 || Time
|-
| Time to Travel to Level 4 || Time
|-
| Travel Time to Medivac || Time
|-
| Type of Area || Varchar(38)
|-
| Type of Blocked Agriculture ||
|-
| Type of Hazardous Area || Varchar(38)
|-
| Type of Infrastructure Blocked ||
|-
| Type Of Mechanical Device ||
|-
| Type of Non-Agricultural Areas Blocked ||
|-
| Type of Roads Blocked ||
|-
| Type of Water Blocked ||
|-
| Unknown Device ||
|-
| Vegetation ||
|-
| Vegetation Density || Varchar(38)
|-
| Vegetation Removed By || Varchar(38)
|-
| Walk Time ||
|}
</center>
===Hazard Reduction===
A field for each country structure level will also be available. Because the country structure levels may vary for each site, these fields are not listed below.
<center>
{| class="wikitable" width="500"
|-
| align="center" colspan="2" | '''Table 17. Hazard fields'''
|-
| width="250pt" | '''Field name'''
| align="center" width="250pt" | '''Data type'''
|-
| Anti Lift ||
|-
| Anti-Lift Fitted ||
|-
| Area Description ||
|-
| Area Officer ||
|-
| Area Officer ||
|-
| Assumption Prior to Visit ||
|-
| Best Route to Site ||
|-
| Booby Trap ||
|-
| Bobby Trapped ||
|-
| Comment ||
|-
| Community Leader ||
|-
| Confirmed ||
|-
| Contamination Type ||
|-
| Cost Per Meter ||
|-
| Dangerous Area Type ||
|-
| Depth ||
|-
| Destruction Method ||
|-
| Distance from Nearest Town ||
|-
| Drainage Features ||
|-
| End Date ||
|-
| End Period ||
|-
| Estimated Workday ||
|-
| Fighting in Area ||
|-
| Ground Profile ||
|-
| Guid ||
|-
| Hazard Reduction ID ||
|-
| Hazard Reduction Name ||
|-
| Hours Spent ||
|-
| Intended Land Use ||
|-
| Interviewer ||
|-
| Lat/Long ||
|-
| Length ||
|-
| Location ID ||
|-
| Marking ||
|-
| Marking Method ||
|-
| Medical Facility Level 1 ||
|-
| Medical Facility Level 2 ||
|-
| Medical Facility Level 3 ||
|-
| Medical Facility Level 4 ||
|-
| Medivac ||
|-
| Metal Contamination level ||
|-
| Mines/UXO Condition ||
|-
| Monitor ||
|-
|Municipality ||
|-
| Number of Teams ||
|-
| Number of Vehicles ||
|-
| Operational Notes ||
|-
| Ordnance SubCategory Exists || A derived field that returns “true” if the hazard reduction contains ordnance data where the sub-category matches the |-
Subcategory property. Please note that you must specify a sub-category with this field.
|-
| Organisation ||
|-
| Planned End Date ||
|-
| Planned Start Date || A derived field that returns the number of positive samples for the hazard reduction.
|-
| Priority Correction ||
|-
| QC Comments ||
|-
| Quality Assurance ||
|-
| Recommendations ||
|-
| Reduction Method ||
|-
| Reliability of Information ||
|-
| Reliability of Source ||
|-
| Reported Progress Area Size || A derived field that returns the total area size of all "Progress Report" field reports that were reconciled to the hazard reduction.
|-
| Road Usable For ||
|-
| Size of Area ||
|-
| Soil Metal Content Level ||
|-
| Soil Type ||
|-
| SOP Dog ||
|-
| SOP Manual ||
|-
| SOP Mechanical ||
|-
| SOP Metal Detector ||
|-
| Start Date ||
|-
| Start Period ||
|-
| Status ||
|-
| Survey MA Guid ||
|-
| Task Dossier ||
|-
| Tasked By ||
|-
| Team ID ||
|-
| Team Leader ||
|-
| Team Location ||
|-
| Terrain Category ||
|-
| Time to Travel to Level 1 ||
|-
| Time to Travel to Level 2 ||
|-
| Time to Travel to Level 3 ||
|-
| Time to Travel to Level 4 ||
|-
| Total Hazard Area Size || A derived field that returns the total area size of all hazards that are linked to the hazard reduction.
|-
| Travel Time to Medivac ||
|-
| Type of Activity ||
|-
| Uncleared Area Size ||
|-
| Verification Notes ||
|-
| Victim Count || A derived field that returns the number of victims that are linked to the hazard reduction.
|-
| Visitor ||
|-
| Year of Reduction || A derived field that returns a string representation of a date formatted by the user provided format, or "yyyy" if no format is |-
provided. The date is the first of the following fields of the hazard reduction that contains data: Start Date, End Date, Planned Start Date, Planned End Date. An optional date format may be specified.
|}
</center>
===Impact Survey===
<center>
{| class="wikitable" width="500"
|-
| align="center" colspan="2" | '''Table 18. Impact survey fields'''
|-
| width="250pt" | '''Field name'''
| align="center" width="250pt" | '''Data type'''
|-
| Accident Cause ||
|-
| Accident in Area ||
|-
| Casualty Type ||
|-
| Economic Base ||
|-
| Enumerator 1 ||
|-
| Enumerator 2 ||
|-
| Expert Type ||
|-
| Fuel Available ||
|-
| Guid ||
|-
| Higher Education ||
|-
| Higher Education Comments ||
|-
| Last Conflict Year ||
|-
| Local Clearance Effects ||
|-
| Local Clearance Effort ||
|-
| Major Mine Impacts ||
|-
| Medical Facility Type ||
|-
| Military Activity Intensity ||
|-
| Mine History Comments ||
|-
| MRE Community Centre ||
|-
| MRE Organization Involved ||
|-
| MRE Other ||
|-
| MRE Performing Group ||
|-
| MRE Posters ||
|-
| MRE Radio ||
|-
| MRE Religious Centre ||
|-
| MRE School Presentation ||
|-
| MRE Victim Assistance ||
|-
| MRE within 24 Months ||
|-
| Number of Households Census ||
|-
| Number of Households Census Pre-War ||
|-
| Number of Households Key Informants ||
|-
| Number of Households Key Informants Pre-War ||
|-
| Number of Primary Schools ||
|-
| Number of Secondary Schools ||
|-
| Number of Victims Injured – Old ||
|-
| Number of Victims Killed – Old ||
|-
| Origin of Impact Survey Report ||
|-
| Piped Water Supply ||
|-
| Population Census ||
|-
| Population Census Pre-War ||
|-
| Primary Interview Language ||
|-
| Priority ||
|-
| Recent Marking Survey ||
|-
| Recent Mine Clearance ||
|-
| Settlement Established ||
|-
| Telephone Connection ||
|-
| Year Mines Last Planted ||
|-
| Year Mines Problem Began ||
|}
</center>
