Accident Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 12: Line 12:
| 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 24:
| 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 52: Line 52:
| 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

Revision as of 12:13, 15 October 2016

The table is called accident and the entity type is called Accident.

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 varchar 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

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:|<td class="navbox-image " style="width:0%;padding:0px 2px 0px 0px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form  · Attachments|+2}}{{#if:Point Types

Geospatial  · Geopoint|+2}}{{#if:Task  · Work item  · Task Child Tables|+2}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|+2}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>
{{{imageleft}}}
}}{{#if:Item Data|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|<td class="navbox-image " style="width:0%;padding:0px 0px 0px 2px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form  · Attachments|+2}}{{#if:Point Types

Geospatial  · Geopoint|+2}}{{#if:Task  · Work item  · Task Child Tables|+2}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|+2}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>
{{{image}}}
}}}}{{#if: Overview DEF
Data Entry Form  · Attachments|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:accident uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if: DEFs| DEFs<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Overview DEF

Data Entry Form  · Attachments

}}{{#if:Point Types
Geospatial  · Geopoint|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:accident uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF

Data Entry Form  · Attachments|}}{{#if: Geo data| Geo data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Point Types

Geospatial  · Geopoint

}}{{#if:Task  · Work item  · Task Child Tables|{{#if: Task | Task <td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Task  · Work item  · Task Child Tables

}}{{#if:Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places|{{#if:Auxiliary Data|Auxiliary Data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Assistance Classification  · Cause Classification  · Country Structure  · Needs Classification  · Ordnance Classification  · Organisation  · Places

}}{{#if:Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases|{{#if:Other|Other<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Enumeration categories  · Other tables  · Table differences between migrated and non-migrated databases

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:accident uncategorised

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF
Data Entry Form  · AttachmentsPoint Types

Geospatial  · Geopoint|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:accident uncategorised
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}