|
|
|
Field: RPQ_End_Date
|
|
Type
|
Datetime
|
|
General Description
|
The end date of a questionnaire answer sheet (resource project questionnaire) is normally the date and time that a user finished filling in a questionnaire.
|
|
Import Group
|
Import Data (by selecting a questionnaire)
|
|
Business Rules
|
- Questionnaire end date must follow the format of general date time; namely: “yyyy-mm-dd hh:mm:ss”
- Importing questionnaire start date is compulsory if you specify ‘completed = true’ in questionnaire completed ‘column’.
- Questionnaire end date must not be greater than current date
- 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 start dates 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 start date 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 specified start date
|
|
Validation
|
- Error message is shown if you try to import wrong format of date time. Error type: ERROR (the import job will not be allowed to be executed).
- Validation error: ‘Questionnaire Start Date must not be greater than Questionnaire End Date’ will be shown if you try to import to start date a value that is bigger than end date. Error type: ERROR (the import job will not be allowed to be executed).
- Validation error: ‘Questionnaire end 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 end date mentioned. Error type: ERROR (the import job will not be allowed to be executed).
|
|
Notes
|
- See questionnaire start date for more information.
- Please investigate the file on import wizard to learn more on importing questionnaires data.
|
