Given Assistance Uncategorised: Difference between revisions

From IMSMA Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 7: Line 7:
! Label!!Database column name!! Data type
! Label!!Database column name!! Data type
|-
|-
| Given Assistance||assistance_base_data_guid||Single Select
| Given Assistance||assistance_base_data_guid||Single-select
|-
|-
| Status||status_guid||Single Select
| Status||status_guid||Single-select
|-
|-
| Start Date||start_date||Date
| Start Date||start_date||Date

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.
The Assistance classification table is called assistance and the entity is called ASSISTANCE.

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