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.

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

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