Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in Template
Summary
Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in TemplateContent
Hi,
I need to build i query to capture the response of questionnaire updated by Employee/Manager in check-in document created.
I have used below tables:
HRA_CHECK_IN_MEETINGS,
HRA_CHECK_IN_TMPLS_VL,
HRQ_QUESTIONNAIRES_B,
HRQ_QSTNR_SECTIONS_B qsec,
HRQ_QSTNR_QUESTIONS qqs,
HRQ_QUESTIONS_B qsn,
HRQ_QSTNR_PARTICIPANTS qprt,
HRQ_QSTNR_RESPONSES qrsp,
HRQ_QSTN_RESPONSES qid
But there is gap between HRA_CHECK_IN_MEETINGS, HRA_CHECK_IN_TMPLS_VL and HRQ_QUESTIONNAIRES_B
Please suggest how can i pull the check-in document name for which employee, manager updated the responses.