default.vw_pin_condo_char.yml

models:
  - name: default.vw_pin_condo_char
    description: '{{ doc("view_vw_pin_condo_char") }}'
    config:
      tags:
        - type_condo

    columns:
      - name: bldg_is_mixed_use
        description: '{{ doc("shared_column_char_bldg_is_mixed_use") }}'
      - name: card
        description: '{{ doc("shared_column_card") }}'
      - name: card_proration_rate
        description: '{{ doc("shared_column_card_proration_rate") }}'
      - name: cdu
        description: '{{ doc("shared_column_cdu") }}'
      - name: char_bedrooms
        description: '{{ doc("shared_column_char_beds") }}'
      - name: char_building_non_units
        description: '{{ doc("shared_column_char_building_non_units") }}'
      - name: char_building_pins
        description: '{{ doc("shared_column_char_building_pins") }}'
      - name: char_building_sf
        description: '{{ doc("shared_column_char_building_sf") }}'
      - name: char_full_baths
        description: '{{ doc("shared_column_char_fbath") }}'
      - name: char_half_baths
        description: '{{ doc("shared_column_char_hbath") }}'
      - name: char_land_sf
        description: '{{ doc("shared_column_char_land_sf") }}'
      - name: char_unit_sf
        description: '{{ doc("shared_column_char_unit_sf") }}'
      - name: char_yrblt
        description: '{{ doc("shared_column_char_yrblt") }}'
      - name: class
        description: '{{ doc("shared_column_class") }}'
      - name: is_common_area
        description: '{{ doc("shared_column_is_common_area") }}'
      - name: is_negative_pred
        description: Indicates a negative prediction when testing models.

          Typically this results from mislabeled parking spaces which have
          a very low percentage of ownership.
      - name: is_parking_space
        description: '{{ doc("shared_column_is_parking_space") }}'
      - name: is_question_garage_unit
        description: Parking/garage space or storage unit indicator
      - name: lline
        description: '{{ doc("shared_column_lline") }}'
      - name: oneyr_pri_board_tot
        description: '{{ doc("shared_column_board_tot") }}'
      - name: parking_space_flag_reason
        description: '{{ doc("shared_column_parking_space_flag_reason") }}'
      - name: pin
        description: '{{ doc("shared_column_pin") }}'
      - name: pin10
        description: '{{ doc("shared_column_pin10") }}'
      - name: pin_is_multiland
        description: '{{ doc("shared_column_pin_is_multiland") }}'
      - name: pin_is_multilline
        description: '{{ doc("shared_column_pin_is_multilline") }}'
      - name: pin_num_landlines
        description: '{{ doc("shared_column_pin_num_landlines") }}'
      - name: pin_num_lline
        description: '{{ doc("shared_column_pin_num_lline") }}'
      - name: tieback_key_pin
        description: '{{ doc("shared_column_tieback_key_pin") }}'
      - name: tieback_proration_rate
        description: '{{ doc("shared_column_tieback_proration_rate") }}'
      - name: township_code
        description: '{{ doc("shared_column_township_code") }}'
      - name: unitno
        description: Condo unit number
      - name: year
        description: '{{ doc("shared_column_year") }}'

    data_tests:
      - not_null:
          name: default_vw_pin_condo_char_bldg_is_mixed_use_not_null
          column_name: bldg_is_mixed_use
      - not_null:
          name: default_vw_pin_condo_char_card_not_null
          column_name: card
      - not_null:
          name: default_vw_pin_condo_char_char_yrblt_not_null
          column_name: char_yrblt
      - unique_combination_of_columns:
          name: default_vw_pin_condo_char_unique_by_14_digit_pin_and_year
          combination_of_columns:
            - pin
            - year