Alfred Harrison Jeffreys - War record

Alfred was in the South African UK military campaign. He received the Queens medalwith 'Belfast' & Cape Colony. His number was H224, he was in the Brabant Horse unit. I am recently into Alfreds research.
I cannot find a death record for him. Family story is that he was lost in a sea event- either at San Franscisco (earthquake), or in New Orleans.