json_std_course_complete

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

uw_id

"_quest"."quest_uw_id"

2147483647

√

null

term_id

"_quest"."quest_term_id"

2147483647

√

null

subject_code

text

2147483647

√

null

catalog

text

2147483647

√

null

json

2147483647

√

null

Table contained 0 rows

View Definition

SELECT c.uw_id,
    c.term_id,
    c.subject_code,
    c.catalog,
    json_build_object('uw_id', c.uw_id, 'term_id', c.term_id, 'subject_code', c.subject_code, 'catalog', c.catalog, 'course_grade', c.course_grade, 'attempt_class', _oat.attempt_class(c.subject_code, c.course_grade, c.grading_basis, c.earn_credit), 'is_academic_subject', _oat.is_academic_subject(c.subject_code), 'transfer_course', c.transfer_course, 'course_id', c.course_id, 'details', json_build_object('career_code', c.career_code, 'class_id', c.class_id, 'course_as_of', c.course_as_of, 'course_take_units', c.course_take_units, 'course_title', c.course_title, 'earn_credit', c.earn_credit, 'grade_category', c.grade_category, 'grade_points', c.grade_points, 'grading_basis', c.grading_basis, 'grade_submission_date', c.grade_submission_date, 'group_code', c.group_code, 'include_in_gpa', c.include_in_gpa, 'requirement_designation', c.requirement_designation, 'requirement_designation_grade', c.requirement_designation_grade, 'transcript_note', c.transcript_note, 'student_take_units', c.student_take_units, 'units_attempted_code', c.units_attempted_code, 'student_ap_units', c.student_ap_units, 'valid_attempt', c.valid_attempt)) AS json
   FROM ( SELECT off_course_section_complete.career_code,
            off_course_section_complete.catalog,
            std_term_course.class_id,
            off_course_section_complete.course_as_of,
            std_term_course.course_grade,
            off_course_section_complete.course_id,
            off_course_section_complete.course_take_units,
            off_course_section_complete.course_title,
            std_term_course.earn_credit,
            std_term_course.grade_category,
            std_term_course.grade_points,
            std_term_course.grading_basis,
            off_course_section_complete.group_code,
            std_term_course.include_in_gpa,
            std_term_course.requirement_designation,
            std_term_course.requirement_designation_grade,
            off_course_section_complete.subject_code,
            std_term_course.term_id,
            std_term_course.student_take_units,
            std_term_course.units_attempted_code,
            std_term_course.student_ap_units,
            std_term_course.uw_id,
            std_term_course.valid_attempt,
            std_term_course.grade_submission_date,
            std_term_course.transcript_note,
            false AS transfer_course
           FROM (_quest.std_term_course
             JOIN _quest.off_course_section_complete USING (term_id, class_id))
        UNION ALL
         SELECT COALESCE(tcd.career_code, 'GRD'::_quest.quest_career) AS career_code,
            COALESCE(tcd.catalog, '000'::text) AS catalog,
            0,
            COALESCE(tcd.course_as_of, '1957-09-01'::date) AS course_as_of,
            tcd.course_grade,
            tcd.course_id,
            COALESCE(cal_course_history.course_take_units, (0)::numeric) AS course_take_units,
            COALESCE(cal_course_history.course_title, 'Unspecified transfer course'::text) AS course_title,
            tcd.earn_credit,
            tcd.grade_category,
            0,
            tcd.grading_basis,
            NULL::text AS group_code,
            tcd.include_in_gpa,
            tcd.requirement_designation,
            ''::text AS text,
            COALESCE(tcd.subject_code, 'UNSPEC'::text) AS subject_code,
            tcd.term_id,
            tcd.student_take_units,
            tcd.units_attempted_code,
            tcd.student_ap_units,
            tcd.uw_id,
            tcd.valid_attempt,
            NULL::date AS grade_submission_date,
            NULL::text AS transcript_note,
            true AS transfer_course
           FROM ((_quest.std_transfer_credit_detail_plus tcd
             LEFT JOIN _quest.cal_course_history USING (course_id, course_as_of))
             LEFT JOIN _quest.std_transfer_credit_school sch USING (uw_id, career_code, transfer_group))) c
  ORDER BY c.subject_code, c.catalog;

Description

Columns

View Definition

Possibly Referenced Tables/Views