Clinical Assessment Unit: Difference between revisions
Ttenbergen (talk | contribs) mNo edit summary |
Ttenbergen (talk | contribs) |
||
| Line 16: | Line 16: | ||
* as per Julie: "I have checked the database and there are also CAU entries at GRA and STB in pre-admit institution, previous loc and dispo (GRA_CAU, STB_CAU). Do they move location too? Can we ask the DC? If so, make it generic _ward. | * as per Julie: "I have checked the database and there are also CAU entries at GRA and STB in pre-admit institution, previous loc and dispo (GRA_CAU, STB_CAU). Do they move location too? Can we ask the DC? If so, make it generic _ward. | ||
In the tmp Boarding Loc, there are 12 cases GH-CAU – so it looks like Internal med is borrowing CAU Bed. What to do here – change to GRA boarding? | * In the tmp Boarding Loc, there are 12 cases GH-CAU – so it looks like Internal med is borrowing CAU Bed. What to do here – change to GRA boarding? | ||
** I am not sure if the more recent entries for boarding loc would now list the actual location or still site-CAU. | |||
}} | |||
{{Collapsable | |||
| always= See sql to see pre-admit, previous and dispo CAUs in CFE | |||
| full= | |||
SELECT L_TmpV2.*, L_TmpV2.Item | |||
FROM L_TmpV2 | |||
WHERE (((L_TmpV2.Item) Like "*CAU")); | |||
}} | }} | ||