Difference between revisions of "Accident Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
{{Note | The table is called ''accident'' and the entity type is called ''Accident''. }}
+
{{New_6.0 | Accident cause, How Ordnance Activated, Time of accident and Was the ordnance moved before the accident are new fields in 6.0. Direction From Nearest Town was activated in 6.0.}}
 +
{{Note | The main table is called ''accident'', the entity type is called ''Accident'', the target is called ''Accidentversion'' and the main maXML artifact is [[Accident Artifact|Accident]]. }}
 
{|
 
{|
 
|- valign="top"
 
|- valign="top"
Line 12: Line 13:
 
| Accident Description||Text|| accidentdescription||||AccidentDescription
 
| Accident Description||Text|| accidentdescription||||AccidentDescription
 
|-
 
|-
−
| Accident ID||String|| Accident_LocalID||||LocalId
+
| Accident ID||String|| accident_localid||||LocalId
 
|-
 
|-
−
| Accident Type||Single-select|| AccidentTypeEnum_GUID||Accident Type||Type
+
| Accident Type||Single-select|| accidenttypeenum_guid||Accident Type||Type
 
|-
 
|-
 
| Area Marked||Single-select|| areamarked_guid||Yes No Answer||AreaMarked
 
| Area Marked||Single-select|| areamarked_guid||Yes No Answer||AreaMarked
Line 24: Line 25:
 
| Confirmed||Single-select|| confirm_guid||Yes No Answer||Confirm
 
| Confirmed||Single-select|| confirm_guid||Yes No Answer||Confirm
 
|-
 
|-
−
| Date of Accident||Date|| DateOfAccident||||DateOfAccident
+
| Date of Accident||Date|| dateofaccident||||DateOfAccident
 
|-
 
|-
 
| Description of ref area||Text|| hazardrefdescription||||HazardRefDescription
 
| Description of ref area||Text|| hazardrefdescription||||HazardRefDescription
Line 40: Line 41:
 
| ''Inactive''||String|| macid||||Macid
 
| ''Inactive''||String|| macid||||Macid
 
|-
 
|-
−
| ''Inactive''||varchar|| maactivityother||||MaActivityOther
+
| ''Inactive''||String|| maactivityother||||MaActivityOther
 
|-
 
|-
 
| ''Inactive''||String|| maactivityref_guid||||MaActivityRef
 
| ''Inactive''||String|| maactivityref_guid||||MaActivityRef
Line 52: Line 53:
 
| Number of Persons Involved||Integer|| numberpersoninvolved||||NumberPersonInvolved
 
| Number of Persons Involved||Integer|| numberpersoninvolved||||NumberPersonInvolved
 
|-
 
|-
−
| Organisation||Organisation|| Org_GUID||||Organisation
+
| Organisation||Organisation|| org_guid||||Organisation
 
|-
 
|-
 
| Reliability of Information||Single-select|| inforeliability_guid||InformationReliability||InfoReliability
 
| Reliability of Information||Single-select|| inforeliability_guid||InformationReliability||InfoReliability

Latest revision as of 13:30, 8 December 2018

New 6.0.png Accident cause, How Ordnance Activated, Time of accident and Was the ordnance moved before the accident are new fields in 6.0. Direction From Nearest Town was activated in 6.0.
Note.jpg The main table is called accident, the entity type is called Accident, the target is called Accidentversion and the main maXML artifact is Accident.

Uncategorised.png

DIM Label Data type Database column name Enumcategory Pojo name
Accident Cause Multi-select AccidentCause AccidentCauses
Accident Description Text accidentdescription AccidentDescription
Accident ID String accident_localid LocalId
Accident Type Single-select accidenttypeenum_guid Accident Type Type
Area Marked Single-select areamarked_guid Yes No Answer AreaMarked
Area Officer String areaofficer AreaOfficer
Clearance In Progress? Single-select clearanceinprogress_guid Yes No Answer ClearanceInProgress
Confirmed Single-select confirm_guid Yes No Answer Confirm
Date of Accident Date dateofaccident DateOfAccident
Description of ref area Text hazardrefdescription HazardRefDescription
Direction From Nearest Town Single-select directionfromnearesttown_guid DirectionFromCity DirectionFromNearestTown
Distance from Nearest Town String distancefromnearesttown DistanceFromNearestTown
How Ordnance Activated Single-select how_ordnance_activated How Ordnance Activated HowOrdnanceActivated
Inactive Text directionfromnearesttown DirectionFromNearestTownOther
Inactive String hazardref_guid HazardRef
Inactive String macid Macid
Inactive String maactivityother MaActivityOther
Inactive String maactivityref_guid MaActivityRef
Inactive Text comments
Inquiry Report Reference Text inquiryreportreference InquiryReportReference
Municipality String municipality Municipality
Number of Persons Involved Integer numberpersoninvolved NumberPersonInvolved
Organisation Organisation org_guid Organisation
Reliability of Information Single-select inforeliability_guid InformationReliability InfoReliability
Reliability of Source Single-select sourcereliability_guid SourceReliability SourceReliability
Source String source Source
Time of Accident Single-select time_of_accident Time Of Accident TimeOfAccident
Type of Area Single-select areatype_guid AreaType AreaType
Type of Hazardous Area Single-select dangerousareatype_guid DangerAreaType DangerousAreaType
Was the Ordnance Moved Before the Accident? Single-select was_the_ordnance_moved_before_the_accident Yes No Answer WasTheOrdnanceMovedBeforeTheAccident
Item Data
DEFs
Geo data
Task
Auxiliary Data
Other
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Accident_Uncategorised&oldid=24170"