Re: Need Help With an Update Script

add an "expected_discharge_date" and "actual_discharge_date" to the table.  Fill the
"expected_discharge_date" with a reasonable estimates based on other
data <

Sounds to be the right way to me. Another approach (with the same
result) could be to maintain a table with ICD diagnostic codes
(assuming a hospitals database has the diagnoses for each patient
stored in another table) and their corresponding estimated stay days
based on the experience for this sickness. Those patients with multi-
sicknesses get at least the longest stay time of their sicknesses
assigned.

Then it becomes easy to run a statistic which shows the patiens which
needed longer for convalescence and those which convaleced quicker
than the average.

brgds

Philipp Post
.