W2_RPTNG_CO_VW

(SQL View)
 Index Back

View of W2 Reporting Companies

This view retrieves combinations of calendar year, W-2 reporting company, and the company description for use in year end reports.

SELECT A.BALANCE_YEAR ,B.W2_REPORTING_CO ,C.DESCR FROM PS_TAXRPT_RUNCTL A ,PS_W2_COMPANY B ,PS_COMPANY_TBL C WHERE A.BALANCE_YEAR = B.CALENDAR_YEAR AND B.COMPANY = B.W2_REPORTING_CO AND C.COMPANY = B.COMPANY

  • Related Language Record: W2_RPTCO_LNG_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CALENDAR_YEAR Number(4,0) SMALLINT NOT NULL Calendar Year
    2 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description