RSF_FCAST_LL_VW

(SQL View)
Index Back

Field Label View - Language

Forecast Field Label - Related Language View

SELECT DISTINCT A.LANGUAGE_CD , B.FIELDNAME , A.PNLNAME , A.LBLTEXT FROM PSPNLFIELDLANG A , PSPNLFIELD B WHERE A.PNLNAME = B.PNLNAME AND A.PNLFLDID = B.PNLFLDID AND B.PNLNAME IN ('RSF_FCAST_REVIEW','RSF_FCAST_FILTER') AND B.FIELDNAME <> ' ' AND B.LBLTEXT <> ' '

  • Related Language Record for RSF_FCAST_L_VW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    3 PNLNAME Character(30) VARCHAR2(30) NOT NULL Page Name (see PSPNLDEFN).
    4 FIELDLABEL Character(60) VARCHAR2(60) NOT NULL Field Label