Difference between revisions of "Assistance Uncategorised"

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. The Assistance classification table is called assistance, the entity is called ASSISTANCE and the target 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 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"
+! colspan="5" | assistance
+|-
   ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 |-
@@ Line 49: / Line 52: @@
 |}
 |}
 {{NavBox Data Dictionary}}
 [[Category:NAA]]