DATA DICTIONARY

Kaplan University

HS415

DATA DICTIONARY

PART 1:

FIELD NAME	FIELD SIZE	DATA TYPE	DATA FORMAT	DESCRIPTION	EXAMPLE

Patient Name	20	Text	Aaaaa	The PT’s name	Isyces Cubes
Patient Gender	6	Text	Aaaaa	Male or Female	Female
Patient DOB	10	Date	MM/DD/YYYY	Date of birth of the PT	04/13/1984
Patient Race	20	Text	Aaaaa	The PT’s race	Black
Patient Address	40	Text	Aaaaa	The PT’s physical address	811 Tyce Ave.Denver, CO 80111
Patient SSN #	4	Numeric	XXXX	The last 4 digits of the PT’s SSN #	5588
Patient Contact #	12	10 Digits	Xxx-xxx-xxxx	The PT’s phone #	317-217-4933
Patient PCP	40	Text	Aaaaa	The PT’s doctor	Dr. Garrott, MD
Patient INS Carrier	10	Text	Aaaaa	The PT’s Insurance Provider	BCBS-CO
Patient HH Size	2	Numeric	XX	The PT’s household size	1

5 Challenges Working with Healthcare Data

Part 2:

1. Insufficient data standards

In order to understand how data standards could become insufficient, the meaning of data standards has to be addressed: data standards are informational components and elements of data sets entered into the computer system to help with decision support, inquire about certain patient outcomes, and the research patient’s history. The reason why these standards are able to become insufficient is because it’s dependent on the data entry and the accuracy of the collection of the information for each patient. Another reason is because that some private medical practices don’t practice sharing medical information with others either because they can’t due to lack of technology or they won’t because they don’t believe in sharing it & keeping the patient’s information in-house.

2. Variations in state privacy rules

State lines should have the same law down the line but there are hurdles preventing that. Some medical facilities might not share information without proper written consent or contest the written consent given. Also, even with the patient’s consent, some medical information is way too sensitive to share & can possibly need additional reasoning for why the information is requested. Understandable, but it makes it very hard for the medical lawyers representing the patient’s get the needed information to obtain a certain type of Medicaid and/or Disability. Another backfire is if the medical facility doesn’t have the HIE/EMR system the either send or receive the information being requested.

3. Inadequate patient matching capabilities

Patient matching is very crucial to sending and receiving their medical information from local hospitals to out of town medical facilities. Names, the DOB and the address can’t be the only data standards used to match the patient. Some data standards used in most parental hospitals aren’t being used in all medical facilities so the information can get mixed up. By using the patient’s SSN could be the right moves for patient matching, but what happens when the patient’s SSN isn’t obtained and entered into the system? Anyone that has the same name with a different suffix such as Sr. and Jr. can end up having their medical information mixed together claims being sent to the insurance providers can be inaccurate.

4. Financial concerns and investment costs

Money. Money is the ruler for everything, including healthcare. And unfortunately, non-for-profit medical facilities rely on the patient’s paying their bill and mainly grants, investments and incentives. But the healthcare industry has already donating and invested millions to hundreds of medical facilities, even the hospitals that don’t show Meaningful Use or have capable EMR interoperability. The Stakeholders are now seeing the downside of this and has raised the bar on the qualifications for approved monitorial support.

5. Need for information governance, trust, and cooperation

Trust is everything when it comes to managing anybody’s information. The employer has to trust the person they hired not to tarnish the reputation of the facility, but also not break the trust of the patient. Then there are policies and required guidelines that have to be in place for all staff to follow. If there is no structure, then there is no business. Last but not least, cooperation. Everyone, including the stakeholders, has to cooperate with State and Federal Laws and guidelines when it comes to having the needed healthcare I.T. systems and show signs of progression.

Medical Information is a Resourceful Key

Part 4

Healthcare revolves and relies on information either from already tried steps, exams and treatments, or by starting a brand new treatment. This is called a clinical trial. The information recorded by these clinical trials can provide the tools for more successful patient outcomes. Gathering all the notes, recorded failures, recorded treatments and the steps the breakthroughs will be helpful to make a medical journal or book and ready for publishing. Once the information is published, more grants, rewards, national attention, Federal incentives, and grand investments will come, just for sharing everything that was learned.

Informational resources give plenty of quality care to the patient and also help the healthcare provider make the right decision for each medical condition that may arise. These days, many people turn to the Internet for medical advice first to either save a trip to the ER or to save money from a medical bill, because they tend to trust the electronic consultations received providing medical expertise by who they trust to be competent and certified medical physicians. Electronic medical information provides needed direction for both the patient to gain knowledge of what worked and what didn’t, and for the physicians to gain knowledge of what treatments were already tried and failed.

Healthcare professors, medical trainers, physicians, medical lawyers, all of them has done medical research at some point by looking up someone else’s medical science for three reasons: to teach others in a class room, to train others on a job, or simply keep themselves currently informed on the ever changing medical field. That’s why information, no matter how it’s received, either by word of mouth, by peer-reviewed reading or electronically, it’s needed to learn or to able to share the knowledge with others, Knowledge is power and this type of power is made to be transferred all over the world.

Reference:

How to create a data dictionary https://www.youtube.com/watch?v=AeVJy-ow2b0

Data Dictionary https://www.youtube.com/watch?v=kH0bcw9P2Lc

De Lusignan, S., & van Weel, C. (2005). The use of routinely collected computer data for research in primary care: opportunities and challenges. Family practice, 23(2), 253-263.

Bresnick, Jennifer. (2015). What Are the 5 Key Challenges to Health Data Interoperability? Health IT Analytics

Diaz, J. A., Griffith, R. A., Ng, J. J., Reinert, S. E., Friedmann, P. D., & Moulton, A. W. (2002). Patients’ use of the Internet for medical information. Journal of general internal medicine, 17(3), 180-185.

PATIENT DATABASE July 8, 1905 Pregnancy Complications SHALOM

Preview YouTube video How to create a Data Dictionary