Forum Discussion
Discharge department
- 3 years ago
bdeleur
For now this is what I can provide you. The difference between Count 2 and Count 3 is that count 3 shall not count discharged from same department unless there is a discharge date. The difference shall not be noticed using the sample data as there are no blanks in the end date.
Hi, andhiii079845
A movement between departments uses the start and end date. When the end date and dismissal date are the same then the patient is discharged form that department.
patient 1 only had a transfer a to B, no discharge out of hospital
patient 2 didn't moved to another department and gets discharged out of hospital
patient 3 moved from department A to B and gets discharged out of B
Is that what you need?
Thank you for the explanation. So the discharge out of the hospital is not relevant, right? How you want to handle the case if a person go from A to B to C or A to B to A. ? Should every transfer should be count ?
- bdeleur3 years ago
Helper III
The discharge out of hospital is only relevant when there is no next department. Then "discharge" needs to count as an movement, but only for the last deparment for that patient.
Every transfer needs to be counted, even they move back to a department
- andhiii0798453 years ago
Solution Sage
Perhaps try tamerj1 solution if it works what you looking for. 🙂
If not, let us know.