An assessment template can include multiple questionnaire templates and document request templates, and a questionnaire template can be reused in more than one assessment template. That is a many-to-many relationship, and it is implemented through the junction table sn_vdr_risk_asmt_m2m_asmt_template_questionnaire_template, which stores one row for each pairing.
A reference field on the questionnaire template would restrict each questionnaire to a single assessment template, which would force duplication whenever a questionnaire is needed in several templates. A reference field on the assessment template would permit only one questionnaire per assessment template, contradicting the ability to group several. A calculated one-to-one relationship would be even more restrictive and is not how the data model is built.
The junction approach has a practical benefit: maintaining a questionnaire in one place updates every assessment template that uses it, while assessment templates can be recomposed without changing the questionnaire. When reporting on template composition or troubleshooting why a questionnaire does not appear in an assessment, administrators should examine the M2M table rather than looking for a reference field on either template.
[Reference: Study Guide – Assessment Configuration: Assessment Templates, Questionnaire Templates and Their Relationships.]
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit