GPES_PP_SH_LNG

(SQL View)
Index Back

IRPF Search record rel lang

IRPF Search record related language

SELECT DISTINCT A.COMPANY , A.GPES_YEAR , A.GPES_MONTH , BLANG.LANGUAGE_CD , BLANG.DESCR FROM PS_GPES_PP_RSLT A , PS_COMPANY_TBL B , PS_COMPNY_TBL_LANG BLANG WHERE A.COMPANY = B.COMPANY AND B.COMPANY = BLANG.COMPANY

  • Related Language Record for GPES_PP_SH_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COMPANY Character(3) VARCHAR2(3) NOT NULL Company

    Prompt Table: COMPANY_TBL

    2 GPES_YEAR Number(4,0) SMALLINT NOT NULL Year
    3 GPES_MONTH Number(2,0) SMALLINT NOT NULL Month
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 DESCR Character(30) VARCHAR2(30) NOT NULL Description