Difference between revisions of "Assistance Uncategorised"

Revision as of 17:31, 10 March 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 60: / Line 60: @@
 ! colspan="5" | assistance_level
 |-
-! scope="col" | DIM_label || scope="col" | wiki_Data_type || scope="col" | DB_Column || scope="col" | Enumcategory || scope="col" | PojoMethod_name
+ ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 |-
 | - || String || dataEnterer ||  || TBD