TAX_YEAREMPLIDPrompt Table: PERSON_NAME
PY_1042S_EE_VW(SQL View) |
Index Back |
|---|---|
1042S Year End Employee View1042S Year End Employee View |
| SELECT DISTINCT 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) |
| # | 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
Prompt Table: PERSON_NAME |
| 3 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Display Name - name formatted for Display based on the Country |