Overstay2 module: Difference between revisions

(7 intermediate revisions by the same user not shown)

Line 1:

The ~~Overstay2 module~~ is ~~the~~ VBA module ~~that encodes~~ the [[Overstay2 ~~scoring models~~]]:

The {{PAGENAME}} is VBA module contains the code used to implement the functionality for the processes documented at [[Overstay2 Overview]]. There is a [https://github.com/squirrelslair/CCMDB/blob/main/Overstay2.bas branch] for this in the [[Git repository]] but the general change log is at [[Log]] and [[CFE Log]].

* [[Overstay2 ~~data processing and reporting in CFE]~~] in [[~~Centralized data front end.accdb~~]]

* [[~~Overstay2 Score and golour generation in CCMDB~~]] in [[~~CCMDB.accdb]]~~

~~See [[Overstay2 Overview~~]] ~~for more context~~.

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

~~The code base is on github at https://github.com/squirrelslair/CCMDB/blob/main/Overstay2.bas~~

~~This should provide detailed diffs, but the general change log would be at [[Log]] and [[CFE Log]].~~

== Related articles ==

@@ Line 1: / Line 1: @@
-The Overstay2 module is the VBA module that encodes the [[Overstay2 scoring models]]:
+The {{PAGENAME}} is VBA module contains the code used to implement the functionality for the processes documented at [[Overstay2 Overview]]. There is a [https://github.com/squirrelslair/CCMDB/blob/main/Overstay2.bas branch] for this in the [[Git repository]] but the general change log is at [[Log]] and [[CFE Log]].
-* [[Overstay2 data processing and reporting in CFE]] in [[Centralized data front end.accdb]]
-* [[Overstay2 Score and golour generation in CCMDB]]  in [[CCMDB.accdb]]
-See [[Overstay2 Overview]] for more context.
+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
-The code base is on github at https://github.com/squirrelslair/CCMDB/blob/main/Overstay2.bas
-This should provide detailed diffs, but the general change log would be at [[Log]] and [[CFE Log]].
 == Related articles ==