Difference between revisions of "Assistance Uncategorised"
From IMSMA Wiki
(Created page with "{| {{table}} | Label||Database colum name||Data type |- | Assistance decided by||victim_assistance_decided_by_guid||Single Select |- | Assistance given at||victim_assistance_g...") |
|||
| Line 1: | Line 1: | ||
| − | + | [[Image:Beneficiaries.png|500px]] | |
| − | | Label | + | {{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 Assistance classification table is called ''assistance'' and the entity is called ''ASSISTANCE''.}} | ||
| + | {| class="wikitable" | ||
| + | ! Label !! Database column name !! Data type | ||
|- | |- | ||
| Assistance decided by||victim_assistance_decided_by_guid||Single Select | | Assistance decided by||victim_assistance_decided_by_guid||Single Select | ||
| Line 35: | Line 39: | ||
|- | |- | ||
| Status changed reason||status_change_reason_guid||Single Select | | Status changed reason||status_change_reason_guid||Single Select | ||
| − | |||
| − | |||
|} | |} | ||
| + | {{NavBox Data Dictionary}} | ||
| + | [[Category:NAA]] | ||
Revision as of 18:06, 27 January 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. |
| 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 |
