In the TRANSFERS table (which goes to VISIT_DETAIL) there is a care_site which tells you where the patient is moved to. However, there is no field to store the reason why a transfer was made (e.g. a bed transfer, a ward transfer, and so on).
In discussion we agree that this should go in a derived table because (1) it will make analysis easier and (2) it is inferred information.
In the TRANSFERS table (which goes to VISIT_DETAIL) there is a
care_sitewhich tells you where the patient is moved to. However, there is no field to store the reason why a transfer was made (e.g. a bed transfer, a ward transfer, and so on).In discussion we agree that this should go in a derived table because (1) it will make analysis easier and (2) it is inferred information.