2,186
edits
Changes
no edit summary
=== Article 7: Form A===
The ''Article 7: Form A'' report returns the total area size of all reductions that are being reported on, the total area size of all hazards Lands that have been linked to the reported reductions, and a count of all victims that have been linked to the reported reductions. If a search definition is associated with the report, the search definition name will be displayed in the report title.
[[Image:fig41SampleReport.png|center|500px|''Figure 41. Sample report - Article 7 form A'']]
| File name || Article 7 Form A.jrxml
|-
| Data source|| Hazard reductionActivity
|-
| Variables
|| Sum of hazard reduction Activity area sizeSum of total hazard Land area size
Sum of victim counts
|-
| Derived fields
|| HazreducLinkedHazardAreaSize ActivityLinkedLandAreaSize (Total Hazard Land Area Size)
HazreducLinkedVictimCount (Victim Count)
|-
===Article 7: Form C===
The ''Article 7: Form C'' report returns a crosstab by district and hazard Land with the number of hazards Lands by hazard Land type.
[[Image:Article 7FormC.png|center|500px|''Figure 42. Sample report- Article 7-form C'']]
| File name|| Article 7 Form C.jrxml
|-
| Data source|| HazardLand
|-
| Variables|| REPORT_COUNT (built-in iReport variable)
==Bar Chart Sample==
The ''Bar Chart'' sample report returns the metal contamination level of hazards Lands and area size. The report includes a bar chart which summarizes the total area size of hazards Lands by their metal contamination level.
[[Image:BarChartSample.png|center|500px|''Figure 43.'' ''Sample report- Bar chart'' '']]
| File name|| Bar Chart Sample.jrxml
|-
| Data source|| HazardLand
|-
| Variable
| File Name|| Clearance by Year and District Sample.jrxml
|-
| Data source|| Hazard reductionActivity
|-
| Variables|| Count variables for all the derived fields
|}
==Hazards Lands by Ordnance Type==The Hazards Lands by Ordnance Type report shows summary data based on the full set of Ordnance Types present. This report groups Hazards Lands based on the full list of Ordnance SubCategories that are found on the HazardLand. The report displays the name of the search in the report title.
[[Image:MRE audience.png|center|500px|''Figure 45.'' ''Sample report- Hazard Land by ordnance type'']]
====Table 10====
{| class="wikitable"
|-
| File name || Hazards Lands by Ordnance Type.jrxml
|-
| Data source|| HazardLand
|-
| Variables
|| Count of hazards Lands for each ordnance sub-category
Sum of area size,
Average of area size
|-
| Derived fields || HazardOrdnanceSubCategoryList LandOrdnanceSubCategoryList (Ordnance SubCategory List)
|-
| Sub-reports|| None
|}
==MRE Education Audience Totals by Age==The MRE Education Audience Totals by Age report lists the different age categories of MRE Education audiences and the total number of male, female, and unknown gender in each age category.
[[Image:MRE audience.png|center|500px|''Figure 46.'' ''Sample report- MRE Education audience totals by age'']]
====Table 11====
{| class="wikitable"
|-
| File name || MRE Education Audience by Age.jrxml
|-
| Data source|| MRE Education Details
|-
| Variables
|| Sums of each gender (derived fields) by group and report
Sum of total audience by group and report
Count of number of events (MRE Education Details) by group and report
|-
| Derived Fields
|| MREDetailMaleAudience EducationDetailMaleAudience (Total Male Audience)MREDetailFemaleAudience EducationDetailFemaleAudience (Total Female Audience)MREDetailUnknownAudience EducationDetailUnknownAudience (Total Unknown Audience)
|-
| Sub-reports|| None
==Pie Chart Sample==
The Pie Chart sample report returns the metal contamination level of hazards Lands and area size. The report includes a pie chart which summarizes the total area size of hazards Lands by their metal contamination level.
[[Image:Pie Chart.png|center|500px|''Figure 47.'' ''Sample report- Pie chart'']]
| File name || Pie Chart Sample.jrxml
|-
| Data source || HazardLand
|-
| Variables
|}
==Hazard Land Summary Report==File: Summary_HazardSummary_Land.jrxmlData source: HazardLand
[[Image:Hazard Summary.png|center|500px|''Figure 49.'' ''Sample report- Hazard Land summary'']]
===Hazard Reduction Activity Summary Report===
File: Summary_Hazreduc.jrxml
Data source: Hazard ReductionActivity[[Image:Hazard Reduction.png|center|500px|''Figure 50.'' ''Sample report- Hazard reduction Activity summary'']]
===Location Summary Report===
[[Image:Location Summary.png|center|500px|''Figure 51.'' ''Sample report- Location summary'']]
==MRE Education Summary Report==For this type of report, compile the sub-report (Sub-reports\Summary_Mre_subSummary_Education_sub-report1.jrxml) before attempting to run the main report.
Set the SUB-REPORT_DIR parameter to .\Sub-reports\.
[[Image:MRE Summary.png|center|500px|''Figure 52.'' ''Sample report- MRE Education summary'']]
====Table 15====
{| class="wikitable"
|-
| File name|| Summary_MRESummary_Education.jrxml
|-
| Data source
|| MREEducation
Query executor (used by the sub-report)
|-
| Derived fields|| None
|-
| Sub-reports|| Sub-reports\Summary_Mre_subSummary_Education_sub-report1.jrxml
|}
==Appendix A: IMSMA Database==
===Overview===
The IMSMA database contains tables for IMSMA’s base data (country structures, explosive, ordnance, organisations, and places), locations, and the locations’ associated accidents, hazardsLands, hazard reductionsActivities, MREsEducations, QCsQMs, and victims.
[[Image:fig56iR_Appndx.png|center|500px|''Figure 56. Conceptual database model'']]
</div>
Within each country structure are zero or more locations. For example, a particular province may have multiple locations within it while another province has no locations. Each location may have zero or more items such as accidents, hazardsLands, hazard reductionsActivities, MREsEducations, QCsQMs, or victims associated with them. These accidents, hazardsLands, hazard reductionsActivities, MREsEducations, QCsQMs, or victims are added to the IMSMA database via field reportsdata entry forms.
IMSMA items may have either a direct or a linked relationship to other items. Direct relationships occur when one item requires the other item to exist. For example, an accident, hazardLand, hazard reductionActivity, MREEducation, QCQM, or victim has a direct relationship to the location to which it is associated. The accident, hazardLand, hazard reductionActivity, MREEducation, QCQM, or victim cannot exist unless it is associated with a location. This direct relationship is enforced in IMSMA via the reconciliation process. Direct relationships also exist when subsets of data are contained within an item. For example, an MRE Education may have MRE Education details such as the MRE Education type, total audience, and percentage of women and men. The MRE Education details data requires the MRE Education to exist. Table 15. Direct relationships between items lists the items and the data subsets that depend on them.
<center>
| align="center" width="400pt" | '''Child item(s) which require the parent item'''
|-
| Hazard reduction Activity || Impact survey
Interviewee
Organisation
|-
| Location || Accident
QA
Victim
|-
| MRE Education || MRE Education details
|-
| Victim || Received MREEducation
|}
</center>
Linked relationships are optional relationships which may exist between items. Accidents, hazardsLands, hazard reductionsActivities, MREsEducations, QCsQMs, and victims may be related to one another via links. For example, a victim may be associated to an accident in a particular hazardLand. If these relationships are known, IMSMA users may define these links while reconciling the field reportdata entry form.
===Guids===
All records in IMSMA have a guid. A guid is a unique value that identifies the record in the IMSMA database. Because the guid is lengthy and comprised of alphanumeric characters, it is typically not a useful value to display in a report. However, the guid is necessary in determining which item records have a direct relationship, and in determining what links exists between item records.
All accidents, hazardsLands, hazard reductionsActivities, MREsEducations, QCsQMs, and victims are associated with a single location. The information about the location to which an item record is associated is stored in the location_guid field of the item table and corresponds to the location_guid of the location to which it is associated ([[:Image:fig57iR_Appndx.png|Figure 57]]).
[[Image:fig57iR_Appndx.png|center|500px|''Figure 57. location_guid'']]
</div>
The location_guid field in the item table contains the guid of the location to which the item record is associated. [[:Image:fig58iR_Appndx.png|Figure 58]] shows an example of a location and the accident and hazard Land that are associated to the location. Notice that the location_guid value (1234-1234) in the accident and hazard Land are identical to the location_guid of the location.
[[Image:fig58iR_Appndx.png|center|500px|''Figure 58. location_guid example'']]
</div>
IMSMA allows users to define relationships between item records of differing types. For example, an accident may be related to a particular hazardLand. These relationships are referred to as links. The link table contains the links that have been defined between item records. The link table contains the guid of the item from which the link was established (from_guid) and the guid to which the link is being established (to_guid). [[:Image:fig60iR_Appndx.png|Figure 60]] shows an example of a link that was created from an accident to a hazardLand. These links are stored in the link table.
[[Image:fig60iR_Appndx.png|center|500px|''Figure 60. Link table example'']]
</center>
===HazardLand===
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.
{| class="wikitable" width="500"
|-
| align="center" colspan="2" | '''Table 16. Hazard Land fields'''
|-
| width="250pt" | '''Field name'''
| Azimuth || Float
|-
| Best Route To Hazard Land || Text
|-
| Blocked Roads || Varchar(38)
| Guid || Varchar(38)
|-
| Hazard Land Description || Text
|-
| Hazard Land ID || Varchar(50)
|-
| Hazard Land Name || Varchar(125)
|-
| Identifier ||
| Lat/Long ||
|-
| Linked Hazard Reduction Activity IDs || A derived field that returns a comma separated list of the local IDs of all hazard reductions Activities that are linked to the hazardLand.
|-
| Location ID || Varchar(38)
| 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 hazardLand.
|-
| 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 hazardLand. "Clearance" is defined as a Hazard Reduction Activity where the type is set to "Clearance", "Road Clearance" or "Battle Area Clearance"
|-
| Priority || Varchar(38)
</center>
===Hazard ReductionActivity===
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.
{| class="wikitable" width="500"
|-
| align="center" colspan="2" | '''Table 17. Hazard Land fields'''
|-
| width="250pt" | '''Field name'''
| Guid ||
|-
| Hazard Reduction Activity ID ||
|-
| Hazard Reduction Activity Name ||
|-
| Hours Spent ||
| Operational Notes ||
|-
| Ordnance SubCategory Exists || A derived field that returns “true” if the hazard reduction Activity contains ordnance data where the sub-category matches the |-
Subcategory property. Please note that you must specify a sub-category with this field.
|-
| Planned End Date ||
|-
| Planned Start Date || A derived field that returns the number of positive samples for the hazard reductionActivity.
|-
| Priority Correction ||
|-
| QC QM Comments ||
|-
| Quality Assurance ||
| Reliability of Source ||
|-
| Reported Progress Area Size || A derived field that returns the total area size of all "Progress Report" field reports data entry forms that were reconciled to the hazard reductionActivity.
|-
| Road Usable For ||
| Time to Travel to Level 4 ||
|-
| Total Hazard Land Area Size || A derived field that returns the total area size of all hazards Lands that are linked to the hazard reductionActivity.
|-
| Travel Time to Medivac ||
| Verification Notes ||
|-
| Victim Count || A derived field that returns the number of victims that are linked to the hazard reductionActivity.
|-
| 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 Activity that contains data: Start Date, End Date, Planned Start Date, Planned End Date. An optional date format may be specified.
|}
</center>
| Mine History Comments ||
|-
| MRE Education Community Centre ||
|-
| MRE Education Organization Involved ||
|-
| MRE Education Other ||
|-
| MRE Education Performing Group ||
|-
| MRE Education Posters ||
|-
| MRE Education Radio ||
|-
| MRE Education Religious Centre ||
|-
| MRE Education School Presentation ||
|-
| MRE Education Victim Assistance ||
|-
| MRE Education within 24 Months ||
|-
| Number of Households Census ||
| Lat/Long ||
|-
| Linked Hazard Land IDs || A derived field that returns a comma separated list of the local IDs of all hazards Lands that are part of the location.
|-
| Location Description ||
| Nearest Medical Facility ||
|-
| Total Hazard Land Area Size || A derived field that returns the total area size of all hazards Lands that are part of the location.
|}
</center>
===MREEducation===
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 21. MRE Education fields'''
|-
| width="250pt" | '''Field name'''
| Mine Action Type ||
|-
| MRE Education ID ||
|-
| Municipality ||
</center>
===MRE Education Details===
<center>
{| class="wikitable" width="500"
|-
| align="center" colspan="2" | '''Table 21. MRE Education fields'''
|-
| width="250pt" | '''Field name'''
| Mine Action Type ||
|-
| MRE Education ID ||
|-
| Municipality ||
| Planned Start Date ||
|-
| QC QM ID ||
|-
| QC QM Result Status ||
|-
| Qualified Medic Avail ||
</center>
===Received MREEducation===
<center>
{| class="wikitable" width="500"
|-
| align="center" colspan="2" | '''Table 27.Received MRE Education fields'''
|-
| width="250pt" | '''Field name'''
| Guid ||
|-
| MRE Education Activity ||
|-
| MRE Education Activity Class ||
|-
| MRE Education Activity Other ||
|-
| MRE Education Frequency ||
|}
</center>
{| class="wikitable" width="500"
|-
| align="center" colspan="2" | '''Table 28.Received MRE Education fields'''
|-
| width="250pt" | '''Field name'''