Need help with fetching state code of a balance in HCM extract

Summary:

In need of help in fetching the current state_code of a balance in HCM extract.

Content (required):

Currently we are using balance group to fetch few YTD balances for the latest payroll run. But I need state code along with balance name and its value. The report must show only those balances that apply for the state that employee is currently residing in.

For eg: If Employee E1 is currently in CA and has balances populated for B1, B2 for state CA and B3 for state of MA.

I only want B1 and B2 to be displayed in the report.