HCM Extract with Custom Balance Group not returning values when joined to employees

I have the need to create a HCM Extract with all employees and their 401k period balance values. Some employees may not have a 401k balance but still need to be in the extract.

I created a custom balance group and balance group usage. I successfully created an extract that returns values for my custom 401k balance group by period using PAY_INTERFACE_PAYROLL_REL_UE as the one and only data group. That is good.

Since I need all employees regardless of whether they have a balance, I created a second HCM extract with PRE_EXT_PAY_EMPLOYEES_V2_US as the root. I joined this to PAY_INTERFACE_PAYROLL_REL_UE via person_id and then recreated the same information of the above working extract in the new Employee based extract. Unfortunately, this does not return any of the custom 401k balance group data.