Abstract
Public Health Database Management System for Prik Municipality (PHDBMS_PM) was a research project supported by the Southern Health Systems Research Institute (HSRI) to study the healthy conditional prototype of a community at the level of sub-district municipality. Prik Municipality at Sadao district, Songkhla province was selected as a target area for this case study. The study composed of six stages. 1) Assessing community needs and collecting data, 2) Designing Knowledge Base System, 3) Developing Knowledge base System, 4) Developing skills and training for Knowledge 5) Developing Public Health Database Management System, and 6) Developing skills and training for Public Health Database Management System.
In the study process, there were a number of field surveys for collection data. The study developed a tool for knowledge management in the format of web application at URL: http://www.tonprikinfo.org for staffs of Prik Municipality, educational offices, and community people. The study process also included learning exchange by classifying on community of practice, story telling, local wisdom, center of excellence, forums, and lesson learned.
The result of assessing community needs indicated a total of indicators of five healthy conditions. 1) Physical condition with 28 indicators, 2) Emotional and spiritual condition with 9 indicators, 3) Social condition with 17 indicators, 4) Environmental condition with 11 indicators, and 5) Network condition with 2 indicators. The data were collected from three sources that were Prik Municipality, Prik Sanitation Station, and Basic Information Needed for Families from the Community Development Department, Ministry of Interior. The study developed a database system to indicate the healthy condition of Prik Municipality community through web application at URL: http://www.tonprikinfo.otg/application. The system shows the output in the easy understandable format with convenience to improving and searching for the information. This system supports three groups of users that are administrators, municipality staffs and community people in Prik community. The administrators can use information for decision-making such as planning the policy for the health of people in Prik community and etc.
The PHDBMS_PM is flexible that can be adjusted to increase, reduce, of change the indicators when needed by users and can be further applied as the prototype of public health database management system in other community as well.
