Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in Template — Cloud Customer Connect
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

Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in Template

edited Feb 25, 2021 11:39AM in Reporting and Analytics for HCM 4 comments

Summary

Need table names/SQL for Check-ins meeting and Questionnaire attached to the Check-in Template

Content

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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