data.ml
LookML Healthcare analytics

Medications

Medications model for healthcare analytics.

source-preserved

Blocks

medications.view.lkml · 60 lines
inferred 
view: medications {
  sql_table_name: Prescriptions ;;

  dimension: medications_id {
    type: int
    sql: ${TABLE}.PrescriptionsID ;;
  }

  dimension: operations_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.MedicalProceduresID ;;
  }

  dimension: medication_dose {
    type: number
    sql: ${TABLE}.MedicationDose ;;
  }

  dimension: medication_dose_calculation {
    sql: ${TABLE}.MedicationDoseCalculation ;;
  }

  dimension: medication_frequency {
    sql: ${TABLE}.MedicationFrequency ;;
  }

  dimension: medication_instructions {
    sql: ${TABLE}.MedicationInstructions ;;
  }

  dimension: medication_lot_number {
    sql: ${TABLE}.MedicationLotNumber ;;
  }

  dimension: medication_unit {
    sql: ${TABLE}.MedicationUnit ;;
  }

  dimension: user_id {
    type: int
    hidden: yes
    sql: ${TABLE}.MemberID ;;
  }

  dimension: visit_id {
    type: int
    sql: ${TABLE}.VisitID ;;
  }

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

  measure: count {
    type: count
  }
}
medications.view.lookml · 40 lines
source-preserved 
- view: medications
  sql_table_name: Prescriptions
  fields:
  - dimension: medications_id
    type: int
    sql: ${TABLE}.PrescriptionsID
  - dimension: operations_id
    type: int
    primary_key: true
    sql: ${TABLE}.MedicalProceduresID
  - dimension: medication_dose
    type: number
    sql: ${TABLE}.MedicationDose
  - dimension: medication_dose_calculation
    sql: ${TABLE}.MedicationDoseCalculation
  - dimension: medication_frequency
    sql: ${TABLE}.MedicationFrequency
  - dimension: medication_instructions
    sql: ${TABLE}.MedicationInstructions
  - dimension: medication_lot_number
    sql: ${TABLE}.MedicationLotNumber
  - dimension: medication_unit
    sql: ${TABLE}.MedicationUnit
  - dimension: user_id
    type: int
    hidden: true
    sql: ${TABLE}.MemberID
  - dimension: visit_id
    type: int
    sql: ${TABLE}.VisitID
  - dimension_group: medication
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.MedicationTime
  - measure: count
    type: count

Contents

  • medications.view.lkml
  • medications.view.lookml