You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What are the subject areas to fetch question and answers in OTBI?

edited Feb 21, 2024 7:27PM in BI Publisher Learning Center

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,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!