I can not always go by the patients' admit date, due to the fact that if the baby isn't a sick baby, we don't get to count that admission. So, it is quite possible that the baby could have worsened a few days after being born, and then had to be moved to the SCN/NICU. Like I said, those are my exceptions, and I will just know to look for those type of scenarios, and correct my data accordingly.

Since we should NEVER admit a patient back to the hospital, using the same account #, I would prefer that those are flagged, so that I can bring it to our admitting department's attention - this would have to be corrected on their end. SO...we can just highlight it, and then I will follow up. I do not foresee that this would be an issue.

We calculate days, admits, etc. on a daily basis, for all of our patients. For the SCN, that department was keeping manual stats that had to be reported once a week, which included # of admits, days, and now our administrators want it compared to last year as well. So, I have dumped in all of 2013, and will be dumping in the 2014 data on a separate tab. I would need to see admits and days (days would be just a count, by month, for every day they are housed in the SCN/NICU). Our final output wouldn't include patient account #'s - just totals by month.