PY_W4_FED_VW(SQL View) |
Index Back |
|---|---|
WEB-PayChk Rvw Pay Chk SummaryView created to support WEB-enabled Paycheck Review. It is based on the PAY_CHECK record. It contains the summary of the result of the payroll confirmation process. |
| SELECT DISTINCT A.EMPLID , A.COMPANY , A.SPECIAL_FWT_STATUS , A.FWT_MAR_STATUS , A.FWT_ALLOWANCES , A.FWT_ADDL_AMT , A.FWT_ADDL_PCT , A.LOCK_IN_RECVD , A.FWT_FORM_VERSION , A.FWT_MULTI_JOBS , A.FWT_TTL_DEP_AMT , A.FWT_OTH_INCOME , A.FWT_DED_ADJ FROM PS_FED_TAX_DATA A , PS_JOB B , PS_COMPANY_TBL C WHERE A.EMPLID = B.EMPLID AND B.COMPANY = C.COMPANY AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_FED_TAX_DATA A1 WHERE A1.EMPLID = A.EMPLID AND A1.COMPANY = A.COMPANY AND A1.EFFDT <= %CurrentDateIn) AND C.EFFDT = ( SELECT MAX(C1.EFFDT) FROM PS_COMPANY_TBL C1 WHERE C1.COMPANY = C.COMPANY AND C1.EFFDT <= %CurrentDateIn) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | COMPANY | Character(3) | VARCHAR2(3) NOT NULL |
Company
Prompt Table: COMPANY_TBL |
| 3 | SPECIAL_FWT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Special FWT Status
A=Nonresident alien E=No taxable gross; no tax taken G=Maintain taxable gross N=None |
| 4 | FWT_MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
FWT Marital Status
H=Head of Household M=Married S=Single X=Exempt |
| 5 | FWT_ALLOWANCES | Number(3,0) | SMALLINT NOT NULL | FWT Allowances |
| 6 | FWT_ADDL_AMT | Number(8,2) | DECIMAL(7,2) NOT NULL | FWT Additional Amount |
| 7 | FWT_ADDL_PCT | Number(6,3) | DECIMAL(5,3) NOT NULL | FWT Additional Percentage |
| 8 | LOCK_IN_RECVD | Character(1) | VARCHAR2(1) NOT NULL | Lock-In Letter Received |
| 9 | FWT_FORM_VERSION | Character(1) | VARCHAR2(1) NOT NULL |
2020 W4 - to indicate if the tax data is based on 2019 W4 form or 2020 W4 form.
A=W-4 - 2019 or Earlier B=W-4 - 2020 or Later C=W-4P - 2022 or Later D=W-4R - 2022 or Later |
| 10 | FWT_MULTI_JOBS | Character(1) | VARCHAR2(1) NOT NULL | 2020 W4 changes - Multiple Jobs Indicator |
| 11 | FWT_TTL_DEP_AMT | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Total Dependent Amount |
| 12 | FWT_OTH_INCOME | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Other Income |
| 13 | FWT_DED_ADJ | Number(11,2) | DECIMAL(10,2) NOT NULL | 2020 W4 - Deduction Adjustment |