1. HCM Data Loading Business Objects
  2. Examples of Associating a Question with a Subscriber Context

Examples of Associating a Question with a Subscriber Context

You can associate contexts to questions that are loaded to the application using HCM Data Loader for the Oracle Recruiting subscriber only.

Scenario

When you create questions in the question library, you can associate the question to one or more of these dimensions:

  • Job Families

  • Recruiting Organizations

  • Job Functions

  • Locations

By default the questions applies to all the dimensions as shown by the fields, Recruiting Organizations, Recruiting Locations, Job Families and Job Functions.

You can restrict a question to a specific value in a dimension. For example, you can specify a Job Location such as New York. In that case, set the field to N, and the specific dimension gets attached to the question.

In HCM Data Loader, the business object Question Context is a child object of Question. The Question Context business object has 4 user keys:

  1. QuestionCode, QstnVersionNum, LocationName

  2. QuestionCode, QstnVersionNum, JobFamilyName

  3. QuestionCode, QstnVersionNum, OrganizationName

  4. QuestionCode, QstnVersionNum, JobFunction

Each set represents a dimension.

Note these guidelines:

  • The parent question must always be in the dat file because Question Context isn't integration enabled.

  • Question Context applies to the Recruiting subscriber only. For other subscribers, the load fails.

  • Question Context business objects support only user keys. SurrogateId load isn't supported.

  • When you load a Question Context to a Question, the MERGE line can have only 1 dimension.

  • For the dimension loaded in the Question Context, the corresponding "All%Flag" should be N.

  • If the "All%Flag" for a dimension is N, there should at least 1 Question Context in that dimension.

To use HCM Spreadsheet Data Loader, go to the Data Exchange work area, create a spreadsheet template and then upload it using the Load Spreadsheet Data task.

Sample Question File

Tip: You can load only one context per line in the question.dat input data file.

Question 1 in Question.dat associates a question to a dimension in Oracle Recruiting.

Questions 2 and 3 fail. Question 2 fails because JobFamilyName and LocationName are on the same line. Question 3 fails because AllJobFamiliesFlag isn't N.

METADATA|Question|QuestionCode|QstnVersionNum|SubscriberName|QuestionType|ResponseTypeName|CategoryName|ClassificationCode|QuestionText|CandidateCode|AllJobFamiliesFlag|AllOrganizationsFlag|AllJobFunctionsFlag|AllLocationsFlag
METADATA|Answer|QstnVersionNum|QuestionCode|SequenceNumber|AnswerCode|LongText|SubscriberName|AddAttachmentFlag|AttachmentTitle|AttachmentDescription|AttachmentFile|AttachmentFileName|Type
METADATA|QuestionContext|JobFamilyName|LocationName|JobFunction|OrganizationName|QuestionContextId|QstnVersionNum|QuestionCode|SubscriberName
COMMENT ------------Question 1----------------------------------------
MERGE|Question|RECRUIT_INTERVIEW_1|1|Recruiting|||Question Library||Is the Candidate willing to work in shifts?|BOTH|N|N|N|N
MERGE|Answer|1|RECRUIT_INTERVIEW_1|234|RECRUIT_INTERVIEW_ANS1|Yes|Recruiting||||||
MERGE|Answer|1|RECRUIT_INTERVIEW_1|235|RECRUIT_INTERVIEW_ANS2|No|Recruiting||||||
MERGE|QuestionContext|ZFRCE_Planning|||||1|RECRUIT_INTERVIEW_1|Recruiting
MERGE|QuestionContext||Germany||||1|RECRUIT_INTERVIEW_1|Recruiting
MERGE|QuestionContext|||Legal|||1|RECRUIT_INTERVIEW_1|Recruiting
MERGE|QuestionContext||||ZBEN United Benefits Corporation||1|RECRUIT_INTERVIEW_1|Recruiting
COMMENT ------------Question 2----------------------------------------
MERGE|Question|RECRUIT_INTERVIEW_2|1|Recruiting|||Question Library||Is the Candidate ready to travel as part of Job?|BOTH|N|N|N|N
MERGE|Answer|1|RECRUIT_INTERVIEW_2|234|RECRUIT_INTERVIEW_2_ANS1|Yes|Recruiting||||||
MERGE|Answer|1|RECRUIT_INTERVIEW_2|235|RECRUIT_INTERVIEW_2_ANS2|No|Recruiting||||||
MERGE|QuestionContext|ZFRCE_Planning|Germany||||1|RECRUIT_INTERVIEW_2|Recruiting
COMMENT ------------Question 3----------------------------------------
MERGE|Question|RECRUIT_INTERVIEW_3|1|Recruiting|||Question Library||Is the candidate ready to migrate as part of Job?|BOTH|||N|N
MERGE|Answer|1|RECRUIT_INTERVIEW_3|234|RECRUIT_INTERVIEW_3_ANS1|Yes|Recruiting||||||
MERGE|Answer|1|RECRUIT_INTERVIEW_3|235|RECRUIT_INTERVIEW_3_ANS2|No|Recruiting||||||
MERGE|QuestionContext|ZFRCE_Planning|||||1|RECRUIT_INTERVIEW_3|Recruiting
MERGE|QuestionContext||Germany||||1|RECRUIT_INTERVIEW_3|Recruiting
MERGE|QuestionContext|||Legal|||1|RECRUIT_INTERVIEW_3|Recruiting
MERGE|QuestionContext||||ZBEN United Benefits Corporation||1|RECRUIT_INTERVIEW_3|Recruiting

To delete the Question Context, change the MERGE to DELETE.