Need help with fetching state code of a balance in HCM extract
In need of help in fetching the current state_code of a balance in HCM extract.
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.