Difference between revisions of "Task Child Tables"

From IMSMA Wiki

Jump to: navigation, search

Latest revision as of 11:17, 16 March 2016

	The child tables of Task are not visible in the Data Inventory Manager.

Item Data

Location	Uncategorised

Land	Information Classification · Evidence of Contamination Affected Resources Data · Clearance Recommendation Data · Medical Facility Data · Reliability Data · Terrain and Operational Information · Uncategorised · Ordnance

Activity	Information Classification Medical Facility Data · Reliability Data · Terrain and Operational Information · Uncategorised · Ordnance Impact Survey Mine Risk Education · Impact survey · Interviewee · Question

Accident	Information Classification · Unknown Device Demining Accident · Uncategorised · Ordnance

Victim	Injury - Cause Advocacy Information · Demining Victim Information · Economic Information · Education Professional Information · Event Information · Household Information · Household Situation · Interview Information · Medical Information · Needs Assessment Information · Personal Information · Social Inclusion Information · Uncategorised · Cause/Event · Needs Assessment · Received Education

Assistance	Assistance · Given Assistance

Education	Information Classification Uncategorised · Education Details

QM	QM

Task · Work item · Task Child Tables

Other

@@ Line 1: / Line 1: @@
 {{Note | The child tables of Task are not visible in the Data Inventory Manager. }}
 {|
 |- valign="top"
 |
-[[Image:Uncategorised.png|100px]]
+[[Image:Task category.png|100px]]
+|
+{| class="wikitable sortable"
+! colspan="5" | task_has_objective
+|-
+ ! Function !! Data type !! Database column name !! Enumcategory !! Pojo name
+|-
+| - || String ||  hazard_guid||  ||
+|-
+| - || Parent ||  task_guid ||  ||
+|}
+|}
+{|
+|- valign="top"
+|
+[[Image:Task category.png|100px]]
 |
 {| class="wikitable sortable"
@@ Line 23: / Line 37: @@
 |}
 |}
+{|
+|- valign="top"
+|
+[[Image:Task category.png|100px]]
+|
+{| class="wikitable sortable"
+! colspan="5" | task_status_history
+|-
+ ! Function !! Data type !! Database column name !! Enumcategory !! Pojo name
+|-
+| - || String ||  guid ||  || Guid
+|-
+| Reason || Text ||  reason ||  || Reason
+|-
+| Status || Single-select ||  status_guid || Task Status || Status
+|-
+| - || Parent ||  task_guid ||  || Task
+|}
+|}
 {{NavBox Data Dictionary}}
 [[Category:NAA]]