CHDA Domain 2 (Data Acquisition and Management) Exam Study Guide |Graded A+|

CHDA Domain 2 (Data Acquisition and Management) Exam Study Guide |Graded A+| An audit tracking DB would contain information from the health care claim payment advice that is in what format? *Ans* 835 (originally payment and remittance advice was one transaction, the ASC X12 835 Payment and Remittance Advice, which supplied information about what payment was made on which claims) Data showing a physician's professional fee charges would be found on which billing format? *Ans* CMS-1500 (physicians submit claims via the 837P electronic format, which takes the place of the CMS-1500 billing form) The practice of "normalization" of a database prevents duplication of data elements and ensures the data conforms to a standard. There are three forms of normalization. The third normal form requires which of the following? *Ans* Eliminating fields that do not depend on the key (1NF eliminate repeating groups in tables, create a separate table for each set of related data, identify each set of related data with a primary key; 2NF create separate tables for sets of values that apply to multiple records, relate these tables with a foreign key) Which of the following is the process of refining a data model to reduce redundant storage of information and best describes the data and its relationships? *Ans* Normalization (entity relationship diagramming is a very useful process because it helps reduce errors; intrinsic to the process is normalization, which eliminates errors associated with updates, deletions, and insertions of data into the database; reduction of redundancy through normalization improves data quality) You need to interface data automatically from one clinical system to another. Which framework is most commonly used for this purpose in healthcare systems? *Ans* HL7 (most EHR systems import and export documents and data in some fashion via interfaces, there are few mandated standards although health level 7 (HL7) has become ubiquitous for some types of interfaces due to industry adoption rather than mandate) An executive has asked you to provide a single report that requires you draw data from multiple tables within a SQL compliant DB. Which of the following is the SQL operator that will allow you to do this? *Ans* JOIN In healthcare, one of the primary uses for data warehouses is ____. *Ans* Outcomes management (data warehouse applications have been primarily used for revenue management because no single transaction system can address all the different contractual and regulatory reimbursement formulas, clinical management where day to day patient data is fed into analytic applications to contribute to best practices, and outcomes management to study factors such as treatment regimens and response to treatment to develop best practices