Discussions

 View Only
Expand all | Collapse all

Daily Census from Admit Date / Discharge Date

  • 1.  Daily Census from Admit Date / Discharge Date

    Posted 08-07-2018 01:50
    I have a table with individual customers that are housed in one of our facilities.  Updates to these records occur every hour.  I can create a Summary Table where Admit Date is less than or equal to today and Discharge Date is greater than or equal to today.  This gives me a count of total customers on any given day that I run the Summary Table for.  I can then select .more. and copy the summary report to another table.  Is there a better way to accomplish this?  Is there an automated way to do this?  Is there a way to keep prior days up to date as discharge date may be back dated and cause issues moving forward.


  • 2.  RE: Daily Census from Admit Date / Discharge Date

    Posted 08-07-2018 03:31
    I suggest exploring the use of a scheduled Automation.