NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "500px {{Note | The Assistance parent table is called ''victim_assistance'' and the entity type is called ''Assistance''. The Assistance child table..."
[[Image:Beneficiaries.png|500px]]
{{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
|-
| Given Assistance||assistance_base_data_guid||Single Select
|-
| Status||status_guid||Single Select
|-
| Start Date||start_date||Date
|-
| End Date||end_date||Date
|-
| Quantity||quantity||Integer
|}
{{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
|-
| Given Assistance||assistance_base_data_guid||Single Select
|-
| Status||status_guid||Single Select
|-
| Start Date||start_date||Date
|-
| End Date||end_date||Date
|-
| Quantity||quantity||Integer
|}