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 | 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']} |
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 |
Message | Loop Through [1 – x]{ Message['MSG'] or Message['RIGHT'] or Message['LEFT'] or |
FICA/Medicare | {GeneralInfo['FICA-PTD'], GeneralInfo['FICA-YTD']} |