Business Rules for Occupied and Vacant Units

Information by State  Print version

• ACC unit:
  hhqnwd018.picdb.dbo.P113PT_PH_unit.acc_unit_ind = 'Y'
  

• Under management:
  hhhqnwd018.picdb.dbo.p113pt_physical_development.pd_status_type_code = 'M'

• Initially approved unit:
  hhhqnwd018.picdb.dbo.P113PT_PH_unit.initial_approved_ind = 'Y'

• Status is not "Removed from Inventory" or "Proposed Removed from Inventory":
  hhhqnwd018.picdb.dbo.P113PT_PH_unit.unit_status_type_code not in ('RMI', 'RMIPRP')

• A family or elderly or family disabled or elderly disabled unit type or official designation disabled or official designation elderly or official designation mixed:
  hhhqnwd018.picdb.dbo.P113PT_PH_unit.unit_type_code in ('FA', 'EL', 'FD', 'ED', 'ODD', 'ODE', 'ODM')

If data from any of the above fields is missing, then we can't know whether a unit is occupied or vacant, so it falls into the status unknown category. The missing data is likely due to form 50058 records predating the corresponding buildings and units records.