Ward Analytics: PID x PV1
Twelve questions answered from RAW HL7 ADT messages: length of stay by ward/room/bed, bed turnover, live census proxy, ED boarding hours, after-hours activity, transfer pairs, average age, long-stay outliers, 28-day returns, doctor census, before-noon discharges, and discharge disposition. One foundation mart, thin views, scheduled refresh.