HIM 350 Module Five Worksheet

HIM 350 Module Five Worksheet
Name
Institution

Using query language modes that are user-friendly like “fill-in-the-blank” techniques could be used to key in the name of the patient to retrieve their data and send it to the patient. However, the Structured Query Language (SQL) has more commands that with a little training can enable the finding, printing and forwarding of the patient’s information to the specialist provider (Herret et al. 2015).
Alternatively, Oracle call interface programs could also extract data in the same fashion as an SQL query mode with additional programming. These two methods mirror each other in their versatility of commands while extracting data.
A table-based approach within the patient’s profile within their domain in the database can provide various categories of information regarding the patient.
The length of stay is calculated as the number of calendar days beginning from the day of the patient’s admission to their day of discharge. The time in the emergency room is added within this calculation as it involves both instances of acute or chronic care within the hospital setting (Herret et al. 2015).
Length of Stay = (Number of days of the month when patient was admitted – Day of date of admission of patient) + Days of months in between + Day of date of discharge of the patient.
3.
Total service days = 5,387
Total bed count days = 31
Therefore;
= (5,387 ÷ 31)
= 173.77
It is important for the specialist provider to comprehend the terms as defined and used at the institution to enable their enable their complete understanding of the data in all its forms absent of ambiguity in a manner that they can compare and contrast data from a third-party perspective.

Such vocabulary provides a framework and its contents that are used to support care decisions. Such is the basis of standardization of clinical data at the industry-level.
With vocabulary standards, sharing of data across the healthcare industry is possible. It increases the reliability of the data within an organization. Vocabulary standards repress redundancy, better documentation and control. Also, they make it easier to examine data for purposes of evidence-based practice.
Average daily census of adults and children for the year
(Total service days for a period ÷ Total bed count days in the period)
Total service days = 75,800 + 11,800 = 87,600
Total bed count days = 1 year = 365 days
Therefore;
= (87,600 ÷ 365)
=240
Average daily census of newborns for the year
Total service days for newborns = 6,100
Therefore;
= (6,100 ÷ 365)
=16.71
=17
(Total length of stay (discharge days) ÷ Total discharges (includes deaths))
Total length of stay of adults and children (discharge days) = 9,000
Total discharges (includes deaths) adults and children = 1300
Therefore;
= 9000 ÷ 1300
Average Length of Stay for adults and children =6.92
Total length of stay for newborns (discharge days) = 231
Total discharges (includes deaths) of newborns = 90
Therefore;
= 231 ÷90
Average Length of Stay for newborns= 2.566
(Total number of patients receiving consultation for a given period ÷ Total number of discharges (including deaths) for the same period) ×100
Total number of patients receiving consultation = 3500
Total number of discharges (including deaths) = 25000
Therefore;
= (3500 ÷ 25000) × 100
Consulation Rate = 14%
(Total number of caesarian sections performed in a period ÷ Total number of deliveries in the period (including caesarian sections)) ×100
Total number of caesarian sections performed = 250
Total number of deliveries in the period (including caesarian sections = 600
Therefore;
= (250 ÷ 600) × 100 = 41.67
Cesarean-Section Rate = 41.67%
Gross Death Rate
(Number of inpatient deaths in a given period ÷ Number of discharged (including deaths) in that period) × 100
Number of inpatient deaths = 11 – 2 = 9
Number of discharged (including deaths) in that period = 1,100 + 125 + 85 + 11 = 1310 – 2
= 1308
Therefore;
= (9 ÷1308) × 100 = 0.688%
Gross Death Rate = 0.688%
Net Death Rate
(Total number of inpatient deaths – Inpatient deaths occurring less than 48 hours after admission) ÷ (Total number of discharges [including deaths] – Deaths occurring less than 48 hours after admission) × 100
Total number of deaths = 11
Inpatient deaths occurring less than 48 hours after admission = 1
Inpatient deaths occurring less than 48 hours after admission) ÷ (Total number of discharges [including deaths] = 1310
Deaths occurring less than 48 hours after admission = 0
Therefore;
= (11 ÷1325) × 100 = 0.83
Net Death Rate = 0.83%
Newborn Death Rate
(Total number of newborn deaths for a given period ÷ Number of discharged (including deaths) in that period) × 100
Total number of newborn deaths = 1
Number of discharged (including deaths) in that period = 85
Therefore;
= (1 ÷ 85) × 100 = 1.1764%
Newborn Death Rate = 1.1764%
(Total number of intermediate and/or late fetal deaths for a period ÷ Total number of live births + intermediate and late fetal deaths for the period) × 100
Total number of intermediate and/or late fetal deaths = 7 + 1
=8
Total number of live births + intermediate and late fetal deaths for the period = 322 + 8
= 330
Therefore;
= (8 ÷ 330) ×100 = 2.424
Fetal Death Rate = 2.424%
Using the data below, calculate the following rates:
February 2017
Deaths (adults and children) 12 (including 1 coroner’s case)
Discharges (adults and children) 1,125
Autopsies 3
Gross Autopsy Rate
(Total inpatient autopsies for a given period ÷total inpatient deaths for the perdiod) × 100
Total inpatient deaths = 12
Total inpatient autopsies = 3
Therefore;
= (3 ÷12) × 100 = 25%
Gross Autopsy Rate = 25%
Net Autopsy Rate
(Total autopsies on inpatient deaths for a given period ÷ Total inpatient deaths minus unautopsied coroners’ or medical examiners’ cases) × 100
Total autopsies inpatients deaths = 3
Total inpatient deaths minus unautopsied coroners’ or medical examiners’ cases = 11 – 1
= (3 ÷11) ×100
Net Autopsy Rate = 27.27%

References
Herrett, E., Gallagher, A. M., Bhaskaran, K., Forbes, H., Mathur, R., van Staa, T., & Smeeth, L. (2015). Data resource profile: clinical practice research datalink (CPRD). International journal of epidemiology, 44(3), 827-836.