Difference between revisions of "Field: RPQ Completed"

From Catglobe Wiki
Jump to: navigation, search
(jrfconvert import)
 
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
[[Category:HelpBooks]]
+
[[Category:Import module]]

+
{{Help_Files_Import_module}}
  
 
==Field: RPQ_Completed==
 
==Field: RPQ_Completed==

Latest revision as of 09:34, 14 December 2011



Field: RPQ_Completed

Field: RPQ_Completed

Type

Boolean(0 or 1, 0 for false, 1 for true)

General Description

The completed status of a questionnaire answer sheet (resource project questionnaire) shows whether a user has completed answering a questionnaire.

Import Group

Import Data (by selecting a questionnaire)

Business Rules

  • Questionnaire completed must be 0 or 1
  • If value for an answer is 1, then Questionnaire Start Date and Questionnaire End Date must not be empty, and start date along with end date must follow its format as in section ‘Questionnaire Start Date’ & ‘Questionnaire End Date’.
  • If value for an answer is 0, then there is no validation applied.
  • To update this field for existing users, you must select a User_Id column in step 1 of the import wizard and also map to the specific questionnaire answer sheet that you want to update.
  • If you choose option 1 in step 2 of the import wizard, any existing questionnaire completed value will be overwritten with the new start date.
  • If you choose option 2 in step 2 of the import wizard, all existing questionnaire will be deleted so the questionnaire completed value will always be that of a new answer sheet.
  • If you choose option 3 in step 2 of the import wizard, the exact answer sheet to which you mapped will get overwritten with the questionnaire completed value.

Validation

  • Error message is shown if you try to import wrong format (not 0 or 1). Error type: ERROR (the import job will not be allowed to be executed).
  • Validation error: ‘Questionnaire start date must not be empty in case you specify a questionnaire answer as completed’ will be shown if you try to import completed value to Questionnaire without start date mentioned. Error type: ERROR (the import job will not be allowed to be executed).

Notes

  • See questionnaire start date and end date for more information