Course Transcript

view: course_transcript {
  sql_table_name: public.CourseTranscript ;;

  dimension: id {
    primary_key: yes
    sql: ${TABLE}.Id ;;
  }

  dimension: alternative_course_code {
    sql: ${TABLE}.AlternativeCourseCode ;;
  }

  dimension: alternative_course_title {
    sql: ${TABLE}.AlternativeCourseTitle ;;
  }

  dimension: attempted_credit_conversion {
    type: number
    sql: ${TABLE}.AttemptedCreditConversion ;;
  }

  dimension: attempted_credit_type_id {
    type: int
    sql: ${TABLE}.AttemptedCreditTypeId ;;
  }

  dimension: attempted_credits {
    type: number
    sql: ${TABLE}.AttemptedCredits ;;
  }

  dimension: course_attempt_result_type_id {
    type: int
    sql: ${TABLE}.CourseAttemptResultTypeId ;;
  }

  dimension: course_code {
    sql: ${TABLE}.CourseCode ;;
  }

  dimension: course_education_organization_id {
    type: int
    sql: ${TABLE}.CourseEducationOrganizationId ;;
  }

  dimension: course_repeat_code_type_id {
    type: int
    sql: ${TABLE}.CourseRepeatCodeTypeId ;;
  }

  dimension: course_title {
    sql: ${TABLE}.CourseTitle ;;
  }

  dimension: earned_credit_conversion {
    type: number
    sql: ${TABLE}.EarnedCreditConversion ;;
  }

  dimension: earned_credit_type_id {
    type: int
    sql: ${TABLE}.EarnedCreditTypeId ;;
  }

  dimension: earned_credits {
    type: number
    sql: ${TABLE}.EarnedCredits ;;
  }

  dimension: education_organization_id {
    type: int
    sql: ${TABLE}.EducationOrganizationId ;;
  }

  dimension: final_letter_grade_earned {
    sql: ${TABLE}.FinalLetterGradeEarned ;;
  }

  dimension: final_numeric_grade_earned {
    type: number
    sql: ${TABLE}.FinalNumericGradeEarned ;;
  }

  dimension: method_credit_earned_type_id {
    type: int
    sql: ${TABLE}.MethodCreditEarnedTypeId ;;
  }

  dimension: school_id {
    type: int
    sql: ${TABLE}.SchoolId ;;
  }

  dimension: school_year {
    type: number
    sql: ${TABLE}.SchoolYear ;;
  }

  dimension: student_usi {
    type: int
    sql: ${TABLE}.StudentUSI ;;
  }

  dimension: term_descriptor_id {
    type: int
    sql: ${TABLE}.TermDescriptorId ;;
  }

  dimension: when_taken_grade_level_descriptor_id {
    type: int
    sql: ${TABLE}.WhenTakenGradeLevelDescriptorId ;;
  }

  dimension_group: create {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.CreateDate ;;
  }

  dimension_group: last_modified {
    type: time
    timeframes: [time, date, week, month]
    sql: ${TABLE}.LastModifiedDate ;;
  }

  measure: count {
    type: count
    drill_fields: [detail*]
  }

  measure: count_with_d_or_f {
    type: count
    filters: [final_letter_grade_earned: "D,F"]
  }

  measure: percent_d_or_lower {
    type: number
    value_format: "#.#\%"
    sql: 100.0 * ${count_with_d_or_f} / nullif(${count},0) ;;
  }
}

- view: course_transcript
  sql_table_name: public.CourseTranscript
  fields:
  - dimension: id
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: alternative_course_code
    sql: ${TABLE}.AlternativeCourseCode
  - dimension: alternative_course_title
    sql: ${TABLE}.AlternativeCourseTitle
  - dimension: attempted_credit_conversion
    type: number
    sql: ${TABLE}.AttemptedCreditConversion
  - dimension: attempted_credit_type_id
    type: int
    sql: ${TABLE}.AttemptedCreditTypeId
  - dimension: attempted_credits
    type: number
    sql: ${TABLE}.AttemptedCredits
  - dimension: course_attempt_result_type_id
    type: int
    sql: ${TABLE}.CourseAttemptResultTypeId
  - dimension: course_code
    sql: ${TABLE}.CourseCode
  - dimension: course_education_organization_id
    type: int
    sql: ${TABLE}.CourseEducationOrganizationId
  - dimension: course_repeat_code_type_id
    type: int
    sql: ${TABLE}.CourseRepeatCodeTypeId
  - dimension: course_title
    sql: ${TABLE}.CourseTitle
  - dimension: earned_credit_conversion
    type: number
    sql: ${TABLE}.EarnedCreditConversion
  - dimension: earned_credit_type_id
    type: int
    sql: ${TABLE}.EarnedCreditTypeId
  - dimension: earned_credits
    type: number
    sql: ${TABLE}.EarnedCredits
  - dimension: education_organization_id
    type: int
    sql: ${TABLE}.EducationOrganizationId
  - dimension: final_letter_grade_earned
    sql: ${TABLE}.FinalLetterGradeEarned
  - dimension: final_numeric_grade_earned
    type: number
    sql: ${TABLE}.FinalNumericGradeEarned
  - dimension: method_credit_earned_type_id
    type: int
    sql: ${TABLE}.MethodCreditEarnedTypeId
  - dimension: school_id
    type: int
    sql: ${TABLE}.SchoolId
  - dimension: school_year
    type: number
    sql: ${TABLE}.SchoolYear
  - dimension: student_usi
    type: int
    sql: ${TABLE}.StudentUSI
  - dimension: term_descriptor_id
    type: int
    sql: ${TABLE}.TermDescriptorId
  - dimension: when_taken_grade_level_descriptor_id
    type: int
    sql: ${TABLE}.WhenTakenGradeLevelDescriptorId
  - dimension_group: create
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CreateDate
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastModifiedDate
  - measure: count
    type: count
    drill_fields:
    - detail*
  - measure: count_with_d_or_f
    type: count
    filters:
    - final_letter_grade_earned: D,F
  - measure: percent_d_or_lower
    type: number
    value_format: '#.#\%'
    sql: 100.0 * ${count_with_d_or_f} / nullif(${count},0)