Performitor

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
^ Sr.No  ^ **Name**                            ^ Type       ^ Comments  ^
| 1  | **id**                               | int        | AUTO_INCREMENT |
| 2  | **clientid**                         | int        |  |
| 3  | **branchid**                         | int        |  |
| 4  | **moduleid**                         | varchar(150) | id(s) of fw_modules |
| 5  | **resetdays**                        | int        |  |
| 6  | **resetwave**                        | int        | 0=A respondent can be invited to evaluate multiple times within a wave; 1=Respondent should be invited just once per wave |
| 7  | **invitationtype**                   | varchar(150) | defines the type of invitation is either email or telephonic or sms for this module at this branch. |
| 8  | **maxphonecals**                     | int        |  |
| 9  | **sendafter**                        | int        | Days after which email invitation is to be sent from the day of creating invitation |
| 10 | **sendon**                            | datetime   | Date and time on which the email invitations should start sending |
| 11 | **expireafter**                      | int        |  |
| 12 | **branchmodulecode**                 | varchar(20) | saves unique code which is used in opensurvey. |
| 13 | **openurlexpiry**                    | date       | expiry date open survey URL. |
| 14 | **openurlsecurechk**                 | varchar(50) | 1=with login, 0=without login, 2=PanelClix, 3= Dynata |
| 15 | **appsurvey**                        | int        | 1=enabled, 0=disabled |
| 16 | **disableinvlimitperday**            | int        | disabe the condition to create only one inv per day per ipaddress |
| 17 | **resetbreakdays**                   | int        | no of days used to check to reinvite an invitation. |
| 18 | **avgnoofhrs**                       | int        |  |
| 19 | **surveycondfieldid**                | int        | id of invitaton fields on which survey questions will display. |
| 20 | **surveycondfieldval**               | int        | value of the invitaton field on which survey questions will display. |
| 21 | **surveycondmoduleids**              | varchar(250) | moduleids for which this survey display conditins will apply. |
| 22 | **wavewiseconditionqdetailids**      | varchar(200) | comma separated qdetailids, which are to be shown/hidden in questionnaire based on a setting in waves |
| 23 | **workinghoursstart**                | time       | Start time of the day from which the timelimit should start elapsing |
| 24 | **workinghoursend**                  | time       | End time of the day after which the timelimit should pause ticking |
| 25 | **escalationemailtext**              | text       | email body message for escalation alert email. |
| 26 | **escalationsmstext**                | text       | SMS text for escalation alert SMS. |
| 27 | **processlevelemails**               | text       | store the email ids to which an alert mail has to be sent when a case is closed at process level. |
| 28 | **facebookurl**                      | text       | stores the facebook url which will display after completion of survey. |
| 29 | **voicerecording**                   | int        | if set will record the voice while taking the survey |
| 30 | **status**                           | int        | 0=inactive, 1=active |
| 31 | **allowrespondentalerts**            | int        | 0=disallow, 1=allow |
| 32 | **reviewrating**                     | varchar(5) |  |
| 33 | **googleserviceaccountemail**        | varchar(250) |  |
| 34 | **reviewemail**                      | varchar(250) |  |
| 35 | **privatekey**                       | text       |  |
| 36 | **accountname**                      | varchar(250) |  |
| 37 | **location**                         | varchar(250) |  |
| 38 | **noofreviews**                      | varchar(250) |  |
| 39 | **overallscore**                     | varchar(10) |  |
| 40 | **testlinkurlval**                   | varchar(250) |  |
| 41 | **stopAlertsFromSurvey**             | int        | 0=Send from survey, 1=stop sending from survey |
| 42 | **multimediasurvey**                 | int        | 0=No, 1=Yes |
| 43 | **enableicarepluswelcomemsg**        | int        |  |
| 44 | **enableicarepluschatmsg**           | int        |  |
| 45 | **enableicareplus**                  | int        |  |
```