Properties

view: properties {
  sql_table_name: PROPERTIES ;;

  dimension: property_id {
    type: int
    primary_key: yes
    sql: ${TABLE}.PROPERTY_ID ;;
  }

  dimension: abbreviation {
    sql: ${TABLE}.ABBREVIATION ;;
  }

  dimension: active {
    type: int
    sql: ${TABLE}.ACTIVE ;;
  }

  dimension: billing_city {
    sql: ${TABLE}.BILLING_CITY ;;
  }

  dimension: billing_state {
    sql: ${TABLE}.BILLING_STATE ;;
  }

  dimension: billing_street_addr {
    sql: ${TABLE}.BILLING_STREET_ADDR ;;
  }

  dimension: billing_street_addr_2 {
    sql: ${TABLE}.BILLING_STREET_ADDR_2 ;;
  }

  dimension: billing_zip_code {
    sql: ${TABLE}.BILLING_ZIP_CODE ;;
  }

  dimension: city {
    sql: ${TABLE}.CITY ;;
  }

  dimension: company_id {
    type: int
    sql: ${TABLE}.COMPANY_ID ;;
  }

  dimension: county {
    sql: ${TABLE}.COUNTY ;;
  }

  dimension: county_fips {
    type: int
    sql: ${TABLE}.COUNTY_FIPS ;;
  }

  dimension: created_by {
    type: int
    sql: ${TABLE}.CREATED_BY ;;
  }

  dimension: credit_end_user_name {
    sql: ${TABLE}.CREDIT_END_USER_NAME ;;
  }

  dimension: deactivated_by {
    type: int
    sql: ${TABLE}.DEACTIVATED_BY ;;
  }

  dimension: has__office {
    type: int
    sql: ${TABLE}.HAS__OFFICE ;;
  }

  dimension: latitude {
    type: number
    sql: ${TABLE}.LATITUDE ;;
  }

  dimension: longitude {
    type: number
    sql: ${TABLE}.LONGITUDE ;;
  }

  dimension: num_units_dim {
    type: int
    sql: ${TABLE}.NUM_UNITS ;;
  }

  dimension: property_name {
    sql: ${TABLE}.PROPERTY_NAME ;;
  }

  dimension: property_type {
    type: int
    sql: ${TABLE}.PROPERTY_TYPE ;;
  }

  dimension: ra_billing_city {
    sql: ${TABLE}.RA_BILLING_CITY ;;
  }

  dimension: ra_billing_state {
    sql: ${TABLE}.RA_BILLING_STATE ;;
  }

  dimension: ra_billing_street_addr {
    sql: ${TABLE}.RA_BILLING_STREET_ADDR ;;
  }

  dimension: ra_billing_street_addr_2 {
    sql: ${TABLE}.RA_BILLING_STREET_ADDR_2 ;;
  }

  dimension: ra_billing_zip_code {
    sql: ${TABLE}.RA_BILLING_ZIP_CODE ;;
  }

  dimension: ra_use_billing_addr {
    type: number
    sql: ${TABLE}.RA_USE_BILLING_ADDR ;;
  }

  dimension: region_id {
    type: int
    sql: ${TABLE}.REGION_ID ;;
  }

  dimension: rent_checks_to {
    sql: ${TABLE}.RENT_CHECKS_TO ;;
  }

  dimension: rent_city {
    sql: ${TABLE}.RENT_CITY ;;
  }

  dimension: rent_county {
    sql: ${TABLE}.RENT_COUNTY ;;
  }

  dimension: rent_fax_number {
    sql: ${TABLE}.RENT_FAX_NUMBER ;;
  }

  dimension: rent_office_hours {
    sql: ${TABLE}.RENT_OFFICE_HOURS ;;
  }

  dimension: rent_phone_number {
    sql: ${TABLE}.RENT_PHONE_NUMBER ;;
  }

  dimension: rent_state {
    sql: ${TABLE}.RENT_STATE ;;
  }

  dimension: rent_street_addr {
    sql: ${TABLE}.RENT_STREET_ADDR ;;
  }

  dimension: rent_zip_code {
    sql: ${TABLE}.RENT_ZIP_CODE ;;
  }

  dimension: stamp_id {
    type: int
    sql: ${TABLE}.STAMP_ID ;;
  }

  dimension: state {
    sql: ${TABLE}.STATE ;;
  }

  dimension: street_addr {
    sql: ${TABLE}.STREET_ADDR ;;
  }

  dimension: use_billing_addr {
    type: int
    sql: ${TABLE}.USE_BILLING_ADDR ;;
  }

  dimension: use_unit_numbers {
    type: int
    sql: ${TABLE}.USE_UNIT_NUMBERS ;;
  }

  dimension: year_built {
    type: int
    sql: ${TABLE}.YEAR_BUILT ;;
  }

  dimension: zip_code {
    sql: ${TABLE}.ZIP_CODE ;;
  }

  dimension: zoom_level {
    type: number
    sql: ${TABLE}.ZOOM_LEVEL ;;
  }

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

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

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

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

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

  measure: num_units {
    type: sum
    sql: ${num_units_dim} ;;
  }

  measure: count {
    type: count
  }
}

- view: properties
  sql_table_name: PROPERTIES
  fields:
  - dimension: property_id
    type: int
    primary_key: true
    sql: ${TABLE}.PROPERTY_ID
  - dimension: abbreviation
    sql: ${TABLE}.ABBREVIATION
  - dimension: active
    type: int
    sql: ${TABLE}.ACTIVE
  - dimension: billing_city
    sql: ${TABLE}.BILLING_CITY
  - dimension: billing_state
    sql: ${TABLE}.BILLING_STATE
  - dimension: billing_street_addr
    sql: ${TABLE}.BILLING_STREET_ADDR
  - dimension: billing_street_addr_2
    sql: ${TABLE}.BILLING_STREET_ADDR_2
  - dimension: billing_zip_code
    sql: ${TABLE}.BILLING_ZIP_CODE
  - dimension: city
    sql: ${TABLE}.CITY
  - dimension: company_id
    type: int
    sql: ${TABLE}.COMPANY_ID
  - dimension: county
    sql: ${TABLE}.COUNTY
  - dimension: county_fips
    type: int
    sql: ${TABLE}.COUNTY_FIPS
  - dimension: created_by
    type: int
    sql: ${TABLE}.CREATED_BY
  - dimension: credit_end_user_name
    sql: ${TABLE}.CREDIT_END_USER_NAME
  - dimension: deactivated_by
    type: int
    sql: ${TABLE}.DEACTIVATED_BY
  - dimension: has__office
    type: int
    sql: ${TABLE}.HAS__OFFICE
  - dimension: latitude
    type: number
    sql: ${TABLE}.LATITUDE
  - dimension: longitude
    type: number
    sql: ${TABLE}.LONGITUDE
  - dimension: num_units_dim
    type: int
    sql: ${TABLE}.NUM_UNITS
  - dimension: property_name
    sql: ${TABLE}.PROPERTY_NAME
  - dimension: property_type
    type: int
    sql: ${TABLE}.PROPERTY_TYPE
  - dimension: ra_billing_city
    sql: ${TABLE}.RA_BILLING_CITY
  - dimension: ra_billing_state
    sql: ${TABLE}.RA_BILLING_STATE
  - dimension: ra_billing_street_addr
    sql: ${TABLE}.RA_BILLING_STREET_ADDR
  - dimension: ra_billing_street_addr_2
    sql: ${TABLE}.RA_BILLING_STREET_ADDR_2
  - dimension: ra_billing_zip_code
    sql: ${TABLE}.RA_BILLING_ZIP_CODE
  - dimension: ra_use_billing_addr
    type: number
    sql: ${TABLE}.RA_USE_BILLING_ADDR
  - dimension: region_id
    type: int
    sql: ${TABLE}.REGION_ID
  - dimension: rent_checks_to
    sql: ${TABLE}.RENT_CHECKS_TO
  - dimension: rent_city
    sql: ${TABLE}.RENT_CITY
  - dimension: rent_county
    sql: ${TABLE}.RENT_COUNTY
  - dimension: rent_fax_number
    sql: ${TABLE}.RENT_FAX_NUMBER
  - dimension: rent_office_hours
    sql: ${TABLE}.RENT_OFFICE_HOURS
  - dimension: rent_phone_number
    sql: ${TABLE}.RENT_PHONE_NUMBER
  - dimension: rent_state
    sql: ${TABLE}.RENT_STATE
  - dimension: rent_street_addr
    sql: ${TABLE}.RENT_STREET_ADDR
  - dimension: rent_zip_code
    sql: ${TABLE}.RENT_ZIP_CODE
  - dimension: stamp_id
    type: int
    sql: ${TABLE}.STAMP_ID
  - dimension: state
    sql: ${TABLE}.STATE
  - dimension: street_addr
    sql: ${TABLE}.STREET_ADDR
  - dimension: use_billing_addr
    type: int
    sql: ${TABLE}.USE_BILLING_ADDR
  - dimension: use_unit_numbers
    type: int
    sql: ${TABLE}.USE_UNIT_NUMBERS
  - dimension: year_built
    type: int
    sql: ${TABLE}.YEAR_BUILT
  - dimension: zip_code
    sql: ${TABLE}.ZIP_CODE
  - dimension: zoom_level
    type: number
    sql: ${TABLE}.ZOOM_LEVEL
  - dimension_group: begin_accounting
    type: time
    timeframes:
    - date
    - week
    - month
    sql: ${TABLE}.BEGIN_ACCOUNTING
  - dimension_group: created
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.CREATED_DATE
  - dimension_group: deactivated
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.DEACTIVATED_DATE
  - dimension_group: last_billing_note
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LAST_BILLING_NOTE
  - dimension_group: last_modified
    type: time
    timeframes:
    - time
    - date
    - week
    - month
    sql: ${TABLE}.LAST_MODIFIED
  - measure: num_units
    type: sum
    sql: ${num_units_dim}
  - measure: count
    type: count