Deck 9: Scrubbing and Mapping Data

Question 1

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) comprehensiveness
B) accuracy
C) consistency
D) granularity

Answer 1

granularity

Question 2

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?

A) Unique
B) Data-type
C) Mandatory
D) Set-membership

Answer 2

Data-type

Question 3

If data are the same across different databases, then the data is _____.

A) comprehensive
B) accurate
C) consistent
D) clean

Answer 3

consistent

Question 4

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

A) clean
B) enhance
C) constrain
D) harmonize

Question 5

A constraint that has a data field (column) of unique values that is shared with other databases is referred to as what?

A) Unique
B) Foreign-key
C) Set-membership
D) Range

Question 6

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

A) comprehensive
B) accurate
C) consistent
D) none of the above

Question 7

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

A) comprehensiveness
B) accuracy
C) consistency
D) all of the above

Question 8

If a medical coder changes all short forms of words like Jr or Sr, or St or Rd, to their full length, then this is called data ______.

A) scrubbing
B) enhancement
C) constraints
D) harmonization

Question 9

What measures the quality characteristic of whether data is correct, valid, and free from errors?

A) Completeness
B) Accuracy
C) Consistency
D) Both b and c

Question 10

A constraint that occurs only once per patient, such as a social security number, is called what?

A) Unique
B) Mandatory
C) Set-membership
D) Range

Question 11

Whether or not data is alpha or numeric would be an example of data-type _________.

A) scrubbing
B) enhancement
C) constraints
D) harmonization

Question 12

On a medical history form, some patients did not answer the question regarding alcohol use. This is an issue of data ________.

A) comprehensiveness
B) accuracy
C) consistency
D) constraints

Question 13

One of the admissions administrators is using a coded set for gender that is M (male), F (female), and U (unknown). What type of data constraint is this?

A) Unique
B) Data-type
C) Mandatory
D) Set-membership

Question 14

If a medical coder adds information by checking against a validated database, then this is called data ______.

A) scrubbing
B) enhancement
C) constraints
D) harmonization

Question 15

A constraint that has limits as to a possible range is called what?

A) Unique
B) Mandatory
C) Set-membership
D) Range

Question 16

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 _________.

A) comprehensiveness
B) accuracy
C) consistency
D) granularity

Question 17

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

A) Unique
B) Mandatory
C) Set-membership
D) Range

Question 18

A constraint that requires a field to be filled in is called what?

A) Unique
B) Mandatory
C) Set-membership
D) Range

Question 19

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

A) Range
B) Unique
C) Foreign-key
D) Set-membership

Question 20

Checking data to see if they can actually be correct is checking for data __________?

A) data consistency
B) data completeness
C) data accuracy
D) data enhancement

Question 21

_________ refer to the rules that are used in the mapping process.

A) Constraints
B) Harmonizations
C) Heuristics
D) Equivalences

Question 22

While looking through the data, you noticed that John Carmichael was a patient with the same birth date as J.D. Carmichael or J. Daniel Carmichael. Checking to be sure that this patient was the same is an example of checking for data _______.

A) completeness
B) accuracy
C) consistency
D) uniformity

Question 23

The data set that the information is mapped from is called the __________.

A) synonymy
B) target
C) source
D) reference

Question 24

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?

A) Data scrubbing
B) Data mapping
C) Data enhancement
D) Data harmonization

Question 25

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

A) One to one
B) One to many matches
C) Many to one
D) All of the above

Question 26

The data set that the information is mapped to is called the ________.

A) synonymy
B) target
C) source
D) reference

Question 27

The process of figuring out which items are similar is called __________.

A) synonymy
B) data mapping
C) harmonization
D) enhancement

Question 28

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) Range
B) Unique
C) Foreign-key
D) Set-membership

Question 29

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.

A) range
B) unique
C) mandatory
D) set-membership

Question 30

Last week, John Luke worked on resolving duplicates that appeared in the database when he added three new cardiologists to the physician practice. What activity was he engaged in?

A) Data scrubbing
B) Data mapping
C) Data harmonization
D) Data enhancement

Question 31

The medical record number of a surgical patient appears in the patient's lab and imaging reports. This is an example of what type of data constraint?

A) Range
B) Unique
C) Foreign-key
D) Set-membership

Question 32

A __________ is a "list of details that describe each field in a database."

A) Data dictionary
B) Patient index
C) Key index
D) Membership constraint

Question 33

A list of details that describe each field in a database is called:

A) a data constraint.
B) a data map.
C) a data dictionary.
D) all of the above.

Question 34

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?

A) Range
B) Unique
C) Foreign-key
D) Set-membership

Question 35

While looking through the data, you noticed that a field requires a leading 0 such as 01, but data has been entered as 1. What type of constraint is this called?

A) Range
B) Unique
C) Foreign-key
D) Set-membership

Question 36

What are used to translate ICD-9-CM codes to ICD-10-CM/PCS codes and vice versa?

A) Data mappings
B) Source mappings
C) Target mappings
D) General equivalence mappings (GEMs)

Question 37

Ruth Johnson, DOB 6/15/56, appeared to be the same as Ruth C. Johnson, DOB 6/15/56, and Ruth Catherine Johnson, DOB 6/15/56. Checking to be sure that this patient was the same is an example of checking for data _______.

A) comprehensiveness
B) accuracy
C) consistency
D) granularity

Question 38

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?

A) Data-type
B) Mandatory
C) Set-membership
D) Range

Question 39

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

A) Data-type
B) Mandatory
C) Set-membership
D) Range

Question 40

A ____________ is a database that has a "list of patients who have received care at the health care facility and their encounter information, (it) is often used to correlate the patient with the file identification."

A) Patient data directory
B) Master patient index
C) Foreign-key index
D) Set-membership constraint

Question 41

Mapping is not useful when there is a software change that uses different names or formats for patient information.

Question 42

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

Question 43

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

Question 44

Which of the following is an example of a foreign-key constraint?

A) Patient's zip code
B) Date of discharge
C) Physician ID number
D) All of the above

Question 45

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

A) synonymy.
B) target.
C) source.
D) reference.

Question 46

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) Constraints
B) Harmonizations
C) Heuristics
D) Equivalences

Question 47

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?

A) Data-type
B) Mandatory
C) Set-membership
D) Range

Question 48

Data mapping is entered in and then no longer updated.

Question 49

Which of the following is NOT an example question aimed to assess the data accuracy?

A) Are the patients who carry delivery codes always women?
B) Are all the columns and databases filled in?
C) Are men the only patients who undergo prostatectomies?
D) Are you treating patients who have birth dates before 1900?

Question 50

Which of the following questions is used to address the issue of consistency?

A) Are men undergoing hysterectomies?
B) Are all the columns and databases filled in?
C) Are the data the same across different databases?
D) Are you treating patients who have birth dates before 1900?