/*[sqlquery[*/ SELECT CAST(assessment.assessment_identifier as VARCHAR) as assessment_identifier, CAST(assessment_party_role.party_identifier as VARCHAR) as party_identifier
FROM demo.acme.assessment_result ar
JOIN demo.acme.underwriting_assessment ua on ar.assessment_result_identifier = ua.assessment_result_identifier
JOIN demo.acme.assessment on ar.assessment_identifier = assessment.assessment_identifier
JOIN demo.acme.assessment_party_role on assessment_party_role.assessment_identifier = assessment.assessment_identifier
WHERE assessment_party_role.party_role_code = 'UW'
/*]sqlquery]*/