EMPLIDRESIDENTA=Nonresident alien (Fed Rules)
E=No taxable gross; no tax taken
G=Maintain taxable gross
N=None
D=Decrease Additional Amount
I=Increase Additional Amount
PY_W4_ST_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 A.EMPLID , A.COMPANY , B.STATE , C.DESCR , B.RESIDENT , B.SPECIAL_SWT_STATUS , B.SWT_MAR_STATUS , B.SWT_ALLOWANCES , B.SWT_ADDL_ALLOWNCES , B.SWT_ADDL_AMT , B.SWT_ADDL_PCT , B.PERCENT_OF_FWT , B.LOCK_IN_RECVD , B.ADDL_AMT_ADJ , B.ANNL_EXEMPTION_AMT , B.RES_ADDL_ALLOW FROM PS_FED_TAX_DATA A ,PS_STATE_TAX_DATA B ,PS_STATE_TBL C WHERE A.EMPLID = B.EMPLID AND A.COMPANY = B.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 A.EFFDT = B.EFFDT AND B.STATE = C.STATE AND C.COUNTRY = 'USA' |
| # | 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 |
| 3 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 4 | STATE_DESCR | Character(30) | VARCHAR2(30) NOT NULL | State Description |
| 5 | RESIDENT |
Character(1) | VARCHAR2(1) NOT NULL | Resident |
| 6 | SPECIAL_SWT_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Special Tax Status
A=Nonresident alien (Fed Rules) E=No taxable gross; no tax taken G=Maintain taxable gross N=None |
| 7 | SWT_MAR_STATUS | Character(1) | VARCHAR2(1) NOT NULL | SWT Marital/Tax Status |
| 8 | SWT_ALLOWANCES | Number(3,0) | SMALLINT NOT NULL | Withholding Allowances |
| 9 | SWT_ADDL_ALLOWNCES | Number(3,0) | SMALLINT NOT NULL | Additional Allowances |
| 10 | SWT_ADDL_AMT | Signed Number(9,2) | DECIMAL(7,2) NOT NULL | SWT Additional Amount |
| 11 | SWT_ADDL_PCT | Number(6,3) | DECIMAL(5,3) NOT NULL | SWT Additional Percentage |
| 12 | PERCENT_OF_FWT | Number(6,3) | DECIMAL(5,3) NOT NULL | AZ Withholding Percent |
| 13 | LOCK_IN_RECVD | Character(1) | VARCHAR2(1) NOT NULL | Lock-In Letter Received |
| 14 | ADDL_AMT_ADJ | Character(1) | VARCHAR2(1) NOT NULL |
Additional Amount Adjustment
D=Decrease Additional Amount I=Increase Additional Amount |
| 15 | ANNL_EXEMPTION_AMT | Number(8,0) | INTEGER NOT NULL | MS Annual Exemption Amount |
| 16 | RES_ADDL_ALLOW | Number(3,0) | SMALLINT NOT NULL | Res State Addl Allowances |