W2_RPTCO_LNG_VW

(SQL View)
 Index Back

Related Lang - W2_RPTNG_CO_VW

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

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

  • Related Language Record for W2_RPTNG_CO_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 W2_REPORTING_CO Character(3) VARCHAR2(3) NOT NULL W-2 Reporting Company
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description