updated Affiliate report sanity tests

also used a ssn from excel file