Overstay2 module

The Overstay2 module is VBA module contains the code used to implement the functionality for the processes documented at Overstay2 Overview. There is a branch for this in the Git repository but the general change log is at Log and CFE Log.

A button on the Patient viewer form triggers Function Handle_Overstay_Button() that generates an overstay score. It also changes the button based on that value.

The value is stored in L_TmpV2 table with Project "Overstay2" and Item "Overstay2 Score". During early testing, the score is 999998 just to have a crazy outlier so we remember to exclude these later. That number turns the button blue.

Details

Exposes the following functions used by CCMDB.accdb and CFE:

• Public Function Get_Overstay_Parameters_from_ID(ByVal ID As Variant, ByRef op As Overstay_Parameters) As Boolean
  • implements Data definition for factor candidates for the Overstay2 project

Exposes the following functions used by CCMDB.accdb:

• Public Function Handle_Overstay_Button(ID As Variant) As Boolean
• Public Function Set_Overstay_Button_Colour
  • as per Project_Overstay2#Possible_Scenario_-_colour_change_due_to_data_entry_error, this will overwrite previously entered values using Function GenerUpdate_tmp_entry
• Public Function Get_Existing_Overstay_Result(ID As Variant) As Double

Contains additional functions to generate results from data in CFE, low/testing only use so see code.

Use in both Centralized data front end.accdb and CCMDB.accdb

The same code is used for both CCMDB and CFE, with a single modifier value required to tell which program it is being run from, one of:

• #Const in_CFE = True
• #Const in_CCMDB = True