|
ADM Products Reconciliation
|   |
|
ADM Products Reconciliation
| |
This Screen shows a reconciliation between the EpisodeMaster Discharge and Admit dates and times, and the total of Ward Bedday and Leave Products, both expressed as seconds. Variances under a second are usually rounding errors from the calculations, Variations over a minute are cause for concern. Variations showing doubling mean two processes have been running at the same time.
Special note, this screen only shows 10,000 records, however a re-flag will flag ALL matching records - ALL!
The Re Flag and process option allows the errant episodes to be recalculated. - beware setting a low value under .005 and into negatives will flag lots of records and cause a good deal of processing, taking many hours. A negative value will Flag ALL Episodes. This is deliberate.
In reprocessing, only 20,000 flagged records will be done in any one go. To process the remainder, set a high flagging value, - no further records will be flagged, but, the balance of records already flagged will be reprocessed.
If the AutoLoad Service loads while reprocessing is underway, or another workstation is accessing this company TLA one process will be terminated, which one is a guess. This prevents duplication as by its nature the processes will tend to lockstep and do the same records, causing doubling. No record locking is used in Talons SQL but process locking .is used
Table Fields
|
Company TLA |
|
|
Campus TLA |
|
|
Admit Date |
yyyy-mm-dd HH:mm:ss |
|
Disch Date |
yyyy-mm-dd HH:mm:ss |
|
LOS HKDVNR |
Calculated LOS in T1HKCPP HKDVNR |
|
LEV HKEVNR |
Leave Midnights count |
|
UQ HKOPVL |
Unqualified Midnight Counts |
|
ALL HKEWNR |
Sum of Midnight Counts - statustical LOS |
|
ELPS LOS |
Midnights between Admit And Discharge - Same day = 0 |
|
Date Difference |
Disch - Admit - in Seconds |
|
Product Delta |
Difference between above and below |
|
Product Seconds |
Sum of Bedday Seconds and Leave Seconds |
|
Leave Seconds |
total of WARD Leave product as Seconds |
|
Bed Seconds |
total of WARD Bedday, Bedday#B product as Seconds |
|
Re-Calc |
Indicator that Record is flagged to be recalculated on next pass |
Buttons
|
ReFresh |
Re-displays table with new seconds value |
|
Re-Flag and Process those over |
Flags and processes records with Product Delta over the Seconds value |
|
Seconds Entry Box |
Enter seconds between +- infinity, down to .0001 and zero |
|
Record Counter Display |
|
|
Exit Button |
Not sure, - actually this button will also cleanyl kill a running recalc process - it may take a second or two. |