Forum Discussion

bdeleur's avatar
bdeleur
Icon for Helper III rankHelper III
3 years ago
Solved

Discharge department

Hi,   I want to make a report witch contains the following information. Out of a big data file I want to extract the follow up department. So I have department A and how many have a transfer (dis...
Help
  • tamerj1's avatar
    tamerj1
    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.

bdeleur's avatar
bdeleur
Icon for Helper III rankHelper III
3 years ago

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?

andhiii079845's avatar
andhiii079845
Icon for Solution Sage rankSolution Sage
3 years ago

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 ?