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.

DIM Label Database column name Data type Enumcategory Pojo name iTERM Comment Text comments Comments COMMENT Cost Numeric cost Cost Currency Single-select currency_guid Unit Of Currency Currency CURRENCY - String guid Guid GUID Assistance ID String localid LocalId VICTIM_ASSISTANCE_ID Assistance Name String name Name VICTIM_ASSISTANCE_NAME Needs Assessment Done By Organisation needs_assessment_done_by_guid NeedsAssessmentDoneBy NEEDS_ASSESSMENT_DONE_BY Number of Direct Beneficiaries Integer number_of_direct_beneficiaries NumberOfDirectBeneficiaries VICTIM_ASSISTANCE_NUMBER_OF_DIRECT_BENEFICIARIES Number of Indirect Beneficiaries Integer number_of_indirect_beneficiaries NumberOfIndirectBeneficiaries VICTIM_ASSISTANCE_NUMBER_OF_INDIRECT_BENEFICIARIES Priority Single-select priority_enum_guid Priority Priority PRIORITY Status Change Comment Text status_change_comment StatusChangeComment STATUS_CHANGE_COMMENT Status Change Reason Single-select status_change_reason_guid Victim Assistance Status Changed Reason StatusChangeReason STATUS_CHANGE_REASON Status Changed Date Date status_changed_date StatusChangedDate STATUS_CHANGED_DATE Status Date status_guid VictimAssistanceStatus Status STATUS Assistance Decided By Organisation victim_assistance_decided_by_guid VictimAssistanceDecidedBy VICTIM_ASSISTANCE_DECIDED_BY Assistance Given At Place victim_assistance_given_at_guid VictimAssistanceGivenAt VICTIM_ASSISTANCE_GIVEN_AT Assistance Given By Organisation victim_assistance_given_by_guid VictimAssistanceGivenBy VICTIM_ASSISTANCE_GIVEN_BY Assistance Paid By Organisation victim_assistance_paid_by_guid VictimAssistancePaidBy VICTIM_ASSISTANCE_PAID_BY