Difference between revisions of "Assistance Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
Line 7: Line 7:
 
|- valign="top"
 
|- valign="top"
 
|
 
|
−
[[Image:Uncategorised.png|200px]]
+
[[Image:Uncategorised.png|50px]]
 
|
 
|
−
{| class="wikitable"
+
{| class="wikitable sortable"
−
  ! Label !! Database column name !! Data type
+
  ! DIM Label !! Database column name !! Data type !! Enumcategory !! Pojo name!! iTERM
 
|-
 
|-
−
| Assistance decided by||victim_assistance_decided_by_guid||Single-select
+
| Comment||Text|| comments||||Comments|| COMMENT
 
|-
 
|-
−
| Assistance given at||victim_assistance_given_at_guid||Single-select
+
| Cost||Numeric|| cost||||Cost||  
 
|-
 
|-
−
| Assistance given by||victim_assistance_given_by_guid||Single-select
+
| Currency||Single-select|| currency_guid||Unit Of Currency||Currency|| CURRENCY
 
|-
 
|-
−
| Assistance ID||localid||String
+
| -||String|| guid||||Guid|| GUID
 
|-
 
|-
−
| Assistance Name||name||String
+
| Assistance ID||String|| localid||||LocalId|| VICTIM_ASSISTANCE_ID
 
|-
 
|-
−
| Assistance paid by||victim_assistance_paid_by_guid||Single-select
+
| Assistance Name||String|| name||||Name|| VICTIM_ASSISTANCE_NAME
 
|-
 
|-
−
| Comment||comments||Text
+
| Needs Assessment Done By|| Organisation|| needs_assessment_done_by_guid||||NeedsAssessmentDoneBy|| NEEDS_ASSESSMENT_DONE_BY
 
|-
 
|-
−
| Cost/Grant||cost||Numeric
+
| Number of Direct Beneficiaries|| Integer|| number_of_direct_beneficiaries||||NumberOfDirectBeneficiaries|| VICTIM_ASSISTANCE_NUMBER_OF_DIRECT_BENEFICIARIES
 
|-
 
|-
−
| Currency||currency_guid||Single-select
+
| Number of Indirect Beneficiaries||Integer|| number_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries|| VICTIM_ASSISTANCE_NUMBER_OF_INDIRECT_BENEFICIARIES
 
|-
 
|-
−
| Needs assessment done by||needs_assessment_done_by_guid||Single-select
+
| Priority||Single-select|| priority_enum_guid||Priority||Priority|| PRIORITY
 
|-
 
|-
−
| Number of Direct Beneficiaries||number_of_direct_beneficiaries||Integer
+
| Status Change Comment||Text|| status_change_comment||||StatusChangeComment|| STATUS_CHANGE_COMMENT
 
|-
 
|-
−
| Number of Indirect Beneficiaries||number_of_indirect_beneficiaries||Integer
+
| Status Change Reason||Single-select|| status_change_reason_guid||Victim Assistance Status Changed Reason||StatusChangeReason|| STATUS_CHANGE_REASON
 
|-
 
|-
−
| Priority||priority_enum_guid||Single-select
+
| Status Changed Date||Date|| status_changed_date||||StatusChangedDate|| STATUS_CHANGED_DATE
 
|-
 
|-
−
| Status||status_guid||Single-select
+
| Status||Date|| status_guid||VictimAssistanceStatus||Status|| STATUS
 
|-
 
|-
−
| Status changed comment||status_change_comment||Text
+
| Assistance Decided By|| Organisation|| victim_assistance_decided_by_guid||||VictimAssistanceDecidedBy|| VICTIM_ASSISTANCE_DECIDED_BY
 
|-
 
|-
−
| Status changed date||status_changed_date||Date
+
| Assistance Given At|| Place|| victim_assistance_given_at_guid||||VictimAssistanceGivenAt|| VICTIM_ASSISTANCE_GIVEN_AT
 
|-
 
|-
−
| Status changed reason||status_change_reason_guid||Single-select
+
| Assistance Given By|| Organisation|| victim_assistance_given_by_guid||||VictimAssistanceGivenBy|| VICTIM_ASSISTANCE_GIVEN_BY
 +
|-
 +
| Assistance Paid By|| Organisation|| victim_assistance_paid_by_guid||||VictimAssistancePaidBy|| VICTIM_ASSISTANCE_PAID_BY
 
|}
 
|}
 
|}
 
|}
 
{{NavBox Data Dictionary}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Revision as of 12:33, 1 February 2016

Beneficiaries.png

Note.jpg 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.

Uncategorised.png

DIM Label Database column name Data type Enumcategory Pojo name iTERM
Comment Text comments Comments COMMENT
Cost Numeric cost Cost
Currency Single-select currency_guid Unit Of Currency Currency CURRENCY
- String guid Guid GUID
Assistance ID String localid LocalId VICTIM_ASSISTANCE_ID
Assistance Name String name Name VICTIM_ASSISTANCE_NAME
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 VICTIM_ASSISTANCE_NUMBER_OF_DIRECT_BENEFICIARIES
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
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
Status Changed Date Date status_changed_date StatusChangedDate STATUS_CHANGED_DATE
Status Date status_guid VictimAssistanceStatus Status STATUS
Assistance Decided By Organisation victim_assistance_decided_by_guid VictimAssistanceDecidedBy VICTIM_ASSISTANCE_DECIDED_BY
Assistance Given At Place victim_assistance_given_at_guid VictimAssistanceGivenAt VICTIM_ASSISTANCE_GIVEN_AT
Assistance Given By Organisation victim_assistance_given_by_guid VictimAssistanceGivenBy VICTIM_ASSISTANCE_GIVEN_BY
Assistance Paid By Organisation victim_assistance_paid_by_guid VictimAssistancePaidBy VICTIM_ASSISTANCE_PAID_BY
Item Data
Assistance  · Given Assistance
DEFs
Geo data
Task
Auxiliary Data
Other
Retrieved from "http://mwiki.gichd.org:8090/mediawiki/index.php?title=Assistance_Uncategorised&oldid=20913"