DATABASE FUNDAMENTALS
DATA WAREHOUSING AND DATA MINING
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Average Length of Stay: The average length of stay is calculated by adding the total length of stay for each discharged resident in the month and dividing by the number of discharge residents in a month.
Detailed explanation-2: -Length of stay (LOS) is calculated by subtracting the admission date (ADATE) from the discharge date (DDATE).
Detailed explanation-3: -Length of stay (LOS) of one patient = date of discharge-date of admission. If these are the same dates, then LOS is set to one day. ALOS (Average length of stay) should preferably be provided to the accuracy of hundreds, i.e. 0.01. Ministry of Health.
Detailed explanation-4: -Estimated Discharge Date (Hospital Provider Spell) is the date a PATIENT was estimated to be discharged from a Hospital Provider Spell.