PAS Answer Fields

This section provides a list of PAS answer fields.

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.

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