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