Blank source info in Candidate application versus Candidate profile

There are candidates who have source info blank in Candidate application where as it is present in Candidate prifle.
The Candidate application is updated via integration.
Need to know how can we get the source info of candidate from which source medium they applied.
Can someone share SQL or OTBI report/criteria using which the data can be fetched.

Thanks.