Update class code cleaning to allow new omitted assessment class codes

ccao-data / data-architecture

Codebase for CCAO data infrastructure construction and management

https://ccao-data.github.io/data-architecture/

5 stars 3 forks source link

Update class code cleaning to allow new omitted assessment class codes #341

Closed wrridgeway closed 2 months ago

wrridgeway commented 3 months ago

The office introduced new class codes this year that start with "OA". Our current syntax for cleaning class codes (REGEXP_REPLACE(par.class, '([^0-9EXR])', '') AS class) only preserves the number after 'OA'.