add active_status to ref data queries