Difference between revisions of "Assistance Uncategorised"
From IMSMA Wiki
(9 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | [[Image:Beneficiaries.png| | + | [[Image:Beneficiaries.png|300px|left]] |
− | {{Note | The Assistance parent table is called ''victim_assistance'' | + | {{New_6.0 | The Assistance item was added in 6.0.}} |
− | The Assistance child table for Given assistance is called ''victim_assistance_assistance'' | + | {{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'' | + | 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" | ||
− | + | ! colspan="5" | assistance | |
|- | |- | ||
− | + | ! 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||Single-select|| currency_guid||Unit Of Currency||Currency |
|- | |- | ||
− | | -||String|| guid||||Guid | + | | -||String|| guid||||Guid |
|- | |- | ||
− | | Assistance ID||String|| localid||||LocalId | + | | Assistance ID||String|| localid||||LocalId |
|- | |- | ||
− | | Assistance Name||String|| name||||Name | + | | Assistance Name||String|| name||||Name |
|- | |- | ||
− | | Needs Assessment Done By|| Organisation|| needs_assessment_done_by_guid||||NeedsAssessmentDoneBy | + | | Needs Assessment Done By|| Organisation|| needs_assessment_done_by_guid||||NeedsAssessmentDoneBy |
|- | |- | ||
− | | Number of Direct Beneficiaries|| Integer|| number_of_direct_beneficiaries||||NumberOfDirectBeneficiaries | + | | Number of Direct Beneficiaries|| Integer|| number_of_direct_beneficiaries||||NumberOfDirectBeneficiaries |
|- | |- | ||
− | | Number of Indirect Beneficiaries||Integer|| number_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries | + | | Number of Indirect Beneficiaries||Integer|| number_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries |
|- | |- | ||
− | | Priority||Single-select|| priority_enum_guid||Priority||Priority | + | | Priority||Single-select|| priority_enum_guid||Priority||Priority |
|- | |- | ||
− | | Status Change Comment||Text|| status_change_comment||||StatusChangeComment | + | | 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||Single-select|| status_change_reason_guid||Victim Assistance Status Changed Reason||StatusChangeReason |
|- | |- | ||
− | | Status Changed Date||Date|| status_changed_date||||StatusChangedDate | + | | Status Changed Date||Date|| status_changed_date||||StatusChangedDate |
|- | |- | ||
− | | Status||Date|| status_guid||VictimAssistanceStatus||Status | + | | Status||Date|| status_guid||VictimAssistanceStatus||Status |
|- | |- | ||
− | | Assistance Decided By|| Organisation|| victim_assistance_decided_by_guid||||VictimAssistanceDecidedBy | + | | Assistance Decided By|| Organisation|| victim_assistance_decided_by_guid||||VictimAssistanceDecidedBy |
|- | |- | ||
− | | Assistance Given At|| Place|| victim_assistance_given_at_guid||||VictimAssistanceGivenAt | + | | Assistance Given At|| Place|| victim_assistance_given_at_guid||||VictimAssistanceGivenAt |
|- | |- | ||
− | | Assistance Given By|| Organisation|| victim_assistance_given_by_guid||||VictimAssistanceGivenBy | + | | Assistance Given By|| Organisation|| victim_assistance_given_by_guid||||VictimAssistanceGivenBy |
|- | |- | ||
− | | Assistance Paid By|| Organisation|| victim_assistance_paid_by_guid||||VictimAssistancePaidBy|| | + | | 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
The Assistance item was added in 6.0. |
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. |
|