Assistance Uncategorised

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.

Label	Database column name	Data type
Assistance decided by	victim_assistance_decided_by_guid	Single Select
Assistance given at	victim_assistance_given_at_guid	Single Select
Assistance given by	victim_assistance_given_by_guid	Single Select
Assistance ID	localid	String
Assistance Name	name	String
Assistance paid by	victim_assistance_paid_by_guid	Single Select
Comment	comments	Text
Cost/Grant	cost	Numeric
Currency	currency_guid	Single Select
Needs assessment done by	needs_assessment_done_by_guid	Single Select
Number of Direct Beneficiaries	number_of_direct_beneficiaries	Integer
Number of Indirect Beneficiaries	number_of_indirect_beneficiaries	Integer
Priority	priority_enum_guid	Single Select
Status	status_guid	Single Select
Status changed comment	status_change_comment	Text
Status changed date	status_changed_date	Date
Status changed reason	status_change_reason_guid	Single Select