PAY_WEB_CODEA=Before-Tax
B=After-Tax
C=Employer-Paid Benefits
D=Taxable Benefits
E=Federal Taxes
F=State Taxes
Z=Unused Value
PY_IC_PI_BT_DED(SQL Table) |
Index Back |
|---|---|
WEB-PayChk Rvw DeductionsRecord created to support WEB-enabled Paycheck Review. It contains the deductions for a check. The structure has been designed so that the panel created using this record will look like the 'Deduction' section of the 'paystub' created using the 'check' SQRs. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PAY_WEB_CODE |
Character(17) | VARCHAR2(17) NOT NULL | Code created for Payroll WEB |
| 2 | PAY_WEB_DESCR | Character(35) | VARCHAR2(35) NOT NULL | Description |
| 3 | PAY_WEB_AMT | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Current Amount |
| 4 | 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 |
| 5 | PAY_WEB_YTD_AMT | Signed Number(15,2) | DECIMAL(13,2) NOT NULL | YTD Amount |