Difference between revisions of "Assistance Uncategorised"
From IMSMA Wiki
| Line 6: | Line 6: | ||
! Label !! Database column name !! Data type | ! Label !! Database column name !! Data type | ||
|- | |- | ||
| − | | Assistance decided by||victim_assistance_decided_by_guid||Single | + | | Assistance decided by||victim_assistance_decided_by_guid||Single-select |
|- | |- | ||
| − | | Assistance given at||victim_assistance_given_at_guid||Single | + | | Assistance given at||victim_assistance_given_at_guid||Single-select |
|- | |- | ||
| − | | Assistance given by||victim_assistance_given_by_guid||Single | + | | Assistance given by||victim_assistance_given_by_guid||Single-select |
|- | |- | ||
| Assistance ID||localid||String | | Assistance ID||localid||String | ||
| Line 16: | Line 16: | ||
| Assistance Name||name||String | | Assistance Name||name||String | ||
|- | |- | ||
| − | | Assistance paid by||victim_assistance_paid_by_guid||Single | + | | Assistance paid by||victim_assistance_paid_by_guid||Single-select |
|- | |- | ||
| Comment||comments||Text | | Comment||comments||Text | ||
| Line 22: | Line 22: | ||
| Cost/Grant||cost||Numeric | | Cost/Grant||cost||Numeric | ||
|- | |- | ||
| − | | Currency||currency_guid||Single | + | | Currency||currency_guid||Single-select |
|- | |- | ||
| − | | Needs assessment done by||needs_assessment_done_by_guid||Single | + | | Needs assessment done by||needs_assessment_done_by_guid||Single-select |
|- | |- | ||
| Number of Direct Beneficiaries||number_of_direct_beneficiaries||Integer | | Number of Direct Beneficiaries||number_of_direct_beneficiaries||Integer | ||
| Line 30: | Line 30: | ||
| Number of Indirect Beneficiaries||number_of_indirect_beneficiaries||Integer | | Number of Indirect Beneficiaries||number_of_indirect_beneficiaries||Integer | ||
|- | |- | ||
| − | | Priority||priority_enum_guid||Single | + | | Priority||priority_enum_guid||Single-select |
|- | |- | ||
| − | | Status||status_guid||Single | + | | Status||status_guid||Single-select |
|- | |- | ||
| Status changed comment||status_change_comment||Text | | Status changed comment||status_change_comment||Text | ||
| Line 38: | Line 38: | ||
| Status changed date||status_changed_date||Date | | Status changed date||status_changed_date||Date | ||
|- | |- | ||
| − | | Status changed reason||status_change_reason_guid||Single | + | | Status changed reason||status_change_reason_guid||Single-select |
|} | |} | ||
{{NavBox Data Dictionary}} | {{NavBox Data Dictionary}} | ||
[[Category:NAA]] | [[Category:NAA]] | ||
Revision as of 18:21, 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 |
