PY_IC_PC_EPB_FL(SQL Table) |
Index Back |
---|---|
Employee Paid Baneffits RecordMobile 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 |