Evaluate how the design of a database can affect data quality. Discuss the role of a data dictionary in ensuring both the quality of enterprise-wide data and data within a specific database applicati

• Evaluate how the design of a database can affect data quality.
• Discuss the role of a data dictionary in ensuring both the quality of enterprise-wide data and data within a specific database application.
• Discuss how to ensure the integrity and security of data within a database.
• Explain the concept of data warehousing and how it is applicable to decision support.
• Describe the purpose of healthcare data sets and standards used healthcare data collection.
• Identify different types of data sets and their purpose

Course outcome assessed in this Assignment:

•  Classify database technologies and healthcare information systems used to manage data and information.
•  Interact with others in a professional manner using appropriate communication and presentation skills.

AHIMA CEE Curriculum Mapping

Domain

Subdomain

Competency

Domain I. Data Content, Structure & Standards (Information Governance)

Subdomain I.A. Classification  Systems

1. Evaluate, implement and manage electronic applications/systems for clinical classification and coding

Domain I. Data Content, Structure & Standards (Information Governance)

Subdomain I.A. Classification  Systems

4. Evaluate the accuracy of diagnostic and procedural coding

Domain I. Data Content, Structure & Standards (Information Governance)

Subdomain I.C. Data Governance

4. Advocate information operability and information exchange

Domain I. Data Content, Structure & Standards (Information Governance)

Subdomain I.D. Data Management

2. Evaluate health information systems and data storage design

Domain I. Data Content, Structure & Standards (Information Governance)

Subdomain I.D. Data Management

3. Manage clinical indices/databases/registries

Domain I. Data Content, Structure & Standards (Information Governance)

Subdomain I.D. Data Management

5. Evaluate data from varying sources to create meaningful  presentations

Assignment Requirements

• Please complete all parts in a Microsoft Word document.
• The body of your document should be at least 1200 words in length.
• Quoting should be less than 10% of the entire paper. Paraphrasing is necessary.
• At least 4 credible sources from: 
• Schiza, E. C., Panos, G., David, C., Petkov, N., & Schizas, C. N. (2015). Integrated Electronic Health Record Database Management System: A Proposal. Studies In Health Technology And Informatics, 213187-190.
• El aboudi, N., & Benhlima, L. (2018). Big Data Management for Healthcare Systems: Architecture, Requirements, and Implementation. Advances In Bioinformatics, 1-10. doi:10.1155/2018/4059018
• Cobb, C., Sudar, S., Reiter, N., Anderson, R., Roesner, F., & Kohno, T. (2017). Computer security for data collection technologies. Development Engineering, doi:10.1016/j.deveng.2017.12.002
• Kuo, J. W., & Kuo, A. M. (2017). Integration of Health Information Systems Using HL7: A Case Study. Studies In Health Technology And Informatics, 234188-194.
• Hovenga, E. S. (2013). National healthcare systems and the need for health information governance. Studies In Health Technology And Informatics, 1933-23.
• Fahy, K., & Downing, K. (2017). Information governance addresses nationwide cybersecurity concerns. Health Management Technology, 38(10), 24.
• Khan, S. I., & Latiful Hoque, A. M. (2015). Development of National Health Data Warehouse for Data Mining. Database Systems Journal, 6(1), 3-13.

Instructions

Imagine that you are the Director of Health Information for a large hospital. As Director, you sit on various institution-wide committees which govern the organization’s policies. You have seen issues arise that cause you to propose changes in policies, procedures and operations across the hospital. Therefore, you have decided

to create a proposal to the CEO and Board of Directors, which you will develop in collaboration with committee teams. Please follow the instructions below in completion of this assignment.

Part

Competency  Assessed

Instructions

1

Evaluate, implementand manage electronicapplications/systems  for clinical classification and coding

Select two (2) applications/systems for clinical classification and coding (e.g., encoders, computer assisted coding (CAC), etc.) and appraise each vendor in terms of (1) capacity to evaluate quality coding practices, (2) possible implementation considerations/issues, and (3) systems management challenges and training needs. Provide support for one system that you find as the "best option" with rationale.

2

Evaluate the accuracyof diagnostic andprocedural coding

Consider the principles and applications of classification systems (e.g., ICD-10, HCPCS) and medical record auditing used within a clinical documentation improvement (CDI) program. Appraise the value and challenges of a quality CDI program by defending the need for ongoing CDI program support and critique at least three (3) challenges in the CDI process. Make connections between auditing, accurate diagnostic and procedural coding with classification systems, and CDI programs. Your executive summary should reflect upon the need for CDI and best practices for ensuring compliance.

3

Advocate informationoperability andinformation exchange

Critique one interoperability issue that is possible within the health information exchange (HIE) (e.g., patient identity matching). Appraise at least three (3) best practices that address the issue.

4

Evaluate healthinformation systems and data storage design

Evaluate at least three (3) health information systems (HIS) and three (3) data storage designs (e.g., onsite, cloud). Select the best HIS and data storage design for disaster recovery purposes. Indicate your selections with rationale.

5

Manage clinicalindices/databases/regist ries

Evaluate three (3) managerial challenges related to clinical indices, databases, and registries from the perspective of a hospital's health information management function. Recommend three (3) best practices or policies related to the management of secondary data sources.

6

Evaluate data fromvarying sources tocreate meaningfulpresentations

With respect to data warehousing, appraise at least two (2) approaches in data warehouse design that supports quality data management from varying sources, processing/storage of data throughout the warehouse model, and meaningful output into the presentation layer. Summarize your recommendations in the executive summary.