Changes

Jump to: navigation, search

Use iReport

233 bytes added, 15:26, 24 October 2012
Accident
| align="center" width="250pt" | '''Data type'''
|-
|Accident Description|| Text|-| Accident ID|| Varchar(50)|-| Area Marked|| Varchar(38)|-| Area Officer|| Varchar(50)|-| Clearance In Progress?|| Varchar(38)|-| Confirmed|| Varchar(38)|-| Data Gathered By|| Varchar(25)|-| Date of Accident|| Datetime|-| Description of ref area|||-| Distance From Nearest Town|| Text|-| Distance From City|| |-| Equipment Damage|| Float|-| Guid|| Varchar(38)|-| Inquiry Report Reference|| Text|-| Lat/Long|| |-| Linked Victim Name(s)Location IDMine Action Activity TypeMunicipalityNumber of Linked VictimsNumber of Persons InvolvedProperty DamageReliability of InformationReliability of SourceSourceType of AccidentType of AreaType of Hazardous AreaUnknown DeviceWas Mine/UXO Marked?||TextVarchar(50)Varchar(38)Varchar(50)Varchar(38)Varchar(38)Varchar(25)Datetime Text FloatVarchar(38)Text A derived field that returns A comma separated list of the names (first and last) of all victims that are linked to the accident.|-| Location ID || Varchar(38)|-| Mine Action Activity Type || Varchar(38)|-| Municipality || Varchar(125)|-| Number of Linked Victims || A derived field that returns the number of victims that are linked to the accident. |-| Number of Persons Involved || Int(10)|-| Property Damage || Float|-| Reliability of Information || Varchar(38)|-| Reliability of Source || Varchar(38)|-| Source || Varchar(50)|-| Type of Accident || Varchar(38)|-| Type of Area || Varchar(38)|-| Type of Hazardous Area || Varchar(38)|-| Unknown Device || Varchar(38)|-| Was Mine/UXO Marked? || Varchar(38)
|}
</center>
0
edits

Navigation menu