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_TAX(SQL Table) |
Index Back |
|---|---|
WEB-PayChk Rvw TaxesRecord created to support WEB-enabled Paycheck Review. It contains the tax details for a check. It will work for both US and Canadian taxes. The structure has been designed so that the panel created using this record will look like the 'Tax' 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(14,2) | DECIMAL(12,2) NOT NULL | YTD Amount |
| 6 | PAY_WEB_TXGRS_CUR | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | Current Taxable Gross |
| 7 | PAY_WEB_TXGRS_YTD | Signed Number(14,2) | DECIMAL(12,2) NOT NULL | YTD Taxable Gross |