CHDA Domain 2 (Data Acquisition and Management) Study Guide With Complete Accurate Verified Answers.
9 views 0 purchase
Course
CHDA
Institution
CHDA
An audit tracking DB would contain information from the health care claim payment advice that is in what format? - correct answer 835 (originally payment and remittance advice was one transaction, the ASC X12 835 Payment and Remittance Advice, which su...
CHDA Domain 2 (Data Acquisition and Management)
An audit tracking DB would contain information from the health care claim payment advice that is in what format? - correct answer 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? - correct answer 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? - correct answer 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? - correct answer 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? - correct answer 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? - correct answer JOIN In healthcare, one of the primary uses for data warehouses is ____. - correct answer 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)
The most basic, or core, element in an information system is the ____. - correct answer Data (raw facts and figures that adhere to the principles of data quality set forth by AHIMA but do not provide value until they are processed into information)
The first level of HCPCS consists of ____. - correct answer CPT (level I of HCPCS
is composed of the CPT codes as published by the AMA and represents medical services and procedures performed by physicians and other healthcare providers)
ICD-10-CM is an example of ____. - correct answer Clinical classification (ICD and CPT represent similar procedures and diagnoses with single codes, useful for functions such as billing and monitoring resource utilization)
In SNOMED-CT, this term is used to describe how concepts are linked to one another. - correct answer Relationship (Example of a relationship in SNOMED-CT is that the concept diabetes mellitus is an endocrine disorder, another concept with a broader meaning)
The process by which concepts and terms in one system are associated with concepts and terms in another system is called ____. - correct answer Mapping (set of relationships of varying complexity established between two vocabularies in order to allow automated translation or connection between them)
Which of the following acronyms represents the language used to extract data from a database? - correct answer SQL
If a database contains two tables: physicians, patients. If a physician may be linked to many patients and patients may only be related to one physician, what is the cardinality of the relationship between the two tables? - correct answer One-to-many
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller RealGrades. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $13.49. You're not tied to anything after your purchase.
