NoPublic, bureaucrat, administrator
6,632
edits
Changes
no edit summary
[[Image:Beneficiaries.png|300px|left]]{{New_6.0 | The Assistance item was added in 6.0.}}{{Note | The Assistance parent tableis 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 [[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''.}} {||- valign="top"| Label[[Image:Uncategorised.png|50px]]|Database colum name{|class="wikitable sortable"! colspan="5" |Data typeassistance
|-
|-
| Assistance given atCost||victim_assistance_given_at_guidNumeric||Single Selectcost||||Cost
|-
| Assistance given byCurrency||victim_assistance_given_by_guidSingle-select|| currency_guid||Unit Of Currency|Single Select|Currency
|-
| Assistance ID-||localidString|| guid|||String|Guid
|-
| Assistance NameID||nameString|| localid|||String|LocalId
|-
| Assistance paid byName||victim_assistance_paid_by_guidString||Single Selectname||||Name
|-
| CommentNeeds Assessment Done By||commentsOrganisation||Textneeds_assessment_done_by_guid||||NeedsAssessmentDoneBy
|-
| Cost/GrantNumber of Direct Beneficiaries||costInteger||Numericnumber_of_direct_beneficiaries||||NumberOfDirectBeneficiaries
|-
| CurrencyNumber of Indirect Beneficiaries||currency_guidInteger||Single Selectnumber_of_indirect_beneficiaries||||NumberOfIndirectBeneficiaries
|-
| Needs assessment done byPriority||needs_assessment_done_by_guidSingle-select|| priority_enum_guid||Priority|Single Select|Priority
|-
| Number of Direct BeneficiariesStatus Change Comment||number_of_direct_beneficiariesText||Integerstatus_change_comment||||StatusChangeComment
|-
| Number of Indirect BeneficiariesStatus Change Reason||number_of_indirect_beneficiariesSingle-select||Integerstatus_change_reason_guid||Victim Assistance Status Changed Reason||StatusChangeReason
|-
| PriorityStatus Changed Date||priority_enum_guidDate||Single Selectstatus_changed_date||||StatusChangedDate
|-
| Status||Date||status_guid||Single SelectVictimAssistanceStatus||Status
|-
| Status changed commentAssistance Decided By||status_change_commentOrganisation||Textvictim_assistance_decided_by_guid||||VictimAssistanceDecidedBy
|-
| Status changed dateAssistance Given At||status_changed_datePlace||Datevictim_assistance_given_at_guid||||VictimAssistanceGivenAt
|-
| Status changed reasonAssistance Given By||status_change_reason_guidOrganisation||Single Selectvictim_assistance_given_by_guid||||VictimAssistanceGivenBy
|-
| Assistance Paid By|| Organisation|| victim_assistance_paid_by_guid||||VictimAssistancePaidBy|-| Comment||Text|| comments||||Comments|}
|}
{{NavBox Data Dictionary}}
[[Category:NAA]]