Assistance Uncategorised: Difference between revisions

Revision as of 12:39, 1 February 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.

DIM Label	Data type	Database column name	Enumcategory	Pojo name
Cost	Numeric	cost		Cost
Currency	Single-select	currency_guid	Unit Of Currency	Currency
-	String	guid		Guid
Assistance ID	String	localid		LocalId
Assistance Name	String	name		Name
Needs Assessment Done By	Organisation	needs_assessment_done_by_guid		NeedsAssessmentDoneBy
Number of Direct Beneficiaries	Integer	number_of_direct_beneficiaries		NumberOfDirectBeneficiaries
Number of Indirect Beneficiaries	Integer	number_of_indirect_beneficiaries		NumberOfIndirectBeneficiaries
Priority	Single-select	priority_enum_guid	Priority	Priority
Status Change Comment	Text	status_change_comment		StatusChangeComment
Status Change Reason	Single-select	status_change_reason_guid	Victim Assistance Status Changed Reason	StatusChangeReason
Status Changed Date	Date	status_changed_date		StatusChangedDate
Status	Date	status_guid	VictimAssistanceStatus	Status
Assistance Decided By	Organisation	victim_assistance_decided_by_guid		VictimAssistanceDecidedBy
Assistance Given At	Place	victim_assistance_given_at_guid		VictimAssistanceGivenAt
Assistance Given By	Organisation	victim_assistance_given_by_guid		VictimAssistanceGivenBy
Assistance Paid By	Organisation	victim_assistance_paid_by_guid		VictimAssistancePaidBy

{{#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 10: / Line 10: @@
 |
 {| class="wikitable sortable"
-  ! DIM Label !! Database column name !! Data type !! Enumcategory !! Pojo name!! iTERM
+  ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 |-
-| Comment||Text|| comments||||Comments|| COMMENT
+| Cost||Numeric|| cost||||Cost
 |-
-| Cost||Numeric|| cost||||Cost||
+| Currency||Single-select|| currency_guid||Unit Of Currency||Currency
 |-
-| Currency||Single-select|| currency_guid||Unit Of Currency||Currency|| CURRENCY
+| -||String|| guid||||Guid
 |-
-| -||String|| guid||||Guid|| GUID
+| Assistance ID||String|| localid||||LocalId
 |-
-| Assistance ID||String|| localid||||LocalId|| VICTIM_ASSISTANCE_ID
+| Assistance Name||String|| name||||Name
 |-
-| Assistance Name||String|| name||||Name|| VICTIM_ASSISTANCE_NAME
+| Needs Assessment Done By|| Organisation|| needs_assessment_done_by_guid||||NeedsAssessmentDoneBy
 |-
-| Needs Assessment Done By|| Organisation|| needs_assessment_done_by_guid||||NeedsAssessmentDoneBy|| NEEDS_ASSESSMENT_DONE_BY
+| Number of Direct Beneficiaries|| Integer|| number_of_direct_beneficiaries||||NumberOfDirectBeneficiaries
 |-
-| Number of Direct Beneficiaries|| Integer|| number_of_direct_beneficiaries||||NumberOfDirectBeneficiaries|| VICTIM_ASSISTANCE_NUMBER_OF_DIRECT_BENEFICIARIES
+| Number of Indirect Beneficiaries||Integer|| number_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries
 |-
-| Number of Indirect Beneficiaries||Integer|| number_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries|| VICTIM_ASSISTANCE_NUMBER_OF_INDIRECT_BENEFICIARIES
+| Priority||Single-select|| priority_enum_guid||Priority||Priority
 |-
-| Priority||Single-select|| priority_enum_guid||Priority||Priority|| PRIORITY
+| Status Change Comment||Text|| status_change_comment||||StatusChangeComment
 |-
-| Status Change Comment||Text|| status_change_comment||||StatusChangeComment|| STATUS_CHANGE_COMMENT
+| Status Change Reason||Single-select|| status_change_reason_guid||Victim Assistance Status Changed Reason||StatusChangeReason
 |-
-| Status Change Reason||Single-select|| status_change_reason_guid||Victim Assistance Status Changed Reason||StatusChangeReason|| STATUS_CHANGE_REASON
+| Status Changed Date||Date|| status_changed_date||||StatusChangedDate
 |-
-| Status Changed Date||Date|| status_changed_date||||StatusChangedDate|| STATUS_CHANGED_DATE
+| Status||Date|| status_guid||VictimAssistanceStatus||Status
 |-
-| Status||Date|| status_guid||VictimAssistanceStatus||Status|| STATUS
+| Assistance Decided By|| Organisation|| victim_assistance_decided_by_guid||||VictimAssistanceDecidedBy
 |-
-| Assistance Decided By|| Organisation|| victim_assistance_decided_by_guid||||VictimAssistanceDecidedBy|| VICTIM_ASSISTANCE_DECIDED_BY
+| Assistance Given At|| Place|| victim_assistance_given_at_guid||||VictimAssistanceGivenAt
 |-
-| Assistance Given At|| Place|| victim_assistance_given_at_guid||||VictimAssistanceGivenAt|| VICTIM_ASSISTANCE_GIVEN_AT
+| Assistance Given By|| Organisation|| victim_assistance_given_by_guid||||VictimAssistanceGivenBy
 |-
-| Assistance Given By|| Organisation|| victim_assistance_given_by_guid||||VictimAssistanceGivenBy|| VICTIM_ASSISTANCE_GIVEN_BY
+| Assistance Paid By|| Organisation|| victim_assistance_paid_by_guid||||VictimAssistancePaidBy
-|-
-| Assistance Paid By|| Organisation|| victim_assistance_paid_by_guid||||VictimAssistancePaidBy|| VICTIM_ASSISTANCE_PAID_BY
 |}
 |}
 {{NavBox Data Dictionary}}
 [[Category:NAA]]

Assistance Uncategorised: Difference between revisions

Revision as of 12:39, 1 February 2016

Navigation menu

Search