Field: RPQ Start Date



Field: RPQ_Start_Date

Field: RPQ_Start_Date
Type	Datetime
General Description	The start date of a questionnaire answer sheet (resource project questionnaire) is normally the starting date and time that a user started filling in a questionnaire.
Import Group	Import Data (by selecting a questionnaire)
Business Rules	Questionnaire start date must follow the format of general date time; namely: “yyyy-mm-dd hh:mm:ss” Importing questionnaire start date is compulsory if you want to import any data to a the questionnaire answer sheet. I.e. whenever there is any mapping to a question in a questionnaire (when you try to import data to questionnaire), the system will check if questionnaire start date is also mapped. Questionnaire start date must not be greater than current date Questionnaire start date must not be empty if you specify questionnaire end date in the mapping. Questionnaire start date must also be less than questionnaire end date in this case. Questionnaire start date must not be empty if you specify ‘Completed = true’ for questionnaire completed. See more in the ‘Questionnaire completed’ help file. 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
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: ‘Start date must not be empty in case you want to import Data’ will be shown if you try to import Data without specifying the Questionnaire start date. Error type: ERROR and you can not finish the Import job with Import Data. Validation error: ‘Questionnaire Start Date must not be greater than current date’ will be shown if you try to import start date that is bigger than current date. 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 Questionnaire end date’ will be shown if you try to import end date without start date. 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 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	Please investigate the file on import wizard to learn more on importing questionnaires data.