Need a direct join between talent meeting and questionnaires to fetch meeting rating.(Meeting ID)
As of now we got only one join between questionnaire and talent review meeting is questionnaire_id but unbale to segregate records based on separate meetings and no meeting ID available in questionnaire tables
We have a requirement where the employees is a part of multiples Talent Review Meetings.
1)As per current configuration in the system we have Multiple reviewers for multiple meetings and they can rate the same employee.
2)There is one questionnaire and the "Talent review meeting template" is same for all the meetings.
3)Based on Talent review meeting names needs to segregate records.
As mention above the questionnaire is same for all the review meetings.