Difference between revisions of "Given Assistance Uncategorised"

Revision as of 13:26, 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
-	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

@@ Line 14: / Line 14: @@
 | End Date|| Date|| end_date||||EndDate
 |-
-| -||varchar|| guid||||Guid
+| -||String|| guid||||Guid
 |-
 | Quantity|| Integer|| quantity||||Quantity
@@ Line 20: / Line 20: @@
 | Start Date|| Date|| start_date||||StartDate
 |-
-| Status|| Date|| status_guid||VictimAssistanceAssistanceStatus||Status
+| Status|| Single-select|| status_guid||VictimAssistanceAssistanceStatus||Status
 |-
 | Assistance||Parent|| victim_assistance_guid||||VictimAssistance