Performitor

This is an old revision of the document!

Sr.No	Name	Type	Comments
1	id	int	AUTO_INCREMENT
2	moduleid	varchar(150)	ids of fw_modules table
3	moduletype	varchar(100)	continuous/wave
4	surveydisplaytype	varchar(250)	Single page survey or default (one question per page)
5	sendbeforedays	int	Discards an invitation, when consultationdate is older than “sendbeforedays” from currentdate.
6	emailtype	varchar(250)	logo on top or logo on life side
7	progressbartype	varchar(250)	Progress bar in survey - whether % based or number based or line based
8	blacklisttype	varchar(250)	Blacklist (whether email / import variable / both)
9	languages	varchar(200)	Single language or multi language
10	languageselection	varchar(200)	Language selection option – whether in invitations screen or in survey page as option
11	hideclientlogoinsurvey	int
12	periodbaringraphs	int	1=show, 0=don't show
13	actionlist	int	0=No, 1=Yes
14	multipleactionitems	int	1=Enables to create multiple action items for a single invitation based on action list settings; 0=Disabled
15	caseassignedsms	int	defines to send SMS alerts on case assign. 1=send SMS, 0=do not send.
16	emailsettings	varchar(200)	default or variable based
17	variablefieldname	varchar(250)	saves the invitations columnname of variable.
18	variablefieldparams	text	saves the Query parts of variabledata.
19	blacklistfield	varchar(150)	Blacklist condition is formed on this column.
20	resethalfyearfield	varchar(150)	Reset Half year condition is formed on this column.
21	resethalfyearcheckmoduleids	varchar(200)	holds ',' separated moduleids whose corresponding columns are also checked for reset half year
22	ignoreresethalfyear	int	0=apply reset condition, 1= apply but don't stop inv from inserting
23	considerparticipatedinvitationsforresethalfyear	int
24	responseoverviewfieldtype	varchar(200)	signifies the type of value stored in column 'responseoverviewfield'. invitations ⇒ id of fw_invitationfields; orgstructure ⇒ id of fw_orgstructuremaster
25	responseoverviewfield	int	holds the id of fw_invitationfields which is used to split data in Response overview page of reports
26	responsepagetype	varchar(250)	Defines response overview page type either it is Performitor type or Reportal type.
27	redirectdelay	int	time delay for redirection to endpageurl after completing survey.
28	endpageurl	varchar(500)	redirecting to this url after completion of survey.
29	importinvlimit	int	limit of invitations import from excel at a time.
30	noinvfields	int	0=No fields required for invitation setup;1=requried
31	noofbars	int
32	showstartsurveybtn	int	enable survey button in 'Verzonden e-mails' for this module or not
33	weight	int	1=weight is considered for this module, 0=no weight consideration.
34	showextracs	int	used to show extra clientsheets for a respondent in this module.
35	multifeedbackaccess	int	used to define the access of multiple feedbacks. 1=has access, 0=no access.
36	showmapincs	int	used to show map in clientsheets or not. 1=show, 0=do not show.
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