data.ml
LKML Healthcare analytics

Equipment

Equipment model for healthcare analytics.

inferred

Blocks

equipment.view.lkml · 68 lines
inferred 
view: equipment {
  sql_table_name: MedicalEquipment ;;

  dimension: equipment_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.MedicalDeviceID ;;
  }

  dimension: area_id {
    type: int
    hidden: yes
    sql: ${TABLE}.SectionID ;;
  }

  dimension: barcode_number {
    type: int
    sql: ${TABLE}.BarcodeNumber ;;
  }

  dimension: department_id {
    type: int
    hidden: yes
    sql: ${TABLE}.DivisionID ;;
  }

  dimension: equipment_category_id {
    type: int
    hidden: yes
    sql: ${TABLE}.MedicalEquipmentCategoryID ;;
  }

  dimension: equipment_idfrom_facility {
    sql: ${TABLE}.MedicalDeviceIDfromBuilding ;;
  }

  dimension: equipment_status_id {
    type: int
    hidden: yes
    sql: ${TABLE}.MedicalEquipmentStatusID ;;
  }

  dimension: manufacturer {
    sql: ${TABLE}.Manufacturer ;;
  }

  dimension: model {
    sql: ${TABLE}.Model ;;
  }

  dimension: serial_number {
    sql: ${TABLE}.SerialNumber ;;
  }

  dimension: equipment_use_history {
    sql: ${equipment_id} ;;
  }

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

  measure: count {
    type: count
  }
}
equipment.view.lookml · 46 lines
source-preserved 
- view: equipment
  sql_table_name: MedicalEquipment
  fields:
  - dimension: equipment_id
    type: int
    primary_key: true
    sql: ${TABLE}.MedicalDeviceID
  - dimension: area_id
    type: int
    hidden: true
    sql: ${TABLE}.SectionID
  - dimension: barcode_number
    type: int
    sql: ${TABLE}.BarcodeNumber
  - dimension: department_id
    type: int
    hidden: true
    sql: ${TABLE}.DivisionID
  - dimension: equipment_category_id
    type: int
    hidden: true
    sql: ${TABLE}.MedicalEquipmentCategoryID
  - dimension: equipment_idfrom_facility
    sql: ${TABLE}.MedicalDeviceIDfromBuilding
  - dimension: equipment_status_id
    type: int
    hidden: true
    sql: ${TABLE}.MedicalEquipmentStatusID
  - dimension: manufacturer
    sql: ${TABLE}.Manufacturer
  - dimension: model
    sql: ${TABLE}.Model
  - dimension: serial_number
    sql: ${TABLE}.SerialNumber
  - dimension: equipment_use_history
    sql: ${equipment_id}
  - dimension_group: equipment
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.MedicalEquipmentDate
  - measure: count
    type: count

Contents

  • equipment.view.lkml
  • equipment.view.lookml