Seniority date blank on front end but populated in PER_SENIORITY_DATES_F Table

Summary: For many employees Seniority date is blank on front end but populated in PER_SENIORITY_DATES_F Table. I noticed TOTAL_ADJUSTMENT_DAYS is Negative and if I add it to Seniority Date it matches to BASE_SENIORITY_DATE. We need to pull this seniority date in reports matching what's on front end.

Is it correct understanding to write query that if Seniority Date matches BASE_SENIORITY_DATE Then we shouldn't populate it?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):23D

Code Snippet (add any code snippets that support your topic, if applicable):