Education Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Created page with "{{Note | The table is called ''mre'' and the entity type is called ''MRE''. }} {| |- valign="top" | 100px | {| class="wikitable sortable" ! DIM L..."
 
No edit summary
Line 9: Line 9:
  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
  ! 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
|}


|}
|}
{{NavBox Data Dictionary}}
{{NavBox Data Dictionary}}
[[Category:NAA]]
[[Category:NAA]]

Revision as of 16:34, 15 March 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 = 
 }}
}}

}}}}}}