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	surveyendpageparam
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
60	createdon	datetime
61	modifiedby	int
62	modifiedon	datetime
63	allowuserlevelwaves	int
64	branchoverallscore	int
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)