Personal Information: Difference between revisions

Revision as of 19:49, 27 January 2016

	These are new Victim fields in version 6.0.

This Data Inventory category contains the following fields used for information about the victim.

Label	Database column name	Data type
Country Structure reference	country_structure_reference	Country Structure
Date Of Death	date_of_death	Date
Displacement Status	displacement_status	Single-select
Health ID Number	health_id_number	String
Height (cm)	height	Numeric
Marital status	marital_status	Single-select
National ID Expire Date	national_id_expire_date	Date
Personal Information Comment	personal_information_comment	Text
Phone number	phone_number	String
Relationship Direct Beneficiary	relationship_direct_beneficiary	Single-select
Shoe size	shoe_size	Numeric
Victim State	victim_state	Single-select
Victim Statistic Category		Multi-select
Victim Type	victim_type	Single-select
Vulnerable group		Multi-select
Weight (kg)	weight	Numeric

{{#switch:|subgroup|child=|none=|#default=

}}{{#if:|<td class="navbox-image " style="width:0%;padding:0px 2px 0px 0px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form · Attachments|+2}}{{#if:Point Types

Geospatial · Geopoint|+2}}{{#if:Task · Work item · Task Child Tables|+2}}{{#if:Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places|+2}}{{#if:Enumeration categories · Other tables · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>

{{{imageleft}}}

}}{{#if:Item Data|<td style="text-align:left;border-left-width:2px;border-left-style:solid;|{{#if:|<td class="navbox-image " style="width:0%;padding:0px 0px 0px 2px;" rowspan={{#expr:1{{#if: Overview DEF

Data Entry Form · Attachments|+2}}{{#if:Point Types

Geospatial · Geopoint|+2}}{{#if:Task · Work item · Task Child Tables|+2}}{{#if:Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places|+2}}{{#if:Enumeration categories · Other tables · Table differences between migrated and non-migrated databases|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}{{#if:|+2}}}}>

{{{image}}}

}}}}{{#if: Overview DEF
Data Entry Form · Attachments|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:personal information

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}|}}{{#if: DEFs| DEFs<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Overview DEF

Data Entry Form · Attachments

}}{{#if:Point Types
Geospatial · Geopoint|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:personal information

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF

Data Entry Form · Attachments|}}{{#if: Geo data| Geo data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Point Types

Geospatial · Geopoint

}}{{#if:Task · Work item · Task Child Tables|{{#if: Task | Task <td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Task · Work item · Task Child Tables

}}{{#if:Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places|{{#if:Auxiliary Data|Auxiliary Data<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Assistance Classification · Cause Classification · Country Structure · Needs Classification · Ordnance Classification · Organisation · Places

}}{{#if:Enumeration categories · Other tables · Table differences between migrated and non-migrated databases|{{#if:Other|Other<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

Enumeration categories · Other tables · Table differences between migrated and non-migrated databases

}}{{#if:|{{#if:|{{{group7}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list7}}}

}}{{#if:|{{#if:|{{{group8}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list8}}}

}}{{#if:|{{#if:|{{{group9}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list9}}}

}}{{#if:|{{#if:|{{{group10}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list10}}}

}}{{#if:|{{#if:|{{{group11}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list11}}}

}}{{#if:|{{#if:|{{{group12}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list12}}}

}}{{#if:|{{#if:|{{{group13}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list13}}}

}}{{#if:|{{#if:|{{{group14}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list14}}}

}}{{#if:|{{#if:|{{{group15}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list15}}}

}}{{#if:|{{#if:|{{{group16}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list16}}}

}}{{#if:|{{#if:|{{{group17}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list17}}}

}}{{#if:|{{#if:|{{{group18}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list18}}}

}}{{#if:|{{#if:|{{{group19}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list19}}}

}}{{#if:|{{#if:|{{{group20}}}<td style="text-align:left;border-left-width:2px;border-left-style:solid;|

{{{list20}}}

}}{{#if:|{{#if:Data Dictionary{{#switch:{{#if:|{{{border}}}|child}}|subgroup|child=|none=|#default=

}}{{#ifeq:|Template|{{#ifeq:{{#if:|{{{border}}}|child}}|child||{{#ifeq:{{#if:|{{{border}}}|child}}|subgroup||{{#switch:personal information

|doc
|sandbox
|testcases =
|#default = {{#switch:
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}} Overview DEF
Data Entry Form · Attachments Point Types

Geospatial · Geopoint|}}

{{{below}}}

}}{{#switch:|subgroup|child=

|none=|#default=}}{{#ifeq:|Template|{{#ifeq:|child||{{#ifeq:|subgroup||{{#switch:personal information

|doc
|sandbox
|testcases =
|#default = {{#switch:hlist
 |plainlist
 |hlist
 |hlist hnum
 |hlist vcard
 |vcard hlist = 
 |#default = 
 }}
}}

}}}}}}

@@ Line 9: / Line 9: @@
 |
 {| class="wikitable"
-! Field !! Data Type
+! Label !! Database column name !! Data type
 |-
- Country Structure reference||Country Structure
+| Country Structure reference||country_structure_reference||Country Structure
 |-
-| Date Of Death||Date
+| Date Of Death||date_of_death||Date
 |-
-| Displacement Status||Single Select
+| Displacement Status||displacement_status||Single-select
 |-
-| Health ID Number||String
+| Health ID Number||health_id_number||String
 |-
-| Height (cm)||BigDecimal
+| Height (cm)||height||Numeric
 |-
-| Marital status||Single Select
+| Marital status||marital_status||Single-select
 |-
-| National ID Expire Date||Date
+| National ID Expire Date||national_id_expire_date||Date
 |-
-| Personal Information Comment||Text
+| Personal Information Comment||personal_information_comment||Text
 |-
-| Phone number||String
+| Phone number||phone_number||String
 |-
-| Relationship Direct Beneficiary||Single Select
+| Relationship Direct Beneficiary||relationship_direct_beneficiary||Single-select
 |-
-| Shoe size||BigDecimal
+| Shoe size||shoe_size||Numeric
 |-
-| Victim State||Single Select
+| Victim State||victim_state||Single-select
 |-
-| Victim Statistic Category||Multiple Select
+| Victim Statistic Category||||Multi-select
 |-
-| Victim Type||Single Select
+| Victim Type||victim_type||Single-select
 |-
-| Vulnerable group||Multiple Select
+| Vulnerable group||||Multi-select
 |-
-| Weight (kg)||BigDecimal
+| Weight (kg)||weight||Numeric
 |-
 |}

Personal Information: Difference between revisions

Revision as of 19:49, 27 January 2016

Navigation menu

Search