Assistance Uncategorised: Difference between revisions

Revision as of 18:21, 27 January 2016

	The Assistance parent table is called victim_assistance and the entity type is called Assistance. The Assistance child table for Given assistance is called victim_assistance_assistance and the entity type is called VICTIM_ASSISTANCE_ASSISTANCE. The Assistance classification table is called assistance and the entity is called ASSISTANCE.

Label	Database column name	Data type
Assistance decided by	victim_assistance_decided_by_guid	Single-select
Assistance given at	victim_assistance_given_at_guid	Single-select
Assistance given by	victim_assistance_given_by_guid	Single-select
Assistance ID	localid	String
Assistance Name	name	String
Assistance paid by	victim_assistance_paid_by_guid	Single-select
Comment	comments	Text
Cost/Grant	cost	Numeric
Currency	currency_guid	Single-select
Needs assessment done by	needs_assessment_done_by_guid	Single-select
Number of Direct Beneficiaries	number_of_direct_beneficiaries	Integer
Number of Indirect Beneficiaries	number_of_indirect_beneficiaries	Integer
Priority	priority_enum_guid	Single-select
Status	status_guid	Single-select
Status changed comment	status_change_comment	Text
Status changed date	status_changed_date	Date
Status changed reason	status_change_reason_guid	Single-select

{{#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:assistance 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:assistance 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:assistance 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:assistance uncategorised

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

}}}}}}

@@ Line 6: / Line 6: @@
   ! Label !! Database column name !! Data type
 |-
-| Assistance decided by||victim_assistance_decided_by_guid||Single Select
+| Assistance decided by||victim_assistance_decided_by_guid||Single-select
 |-
-| Assistance given at||victim_assistance_given_at_guid||Single Select
+| Assistance given at||victim_assistance_given_at_guid||Single-select
 |-
-| Assistance given by||victim_assistance_given_by_guid||Single Select
+| Assistance given by||victim_assistance_given_by_guid||Single-select
 |-
 | Assistance ID||localid||String
@@ Line 16: / Line 16: @@
 | Assistance Name||name||String
 |-
-| Assistance paid by||victim_assistance_paid_by_guid||Single Select
+| Assistance paid by||victim_assistance_paid_by_guid||Single-select
 |-
 | Comment||comments||Text
@@ Line 22: / Line 22: @@
 | Cost/Grant||cost||Numeric
 |-
-| Currency||currency_guid||Single Select
+| Currency||currency_guid||Single-select
 |-
-| Needs assessment done by||needs_assessment_done_by_guid||Single Select
+| Needs assessment done by||needs_assessment_done_by_guid||Single-select
 |-
 | Number of Direct Beneficiaries||number_of_direct_beneficiaries||Integer
@@ Line 30: / Line 30: @@
 | Number of Indirect Beneficiaries||number_of_indirect_beneficiaries||Integer
 |-
-| Priority||priority_enum_guid||Single Select
+| Priority||priority_enum_guid||Single-select
 |-
-| Status||status_guid||Single Select
+| Status||status_guid||Single-select
 |-
 | Status changed comment||status_change_comment||Text
@@ Line 38: / Line 38: @@
 | Status changed date||status_changed_date||Date
 |-
-| Status changed reason||status_change_reason_guid||Single Select
+| Status changed reason||status_change_reason_guid||Single-select
 |}
 {{NavBox Data Dictionary}}
 [[Category:NAA]]

Assistance Uncategorised: Difference between revisions

Revision as of 18:21, 27 January 2016

Navigation menu

Search