CREATE OR REPLACE VIEW public.vw_active_course_professor AS
 SELECT cpl.id AS assignment_id,
    cpl.course_id,
    cpl.professor_id,
    cpl.level_id,
    p.name,
    p.surname,
    p.email,
    fn_full_name(p.name::text, p.surname::text) AS full_name
   FROM course_professor_levels cpl
     JOIN professor_profiles pp ON pp.partner_id = cpl.professor_id AND pp.status = 'ACTIVE'::text
     JOIN partners p ON p.partner_id = cpl.professor_id;;