Examples of Loading Questionnaire Templates

This topic provides an example to show how to load a questionnaire template including the sections, questions, and responses using HCM Data Loader for the subscriber, Recruiting.

Questionnaire Template

This example shows the QuestionnaireTemplate.dat file to load questionnaire template components using the user keys.

A questionnaire template is created with 2 sections, 606013 and 60614. Questions and answer choices are provided for the section 606013.
The AllJobFamiliesFlag, AllJobFunctionsFlag, AllLocationsFlag and AllOrganizationsFlag will default to Y because the HCM Data Loader doesn't support associating a question to a specific job family, job function, location, or organization.

METADATA|QuestionnaireTemplate|SubscriberName|QuestionnaireCode|Name|Status|AllowIntroChg|AllowFormatChg|AllowSectionChg|AllowQstnOrderChg|AllowRespOrderChg|SectionOrder|SectionPresentation|PrivacyFlag|PlainTextResponse|SingleChoiceListResponse|RichTextResponse|MultipleChoiceListResponse|NoneResponse|SingleChoiceRadioResponse|MultipleChoiceCheckResponse|OwnerPersonNumber
MERGE|QuestionnaireTemplate|Recruiting|RECRUIT_QSTNR_TMPL_1|RECRUIT_QSTNR_TMPL_1|A|Y|N|Y|Y|Y|R||N|Y|N|N|N||Y||180807
METADATA|Section|SubscriberName|QuestionnaireCode|SectionSeqNum|Name|NewPage|Description|IntroText|QuestionOrder|ResponseOrder|Mandatory|AllowAdhoc
MERGE|Section|Recruiting|RECRUIT_QSTNR_TMPL_1|606013|RECRUIT_QSTNR_TMPL_1_SEC_1|Y|Introduction|Section for Introduction|V|R|Y|Y
MERGE|Section|Recruiting|RECRUIT_QSTNR_TMPL_1|606014|RECRUIT_QSTNR_TMPL_1_SEC_2|Y|Feedback|Section for feed back questions|R|R|N|N
METADATA|Question|SubscriberName|QuestionnaireCode|SectionSeqNum|QuestionCode|QstnVersionNum|SeqNum|KeepWithPrev|AdhocQstn|Mandatory|ResponseTypeName|Status|QuestionText|CategoryName|QuestionType|PrivacyFlag|RatingModelCode|ConditionDisplay|ConditionQstnVersionNum|ConditionQuestionCode|ConditionAnswerCode|AllJobFamiliesFlag|AllJobFunctionsFlag|AllLocationsFlag|AllOrganizationsFlag|CandidateCode|ClassificationCode|QstnResponseTypeName|AdhocFlag
MERGE|Question|Recruiting|RECRUIT_QSTNR_TMPL_1|606013|RECRUIT_QSTN_EXPERTISE|1|32956||N|Y|Multiple Choices from List|D|What is your area of expertise?|Question Library|MULTCHOICE|N|TALENTSCORE|||||Y|Y|Y|Y|BOTH|DISQUALIFICATION|Multiple Choices from List|
METADATA|Answer|SubscriberName|QuestionnaireCode|SectionSeqNum|QuestionCode|QstnVersionNum|SeqNum|AnswerCode|ShortText|LongText|Score
MERGE|Answer|Recruiting|RECRUIT_QSTNR_TMPL_1|606013|RECRUIT_QSTN_EXPERTISE|1|329456|RECRUIT_QSTN_EXPERTISE_1||Java|
MERGE|Answer|Recruiting|RECRUIT_QSTNR_TMPL_1|606013|RECRUIT_QSTN_EXPERTISE|1|329457|RECRUIT_QSTN_EXPERTISE_2||PL/SQL|
MERGE|Answer|Recruiting|RECRUIT_QSTNR_TMPL_1|606013|RECRUIT_QSTN_EXPERTISE|1|329458|RECRUIT_QSTN_EXPERTISE_3||Python|