Performitor

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

```