Exam 9: Scrubbing and Mapping Data

Outpatient data revealed that some patients who were treated had very close street addresses, but different zip codes. This could be an issue of data _________.

If all columns and rows of a database are filled in and no data is missing, then the database is ________.

Charles used the ICD-9-CM code when he mapped it to the ICD-10-CM code. The ICD-10-CM code is the:

All data are collected with the same instrument, same database rules, EHR program, or with the same classification systems.

The new medical coder for the surgical orthopedic center realized that she needed to set a _________ constraint that prevents the admission date from being after the discharge date.

Using rules that changed each zip code to nine digits and every date of birth to consecutive two-digit month, two-digit day, and four-digit year are examples of what?

A constraint that restricts a data field to a given number of options is called what?

A pregnancy questionnaire inquired as to the educational level of expectant mothers. The fields used a set of options such as SHS (some high school), HSD (high school diploma), SC (some college), BD (bachelor's degree), MD (master's degree), and DD (doctoral degree). This is an example of what type of data constraint?

A data checks to see if all data are included for the task at hand is called data __________.

Because data may often be incomplete, inconsistent, and inaccurate, it is important to ____ the data.

Physicians in the oncology wing are recording patient insurance by abbreviation, but physicians in the pediatric wind use a number to represent the type of insurance. What type of data constraint is this?

Yesterday, while reviewing the addresses of the client list, Delilah noticed that there were problems with how the practice was recording route numbers. Some were recorded as the abbreviation "Rt" and some as "Rte," and other still were spelled out completely. She changed all of the abbreviations to the full spelling of route. What process was she engaged in?

One of the first EHR systems in his city was implemented by Dr. Watson. When he joined the hospital practice, the way that insurance was abbreviated and categorized was different. In order to map the doctor's old system to the hospital's new system used what type of constraint?

Doctor Smith recorded a newborn baby's weights in pounds, while Nurse Jones has all of the newborn weights in kilograms. This is an issue of data _______.

A piece of data has the suffix "Jr." instead of "II." What type of constraint is this called?

The ICD-9 to ICD-10 GEMs can result in which type of matches?

While looking through the data, you noticed that a hysterectomy procedure code was submitted for a male patient. What type of constraint is this called?

While looking through the data, you noticed that the coded set for marriage status included "M" for married, "S" for single, and "D" for divorced. This is an example of what type of constraint?

After the data is collected and before it is cleaned, the most important step is to back up the database.

Some of the orthopedic discharge forms list the date as 2024 instead of 2014. What type of data constraint is this?