How to convert resident balances in Oracle when legacy do not have resident and nonresident separate

Summary:

For the current client they do not have separate balance for resident and non resident taxes withheld, everything is in same balance, how to convert them in Oracle from PSFT for each city employees would have worked in or have been resident of.

Content (please ensure you mask any confidential information):

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

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