Difference between revisions of "Assistance Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
 
(9 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Image:Beneficiaries.png|500px]]
+
[[Image:Beneficiaries.png|300px|left]]
{{Note | The Assistance parent table is called ''victim_assistance'' and the entity type is called ''Assistance''.
+
{{New_6.0 | The Assistance item was added in 6.0.}}
The Assistance child table for Given assistance is called ''victim_assistance_assistance'' and the entity type is called ''VICTIM_ASSISTANCE_ASSISTANCE''. <br>
+
{{Note | The Assistance parent table is called ''victim_assistance'', the entity type is called ''Assistance'', the target is called ''VictimAssistanceVersion'' and the main maXML artifact is [[Assistance Artifact|VictimAssistance]].<br/>
The Assistance classification table is called ''assistance'' and the entity is called ''ASSISTANCE''.}}
+
The [[Given Assistance Uncategorised | Assistance child table]] for '''Given assistance''' is called ''victim_assistance_assistance'', the entity type is called ''VICTIM_ASSISTANCE_ASSISTANCE'' and the target is called ''VictimAssistanceAssistanceVersion''. <br/>
 +
The [[Assistance Classification Uncategorised | Assistance classification table]] is called ''assistance'', the entity is called ''ASSISTANCE'' and the target is called ''Assistance''.}}
  
 
{|
 
{|
Line 10: Line 11:
 
|
 
|
 
{| class="wikitable sortable"
 
{| class="wikitable sortable"
! DIM Label !! Database column name !! Data type !! Enumcategory !! Pojo name!! iTERM
+
! colspan="5" | assistance
 
|-
 
|-
| Comment||Text|| comments||||Comments|| COMMENT
+
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 
|-
 
|-
| Cost||Numeric|| cost||||Cost||
+
| Cost||Numeric|| cost||||Cost
 
|-
 
|-
| Currency||Single-select|| currency_guid||Unit Of Currency||Currency|| CURRENCY
+
| Currency||Single-select|| currency_guid||Unit Of Currency||Currency
 
|-
 
|-
| -||String|| guid||||Guid|| GUID
+
| -||String|| guid||||Guid
 
|-
 
|-
| Assistance ID||String|| localid||||LocalId|| VICTIM_ASSISTANCE_ID
+
| Assistance ID||String|| localid||||LocalId
 
|-
 
|-
| Assistance Name||String|| name||||Name|| VICTIM_ASSISTANCE_NAME
+
| Assistance Name||String|| name||||Name
 
|-
 
|-
| Needs Assessment Done By|| Organisation|| needs_assessment_done_by_guid||||NeedsAssessmentDoneBy|| NEEDS_ASSESSMENT_DONE_BY
+
| Needs Assessment Done By|| Organisation|| needs_assessment_done_by_guid||||NeedsAssessmentDoneBy
 
|-
 
|-
| Number of Direct Beneficiaries|| Integer|| number_of_direct_beneficiaries||||NumberOfDirectBeneficiaries|| VICTIM_ASSISTANCE_NUMBER_OF_DIRECT_BENEFICIARIES
+
| Number of Direct Beneficiaries|| Integer|| number_of_direct_beneficiaries||||NumberOfDirectBeneficiaries
 
|-
 
|-
| Number of Indirect Beneficiaries||Integer|| number_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries|| VICTIM_ASSISTANCE_NUMBER_OF_INDIRECT_BENEFICIARIES
+
| Number of Indirect Beneficiaries||Integer|| number_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries
 
|-
 
|-
| Priority||Single-select|| priority_enum_guid||Priority||Priority|| PRIORITY
+
| Priority||Single-select|| priority_enum_guid||Priority||Priority
 
|-
 
|-
| Status Change Comment||Text|| status_change_comment||||StatusChangeComment|| STATUS_CHANGE_COMMENT
+
| Status Change Comment||Text|| status_change_comment||||StatusChangeComment
 
|-
 
|-
| Status Change Reason||Single-select|| status_change_reason_guid||Victim Assistance Status Changed Reason||StatusChangeReason|| STATUS_CHANGE_REASON
+
| Status Change Reason||Single-select|| status_change_reason_guid||Victim Assistance Status Changed Reason||StatusChangeReason
 
|-
 
|-
| Status Changed Date||Date|| status_changed_date||||StatusChangedDate|| STATUS_CHANGED_DATE
+
| Status Changed Date||Date|| status_changed_date||||StatusChangedDate
 
|-
 
|-
| Status||Date|| status_guid||VictimAssistanceStatus||Status|| STATUS
+
| Status||Date|| status_guid||VictimAssistanceStatus||Status
 
|-
 
|-
| Assistance Decided By|| Organisation|| victim_assistance_decided_by_guid||||VictimAssistanceDecidedBy|| VICTIM_ASSISTANCE_DECIDED_BY
+
| Assistance Decided By|| Organisation|| victim_assistance_decided_by_guid||||VictimAssistanceDecidedBy
 
|-
 
|-
| Assistance Given At|| Place|| victim_assistance_given_at_guid||||VictimAssistanceGivenAt|| VICTIM_ASSISTANCE_GIVEN_AT
+
| Assistance Given At|| Place|| victim_assistance_given_at_guid||||VictimAssistanceGivenAt
 
|-
 
|-
| Assistance Given By|| Organisation|| victim_assistance_given_by_guid||||VictimAssistanceGivenBy|| VICTIM_ASSISTANCE_GIVEN_BY
+
| Assistance Given By|| Organisation|| victim_assistance_given_by_guid||||VictimAssistanceGivenBy
 
|-
 
|-
| Assistance Paid By|| Organisation|| victim_assistance_paid_by_guid||||VictimAssistancePaidBy|| VICTIM_ASSISTANCE_PAID_BY
+
| Assistance Paid By|| Organisation|| victim_assistance_paid_by_guid||||VictimAssistancePaidBy
 +
|-
 +
| Comment||Text|| comments||||Comments
 
|}
 
|}
 
|}
 
|}
 +
 
{{NavBox Data Dictionary}}
 
{{NavBox Data Dictionary}}
 
[[Category:NAA]]
 
[[Category:NAA]]

Latest revision as of 17:49, 5 November 2018

Beneficiaries.png
New 6.0.png The Assistance item was added in 6.0.
Note.jpg The Assistance parent table is called victim_assistance, the entity type is called Assistance, the target is called VictimAssistanceVersion and the main maXML artifact is VictimAssistance.

The Assistance child table for Given assistance is called victim_assistance_assistance, the entity type is called VICTIM_ASSISTANCE_ASSISTANCE and the target is called VictimAssistanceAssistanceVersion.
The Assistance classification table is called assistance, the entity is called ASSISTANCE and the target is called Assistance.

Uncategorised.png

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
Comment Text comments Comments