I'm confused, you're confused. Modifying existing forum entries just adds to the confusion!
Why do you have a leavebalance table? Are you integrating a 3rd party system? If not, use Alfresco native capabilities. That is, define a content model for your data requirements and store the data in Alfresco, not in mysql tables. That way, you can use Alfresco's native workflow support for displaying custom data in workflow dialogs.
If you are integrating a 3rd party system, then you have two options.
a) Define an Alfresco content model for the pieces of data you wish to integrate - then during the workflow, populate those pieces of data from your 3rd party system, and use Alfresco's native capabilities for displaying that data - of course, you are duplicating this information, but that may not be a bad thing, as you may want a snapshot anyway for the lifetime of the workflow.
b) Customise (i.e. do some manual code modification of) Alfresco so that it integrates with your 3rd party system - this is possibly more difficult - don't ask me how - as I only know half the answer, as I only know Alfresco, not your 3rd party system.
