PER_EXT_PERSON_ADDRESSES_UE not fetching address of type 'MAIL' but its fetching address of type 'HO

Summary

PER_EXT_PERSON_ADDRESSES_UE not fetching address of type 'MAIL' but its fetching address of type 'HOME'

Content

I am building hcm extract with Assignment UE as root data group. In Assignment data group person id is set as key attribute. I have a person with 2 addresses -one with address type 'HOME' and other with address type 'MAIL'. I dont give any data group filter for Address UE and join the address UE with Assignment UE with Person Id. When I run the extract I am getting only the HOME address type in my output and not the MAIL address. Why is this issue happening? My expectation is to get both the addresses in my UE.