modified givrate with column type & status