If I understand it right , you are "not" concerned about the rest of the joists. Just the one on top the foundation running in the same direction as the rest and the corner?
Type, size and condition of foundation?
One story addition?
Roof gable above this wall? Ceiling joist ends, siting on this wall above?
Welcome to the site!