Biology Reference
In-Depth Information
Table 13.3
Information
Stored in the Database
Attribute
Description
Example
Provider
Same as in Table 13.2
Provider name: Kurnegala Base
Hospital, provider type: Hospital,
provider town/village: Kurunegala
Provider name: Sevanipatti-PHC,
provider type: Primary Health
Centre; provider town/village:
Sevanipatti
Provider name: Asiri Community
Healthcare Centre, provider type:
clinic; provider town/village:
Pannala
Disease
Same as in Table 13.2; can be null. The
database will try to resolve (suggest) a
diagnosis based on the received
symptoms
Dengue, cholera, malaria
Symptoms
Same as in Table 13.2; cannot be null
Fever, joint aches, vomit blood,
rash (dengue), fever, joint ache
(dengue), bloody stools (diarrhea)
Signs
Same as in Table 13.2; can be null
Swelling, rash, enlarged retina,
discoloration of tongue
Gender
Same as in Table 13.2. If the input value
is NULL, then will default to
“Unknown”
Male, female, or unknown
Age group
Same as in Table 13.2; cannot be null
Adult/child, 0-10, 11-20, … ,
91-100, infant (0-1), child (2-12),
teenager (13-19), youth (20-25),
adult (26-50), elder (50-100)
No. of
cases
Same as in Table 13.2; can be null, if null,
then will default to 1
Default value = 1 General value =
any “natural” number: 1, 2, 3, 4 ...
Date
Same as in Table 13.2; can be null
01/08/09 01-Aug-09
ICD-10
Single value: International Code for
Diseases version 10; the database will
resolve the value based on the
relationship of the codes associated
with the diagnosis (disease). The
healthcare workers will not be required
to submit this data but the internal
processes will fill in the voids.
A01.0 Typhoid fever A90-Dengue
fever B01-Varicella (chickenpox)
None; some diseases are not
classified. So “none” should be a
valid option
Long./lat.
Two values: GIS longitude and latitude
will be resolved by the database by
looking up the values from the
preregistered GIS location information
assigned to the provider's village/
town or other location identifier.
Long. = 8.1414 Lat. = 3.4123
Other
Multiple values: other attributes the user
can set or processes the user can
execute to detect adverse events
Weather information
