Census Data Assignment

READINGS
Read and understand the inpatient census data pg 481-523 of the Statistic chapter
(LaTour chapter 18).
Understand the following defintions:
-Hospital Inpatients-a hospital patient who is provided with room, board, and continuous
general nursing service in an area of the hospital where patients generally stay at least
overnight.
-Hospital Newborn-a hospital patient who was born in the hospital at the beginning of the
current inpatient hospitalization (normal or with some kind of pathologic condition).
Geographic Organization of the Facility:
Inpatient beds-accommodations with supporting services for inpatients excluding those
for newborn nursery.
Newborn bassinets-accommodations with supporting services for newborn (possibly
bassinets, cribs, incubators, isolettes in a regular nursery or NB-ICU).
Medical care units-an assemblage of inpatient beds (or newborn accommodations) and
related facilities and assigned personnel in which medical services are provided to a
defined and limited class of patients according to their particular medical care needs.
Special care unit-a medical care unit in which there is appropriate equipment and a
concentration of physicians, nurses, and others who have special skills and experience to
provide optimal medical care for critically ill patients, or continuous care of patients in
special diagnostic categories (ICU, CCU, NB-ICU).
Labor and delivery-a special unit in which there is appropriate equipment and a
concentration of physicians, nurses, and others who have special skills and experience to
provide services related to the labor and delivery of maternity patients.
Operating room-an area of a hospital equipped and staffed to provide facilities and
personnel services for the performance of surgical procedures but not considered a unit or
counted for inpatient census.
Events of Inpatient Hospitalization–the units of measurement in the census statistical
system:
Inpatient hospitalization-a period in a person’s life during which he is an inpatient in a
single hospital without interruption except by possible intervening leaves of absence.
Inpatient admission-the formal acceptance by a hospital of a patient who is to be provided
with room, board, and continuous nursing service in an area of the hospital where patients
generally stay at least overnight.
Hospital live birth-the complete expulsion or extraction from the mother, in a hospital
facility, of a product of conception, irrespective of the duration of the pregnancy, which,
after such expulsion or extraction, breathes or shows any other evidence of life, such
as:Â Beating of the heart, pulsation of the umbilical cord, or definite movement of
voluntary muscles whether or not the umbilical cord has been cut or the placenta is
attached; heartbeats are to be distinguished from transient cardiac contractions,
respirations from fleeting respiratory gasps.
Inpatient discharge-the termination of a period of inpatient hospitalization through the
formal release of the inpatient by the hospital (includes leaving against medical advice
(AMA) or death).
Fetal death-death prior to the complete expulsion or extraction from its mother, in a
hospital facility, of a product of human conception, fetus and placenta, irrespective of the
duration of pregnancy; the death is indicated by the fact that after such expulsion or
extraction, the fetus does not breathe or show any other evidence of life such as beating
of the heart, pulsation of the umbilical cord, or definitive movement of voluntary
muscles.
Stillbirth-after 20 completed weeks of gestation
Abortion-before 20 completed weeks of gestation
Neonatal death-death of a liveborn infant within the first 27 days, 23 hours, and 59
minutes of life.
Admission and Discharge or A&D-an inpatient hospitalization for which the patient is
admitted and discharged during one 24-hour period (midnight to midnight) census day.
Leave of absence-a day or period of hours occurring after the admission or prior to the
discharge of a hospital inpatient when they are no longer formally accepted by the
hospital as an inpatient because they are absent from the facility for personal reasons (vs
clinical reasons) and which are not counted if occurring over the census-taking hour.
Intrahospital transfer-a change in medical care unit for an inpatient.
Discharge transfer-the disposition of an inpatient to another health care institution at the
time of discharge.
Swing beds-hospital-based acute care beds that may be used flexibly to serve as longterm care beds.
Inpatient census-the number of inpatients present at any one time (census).
Daily inpatient census-the number of inpatients present at the census-taking time each
day plus any inpatients who were both admitted and discharged after the census-taking
time the previous day.
Inpatient service day-a unit of measure denoting one 24-hour period of inpatient service
(but appearing sometimes less than 24 hours and including A&Ds).
Total inpatient service days-the sum of all of the inpatient service days for each of the
days in the period under consideration.
Computation of the Census
-Counting of patients in a status of admission at the same “time” every day.
-To census of the previous day, add admissions and intrahospital transfers in, subtract
discharges and intrahospitals transfers out to get census today (Balancing!).
ASSIGNMENTS
On pages 486-489 it covers the inpatient census data calculations. In Figure 18.4 it shows
you an example to calculate the inpatient services days, you take the number of patients
in the hospital at midnight (11:59 pm) and add to that number those patients that were
admitted and discharged the same day (a/d).
On the census spreadsheet, for adults & children (a/c) you would take the data in column
B + column C + column F = Column G. Then Column G – column I – Column K =
Column L, then column L + column N = Column O, If column N is blank than there were
no patients admitted and discharged the same day so it is equal to a zero.
For newborns, column C + Column E = column H. Then Column H – column J = column
M. Then column M = column P. You can assume that no newborns were admitted and
discharged the same day for this assignment.
On sheet two, you are recapping the information from sheet 1. Row 4 is the 12:00 am
census on May 1, then in row 5 you would add the total number of admissions for the
entire month or column D from sheet 1, then add the total number of transfers in or
column F from sheet 1 = row7 on sheet 2. Next subtract the total number of discharges
for the entire month or column I from sheet 1, next subtract the total number of transfers
out or column K from sheet 1 which should then match the 11:59 census on May 31 or
row 10 on sheet 2. You would then do the same for the newborn numbers.
Complete the census data spreadsheet in Excel. Please use the formulas in
Excel to do the calculations for you. Submit completed copy to instructor. (25
pts)

Assignment #, Worksheet #1
Monthly Compilation of Inpatient Census and Inpatient Service Days
May, 200_
12:00 Census 11:59 census Serv Days Serv Days
Day A/C Nb Adm A/C b Trf in Total A/C Total b Dis A/C Dis b Trf out A/C Nb a/d A/C Nb
1 162 2 22 1 10 194 3 19 0 10 165 3 1 166 3
2 165 3 29 0 8 23 1 8
3 14 2 3 24 0 3 1
4 24 0 5 25 0 5
5 11 1 6 25 2 6
6 20 0 1 16 0 1
7 29 0 10 17 0 10
8 24 2 13 20 0 13 3
9 23 1 7 22 1 7 1
10 19 0 10 17 0 10
11 11 0 5 22 3 5 1
12 16 0 6 24 0 6
13 18 1 5 25 0 5
14 29 0 5 19 0 5
15 28 0 8 22 2 8 1
16 26 3 6 19 0 6
17 26 0 7 19 2 7
18 18 0 10 25 0 10
19 12 0 6 33 0 6
20 22 1 8 16 3 8 1
21 26 0 3 17 0 3 1
22 32 2 11 25 0 11 1
23 29 2 14 27 0 14
24 22 0 10 21 2 10
25 20 3 13 34 0 13
26 14 0 6 37 1 6 1
27 23 0 5 16 0 5
28 26 2 4 18 2 4
29 17 0 6 22 1 6 1
30 19 0 7 21 1 7
31 141 2 21 1 12 174 3 16 0 12 146 3 1 147 3