with fact as (
     select 
         asub.student_user_id, asub.assignment_id, aa.program_map_id, ar.rubric_id submission_rubric_id, ar.value submission_rubric_value,
         asub.note as submission_note, asub.is_submitted submission_is_submitted, asub.grade submission_grade, asub.assignment_submission_id, 
         asub.submitted_date, asub.grade_note submission_grade_note,
         dwar.expected_percentage performance_goal_percentage, dwar.expected_level performance_goal_rubric_level,
         dwar.assessment_detail_response_id,
         dwar.program_rubric_id assessment_results_course_learning_objective_id, dwar.rubric_level assessment_results_user_rubric, dwar.success assessment_results_user_success, dwar.response assessment_results_user_response,
         pr.color program_rubric_color, pr.rubric_level program_rubric_level, pr.name program_rubric_name, pr.program_rubric_id
     from dw_fact_assignment_submission aSub
         inner join dw_deg_assessment_assignment aa on aa.assignment_id = aSub.assignment_id
         inner join assessment_evidence ae on ae.assignment_submission_id = aSub.assignment_submission_id
         inner join dw_fact_assessment_response dwar on dwar.assessment_detail_response_id = ae.assessment_detail_response_id and aa.program_map_id = dwar.program_map_id
         inner join program_rubric pr on pr.program_rubric_id = dwar.program_rubric_id
         left join dw_fact_assignment_rubric ar on aSub.assignment_submission_id = ar.assignment_submission_id
     )
 select 
     dwcsh.course_code, dwcsh.course_id, dwcsh.course_name, dwcsh.course_description, dwcsh.course_version_uuid,
 	 dwcsh.course_section_code, dwcsh.course_section_syllabus_form_id, dwcsh.course_section_id,
 	 dwcsh.course_section_term term_code, dwcsh.course_section_term_description term_name, dwcsh.course_section_term_id term_id, dwcsh.course_section_term_term_type_name term_type_name, dwcsh.course_section_term_status term_status,
 	 dwrh.course_learning_objective_id clo_id, dwrh.course_learning_objective_code clo_code, dwrh.course_learning_objective_description clo_description,
 	 dwrh.student_outcome_id, dwrh.student_outcome_description, dwrh.student_outcome_name, dwrh.student_outcome_code,
 	 iif(dwrh.source = 'p', dwrh.program_id, dwrh.accreditor_id) as accreditor_id,
     iif(dwrh.source = 'p', dwrh.program_code, dwrh.accreditor_code) as accreditor_code,
 	 iif(dwrh.source = 'p', dwrh.program_name, dwrh.accreditor_name) as accreditor_name,
 	 dwrh.accreditor_description, dwrh.source as accreditor_source,
 	 arh.assignment_id, arh.name as assignment_name, arh.description as assignment_description,
 	 arh.maximum_grade as assignment_maximum_grade, arh.grading_type as assignment_grading_type, arh.program_map_id as assignment_program_map_id,
 	 arh.rubric_criteria_id, arh.rubric_criteria_code, arh.rubric_criteria_name, arh.rubric_criteria_description, arh.submission_type assignment_submission_type,
 	 arh.rubric_id, arh.rubric_code, arh.rubric_name, arh.rubric_description, arh.rubric_value, arh.rubric_color, arh.rubric_points,
 	 ddaa.assignment_link_id assignment_link_id, ddaa.calculation_percent assignment_link_calculation_percent, ddaa.assignment_template_id assignment_link_assignment_template_id, 
 	 ddaa.success_score assignment_link_success_score, arh.program_map_id assignment_link_outcome_course_map_id, ddaa.criteria_link assignment_link_criteria_link,
     f.submission_note, f.submission_is_submitted, f.submission_grade, f.assignment_submission_id, f.submitted_date, f.submission_grade_note,
     f.performance_goal_percentage, f.performance_goal_rubric_level, dwrh.program_outcome_map_id, dwrh.student_outcome_id program_outcome_map_outcome_id,
     dwrh.is_placeholder performance_indicator_is_place_holder, dwrh.program_description,
     dwrh.performance_indicator_code, dwrh.performance_indicator_description,dwrh.performance_indicator_id, dwrh.performance_indicator_name,
     dwrh.program_map_id, dwrh.program_id, dwrh.developmental_level_id, dwrh.developmental_level_level, dwrh.developmental_level_color, dwrh.developmental_level_name,
     dwrh.program_name, dwrh.program_code, f.assessment_detail_response_id,
     dwrh.program_rubric_id program_map_rubric_id, dwrh.program_rubric_color program_map_rubric_color, dwrh.program_rubric_level program_map_rubric_level, dwrh.program_rubric_name program_map_rubric_name,
     f.program_rubric_id, f.program_rubric_level, f.program_rubric_name, f.program_rubric_color, f.submission_rubric_id, f.assessment_results_user_success, f.assessment_results_user_response, f.submission_rubric_value
 from dw_assignment_rubric_outcome_hierarchy arh
 	 inner join dw_program_rubric_hierarchy dwrh on dwrh.program_map_id = arh.program_map_id
     inner join dw_course_section_assessment_hierarchy dcsah on dcsah.course_section_id = arh.course_section_id
     inner join dw_deg_assessment_assignment ddaa on ddaa.assignment_id = arh.assignment_id
                                                 and dcsah.program_id = ddaa.program_id
                                                 and arh.program_map_id = ddaa.program_map_id
     inner join dw_user_enrollment_hierarchy dwueh on arh.course_section_id = dwueh.course_section_id 
     inner join dw_course_section_hierarchy dwcsh on dwcsh.course_section_id = arh.course_section_id
     left join fact f on f.assignment_id = ddaa.assignment_id
                             and f.program_map_id = ddaa.program_map_id
                             and COALESCE(f.submission_rubric_id,0) = COALESCE(arh.rubric_id,0)
                             and dwueh.user_id = f.student_user_id	
 where 
     1 = 1
     and f.student_user_id = 123456