Thanks Chris! Kind regards, William Rose Business Intelligence Manager Information Management +61 3 9656 5231 | Level 8, St Andrews Place, East Melbourne VIC 3002 ________________________________ From: chai-t-bounce@xxxxxxxxxxxxx [mailto:chai-t-bounce@xxxxxxxxxxxxx] On Behalf Of Chris Hamilton Sent: Tuesday, 24 July 2012 1:28 PM To: 'chai-t@xxxxxxxxxxxxx' Subject: [chai-t] Inpatient NWAU calc Hi all, As discussed on Friday here is our first go at updating a staging table with NWAU flag and adjustment fields. The definitions seem to be a slowly moving target so I'm sure they will need refining. Please let me know if you find anything blatantly wrong; we have validated it against SAS code we got from DoH and it was pretty close which is all I ever hope for when comparing our live data to VAED. The key seems to be to add or multiply the adjustments in the correct order. Hope it helps someone anyway. Regards, Chris Hamilton | Manager: Clinical Information Management Southern Health | Level 1, E Block 246 Clayton Road, Clayton VIC 3168 ph. 9594 4017 | mob. 0418 317 581 | Intranet site <http://shdashboard/Reports/SHARE/Shared%20Documents/Home.aspx> ________________________________ THIS E-MAIL IS CONFIDENTIAL. If you have received this e-mail in error, please notify us by return e-mail and delete the document. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Southern Health are not liable for the proper and complete transmission of the information contained in this communication or for any delay in its receipt. ________________________________ This email (including any attachments or links) may contain confidential and/or legally privileged information and is intended only to be read or used by the addressee. If you are not the intended addressee, any use, distribution, disclosure or copying of this email is strictly prohibited. Confidentiality and legal privilege attached to this email (including any attachments) are not waived or lost by reason of its mistaken delivery to you. If you have received this email in error, please delete it and notify us immediately by telephone or email. Peter MacCallum Cancer Centre provides no guarantee that this transmission is free of virus or that it has not been intercepted or altered and will not be liable for any delay in its receipt.