TAX_YEAREMPLIDPY_1042S_EE_CVW(SQL View) |
Index Back |
|---|---|
Employee Received 1042-SEmployee Received 1042-S |
| SELECT A.TAX_YEAR , A.EMPLID , A.NAME_DISPLAY FROM PS_PY_1042S_YE_EE A WHERE A.PY_EE_SEQ_NO = ( SELECT MAX(A1.PY_EE_SEQ_NO) FROM PS_PY_1042S_YE_EE A1 WHERE A1.TAX_YEAR = A.TAX_YEAR AND A1.EMPLID = A.EMPLID) AND EXISTS ( SELECT 'X' FROM PS_PY_1042S_YE_TAX B WHERE A.TAX_YEAR = B.TAX_YEAR AND A.EMPLID = B.EMPLID AND B.PY_PROC_STATUS = 'C') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TAX_YEAR |
Signed Number(5,0) | DECIMAL(4) NOT NULL | Tax Year |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |