Difference between revisions of "Assistance Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
Line 10: Line 10:
 
|
 
|
 
{| class="wikitable sortable"
 
{| 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}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Revision as of 12:39, 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 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
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=20914"