Notes

Quota

RPQ is registered in the quota_resource_project_questionnaire table when:

• checkAllQuotas() cgs function is called.
• UpdateQuota function on quota tab is called
• User moves to the last question of the rpq. In this case, rpq must be completed to be in the quota_resource_project_questionnaire table. However, if user moves to the previous question from the last question, the rpq is still in the table even though it is not completed.

The difference between checkAllQuotas(), CGS function, and UpdateQuota, GUI feature:

• CheckAllQuotas(): update the RPQ's quotas status.
• UpdateQuota: update all RPQs' quotas status 

Testing tips

Questionnaire Property

CREATE TABLE #Questionnaire_Property(

 P_Id int,
 P_Description nvarchar(50)

)

INSERT INTO #Questionnaire_Property VALUES(1,'Required') INSERT INTO #Questionnaire_Property VALUES(2,'RandomizeAnswerOptions') INSERT INTO #Questionnaire_Property VALUES(3,'RotateAnswerOptions') INSERT INTO #Questionnaire_Property VALUES(4,'Maximum') INSERT INTO #Questionnaire_Property VALUES(5,'Minimum') INSERT INTO #Questionnaire_Property VALUES(6,'Dummy') INSERT INTO #Questionnaire_Property VALUES(7,'NoMulti') INSERT INTO #Questionnaire_Property VALUES(8,'End') INSERT INTO #Questionnaire_Property VALUES(9,'Sound') INSERT INTO #Questionnaire_Property VALUES(10,'Step') INSERT INTO #Questionnaire_Property VALUES(11,'Discrete') INSERT INTO #Questionnaire_Property VALUES(12,'Direction') INSERT INTO #Questionnaire_Property VALUES(13,'MinimumText') INSERT INTO #Questionnaire_Property VALUES(14,'MaximumText') INSERT INTO #Questionnaire_Property VALUES(15,'Reverse') INSERT INTO #Questionnaire_Property VALUES(16,'AllRequired') INSERT INTO #Questionnaire_Property VALUES(17,'NotRequired') INSERT INTO #Questionnaire_Property VALUES(18,'BackButtonVisible') INSERT INTO #Questionnaire_Property VALUES(19,'BackButtonText') INSERT INTO #Questionnaire_Property VALUES(20,'CloseButtonVisible') INSERT INTO #Questionnaire_Property VALUES(21,'CloseButtonText') INSERT INTO #Questionnaire_Property VALUES(22,'NextButtonVisible') INSERT INTO #Questionnaire_Property VALUES(23,'NextButtonText') INSERT INTO #Questionnaire_Property VALUES(24,'RandomizeSubQuestions') INSERT INTO #Questionnaire_Property VALUES(25,'RotateSubQuestions') INSERT INTO #Questionnaire_Property VALUES(26,'MinimumScaleValue') INSERT INTO #Questionnaire_Property VALUES(27,'MaximumScaleValue') INSERT INTO #Questionnaire_Property VALUES(28,'MinimumMultiValue') INSERT INTO #Questionnaire_Property VALUES(29,'MaximumMultiValue') INSERT INTO #Questionnaire_Property VALUES(30,'MinimumNumberValue') INSERT INTO #Questionnaire_Property VALUES(31,'MaximumNumberValue') INSERT INTO #Questionnaire_Property VALUES(32,'Script') INSERT INTO #Questionnaire_Property VALUES(33,'OpenAnswerOptions') INSERT INTO #Questionnaire_Property VALUES(34,'QuestionnaireNotOpenText') INSERT INTO #Questionnaire_Property VALUES(35,'QuestionnaireUnauthorizedAccessText') INSERT INTO #Questionnaire_Property VALUES(36,'QuestionnaireClosedText') INSERT INTO #Questionnaire_Property VALUES(37,'QuestionnaireEndText') INSERT INTO #Questionnaire_Property VALUES(38,'QuestionnairePausedText') INSERT INTO #Questionnaire_Property VALUES(39,'QuestionnaireCompletedText') INSERT INTO #Questionnaire_Property VALUES(40,'QuestionnaireBeforeStartDateText') INSERT INTO #Questionnaire_Property VALUES(41,'QuestionnaireAfterEndDateText') INSERT INTO #Questionnaire_Property VALUES(42,'NotRequiredAll') INSERT INTO #Questionnaire_Property VALUES(43,'ResetButtonVisible') INSERT INTO #Questionnaire_Property VALUES(44,'ResetButtonText') INSERT INTO #Questionnaire_Property VALUES(45,'Layout') INSERT INTO #Questionnaire_Property VALUES(46,'Impsys') INSERT INTO #Questionnaire_Property VALUES(47,'QuestionnaireRequiredText') INSERT INTO #Questionnaire_Property VALUES(48,'QuestionnaireMinRequiredText') INSERT INTO #Questionnaire_Property VALUES(49,'QuestionnaireMaxRequiredText') INSERT INTO #Questionnaire_Property VALUES(50,'QuestionnaireNumberRequiredText') INSERT INTO #Questionnaire_Property VALUES(51,'QuestionnaireMinValRequiredText') INSERT INTO #Questionnaire_Property VALUES(52,'QuestionnaireMaxValRequiredText') INSERT INTO #Questionnaire_Property VALUES(53,'QuestionnaireNoFloatValText') INSERT INTO #Questionnaire_Property VALUES(54,'QuestionnaireNumberOverflow') INSERT INTO #Questionnaire_Property VALUES(55,'QuestionnaireInGridRequiredText') INSERT INTO #Questionnaire_Property VALUES(56,'QuestionnaireMinInGridRequiredText') INSERT INTO #Questionnaire_Property VALUES(57,'QuestionnaireMaxInGridRequiredText') INSERT INTO #Questionnaire_Property VALUES(58,'QuestionnaireIllegalTypeText') INSERT INTO #Questionnaire_Property VALUES(59,'EndPoints') INSERT INTO #Questionnaire_Property VALUES(60,'PointText') INSERT INTO #Questionnaire_Property VALUES(61,'Unit') INSERT INTO #Questionnaire_Property VALUES(62,'DefaultAnswerOption') INSERT INTO #Questionnaire_Property VALUES(63,'Compact') INSERT INTO #Questionnaire_Property VALUES(64,'AutoArrangeAnswerOptions') INSERT INTO #Questionnaire_Property VALUES(65,'AnswerOptionColumns') INSERT INTO #Questionnaire_Property VALUES(66,'AnswerOptionRows') INSERT INTO #Questionnaire_Property VALUES(67,'QuestionnaireCatiMode') INSERT INTO #Questionnaire_Property VALUES(68,'Countdown') INSERT INTO #Questionnaire_Property VALUES(69,'AnswerOptionUniqueChoice') INSERT INTO #Questionnaire_Property VALUES(70,'QuestionStylesheet') INSERT INTO #Questionnaire_Property VALUES(71,'FlashPath') INSERT INTO #Questionnaire_Property VALUES(72,'FlashHeight') INSERT INTO #Questionnaire_Property VALUES(73,'FlashWidth') INSERT INTO #Questionnaire_Property VALUES(74,'QuestionnaireOnBegin') INSERT INTO #Questionnaire_Property VALUES(75,'QuestionnaireOnCompleted') INSERT INTO #Questionnaire_Property VALUES(76,'RPQStatus') INSERT INTO #Questionnaire_Property VALUES(77,'ImpSysRequiredText') INSERT INTO #Questionnaire_Property VALUES(78,'ImpSysSelectionText') INSERT INTO #Questionnaire_Property VALUES(79,'ImpSysChoiceText') INSERT INTO #Questionnaire_Property VALUES(80,'ImpSysGender') INSERT INTO #Questionnaire_Property VALUES(81,'AllowDecimals') INSERT INTO #Questionnaire_Property VALUES(82,'AllowDecimalsInterval') INSERT INTO #Questionnaire_Property VALUES(83,'NumericalInterval') INSERT INTO #Questionnaire_Property VALUES(84,'ExportPosition') INSERT INTO #Questionnaire_Property VALUES(85,'ExportLength') INSERT INTO #Questionnaire_Property VALUES(86,'OpenAnswerRequired') INSERT INTO #Questionnaire_Property VALUES(87,'AlphabeticalTab') INSERT INTO #Questionnaire_Property VALUES(88,'RepresentAsDropDown') INSERT INTO #Questionnaire_Property VALUES(89,'IsShadowQuestion') INSERT INTO #Questionnaire_Property VALUES(90,'QuestionInCludeInPage')

SELECT * FROM #Questionnaire_Property

DROP TABLE #Questionnaire_Property