DESIGN AND IMPLEMENTATION OF A COMPUTERIZED HEALTH INSURANCE INFORMATION SYSTEM A CASE STUDY OF MINISTRY OF HEALTH ENUGU

0
611

ABSTRACT

Computerized patient record (CPR) has reached a state of technical maturity that makes them an essential component of mordern patient care. However, because information technogy standard do not exist, CPRs constructed by different vendors do not convey clinical infortion easily from provider to provider. Moreover unequal acess to capitals may mean a two-tier clinical information environment in the future. Nigeria health care system remained mired in a morass of paper record bill and unretured telephone message.

This project goes towords implementig and maintaining financial system (such as billing). Nigeria lags well behind other countries, notably Great Britain, Astrialia and New Zealand, in the adoptation of computerized clinical system. However a growing body of evidence suggested that

 fragementation and inacessible clinical informationalso threatens the lives and health of many Nigerians. This computerized health care system will serve as a modern for capturing and storing information on health. There are different programs that can be written to develop such programs, PASCAL, JAVA, VISUAL BASIC, C++ etc. But I will be making use of Visual Basic.

ORGANISATIONS OF WORK

         This work is divided into three sections namely; The premiliminary pages, chapters and finally refferences.

         The preliminary pages consist of title page, certification p[age, drdication, Acknowledgement, Abstract, organization of work and Table of contents.

        The chapters are organized into seven with chapter one consistin of introduction, statement problem, aims and objectives, purpose of study, significance of the study, scop/delimitation limitation, assumption and definition of terms. Chapter two deals with Literature review. Chapter three is centerd on the description and analysis of the existing system. This is made up of the following; fact finding method, organizational structure, objectives of the existing system, input and output analysis, information flow diagram, problems of the existing system and justification of the new system. Chapter four deals with the design of the new system. This involves input and output specifications and design, procedure chart, system flowchart and system requirment chapter five treats on the implementation of the new system which contains program design, program flowchart, pseudocode, source program and test run. Chapter six concentrates on documentation while Chapter seven discusses recommendation and conclusion. Finally the last section refferences.

TABLE OF CONTENTS

TITLE……………………………………………………………………………………..i

APPROVAL PAGE……………………………………………………………………..ii

DEDICATION……………………………………………………………………………iii

ACKNOWLEDGMENT…………………………………………………………………iv

ABSTRACT……………………………………………………………………………….v

ORGANIZATION OF WORK………………………………………………………..vi

LIST OF FIGURES……………………………………………………………………..

TABLE OF CONTENTS………………………………………………………………vii

CHAPTER ONE

1.0 INTRODUCTION……………………………………………………………………1

1.1 STATEMENT OF PROBLEMS……………………………………………………1

1.2 AIMS AND OBJECTIVES…………………………………………………………3

1.3 PURPOSE OF STUDY………………………………………………………….….3

1.4 SIGNIFICANT OF THE STUDY………………………………………………..5

1.5 SCOPE/DELIMITATIONS OF THE STUDY…………………….…………..5

1.6 LIMITATION / CONSTRAINTS…………………………………………………5

1.7 ASSUMPTION OF STUDY……………………………………………………….6

1.8 DEFINITON OF TERMS…………………………………….……………………6

CHAPTER TWO

2.0 REVIEW OF THE RELATED LITERATURE…………………………………..8

CHAPTER THREE

3.0 DESCRIPTION AND ANALYSIS OF THE EXISTING SYSTEM…………13

3.1 FACT FINDING METHODS……………………………………………………….13

3.2 ORGANIZATIONAL STRUCTURE………………………………………………15

3.3 OBJECTIVES OF   THE EXISTING SYSTEMS………………………………15

3.4 INPUT, PROCESS AND OUTPUT ANALYSIS………………………….……16

    3.4.1 INPUT ANALYSIS…………………………………………………………….16

    3.4.2 PROCESSING ANALYSIS……………………………………………………17

    3.4.3 OUTPUT ANALYSIS………………………………………………………….17

3.5 INFORMATION FLOW DIAGRAM………………………………………………18

3.6 PROBLEMS OF THE EXISTING SYSTEM…………………………………….19

3.7 JUSTIFICATION OF THE NEW SYSTEM…………………………………….19

CHAPTER FOUR

4.0 DESIGN OF THE NEW SYSTEM……………………………………………….21

4.1 DESIGN STANDARD……………………………………………………………….21

4.2OUTPUT SPECIFICATION AND DESIGN…………………………………….21

4.3 INPUT SPECIFICATION AND DESIGN………………………………………22

    4.3.1 FILE DESIGN …………………………………………………………………23

4.4 PROCEDURE CHART………………………………………………………………25

4.5 SYSTEM FLOW CHART……………………………………………………………26

4.6 SYSTEM REQUIREMENTS……………………………………………………….26

    4.6.1 HARDWARE REQUIREMENT…………………………………………….26

    4.6.2 SOFTWARE REQUIREMENT……………………………………………..27

   4.6.3OPERATIONALREQUIREMENT……………………………………………27

   4.6.4 PERSONAL REQUIREMENT……………………………………………….28

CHAPTER FIVE

5.0IMPLEMETATION……………………………………………………………………29

5.1 DESIGNSTANDARD………………………………………………………………..29

5.2 PROGRAM DESIGN…………………………………………………………………29

    5.2.1 PROGRAM FLOWCHART…………………………………………………..32

    5.2.2PSEUDOCODE………………………………………………………………….41

5.3 THE SOURCE PROGRAM / CHIOCE OF LANGUAGE…………………….43

5.4 TEST RUN……………………………………………………………………………..44

5.5 USER TRAINING…………………………………………………………………….45

5.6 CUTOVER PROCESS……………………………………………………………….45

CHAPTER SIX

6.0 DOCUMENTATION……………….……………………………………………..46

6.1 PROGRAM DOCUMENTATION……………………………………………….46

6.2 USER DOCUMENTATION……………………………………………………….47

CHAPTER SEVEN

7.0 RECOMMENDATION, SUMMARY AND CONCLUSION…………………49

7.1RECOMMENDATION ………………………………………………………………49

7.2 SUMMARY AND …………………………………………………………………… 49

7.3 CONCLUSION……………………………………………………………………….49

           REFERENCE…………………………………………………………………… 50

           APPENDIX……………………………………………………………………..

           SOURCE LISTING…………………………………………………………..

           LIST OF FIGURES…………………………………………………………..

CHAPTER ONE

1.0 INTRODUCTION

Policymakers are currently considering proposals aimed at reducing the number of children without health insurance. The debate over various proposals could benefit from better information about the uninsured child population. To start, there is a lack of consensus about the number of uninsured children and the extent to which some of the uninsured are eligible for Medicaid but not participating. This study reviews the literature on children’s health insurance patens and Medicaid program participation.

1.1 Statement of Problems

This literature review is the first task in an eight month research contract awarded by the Department of Health and Human Services, Office of the Assistant Secretary for Planning and Evaluation (ASPE), to Mathematics Policy Research, Inc. (MPR). The overall study objective is to improve understanding of the issues involved in analysis of children’s health insurance patterns. This literature review was designed to identify key analytic questions that are not fully answered from current research. Subsequent tasks will include the design and implementation of further analyses of uninsured children using the Survey of Income and Program Participation (SIPP) and possibly other data as well. These analyses will benefit from the literature review, particularly with regard to the identification of methodological issues in measuring children’s health insurance patterns. This review also provides a basis of comparison for key estimates produced in the additional tasks of this effort.

1.2 Aim and Objectives

The study is aimed at developing a new information system that will be used for the Health Insurance System, and specifically, focuses on (1) uninsured children — how many are there, what are their characteristics, how long are they uninsured, and why are they uninsured; and (2) Medicaid eligibility, enrollment, participation rates, program dynamics, and measurement issues. In order to achieve this, the following objectives has to be met thus,

  1. Provision of accurate data/information of drugs from production to distribution,
  2. Ensuring efficient information retrieval,
  3. Reduction by more than 80% the over reliance on manual paper work and save more physical space,
  4. Increase by over 70% the system response time,
  5. Produce a real-time online reporting mechanism for the system, and
  6. Produce a framework for maintaining huge and reliable, efficient and effective as well as easy to use but highly secured database system for the agency.
DESIGN AND IMPLEMENTATION OF A COMPUTERIZED HEALTH INSURANCE INFORMATION SYSTEM A CASE STUDY OF MINISTRY OF HEALTH ENUGU