W2_REPORTING_COW2_CO_PR_VW(SQL View) |
Index Back |
|---|---|
W2 Reporting Comps |
| SELECT DISTINCT A.W2_REPORTING_CO , A.DESCR FROM PS_W2_COMPANY A , PS_COMPANY_TBL B WHERE A.W2_REPORTING_CO = B.COMPANY AND B.TAX_REPORT_TYPE = 'P' AND A.CALENDAR_YEAR = ( SELECT MAX(C.CALENDAR_YEAR) FROM PS_W2_COMPANY C WHERE C.W2_REPORTING_CO = A.COMPANY) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | W2_REPORTING_CO |
Character(3) | VARCHAR2(3) NOT NULL | W-2 Reporting Company |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |