Dim Employee

view: dim_employee {
  sql_table_name: reporting.dim_employee ;;

  dimension: employee_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.dim_employee_id ;;
  }

  dimension: branch_address {
    sql: ${TABLE}.branch_address ;;
  }

  dimension: branch_city {
    sql: ${TABLE}.branch_city ;;
  }

  dimension: branch_county {
    sql: ${TABLE}.branch_county ;;
  }

  dimension: branch_fax_number {
    sql: ${TABLE}.branch_fax ;;
  }

  dimension: branch_follows_dst {
    type: yesno
    sql: ${TABLE}.branchfollowsdst ;;
  }

  dimension: branch_name {
    sql: ${TABLE}.branch_name ;;
  }

  dimension: branch_nmls_id {
    sql: ${TABLE}.branchnmlsid ;;
  }

  dimension: branch_number {
    sql: ${TABLE}.branchnumber ;;
  }

  dimension: branch_phone_number {
    sql: ${TABLE}.branchphone ;;
  }

  dimension: branch_region {
    sql: ${TABLE}.branch_region ;;
  }

  dimension: branch_state {
    sql: ${TABLE}.branch_state ;;
  }

  dimension: branch_status {
    sql: ${TABLE}.branchstatus ;;
  }

  dimension: branch_suite {
    sql: ${TABLE}.branchsuite ;;
  }

  dimension: branch_utc_offset {
    type: int
    sql: ${TABLE}.branchutcoffset ;;
  }

  dimension: branch_zip {
    sql: ${TABLE}.branchzip ;;
  }

  dimension: business_phone_number {
    sql: ${TABLE}.businessphone ;;
  }

  dimension: business_unit_code {
    sql: ${TABLE}.businessunitcode ;;
  }

  dimension: business_unit_name {
    sql: ${TABLE}.businessunitname ;;
  }

  dimension: employee_id_current {
    sql: ${TABLE}.dim_employee_id_current ;;
  }

  dimension: branch_id {
    type: int
    sql: ${TABLE}.dimbranchid ;;
  }

  dimension: branch_id_current {
    sql: ${TABLE}.dimbranchidcurrent ;;
  }

  dimension: manager_employee_id {
    type: int
    sql: ${TABLE}.dimemployeeidmanager ;;
  }

  dimension: manager_employee_id_current {
    sql: ${TABLE}.dimemployeeidmanagercurrent ;;
  }

  dimension: email {
    sql: ${TABLE}.email ;;
  }

  dimension: employee_address.city {
    sql: ${TABLE}.employeecity ;;
  }

  dimension: employee_address.state {
    sql: ${TABLE}.employeestate ;;
  }

  dimension: status {
    sql: ${TABLE}.employee_status ;;
  }

  dimension: employee_address.street {
    sql: ${TABLE}.employeestreetaddress ;;
  }

  dimension: employee_address.zipcode {
    type: zipcode
    sql: ${TABLE}.employeezipcode ;;
  }

  dimension: file_number {
    sql: ${TABLE}.file_number ;;
  }

  dimension: first_name {
    sql: ${TABLE}.firstname ;;
  }

  dimension: full_name {
    sql: ${TABLE}.full_name ;;
  }

  dimension: days_as_employee {
    type: number
    sql: DATEDIFF('day', NOW(), hire_date) ;;
  }

  dimension: ihm_employee_id {
    type: int
    sql: ${TABLE}.ihm_employee_id ;;
  }

  dimension: ihm_person_id {
    type: int
    sql: ${TABLE}.ihm_person_id ;;
  }

  dimension: ihm_branch_id {
    type: int
    sql: ${TABLE}.ihmbranchid ;;
  }

  dimension: ihm_first_name {
    sql: ${TABLE}.ihmfirstname ;;
  }

  dimension: ihm_full_name {
    sql: ${TABLE}.ihmfullname ;;
  }

  dimension: ihm_last_name {
    sql: ${TABLE}.ihmlastname ;;
  }

  dimension: ihm_last_first_name {
    sql: ${TABLE}.ihmlastnamefirstname ;;
  }

  dimension: ihm_security_level {
    sql: ${TABLE}.ihmsecuritylevel ;;
  }

  dimension: job_title {
    sql: ${TABLE}.jobtitle ;;
  }

  dimension: job_type {
    sql: ${TABLE}.jobtype ;;
  }

  dimension: last_name {
    sql: ${TABLE}.lastname ;;
  }

  dimension: last_first_name {
    sql: ${TABLE}.lastnamefirstname ;;
  }

  dimension: license_number {
    sql: ${TABLE}.licensenumber ;;
  }

  dimension: location_code {
    sql: ${TABLE}.locationcode ;;
  }

  dimension: location_name {
    sql: ${TABLE}.locationname ;;
  }

  dimension: login_name {
    sql: ${TABLE}.loginname ;;
  }

  dimension: nmlsid {
    sql: ${TABLE}.nmlsid ;;
  }

  dimension: notification_email {
    sql: ${TABLE}.notificationemail ;;
  }

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

  dimension_group: effective {
    type: time
    timeframes: [date]
    sql: ${TABLE}.effective_date ;;
  }

  dimension_group: hire {
    type: time
    timeframes: [date]
    sql: ${TABLE}.hiredate ;;
  }

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

  dimension_group: terminated {
    type: time
    timeframes: [date, yesno]
    sql: ${TABLE}.terminationdate ;;
  }

  measure: count {
    type: count
  }
}

- view: dim_employee
  sql_table_name: reporting.dim_employee
  fields:
  - dimension: employee_id
    type: int
    primary_key: true
    sql: ${TABLE}.dim_employee_id
  - dimension: branch_address
    sql: ${TABLE}.branch_address
  - dimension: branch_city
    sql: ${TABLE}.branch_city
  - dimension: branch_county
    sql: ${TABLE}.branch_county
  - dimension: branch_fax_number
    sql: ${TABLE}.branch_fax
  - dimension: branch_follows_dst
    type: yesno
    sql: ${TABLE}.branchfollowsdst
  - dimension: branch_name
    sql: ${TABLE}.branch_name
  - dimension: branch_nmls_id
    sql: ${TABLE}.branchnmlsid
  - dimension: branch_number
    sql: ${TABLE}.branchnumber
  - dimension: branch_phone_number
    sql: ${TABLE}.branchphone
  - dimension: branch_region
    sql: ${TABLE}.branch_region
  - dimension: branch_state
    sql: ${TABLE}.branch_state
  - dimension: branch_status
    sql: ${TABLE}.branchstatus
  - dimension: branch_suite
    sql: ${TABLE}.branchsuite
  - dimension: branch_utc_offset
    type: int
    sql: ${TABLE}.branchutcoffset
  - dimension: branch_zip
    sql: ${TABLE}.branchzip
  - dimension: business_phone_number
    sql: ${TABLE}.businessphone
  - dimension: business_unit_code
    sql: ${TABLE}.businessunitcode
  - dimension: business_unit_name
    sql: ${TABLE}.businessunitname
  - dimension: employee_id_current
    sql: ${TABLE}.dim_employee_id_current
  - dimension: branch_id
    type: int
    sql: ${TABLE}.dimbranchid
  - dimension: branch_id_current
    sql: ${TABLE}.dimbranchidcurrent
  - dimension: manager_employee_id
    type: int
    sql: ${TABLE}.dimemployeeidmanager
  - dimension: manager_employee_id_current
    sql: ${TABLE}.dimemployeeidmanagercurrent
  - dimension: email
    sql: ${TABLE}.email
  - dimension: employee_address.city
    sql: ${TABLE}.employeecity
  - dimension: employee_address.state
    sql: ${TABLE}.employeestate
  - dimension: status
    sql: ${TABLE}.employee_status
  - dimension: employee_address.street
    sql: ${TABLE}.employeestreetaddress
  - dimension: employee_address.zipcode
    type: zipcode
    sql: ${TABLE}.employeezipcode
  - dimension: file_number
    sql: ${TABLE}.file_number
  - dimension: first_name
    sql: ${TABLE}.firstname
  - dimension: full_name
    sql: ${TABLE}.full_name
  - dimension: days_as_employee
    type: number
    sql: DATEDIFF('day', NOW(), hire_date)
  - dimension: ihm_employee_id
    type: int
    sql: ${TABLE}.ihm_employee_id
  - dimension: ihm_person_id
    type: int
    sql: ${TABLE}.ihm_person_id
  - dimension: ihm_branch_id
    type: int
    sql: ${TABLE}.ihmbranchid
  - dimension: ihm_first_name
    sql: ${TABLE}.ihmfirstname
  - dimension: ihm_full_name
    sql: ${TABLE}.ihmfullname
  - dimension: ihm_last_name
    sql: ${TABLE}.ihmlastname
  - dimension: ihm_last_first_name
    sql: ${TABLE}.ihmlastnamefirstname
  - dimension: ihm_security_level
    sql: ${TABLE}.ihmsecuritylevel
  - dimension: job_title
    sql: ${TABLE}.jobtitle
  - dimension: job_type
    sql: ${TABLE}.jobtype
  - dimension: last_name
    sql: ${TABLE}.lastname
  - dimension: last_first_name
    sql: ${TABLE}.lastnamefirstname
  - dimension: license_number
    sql: ${TABLE}.licensenumber
  - dimension: location_code
    sql: ${TABLE}.locationcode
  - dimension: location_name
    sql: ${TABLE}.locationname
  - dimension: login_name
    sql: ${TABLE}.loginname
  - dimension: nmlsid
    sql: ${TABLE}.nmlsid
  - dimension: notification_email
    sql: ${TABLE}.notificationemail
  - dimension_group: branch_nmls_id_expirationdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.branchnmlsidexpirationdate
  - dimension_group: effective
    type: time
    timeframes:
    - date
    sql: ${TABLE}.effective_date
  - dimension_group: hire
    type: time
    timeframes:
    - date
    sql: ${TABLE}.hiredate
  - dimension_group: nmlsidexpirationdate
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.nmlsidexpirationdate
  - dimension_group: terminated
    type: time
    timeframes:
    - date
    - yesno
    sql: ${TABLE}.terminationdate
  - measure: count
    type: count