W2_REPORTING_COPY_W2_RPT_CO_VW(SQL View) |
Index Back |
|---|---|
W-2 Reporting Companies ViewW-2 Reporting Companies View |
| SELECT DISTINCT A.COMPANY FROM PS_YE_DATA A , PS_TAXRPT_RUNCTL B , PS_W2_COMPANY C WHERE A.CALENDAR_YEAR = B.BALANCE_YEAR AND A.TAXFORM_ID='P' AND A.COMPANY=C.W2_REPORTING_CO AND C.CALENDAR_YEAR = B.BALANCE_YEAR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | W2_REPORTING_CO |
Character(3) | VARCHAR2(3) NOT NULL | W-2 Reporting Company |