Differences

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

--- modulesettings [2025/02/04 11:34] – 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 |
+| 42 | **firstqtninemail**               | int        | stores the qdetailid of the question which has to be shown as first question in email. |
+| 43 | **evaluationmasterosid**          | int        | stores the org masterosid which is used for evaluation. If this is set then there is provision for inserting multiple invitations, one for one orgstructure. |
+| 44 | **processlevelclose**             | int        | used to define whether Process level closed concept enable or not. 1=enable, 0=disable. |
+| 45 | **autosubmitmobilesurvey**        | int        | if set, will automatically proceed to next question on answering a question in mobile survey |
+| 46 | **showthisbranchbenchmark**       | int        | 1=show; 0=Don't show |
+| 47 | **showallbranchbenchmark**        | int        | 1=show; 0=Don't show |
+| 48 | **surveylangimage**               | longblob   | stores the image which is to show in language selection screen in survey. |
+| 49 | **escalationstartdate**           | datetime   | only actionlist cases created or updated after this date will be counted in for escalations |
+| 50 | **appaccess**                     | int        | used to show this module in app. 1=show, 0=hide. |
+| 51 | **excludeoptout**                 | int        | if set will exclude the optout responses from graphs |
+| 52 | **addemptoopensurey**             | int        | 1=enable |
+| 53 | **tatinminutes**                  | int        |  |
+| 54 | **caseresolvedstatus**            | blob       | 1=Use case resolved status; 0=Do not use |
+| 55 | **hideotherclosurebuttons**       | int        | if set will hide action list close buttons such as Close not contacted |
+| 56 | **flexigridautorefresh**          | int        |  |
+| 57 | **titlebasedon**                  | varchar(50) | will show this value as page title in survey |
+| 58 | **hl7importsenabled**             | int        | 0=disabled; 1= enabled |
+| 59 | **createdby**                     | int        |  |User ID who created this module setting.
+| 60 | **createdon**                     | datetime   |  |Timestamp of the creation.
+| 61 | **modifiedby**                    | int        |  |User ID who created this module setting.
+| 62 | **modifiedon**                    | datetime   |  |Timestamp of the last modification.
+| 63 | **allowuserlevelwaves**           | int        |  |User ID who last modified this module setting
+| 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 |
+| 67 | **surveylivesite**                | varchar(250) |  |
+| 68 | **emailheadercolor**              | varchar(6)  |  |