ADM HBCIS/TALONS Discharge Reconciliation

The menu options provides a screen of data showing INPATIENT counts by Year/Month in several tables

File Menu Options

A summary of this data is emailed daily if appropriate

This

27 Sep 2012 10:22 HBCIS Talons Discharge Reconciliation
+-----+-----+------+-------+----------+-----------+-------+------------+-------------------+-
| TLA | CMP | Year | Month | T2K6_Dis | HBCIS_Dis | Delta | Util Delta | HBCIS Date        |
+-----+-----+------+-------+----------+-----------+-------+------------+-------------------+-
| GCH | GCH | 2012 |     8 |     8056 |      8057 |    -1 |         -1 | 27 Sep 2012 10:06 |
+-----+-----+------+-------+----------+-----------+-------+------------+-------------------+

Is a summary of the current discharge reconciliation where Delta (∆ the usual symbol for difference) is not zero

Be aware but not alarmed...

These will crop up and vanish as the system process Merges and deletions made on HBCIS and can persist till Night Daemon runs made in the following evening

In this case SPECIFCALLY we see

• A HBCIS summary report run on 27th Sep 10:06 had 8057 discharges for August 2012,
• Talons SQL had 8056.. "episodes" in its episode table (tblEpisodeMaster) .. a delta of -1
• Talons SQL had 8056.. "discharges" in its products utilisation tables (tblADMUtil) .. a delta of -1

Now when we look all is resolved

When errors persist over shall we say 24 hours especially in older months - Then we need to do something as the self - healing logic has been defeated usually by a very messy complex merge, shuffle and lambada with one or more patients.

Usually requesting a Months Extracts with re-load will fix it

If the Problem is only UTIL delta.. try ADM Products Reconcile and flag and reprocess