Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
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.
Tagged:
1