Assignment Salary Basis Name & Assignment Salary Amount DBIs are not fetching data for all records

Summary:

PER_EXT_PERSON_BY_TYPE_USAGE_UE(root dg)

----PER_EXT_SEC_HISTORY_ASSIGNMENTS_UE

joined by Extract Historical Person Type Usage Person Id and Extract Historical Assignment Person ID

Data is extracted for few records and for others it is coming as blank

Employees am trying to fetch are active and has Salary basis and amount defined

Content (required):

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

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