Education Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 31: Line 31:
| Mine Action Activity Type || Single-select ||  mineactiontype_guid || Mine Action Activity || MaType
| Mine Action Activity Type || Single-select ||  mineactiontype_guid || Mine Action Activity || MaType
|-
|-
| Education ID || String ||  MRE_LocalID ||  || LocalId
| Education ID || String ||  mre_localid||  || LocalId
|-
|-
| Date || Date ||  MREDate ||  || Date
| Date || Date ||  mredate||  || Date
|-
|-
| Reason || Text ||  mrereason ||  || Reason
| Reason || Text ||  mrereason ||  || Reason
Line 39: Line 39:
| Municipality || String ||  municipality ||  || Municipality
| Municipality || String ||  municipality ||  || Municipality
|-
|-
| Organisation || Organisation ||  Org_GUID ||  || Organisation
| Organisation || Organisation ||  org_guid||  || Organisation
|-
|-
| Period || Single-select ||  period_guid || MREPeriod || Period
| Period || Single-select ||  period_guid || MREPeriod || Period

Revision as of 12:15, 15 October 2016

The table is called mre and the entity type is called MRE.

DIM Label Data type Database column name Enumcategory Pojo name
Inactive Single-select briefinglimits_guid BriefingLimits BriefingLimits
Inactive Single-select briefingthreats_guid BriefingThreats BriefingThreats
Inactive Single-select briefingwalked_guid BriefingWalked BriefingWalked
Campaign Level Single-select campaignlevel_guid CampaignLevel CampaignLevel
Comments Text comments Comments
Confirmed Single-select confirmed_guid Yes No Answer Confirmed
End Date Date enddate EndDate
Inactive - hazardref_guid HazardRef
Reliability of Information Single-select inforeliability_guid InformationReliability InfoReliability
Inactive - macid Macid
Mine Action Activity Type Single-select mineactiontype_guid Mine Action Activity MaType
Education ID String mre_localid LocalId
Date Date mredate Date
Reason Text mrereason Reason
Municipality String municipality Municipality
Organisation Organisation org_guid Organisation
Period Single-select period_guid MREPeriod Period
Planned End Date Date plannedenddate PlannedEndDate
Planned Start Date Date plannedstartdate PlannedStartDate
Project String project Project
Qty Integer qty Qty
Reliability of Source Single-select sourcereliability_guid SourceReliability SourceReliability
Start Date Date startdate StartDate
Status Single-select status_guid MREStatus Status
Inactive - supportedactivityother SupportedActivityOther
Supported Activity Type Single-select supportedactivitytype_guid SupportedActivity SupportedActivityType
Inactive - totalaudience TotalAudience

{{#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:education 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:education 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:education 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:education uncategorised
|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}