Patient Demographics Assignment Patient Demographics Assignment
Patient Demographics Assignment
Patient Demographics Assignment
As a data steward, you have been asked to create a Microsoft Access database to store patient demographics. Once you have created the database, you must write policies to govern how the data should be collected, stored, and shared. Use search tools to help you write your policies.
Part-1: Create Your Access Database
Permalink: https://collepals.com/patient-demographics-assignment/
Be sure to include the following demographic elements in your database:
- Patient First Name
- Patient Last Name
- Patient Middle Initial
- Street Address
- State
- Zip Code
- Phone number
- Social Security Number
- Birthdate
- Gender
- Emergency Contact Name
- Emergency Contact Number
- Primary Physician
Once you have created the database with the patient demographic elements, provide fictitious information for 3 patients for each element.
Part-2: Create Your Policy and Procedure Document
In a Microsoft Word document, create a Policy and Procedure document to govern the collection, storage, and sharing of data. For your convenience, a blank policy and procedure template is provided below.
Patient demographics form the core of the data for any medical institution. They allow for the identification of a patient and his categorization into categories for the purpose of statistical analysis. In my work I have found that there are more or less 5 different ways of interpreting the term “demographics.”
- Date of birth, gender (Ref: Google Health)
- Birth year, gender, country, postal code, ethnicity, blood type (Ref: Microsoft HealthVault: Personal Demographic Information, Basic Demographic Information)
- (A or B) + Contact information (Name, Phone, Address)
- C + Emergency contact information, family doctor, insurance provider data
- (C or D) + Allergies, major diagnoses, major medical history
Now here is the problem: somewhere around item C, the definition of patient demographics starts to get polluted with items such as patient and emergency contact information and patient medical record data. There is a very good reason for this concept drift to have occurred in practice and I’ll break it down as to why it happened.
We can agree that date of birth and gender creates the most classic type of demographic. We can all remember reading news articles about key demographics such as males aged 55-65. Add in ethnicity and some geographical elements such as country and postal code and we have most of the classic of categories. Google Health and Microsoft HealthVault have been careful to adhere to this formal definition.
In the medical domain, however, there are additional elements that can be used to categorize patients, such as patients with a particular medical condition, allergy or past medical event, e.g. coronary bypass surgery in 1999. I would caution against including these as core demographics though. The reason for this is that they are specific enough that they can be called something else. Even Microsoft HealthVault felt the pressure and included blood type in one of its demographic “things” and this is probably because the term sometimes acts as a catchall and they didn’t know where else to put it.
The term patient demographics, therefore, should be used primarily for the same data items as marketing people use. Everything else has a different name like patient contact information, emergency contact information, family doctor, insurance provider information, etc.
A word of caution though, medical people will almost always include patient contact information when talking about patient demographics. There’s probably no traceable reason why this has happened, but if it helps, patient contact information (+ identifiers) does make it possible to divide the patient population into groups of 1 and this is needed to count how many people belong to the real demographic categories.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.