PY_IC_PC_EPB_FL

(SQL Table)
Index Back

Employee Paid Baneffits Record

Mobile Paycheck: Employee Paid Baneffits Record

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
2 PAY_WEB_CODE Character(17) VARCHAR2(17) NOT NULL Code created for Payroll WEB
3 PAY_WEB_DES50 Character(43) VARCHAR2(43) NOT NULL Description
4 PAY_WEB_AMT Signed Number(14,2) DECIMAL(12,2) NOT NULL Current Amount
5 PAY_WEB_SORT Character(1) VARCHAR2(1) NOT NULL Sortfld for Payroll WEB
A=Before-Tax
B=After-Tax
C=Employer-Paid Benefits
D=Taxable Benefits
E=Federal Taxes
F=State Taxes
Z=Unused Value
6 PAY_WEB_YTD_AMT Signed Number(15,2) DECIMAL(13,2) NOT NULL YTD Amount