Difference between revisions of "Given Assistance Uncategorised"

Revision as of 14:24, 1 February 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.

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

@@ Line 7: / Line 7: @@
 |- valign="top"
 |
-[[Image:Uncategorised.png|200px]]
+[[Image:Uncategorised.png|100px]]
 |
-{| class="wikitable"
+{| class="wikitable sortable"
-! Label!!Database column name!! Data type
+ ! DIM Label !! Data type !! Database column name !! Enumcategory !! Pojo name
 |-
-| Given Assistance||assistance_base_data_guid||Single-select
+| End Date|| Date|| end_date||||EndDate
 |-
-| Status||status_guid||Single-select
+| -||varchar|| guid||||Guid
 |-
-| Start Date||start_date||Date
+| Quantity|| Integer|| quantity||||Quantity
 |-
-| End Date||end_date||Date
+| Start Date|| Date|| start_date||||StartDate
 |-
-| Quantity||quantity||Integer
+| Status|| Date|| status_guid||VictimAssistanceAssistanceStatus||Status
+|-
+| Assistance||Parent|| victim_assistance_guid||||VictimAssistance
 |}
 |}
 {{NavBox Data Dictionary}}
 [[Category:NAA]]