A large direct health and insurance medical provider needed an enterprise information management system to enable...

A large direct health and insurance medical provider needed an enterprise information management system to enable enterprise-wide information management and to support the effective use of data for critical cross-functional decision making. In addition, the company needed to resolve issues related to data redundancy, inconsistency, and unnecessary expenditure. The company faced several information challenges: The company data resided in multiple locations, the data were developed for department-specific use, and there was limited enterprise access. Also, data definitions were created by individual departments and were not standardized, and data were being managed by multiple departments within the company.

Given the situation, What solution would you propose for this company?
Discuss the role that data modelling would play in a project to solve this problem.
Support or Oppose the above statements with arguments

Solutions

Expert Solution

Information about the same patient will be generated and entered into the database through various tools in own proprietary data formats are employed. In this case, if any flawed user input are entered and imperfect database design leads to data inconsistency and redundancy.

In order to preclude data redundancy, inconsistency problems and less expenditure to create effective database structures before they are deployed. But in some cases, database which does not have effective data structures that can suffer from these problems, a process of database normalization should be implemented. The purpose of database normalization is to re-modify tables such a way that the relations among them are logical, so that database is scalable without any anomalies and avoid data redundancy, inconsistency problems and less expenditure. It is recommendable to design the database in the OLTP format which are highly normalized which avoids data duplication errors.

In health and insurance,a central semantic store approach can be deployed which concentrates on logging as well as storing all the rules employed by the database integration process in a single centralized repository. The reason for this approach is that data sources are updated and new ones which that included do not fall outside data integration rules.

venereology answered 1 year ago

Next > < Previous

Related Solutions

A large direct health and insurance medical provider needed an enterprise information management system to enable...

A large direct health and insurance medical provider needed an enterprise information management system to enable enterprisewide information management and to support the effective use of data for critical cross-functional decision making. In addition, the company needed to resolve issues related to data redundancy, inconsistency, and unnecessary expenditure. The company faced several information challenges: The company data resided in multiple locations, the data were developed for department-specific use, and there was limited enterprise access. In addition, data definitions were created...

Kabwe Medical Center Limited is a small health care provider owned by an Insurance Company. It...

Kabwe Medical Center Limited is a small health care provider owned by an Insurance Company. It employs five salaried physicians 5(doctors), five nurses, three support staff, and three clerical workers. The clerical workers perform activities such as reception, correspondence, cash receipts, billing, and appointment scheduling. Most patients pay for services rendered by cash or cheque on the day of their visit. Sometimes, however, the physician approves credit and files a memo with one of the clerks to set up the...

A medical office has many patients covered by WeCare, a preferred provider health insurance company. A...

A medical office has many patients covered by WeCare, a preferred provider health insurance company. A Level 1 office visit has a standard charge of $80. WeCare pays $50. The past history shows that WeCare denied 5% of claims for Level 1 office visits. There were 100 Level 1 office visits by WeCare patients in the past month. Assuming the same past history, what will the totals be for accounts receivable and less: Allowance for Uncollectible payments?

Information Management Systems: Benefits of Computerized Provider Order Entry System (CPOE)

You are the director of health information at a large medical Center that offers inpatient outpatient...

You are the director of health information at a large medical Center that offers inpatient outpatient and Emergency Care at several sites in one state. your medical center has announced that it will acquire a facility offering similar services in a neighboring state. the laws and regulations governing the retention and destruction of health records differ between the states. discuss how the lack of a consistent set of laws and regulations on these two matters affects the institutions you serve...

A management accountant is both an information provider and a part of management. Explain

ACCOUNTING INFORMATION SYSTEMS - ACC 332 12.8 Parktown Medical Center, Inc. is a small health care provider...

ACCOUNTING INFORMATION SYSTEMS - ACC 332 12.8 Parktown Medical Center, Inc. is a small health care provider owned by a publicly held corporation. It employs seven salaried physicians, ten nurses, three support staff, and three clerical workers. The clerical workers perform such tasks as reception, correspondence, cash receipts, billing, and appointment scheduling. All are adequately bonded. Most patients pay for services rendered by cash or check on the day of their visit. Sometimes, however, the physician who is to perform the...

Imagine you need to redesign the workflow of the medical coders in Health Information Management in...

Imagine you need to redesign the workflow of the medical coders in Health Information Management in order to accommodate the new financial reimbursement program that is being installed in the Business Office. Explain the impact of this system on the medical coders and detail how you would redesign their workflow around this new program.

Hello, Please assist with the following: What kind of medical information in a large health care...

Hello, Please assist with the following: What kind of medical information in a large health care organization database should be kept confidential? Why? What kind of information in a governmental database should be make public? Why?

Imagine you are the supervisor of the health information management (HIM) department in a large outpatient...

Imagine you are the supervisor of the health information management (HIM) department in a large outpatient clinic. This department manages patient records. Complaints about your department are becoming more frequent and intense than in the past. Some clinic employees have complained that the HIM department takes too long to retrieve patient records. Others have expressed dismay over the rudeness of HIM staff. You decide to talk about these problems with employees throughout the clinic. The clinic's receptionists respond to you...

Subjects