20Q2 - QAQC - output jobs where occ_init or occ_prop suggests non-residential, but units_init/prop <> 0

[AmandaDoyle]

In QAQC sit output all records where ~occ_category = Other and units_init/prop <> 0~

WHERE 
(NOT 
    (occ_init ~* 'RESIDENTIAL' 
     OR occ_prop ~* 'RESIDENTIAL'
     OR upper(occ_init) LIKE '%ASSISTED%LIVING%' 
     OR upper(occ_prop) LIKE '%ASSISTED%LIVING%')
AND (units_init > 0 OR units_prop > 0))

[kschmidtDCP]

This is still important, so that we can see the full list of jobs that have units but don't specify a resisential occupancy and potentially research them if needed. Knowing what we know about the resid_flag, the new logic is provided below, and also listed in the QAQC document in #33:

Output TRUE if either is true:

• occ_init does not contain the word “residential” AND units_init > 0
• occ_prop does not contain the word “residential” AND units_prop > 0.