EO Check Stub and hr_eostub Table Mapping

The following table holds standard checkwriter values that display in sections of the EO check page.
The current EO check stub pulls from the hr_eostub table. The table is initially queried as follows:
Select * from hr_eostub where Id = '{userId}' and cknum eq '{CheckNumber}'
From these results, the system pulls items and puts them into dictionaries so that they can be accessed on the MVC page easier:

Dictionary	Where clause on top of above
GeneralInfo	Category = 'GENERAL INFO'
Earnings	Category='EA'
Nontax	Category='EB'
If Earnings and Nontax are empty above then Earnings is pulled from this	Category='E'
Wages	Category='Wages'
Taxes	Category='DA'
PTD (Pre Tax Deductions)	Category='DB'
ATD (After Tax Deductions)	Category='DC'
Deductions (Other)	Category='D'
Bene	Category='CA'
Also Bene is pulled from	Category='C'
Also Bene if pulled from (Added for custom clients)	Cateogry='DC', Cateogry='DB', and Cateogry='DA'. Looks only for names {"DESC", "C-PTD", "C-YTD", "TOT:CPTD", and "TOT:CYTD"}
Contribution	Category='CB'
(Benefits totals pulled directly from)	(Bene[0]['TOT:PTD'], Bene[0]['TOT:YTD']) or (GeneralInfo['CA-CB-PTD-TOT'], GeneralInfo['CA-CB-YTD-TOT'])
Bank (Direct Deposit info)	Category='B'
Leave (Leave totals/balances)	Category='L'
Additional	Category="MISC"
Message	(Category='MSG' or Category='CMNT' or Category='M') & (Name='MSG' or Name='CMNT' or Name='LEFT' or Name='RIGHT') [first one only]
Certification	Category='CERT'

The following table shows how those dictionaries are used on the actual checkstubdetail page.

Value	Dictionary pulled from
Employee Name	GeneralInfo['Name'] or GeneralInfo['XPE-NAME-REVERSED'] or Comment['EMP NAME']
Address	GeneralInfo['ADDR1'], GeneralInfo['ADDR2']
Employee ID	GeneralInfo['ID'] or GeneralInfo['EMP ID'] or Comment['EMP ID']
Check Date	GeneralInfo['CK-DT1'] or GeneralInfo['CK-DT2'] or GeneralInfo['CHECK DT'] or Comment['CHECK DT']
Check Number	GeneralInfo['CK-NUM1'] or GeneralInfo['CK-NUM2'] or GeneralInfo['CHECKNO'] or Comment['CK NUM']
Period Begin	GeneralInfo['PERIOD-BE'] or GeneralInfo['PERIOD-BEG'] or GeneralInfo['PER-DATES']
Department/Location	GeneralInfo['EDUC5'] or GeneralInfo['EDUC52'] or GeneralInfo['LOC']
Location Name	GeneralInfo['LOC-NAME']
District Name	GeneralInfo['DIST NAME']
Period End	GeneralInfo['PER END DT'] or GeneralInfo['PERIOD-END'] or Comment['PERIOD END']
Earnings	Loop Through [1 – x] {Earnings['DESC'], Earnings['HRS'], Earnings['RATE'], Earnings['PTD'], Earnings['YTD']}
Earnings Totals	{Earnings[0][HRS], Earnings[0][RATE], Earnings[0][EARN PTD], Earnings[0][EARNYTD], Earnings[0][TOT:PTD], Earnings[0][TOT:YTD]}
Non-Taxable earnings	Loop Through [1 – x] {NonTax['DESC'], NonTax ['HRS'], NonTax ['RATE'], NonTax ['PTD'], NonTax['YTD']}
Federal Withholding	GeneralInfo['FED STATUS'] or GeneralInfo['FED-STATUS'] or GeneralInfo['FIT STATUS'] or GeneralInfo['FED STAT'] or GeneralInfo['FED-STATUS-LONG'] or Comment['FED W4']
State Withholding	GeneralInfo['STATE STATUS'] or GeneralInfo['STATE-STATUS'] or Comment['STATE W4']
Federal Exemptions	GeneralInfo['FIT ALLOWANCE'] or GeneralInfo['FED-EXEMPT']
State Exemptions	GeneralInfo['SIT ALLOWANCE'] or GeneralInfo['STATE-EXEMPT']
Federal Additional Withholding	GeneralInfo['FED-ADDL9'] or GeneralInfo['FIT ADDL'] or GeneralInfo['FED-ADDL'] or GeneralInfo['FED ADDL']
State Additional Withholding	GeneralInfo['STATE-ADDL9'] or GeneralInfo['SIT ADDL'] or GeneralInfo['STATE-ADDL']
Taxes	Loop Through [1 – x] {Taxes['DESC'], Taxes['PTD'], Taxes['YTD']}
Taxes Totals	{Taxes[0]['TOT:PTD'], Taxes[0]['TOT:YTD']} OR {GeneralInfo['FIT-PTD'], GeneralInfo['FIT-YTD']}
Deduction	Loop Through [1 – x] {Deductions['DESC'], Deductions['PTD'], Deductions['YTD']}
Deduction Total	{Deductions[0]['TOT:PTD'], Deductions[0]['TOT:YTD']}
Employer Paid Benefits	Loop Through [1 – x] {Bene['DESC'], Bene['PTD'], Bene['YTD']}
Employer Paid Contribution	Loop Through [1 – x] {Contribution['DESC'], Contribution['PTD'], Contribution['YTD']}
Employer Paid Benefits Total	{Bene[0]['TOT:PTD'], Bene[0]['TOT:YTD']}
Pre-Tax Deductions	Loop Through [1 – x] {PTD['DESC'], PTD['PTD'], PTD['YTD']}
Pre-Tax Deductions Total	{PTD[0]['TOT:PTD'], PTD[0]['TOT:YTD']} OR {GeneralInfo['ECA-PTD-TOT'], GeneralInfo['ECA-YTD-TOT']}
After-Tax Deductions	Loop Through [1 – x] {ATD['DESC'], ATD['PTD'], ATD['YTD']}
After-Tax Deductions Total	{ATD[0]['TOT:PTD'], ATD[0]['TOT:YTD']} OR {GeneralInfo['MISC-DED-PTD'], GeneralInfo['MISC-DED-YTD']}
Gross Wages	{GeneralInfo['EARN PTD'], GeneralInfo['EARN YTD']} OR {GeneralInfo['EP-PTD-TOT'], GeneralInfo['EP-YTD-TOT']}
Taxable Wages	{Wages['TAXABLE PTD'], Wages['TAXABLE YTD']} OR {GeneralInfo['TAXABLE-GRS-PTD'], GeneralInfo['TAXABLE-GRS-YTD']}
Net Pay	{GeneralInfo['PAY'], (GeneralInfo['PAYYTD'] or GeneralInfo['PAY2'])} or {Wages['NET PTD'], Wages['NET YTD']} or {GeneralInfo['NET PTD'], GeneralInfo['NET YTD']}
Bank	Loop Through [1 – x] {(Bank['DESC'] or Bank['TRANSIT-NO']), (Bank['ACCT-NO'] or Bank['USER-S1'] and/or Bank['ACCT-TYPE']), Bank['PTD']}
Leave Information	Loop Through [1 – x] {Leave['DESC'], Leave['BEG'], Leave['ACC'] or Leave['ACCR'], Leave['PTD'], Leave['YTD'], Leave['USED'] or Leave['USE'], Leave['END']}
Additional Information	Loop Through [1 – x] {Label: Additional["DESC"], Value: Additional["INFO"]} and/or Loop Through [1 - x] {Label: Certificate["TITLE"], Value: Certificate["DATE"]} and/or Label: GeneralInfo["MSG"]
Message	Loop Through [1 – x]{ Message['MSG'] or Message['RIGHT'] or Message['LEFT'] or Message['CMNT']}
FICA/Medicare	{GeneralInfo['FICA-PTD'], GeneralInfo['FICA-YTD']}