Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlkiller
Starting Member
1 Post |
 Posted - 2012-01-26 : 11:16:58
|
| Hi All,i have a request from the user to work on Financial Length of Stay for each month i.e, total no of days the different patients stayed in for that month / total no of discharged patients.Say i have 100 patients admitted from Jan 1- Jan 31 and all 99 patients discharged before or on Jan 31 and 1 patient in next month in Feb, so the length of stay for 99 patients is say 100 days.therefore financial length of stay will be 100/99.The other 1 patient discharged in next month should be included into feb month discharge patients list.any help will be appreciated.I have all data in a table with columnspatientid,admit_date,dischrg_date,lengthofstay(admitdate-dischardate)in days. |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-26 : 11:51:49
|
| Is the length of stay for 99 patients = 100 because there are total of 100 patients? Or is it based on some other criterion, such as adding up the number of days each patient stayed (which doesn't seem like it because, that would mean that 99 patients stayed one day each and the 100th patient was admitted on the last day of the month) |
 |
|
|
|
|
|
Financial Length of Stay in healthcare