Difference between revisions of "Assistance Uncategorised"

Revision as of 17:56, 13 June 2017

	The Assistance item was added in 6.0.

	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.

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

@@ 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 [[Given Assistance Uncategorised | 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'' and the entity type is called ''Assistance''.<br/>
+The [[Given Assistance Uncategorised | Assistance child table]] for Given assistance is called ''victim_assistance_assistance'' and the entity type is called ''VICTIM_ASSISTANCE_ASSISTANCE''. <br/>
 The [[Assistance Classification Uncategorised | Assistance classification table]] is called ''assistance'' and the entity is called ''ASSISTANCE''.}}