default.vw_pin_appeal.yml

models:
  - name: default.vw_pin_appeal
    description: '{{ doc("view_vw_pin_appeal") }}'

    columns:
      - name: agent_code
        description: '{{ doc("shared_column_agent_code") }}'
      - name: agent_name
        description: '{{ doc("shared_column_agent_name") }}'
      - name: appeal_type
        description: '{{ doc("shared_column_appeal_type") }}'
      - name: case_no
        description: '{{ doc("shared_column_case_no") }}'
      - name: certified_bldg
        description: '{{ doc("shared_column_certified_bldg") }}'
      - name: certified_land
        description: '{{ doc("shared_column_certified_land") }}'
      - name: certified_tot
        description: '{{ doc("shared_column_certified_tot") }}'
      - name: change
        description: '{{ doc("shared_column_appeal_change") }}'
      - name: class
        description: '{{ doc("shared_column_class") }}'
      - name: mailed_bldg
        description: '{{ doc("shared_column_mailed_bldg") }}'
      - name: mailed_land
        description: '{{ doc("shared_column_mailed_land") }}'
      - name: mailed_tot
        description: '{{ doc("shared_column_mailed_tot") }}'
      - name: pin
        description: '{{ doc("shared_column_pin") }}'
      - name: reason_code1
        description: '{{ doc("shared_column_reason_code") }}'
      - name: reason_code2
        description: '{{ doc("shared_column_reason_code") }}'
      - name: reason_code3
        description: '{{ doc("shared_column_reason_code") }}'
      - name: status
        description: '{{ doc("shared_column_appeal_status") }}'
      - name: township_code
        description: '{{ doc("shared_column_township_code") }}'
      - name: year
        description: '{{ doc("shared_column_year") }}'

    data_tests:
      - row_count:
          name: default_vw_pin_appeal_row_count
          above: 8815299 # as of 2024-11-14

unit_tests:
  - name: default_vw_pin_appeal_class_strips_non_alphanumerics
    description: class transformation should remove non-alphanumeric characters
    model: default.vw_pin_appeal
    given:
      - input: source("iasworld", "pardat")
        rows:
          # `class` is the important column here, and all other columns are
          # only set to ensure proper joins when creating the dummy tables
          - {parid: "123", taxyr: "2024", cur: "Y", deactivat: null, class: "2.1-1)A"}
      - input: source("iasworld", "htpar")
        rows:
          - {parid: "123", taxyr: "2024", cur: "Y", deactivat: null, cpatty: "1", caseno: "1"}
      - input: source("iasworld", "legdat")
        rows:
          - {parid: "123", taxyr: "2024", cur: "Y", deactivat: null}
      - input: ref("default.vw_pin_value")
        rows:
          - {pin: "123", year: "2024"}
      - input: source("iasworld", "htagnt")
        rows:
          - {agent: "1", cur: "Y", deactivat: null}
      - input: ref("ccao.htpar_reascd")
        rows:
          - {reascd: "28"}
    expect:
      rows:
        - {class: "211A"}