Details and Examples: PAS Answer Fields Data Set

The 'PAS Answer Fields' data set contains details of customer's answers to questions asked in the Post Appointment Survey that are present in the application with status 'delivered' by the moment of extraction.

Important: This information only applies to Oracle Field Service environments. You can verify whether you've Oracle Field Service or Oracle Fusion Field Service, by signing in and checking on the About page.

PAS Answer Fields are exported in the Daily Extract file for which 'PAS Answer Fields' is selected as the entity. Any PAS answer properties and fields available in Oracle Field Service (for example, 'PAS Question Number', 'Message ID', 'PAS-Related Activity ID'.) can be included in the Daily Extract by adding them to the file structure.

Depending on the requirements of the company, the list of exported properties and fields can be changed at any time by removing or adding certain fields.

Data can be retrieved as one or more XML files consisting of 'pas_answers' root element that contains 'pas_answer' elements. 'pas_answer' elements are sets of 'Field' elements whose attributes are names of PAS question fields and whose contents are their corresponding values.

This table provides the label and description for those fields that can be configured:

Field	Label	Description
Message ID	survey_take.mqid	Identifier of the message with which the question is asked.
PAS Question ID	survey_result.question_id	Identifier of the question, to which the answer is given.
ID	translation.tid	Identifier of the answer which is selected for the question
PAS Question Language	translation.t_lid	Identifier of language for the PAS question.
PAS Question Number	survey_question.qorder	Number of the question, to which the answer is given
Text	translation.ttext	PAS answer name.
PAS-Related Activity Date	survey_result.date	Date and time of the activity on which the questions were asked.
PAS-Related Activity ID	survey_take.aid	Identifier of the activity at which the answer is given.

Note: No changes and custom properties for this data set.

Note: Date and time values in the 'Pas Answer Fields' file are exported in GMT time zone.

Example: PAS Answer Fields File

The following data is collected. Provide a meaningful name to the report.

Identifier of the question, to which the answer is given, for example, qid
Date and time of the activity on which the questions were asked, for example, date
Identifier of the activity at which the answer is given, for example, aid
Identifier of the message with which the question is asked, for example, mid
Number of the question, to which the answer is given, for example, qnum
Customer's answer, for example, answ

Details for answers to questions 101 and 102 are extracted for activity 34567 performed on November 8, 2013, the questions were asked within message 567. Answer to both questions was 'Yes'.

<?xml version="1.0" encoding="UTF-8"?>
<pas_answers>
   <pas_answer>
      <Field name=”qid”>101</Field>
      <Field name=”date”>08-03-2011</Field>
      <Field name=”aid”>34567</Field>
      <Field name=”mid”>567</Field>
      <Field name=”qnum”>01</Field>
      <Field name=”answ">Y</Field>
   </pas_answer>
   <pas_answer>
      <Field name=”qid”>102</Field>
      <Field name=”date”>08-03-2011</Field>
      <Field name=”aid”>34567</Field>
      <Field name=”mid”>567</Field>
      <Field name=”qnum”>02</Field>
      <Field name=”answ">Y</Field>
   </pas_answer>
</pas_answers>