What are the subject areas to fetch question and answers in OTBI?
In BI report we get the following fields from the following tables:
QuestionnaireParticipantPEO.qstnr_participant_id AS Q_QSTNR_PARTICIPANT_ID,
QuestionnaireParticipantPEO.participant_id,
QuestionnaireParticipantPEO.subject_id,
QuestionnaireResponsePEO.qstnr_response_id AS QRR_QSTNR_RESPONSE_ID,
QuestionnaireResponsePEO.business_group_id AS QRR_BUSINESS_GROUP_ID,
QuestionResponsePEO.business_group_id AS QR_BUSINESS_GROUP_ID,
QuestionResponsePEO.qstnr_question_id,
QuestionResponsePEO.qstn_response_id,
QuestionResponsePEO.answer_type,
QuestionResponsePEO.answer_id,
QstnResponsePEO.business_group_id,
QstnResponsePEO.qstnr_question_id AS QSTNR_QUESTION_ID505,
QuestionResponsePEO.ANSWER_CLOB
FROM hrq_qstnr_sections_b QuestionnaireSectionBPEO,
hrq_qstnr_sections_tl QuestionnaireSectionTranslat1,
hrq_qstnr_questions QuestionnaireQuestionPEO,
hrq_questions_b QuestionBPEO,