utility changes, added status enum

also includes hql's