Course

view: course {
  sql_table_name: public.Course ;;

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

  dimension: academic_subject_descriptor_id {
    type: int
    sql: ${TABLE}.AcademicSubjectDescriptorId ;;
  }

  dimension: career_pathway_type_id {
    type: int
    sql: ${TABLE}.CareerPathwayTypeId ;;
  }

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

  dimension: course_defined_by_type_id {
    type: int
    sql: ${TABLE}.CourseDefinedByTypeId ;;
  }

  dimension: course_description {
    sql: ${TABLE}.CourseDescription ;;
  }

  dimension: course_gpaapplicability_type_id {
    type: int
    sql: ${TABLE}.CourseGPAApplicabilityTypeId ;;
  }

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

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

  dimension: high_school_course_requirement {
    sql: ${TABLE}.HighSchoolCourseRequirement ;;
  }

  dimension: maximum_available_credit_conversion {
    type: number
    sql: ${TABLE}.MaximumAvailableCreditConversion ;;
  }

  dimension: maximum_available_credit_type_id {
    type: int
    sql: ${TABLE}.MaximumAvailableCreditTypeId ;;
  }

  dimension: maximum_available_credits {
    type: number
    sql: ${TABLE}.MaximumAvailableCredits ;;
  }

  dimension: minimum_available_credit_conversion {
    type: number
    sql: ${TABLE}.MinimumAvailableCreditConversion ;;
  }

  dimension: minimum_available_credit_type_id {
    type: int
    sql: ${TABLE}.MinimumAvailableCreditTypeId ;;
  }

  dimension: minimum_available_credits {
    type: number
    sql: ${TABLE}.MinimumAvailableCredits ;;
  }

  dimension: number_of_parts {
    type: int
    sql: ${TABLE}.NumberOfParts ;;
  }

  dimension: time_required_for_completion {
    type: int
    sql: ${TABLE}.TimeRequiredForCompletion ;;
  }

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

  dimension_group: date_course_adopted {
    type: time
    timeframes: [date, week, month]
    convert_tz: no
    sql: ${TABLE}.DateCourseAdopted ;;
  }

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

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

- view: course
  sql_table_name: public.Course
  fields:
  - dimension: id
    primary_key: true
    sql: ${TABLE}.Id
  - dimension: academic_subject_descriptor_id
    type: int
    sql: ${TABLE}.AcademicSubjectDescriptorId
  - dimension: career_pathway_type_id
    type: int
    sql: ${TABLE}.CareerPathwayTypeId
  - dimension: course_code
    sql: ${TABLE}.CourseCode
  - dimension: course_defined_by_type_id
    type: int
    sql: ${TABLE}.CourseDefinedByTypeId
  - dimension: course_description
    sql: ${TABLE}.CourseDescription
  - dimension: course_gpaapplicability_type_id
    type: int
    sql: ${TABLE}.CourseGPAApplicabilityTypeId
  - dimension: course_title
    sql: ${TABLE}.CourseTitle
  - dimension: education_organization_id
    type: int
    sql: ${TABLE}.EducationOrganizationId
  - dimension: high_school_course_requirement
    sql: ${TABLE}.HighSchoolCourseRequirement
  - dimension: maximum_available_credit_conversion
    type: number
    sql: ${TABLE}.MaximumAvailableCreditConversion
  - dimension: maximum_available_credit_type_id
    type: int
    sql: ${TABLE}.MaximumAvailableCreditTypeId
  - dimension: maximum_available_credits
    type: number
    sql: ${TABLE}.MaximumAvailableCredits
  - dimension: minimum_available_credit_conversion
    type: number
    sql: ${TABLE}.MinimumAvailableCreditConversion
  - dimension: minimum_available_credit_type_id
    type: int
    sql: ${TABLE}.MinimumAvailableCreditTypeId
  - dimension: minimum_available_credits
    type: number
    sql: ${TABLE}.MinimumAvailableCredits
  - dimension: number_of_parts
    type: int
    sql: ${TABLE}.NumberOfParts
  - dimension: time_required_for_completion
    type: int
    sql: ${TABLE}.TimeRequiredForCompletion
  - dimension_group: create
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CreateDate
  - dimension_group: date_course_adopted
    type: time
    timeframes:
    - date
    - week
    - month
    convert_tz: false
    sql: ${TABLE}.DateCourseAdopted
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LastModifiedDate
  - measure: count
    type: count
    drill_fields:
    - detail*