UCBG reports - updating three accession reports

left outer join on briefdescriptions