Difference between revisions of "Education Uncategorised"

Latest revision as of 10:04, 1 November 2018

	The main table is called mre, the entity type is called MRE, the target is called Mreversion and the main maXML artifact is MREActivity.

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

@@ Line 1: / Line 1: @@
-{{Note | The table is called ''mre'' and the entity type is called ''MRE''. }}
+{{Note | The main table is called ''mre'', the entity type is called ''MRE'', the target is called ''Mreversion'' and the main maXML artifact is [[Education Artifact|MREActivity]]. }}
 {|
@@ Line 31: / Line 31: @@
 | 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
@@ Line 39: / Line 39: @@
 | Municipality || String ||  municipality ||  || Municipality
 |-
-| Organisation || Organisation ||  Org_GUID ||  || Organisation
+| Organisation || Organisation ||  org_guid||  || Organisation
 |-
 | Period || Single-select ||  period_guid || MREPeriod || Period