Difference between revisions of "Assistance Uncategorised"

Revision as of 10:22, 13 April 2016

	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]]
 {{Note | 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''. <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 table is called ''assistance'' and the entity is called ''ASSISTANCE''.}}
+The [[Assistance Classification Uncategorised | Assistance classification table]] is called ''assistance'' and the entity is called ''ASSISTANCE''.}}
 {|
@@ Line 52: / Line 52: @@
 |}
-{|
-|- valign="top"
-|
-[[Image:Uncategorised.png|50px]]
-|
-{| class="wikitable sortable"
-! colspan="5" | assistance_level
-|-
- ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
-|-
-| - || String || dataEnterer ||  || TBD
-|-
-| - || Date || dataEntryDate ||  || TBD
-|-
-| - || String || guid ||  || TBD
-|-
-| - || String || level ||  || TBD
-|-
-| - || Integer || seqNo ||  || TBD
-|}
-|}
 {{NavBox Data Dictionary}}
 [[Category:NAA]]