Difference between revisions of "Given Assistance Uncategorised"

From IMSMA Wiki
Jump to: navigation, search
 
(6 intermediate revisions by the same user not shown)
Line 1: Line 1:
[[Image:Given assistance.png|500px]]
+
 
 
{{Note | The Assistance parent table is called ''victim_assistance'' and the entity type is called ''Assistance''.
 
{{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 child table for Given assistance is called ''victim_assistance_assistance'', the entity type is called ''VICTIM_ASSISTANCE_ASSISTANCE'' and the target is called ''VictimAssistanceAssistanceVersion''. <br>
 
The Assistance classification table is called ''assistance'' and the entity is called ''ASSISTANCE''.}}
 
The Assistance classification table is called ''assistance'' and the entity is called ''ASSISTANCE''.}}
 
+
[[Image:Given assistance.png|500px]]
{| class="wikitable"
+
{|
! Label!!Database column name!! Data type
+
|- valign="top"
 +
|
 +
[[Image:Uncategorised.png|100px]]
 +
|
 +
{| class="wikitable sortable"
 +
! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 +
|-
 +
| End Date|| Date|| end_date||||EndDate
 +
|-
 +
| -||String|| guid||||Guid
 
|-
 
|-
| Given Assistance||assistance_base_data_guid||Single-select
+
| Quantity|| Integer|| quantity||||Quantity
 
|-
 
|-
| Status||status_guid||Single-select
+
| Start Date|| Date|| start_date||||StartDate
 
|-
 
|-
| Start Date||start_date||Date
+
| Status|| Single-select|| status_guid||VictimAssistanceAssistanceStatus||Status
 
|-
 
|-
| End Date||end_date||Date
+
| Assistance||Parent|| victim_assistance_guid||||VictimAssistance
 
|-
 
|-
| Quantity||quantity||Integer
+
| Assistance Classification||Classification|| assistance_base_data_guid||||Assistance
 +
|}
 
|}
 
|}
 +
{{NavBox Data Dictionary}}
 +
[[Category:NAA]]

Latest revision as of 10:48, 1 November 2018

Note.jpg 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, the entity type is called VICTIM_ASSISTANCE_ASSISTANCE and the target is called VictimAssistanceAssistanceVersion.
The Assistance classification table is called assistance and the entity is called ASSISTANCE.

Given assistance.png

Uncategorised.png

DIM Label Data type Database column name Enumcategory Pojo name
End Date Date end_date EndDate
- String guid Guid
Quantity Integer quantity Quantity
Start Date Date start_date StartDate
Status Single-select status_guid VictimAssistanceAssistanceStatus Status
Assistance Parent victim_assistance_guid VictimAssistance
Assistance Classification Classification assistance_base_data_guid Assistance