added view file include as delete status is still applicable for joining tables