data.ml
LookML Insurance brokerage

Enrollment

Enrollment model for insurance brokerage.

source-preserved

Blocks

enrollment.view.lkml · 160 lines
inferred 
view: enrollment {
  sql_table_name: Enrollment ;;

  dimension: carrier_code {
    sql: ${TABLE}.CarrierCode ;;
  }

  dimension: company_code {
    sql: ${TABLE}.CompanyCode ;;
  }

  dimension: coverage_code {
    sql: ${TABLE}.CoverageCode ;;
  }

  dimension: family_id {
    sql: ${TABLE}.FamilyId ;;
  }

  dimension: group_code {
    sql: ${TABLE}.GroupCode ;;
  }

  dimension: is_dental {
    sql: ${TABLE}.IsDental ;;
  }

  dimension: is_employee {
    type: int
    sql: ${TABLE}.IsEmployee ;;
  }

  dimension: is_medical {
    sql: ${TABLE}.IsMedical ;;
  }

  dimension: is_rx {
    sql: ${TABLE}.IsRx ;;
  }

  dimension: is_single_coverage {
    type: int
    sql: ${TABLE}.IsSingleCoverage ;;
  }

  dimension: is_vision {
    sql: ${TABLE}.IsVision ;;
  }

  dimension: member_id {
    hidden: yes
    sql: ${TABLE}.MemberId ;;
  }

  dimension: other01 {
    sql: ${TABLE}.Other01 ;;
  }

  dimension: other02 {
    sql: ${TABLE}.Other02 ;;
  }

  dimension: other03 {
    sql: ${TABLE}.Other03 ;;
  }

  dimension: other04 {
    sql: ${TABLE}.Other04 ;;
  }

  dimension: other05 {
    sql: ${TABLE}.Other05 ;;
  }

  dimension: other06 {
    sql: ${TABLE}.Other06 ;;
  }

  dimension: other07 {
    sql: ${TABLE}.Other07 ;;
  }

  dimension: other08 {
    sql: ${TABLE}.Other08 ;;
  }

  dimension: other09 {
    sql: ${TABLE}.Other09 ;;
  }

  dimension: other10 {
    sql: ${TABLE}.Other10 ;;
  }

  dimension: other11 {
    sql: ${TABLE}.Other11 ;;
  }

  dimension: other12 {
    sql: ${TABLE}.Other12 ;;
  }

  dimension: other13 {
    sql: ${TABLE}.Other13 ;;
  }

  dimension: other14 {
    sql: ${TABLE}.Other14 ;;
  }

  dimension: other15 {
    sql: ${TABLE}.Other15 ;;
  }

  dimension: other16 {
    sql: ${TABLE}.Other16 ;;
  }

  dimension: other17 {
    sql: ${TABLE}.Other17 ;;
  }

  dimension: other18 {
    sql: ${TABLE}.Other18 ;;
  }

  dimension: other19 {
    sql: ${TABLE}.Other19 ;;
  }

  dimension: other20 {
    sql: ${TABLE}.Other20 ;;
  }

  dimension: plan_code {
    sql: ${TABLE}.PlanCode ;;
  }

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

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

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

  measure: count {
    type: count
  }
}
enrollment.view.lookml · 98 lines
source-preserved 
- view: enrollment
  sql_table_name: Enrollment
  fields:
  - dimension: carrier_code
    sql: ${TABLE}.CarrierCode
  - dimension: company_code
    sql: ${TABLE}.CompanyCode
  - dimension: coverage_code
    sql: ${TABLE}.CoverageCode
  - dimension: family_id
    sql: ${TABLE}.FamilyId
  - dimension: group_code
    sql: ${TABLE}.GroupCode
  - dimension: is_dental
    sql: ${TABLE}.IsDental
  - dimension: is_employee
    type: int
    sql: ${TABLE}.IsEmployee
  - dimension: is_medical
    sql: ${TABLE}.IsMedical
  - dimension: is_rx
    sql: ${TABLE}.IsRx
  - dimension: is_single_coverage
    type: int
    sql: ${TABLE}.IsSingleCoverage
  - dimension: is_vision
    sql: ${TABLE}.IsVision
  - dimension: member_id
    hidden: true
    sql: ${TABLE}.MemberId
  - dimension: other01
    sql: ${TABLE}.Other01
  - dimension: other02
    sql: ${TABLE}.Other02
  - dimension: other03
    sql: ${TABLE}.Other03
  - dimension: other04
    sql: ${TABLE}.Other04
  - dimension: other05
    sql: ${TABLE}.Other05
  - dimension: other06
    sql: ${TABLE}.Other06
  - dimension: other07
    sql: ${TABLE}.Other07
  - dimension: other08
    sql: ${TABLE}.Other08
  - dimension: other09
    sql: ${TABLE}.Other09
  - dimension: other10
    sql: ${TABLE}.Other10
  - dimension: other11
    sql: ${TABLE}.Other11
  - dimension: other12
    sql: ${TABLE}.Other12
  - dimension: other13
    sql: ${TABLE}.Other13
  - dimension: other14
    sql: ${TABLE}.Other14
  - dimension: other15
    sql: ${TABLE}.Other15
  - dimension: other16
    sql: ${TABLE}.Other16
  - dimension: other17
    sql: ${TABLE}.Other17
  - dimension: other18
    sql: ${TABLE}.Other18
  - dimension: other19
    sql: ${TABLE}.Other19
  - dimension: other20
    sql: ${TABLE}.Other20
  - dimension: plan_code
    sql: ${TABLE}.PlanCode
  - dimension_group: date_tag
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DateTag
  - dimension_group: effective
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.EffectiveDate
  - dimension_group: termination
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.TerminationDate
  - measure: count
    type: count

Contents

  • enrollment.view.lkml
  • enrollment.view.lookml