FFS_REP_PAS_ANSWER_V

Details

• Schema: FUSION

• Object owner: FFS

• Object type: VIEW

Columns

Name
ACTIVITY_ID QUESTION ANSWER

Query

SQL_Statement
SELECT st.activity_id, sr.question_id question, tr.text answer FROM ffs_survey INNER JOIN ffs_survey_take st ON ffs_survey.survey_id = st.survey_id INNER JOIN ffs_survey_result sr ON st.take_id = sr.take_id INNER JOIN ffs_translation tr ON sr.answer_id = tr.translation_id AND tr.translation_table = 'survey_answer.answer_id'