Differences

This shows you the differences between two versions of the page.

--- modulesettings [2025/02/04 11:35] – gloria
+++ modulesettings [2025/03/11 06:18] (current) – gloria
@@ Line 1: / Line 1: @@
+====== Introduction: ======
+The ModuleSettings table is responsible for storing the configuration settings for each survey module in the system. It controls the behavior, display, and overall functionality of the survey modules based on different settings.
+This table contains configurations related to:
+  * Survey Display: How the survey is presented (single-page or multi-page).
+  * Invitation Handling: Rules for sending, discarding, and processing invitations.
+  * Email Settings: Defines email layout, language, and variable-based content.
+  * Action List Management: Settings for creating and managing action list items.
+  * Response Handling: Configurations to manage survey responses, response overview, and case resolutions.
+  * Survey End Behavior: Defines what happens after a respondent completes a survey.
+  * Blacklist Settings: Conditions to exclude specific emails or variables from survey participation.
+  * Language Settings: Controls the language selection and display options in the survey.
+  * Other Configurations: Additional settings like app access, weight consideration, reset half-year rules, benchmark display, etc.
+The table is linked to the fw_modules table via the moduleid column and contains settings that impact the behavior of the survey module.
+Below is the detailed structure of the ModuleSettings table along with comments.
 ^ Sr.No ^ **Name**                      ^ Type         ^ Comments  ^
 | 1  | **id**                        | int          | AUTO_INCREMENT |
@@ Line 38: / Line 59: @@
 | 37 | **resetonallbranches**         | int          | 1=check reset condition in all branches, 0=vice-versa |
 | 38 | **surveyendparamtypes**        | varchar(100) | **^** separated values defining operation type(insert/update) for surveyendpageparam values |
-| 39 | **surveyendpageparam**        |               |      |
+| 39 | **surveyendpageparam**            | text       | if set, executes this param right after completing questionnaire |
 | 40 | **archivecasestimeperiod**        | int        | time period in days for the automatic archive of actionlist cases. |
 | 41 | **appcasesdaterangelimit**        | int        | holds the maximum no. of days that can be passed since a respondent case is created, so as to be eligible for showing in app second page |
@@ Line 58: / Line 79: @@
 | 57 | **titlebasedon**                  | varchar(50) | will show this value as page title in survey |
 | 58 | **hl7importsenabled**             | int        | 0=disabled; 1= enabled |
-| 59 | **createdby**                     | int        |  |
+| 59 | **createdby**                     | int        |  |User ID who created this module setting.
-| 60 | **createdon**                     | datetime   |  |
+| 60 | **createdon**                     | datetime   |  |Timestamp of the creation.
-| 61 | **modifiedby**                    | int        |  |
+| 61 | **modifiedby**                    | int        |  |User ID who created this module setting.
-| 62 | **modifiedon**                    | datetime   |  |
+| 62 | **modifiedon**                    | datetime   |  |Timestamp of the last modification.
-| 63 | **allowuserlevelwaves**           | int        |  |
+| 63 | **allowuserlevelwaves**           | int        |  |User ID who last modified this module setting
-| 64 | **branchoverallscore**            | int        |  |
+| 64 | **branchoverallscore**            | int        |  |Timestamp of the last modification.
 | 65 | **respondentattachmenttype**      | varchar(50) | 1=clientsheet, 2=overalldashboard, 3=ListeningProof, 4=Gedragslijn PF |
 | 66 | **opensurveyapi**                 | int        | 0 |