Question

In: Operations Management

A new hospital is preparing to open. They want to ensure that, when it is time...

A new hospital is preparing to open. They want to ensure that, when it is time to report on the national quality measures to The Joint Commission, the data flows properly.

Assist in creating the data dictionary for the following data elements to be reported by noting the correct format and allowable values.
Identify and use the appropriate source document for this information.
Admission date
Discharge disposition
Sex
Race
Hispanic
Payment source

Objective: Apply knowledge of database architecture and design

Assessment: Student will apply knowledge of database architecture and design by formatting a data dictionary to the standardization of internal and external forces to meet the needs of the enterprise.

Solutions

Expert Solution

Answer:

The data flow needs to be smooth so that the data can be extracted from the database and can be sends to any government or non government agencies upon requirements. The data sources should be controlled in such a way that the right data inputs are captured in the database and the avoids the data inaccuracy. The data inaccuracy is a major problem and it is very difficult to make the data in the correct form.

Database needs to be supported by the data dictionary so that the data can be selected from the data dictionary instead of typing the data so that the correct data will be captured in the database and it will avoids the data inaccuracy. Later it will be very helpful in data quality and the data can be easily used for required analysis.

Admission date: The data dictionary need to be formatted in such a way that the admission date is picked from the colander in the database system. The database will be formatted such that whenever any date entry is required, the colander will open and it will capture the date in the correct US format. The colander format will ensure right quality of admission date entry in the database and will ensure right quality of data.

Discharge disposition: The discharge disposition will be supported with dictionary data source as a list of sheet which will contain all possible disposition after discharge of patients. Thus the list will be updated in the database source and the value will be picked from this list only.
Sex: The sex value will be supported with dictionary data source as a list of sheet which will contain all possible disposition for sex like Male, Female, etc. Thus the list will be updated in the database source and the value will be picked from this list only.
Race: The race will be supported with the dictionary data sources which will contain all the name of race such that the suitable race will be picked from the drop down menu. The drop down menu will be supported with the lost of data.
Hispanic: The Hispanic list will be formatted and updated in the dictionary source so that the suitable field can be picked and it will maintain the data quality.
Payment source: The payment source list will be updated with a suitable list of data that will contain all the possible payment sources and can be picked from the drop down list.


Related Solutions

Michael and Sofia decided to open a new chain of restaurants, and they want to open...
Michael and Sofia decided to open a new chain of restaurants, and they want to open 2 branches in the city. What is the most appropriate source of finance? a. Sale of Assets b. Share of capital c. IOU d. Loan from a bank
1. We want to test a new drug and we want to ensure that all age...
1. We want to test a new drug and we want to ensure that all age groups are represented it to do this we split up the general population into age groups and then select randomly within each group state what type of sampling this is and support your answer. 1b. Describe what type of distribution this is and support your answer 2. We roll 5 six-sided die. What is the probability of obtanining exactly two 1s? 3. How many...
Crazy Cakes, a private company, is preparing to issue a bond to open a new bakery...
Crazy Cakes, a private company, is preparing to issue a bond to open a new bakery in an up-andcoming city. The bookkeeper, Sloan Baker, plans to amortize the bond using the effective interest method. For calculation purposes, assume the following information: The bond is expected to be a 4-year, $100,000 face value, 4% bond with an effective annual yield of 8%. Interest will be payable semiannually. If all goes well, the bond will be issued on March 1, 2021, and...
Shelly’s Auto Repair, a private company, is preparing to issue a bond to open a new...
Shelly’s Auto Repair, a private company, is preparing to issue a bond to open a new branch in an up-and-coming city. The bookkeeper, Carson Booker, plans to amortize the bond using the effective-interest method. For calculation purposes, assume the following information: The bond is expected to be a 5-year, $100,000 face value, 6% bond with an effective annual yield of 5%. Interest will be payable semiannually. If all goes well, the bond will be issued on March 1, 2021, and...
What do you need to ensure when preparing and distributing reports that document accounts receivable, debt...
What do you need to ensure when preparing and distributing reports that document accounts receivable, debt recovery type and cause, and debt recovery plan?
11. What do you need to ensure when preparing and distributing reports that document accounts receivable,...
11. What do you need to ensure when preparing and distributing reports that document accounts receivable, debt recovery type and cause, and debt recovery plans? 12. What types of accounting documentation will need to be filed, according to the organisational policies and procedures? List 4 examples 13. What documentation would you require to identify, investigate and rectify creditor invoice discrepancies?
Assume you want to open a new retail bookstore that carries both new and used books....
Assume you want to open a new retail bookstore that carries both new and used books. You hope that you can also bring in authors to the store in order to sign their books. You can select any city you would like in which to locate the bookstore. Using Michael Porter's five industry forces as your framework, determine the viability of actually opening your bookstore.
In a hospital setting, when might you want to know the mean differences between two or...
In a hospital setting, when might you want to know the mean differences between two or more groups? Please describe the situation, including how and why it would be used.
Describe a time when you or someone you know visited a hospital as a patient and...
Describe a time when you or someone you know visited a hospital as a patient and had a very bad experience with the care. Discuss the healthcare delivery systems that contributed to the bad experience.
Imagine yourself preparing to open a new restaurant. While you have never owned a restaurant yourself,...
Imagine yourself preparing to open a new restaurant. While you have never owned a restaurant yourself, you have over twenty years of experience in the industry, starting as a host(ess) and working up to a manager. You have approached many banks for loans, and have been turned down by all, since the restaurant business is very risky. What avenues might you pursue to gain the financing you need? For example, think outside of the box when it comes to considering...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT