Education Details Uncategorised: Difference between revisions

Revision as of 12:17, 15 October 2016

	The Education child table for Education details is called mredetail and the entity type is called MRE_DETAIL.

DIM Label	Data type	Database column name	Enumcategory	Pojo name'
Audience Age Info	Single-select	agerangeenum_guid	Age Range	AgeRange
Military Audience	Single-select	audiencemilitary_guid	AudienceMilitary	AudienceMilitary
Mine Action Personnel Audience	Single-select	audiencepersonnel_guid	AudiencePersonnel	AudiencePersonnel
Audience	Single-select	audiencetypeenum_guid	Audience Type	AudienceType
Inactive	-	audiencetypeother		AudienceTypeOther
% Female	Numeric	femalepercentage		FemalePercentage
% Male	Numeric	malepercentage		MalePercentage
-	Parent	mre_guid		Mre
-	String	mredetail_guid		Guid
Education Sub Type	Single-select	mresubtypeenum_guid	MRESubType	MreSubType
Education Type	Single-select	mretypeenum_guid	MRE Type	MreType
Where did the activity take place?	Place	place_guid		Place
Total Audience Number	Integer	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 details 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 details 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 details uncategorised

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

}}}}}} Overview DEF
Data Entry Form · Attachments Point Types

Geospatial · Geopoint|}}

{{{below}}}

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

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:education details uncategorised

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

}}}}}}

@@ Line 8: / Line 8: @@
   ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name'
 |-
-| Audience Age Info || Single-select ||  AgeRangeEnum_GUID || Age Range || AgeRange
+| Audience Age Info || Single-select ||  agerangeenum_guid|| Age Range || AgeRange
 |-
 | Military Audience || Single-select ||  audiencemilitary_guid || AudienceMilitary || AudienceMilitary
@@ Line 14: / Line 14: @@
 | Mine Action Personnel Audience || Single-select ||  audiencepersonnel_guid || AudiencePersonnel || AudiencePersonnel
 |-
-| Audience || Single-select ||  AudienceTypeEnum_GUID || Audience Type || AudienceType
+| Audience || Single-select ||  audiencetypeenum_guid|| Audience Type || AudienceType
 |-
 | ''Inactive'' || - ||  audiencetypeother ||  || AudienceTypeOther
 |-
-| % Female || Numeric ||  FemalePercentage ||  || FemalePercentage
+| % Female || Numeric ||  femalepercentage||  || FemalePercentage
 |-
-| % Male || Numeric ||  MalePercentage ||  || MalePercentage
+| % Male || Numeric ||  malepercentage||  || MalePercentage
 |-
-| - || Parent ||  MRE_GUID ||  || Mre
+| - || Parent ||  mre_guid||  || Mre
 |-
-| - || String ||  MREDetail_GUID ||  || Guid
+| - || String ||  mredetail_guid||  || Guid
 |-
 | Education Sub Type || Single-select ||  mresubtypeenum_guid || MRESubType || MreSubType
 |-
-| Education Type || Single-select ||  MRETypeEnum_GUID || MRE Type || MreType
+| Education Type || Single-select ||  mretypeenum_guid|| MRE Type || MreType
 |-
-| Where did the activity take place? || Place ||  Place_GUID ||  || Place
+| Where did the activity take place? || Place ||  place_guid||  || Place
 |-
-| Total Audience Number || Integer ||  TotalAudience ||  || TotalAudience
+| Total Audience Number || Integer ||  totalaudience||  || TotalAudience
 |}

Education Details Uncategorised: Difference between revisions

Revision as of 12:17, 15 October 2016

Navigation menu

Search