Work item Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
Created page with "{{Note | The table is called ''work_item'' and the entity type is called ''WORK_ITEM''. }} {| |- valign="top" | 100px | {| class="wikitable sortable"..."
 
No edit summary
Line 54: Line 54:
|}
|}


{{Note | The table is called ''tool'' and is is not possible to create CDFs. }}
{|
|- valign="top"
|
[[Image:Wi category.png|100px]]
|
{| class="wikitable sortable"
! colspan="5" | tool
|-
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
|-
| - || String ||  guid ||  || Guid
|-
| Quantity || Integer ||  quantity ||  || Quantity
|-
| Resource ||  ||  resource_guid ||  || Resource
|-
| - || Parent ||  workitem_guid ||  || Workitem
|}
{{NavBox Data Dictionary}}
{{NavBox Data Dictionary}}
[[Category:NAA]]
[[Category:NAA]]

Revision as of 10:49, 16 March 2016

The table is called work_item and the entity type is called WORK_ITEM.

work_item
DIM Label Data type Database column name Enumcategory Pojo name
Actual End Date date actual_end_date ActualEndDate
Actual Start Date date actual_start_date ActualStartDate
Actual Work Days Numeric actual_work_days ActualWorkDays
Dependency String dependency_guid Dependency
- String guid Guid
(Link) - hazreduc_guid Hazreduc
Importance Single-select importance_guid Importance Importance
Work Item ID String localid LocalId
Manager String manager Manager
Activity Single-select method_guid Work Method Method
(Link) String mre_guid Mre
Name String name Name
Planned End Date Date planned_end_date PlannedEndDate
Planned Start Date Date planned_start_date PlannedStartDate
Planned Work Days Numeric planned_work_days PlannedWorkDays
(Link) String qa_guid Qa
Responsibility Organisation responsibility_guid Responsibility
Result Text result Result
Status Single-select status_guid Work Item Status Status
- Parent task_guid Task
(Link) String victim_assistance_guid VictimAssistance
The table is called tool and is is not possible to create CDFs.
}}{{#if: DEFs|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|}}{{#if:Point Types
Geospatial  · Geopoint|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

tool
DIM Label Data type Database column name Enumcategory Pojo name
- String guid Guid
Quantity Integer quantity Quantity
Resource resource_guid Resource
- Parent workitem_guid Workitem
{{#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:work item uncategorised
doc sandbox testcases = #default = {{#switch: plainlist hlist hlist hnum hlist vcard vcard hlist = #default =
 }}
}}
}}}}}}|
DEFs

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:work item 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:work item 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:work item uncategorised doc sandbox testcases = #default = {{#switch:hlist plainlist hlist hlist hnum hlist vcard vcard hlist = #default =
 }}
}}

}}}}}}